Harvest
Online Time Tracking and Invoicing Software
Integrate the Harvest API with the Airtable API
Setup the Harvest API trigger to run a workflow which integrates with the Airtable API. Pipedream's integration platform allows you to integrate Harvest and Airtable remarkably fast. Free for developers.
Popular Harvest and Airtable Triggers#
Emit new notifications when a new timesheet entry is created
Emit an event for each new or modified record in a table
Emit an event for each new or modified record in a view
Popular Harvest and Airtable Actions#
Creates a new time entry object. Create a time entry via duration documentation, Create a time entry via start and end time documentation
Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs.
Retrieve records from a table with automatic pagination. Optionally sort and filter results.
Retrieve records in a view with automatic pagination. Optionally sort and filter results.
Overview of Harvest#
The Harvest API allows developers to programmatically access data and objects
in Harvest, a web-based time tracking application. With the API, developers can
create applications that submit and retrieve time tracking data, as well as
automate various aspects of the Harvest user experience.
Some examples of what you can build using the Harvest API include:
- A time tracking application that automatically submits time tracking data to
Harvest on behalf of the user - A reporting application that retrieves time tracking data from Harvest and
presents it in various charts and graphs - An integration with a third-party project management application that pulls
in time tracking data from Harvest to provide a more complete picture of
project progress
Connect Harvest#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
harvest: {
type: "app",
app: "harvest",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.harvestapp.com/v2/users/me`,
headers: {
Authorization: `Bearer ${this.harvest.$auth.oauth_access_token}`,
"Harvest-Account-Id": `${this.harvest.$auth.account_id}`,
"User-Agent": `Pipedream.com`,
},
params: {
account_id: `${this.harvest.$auth.account_id}`,
},
})
},
})
Overview of Airtable#
Using the Airtable API, you can build applications that can:
- Create and manage databases
- Add, update, and delete records
- Search for records
- Sort and filter records
- Display records in a variety of ways
- Import and export data
Connect Airtable#
module.exports = defineComponent({
props: {
airtable: {
type: "app",
app: "airtable",
},
baseId: {
type: "$.airtable.baseId",
appProp: "airtable",
},
tableId: {
type: "$.airtable.tableId",
baseIdProp: "baseId",
},
},
async run({steps, $}) {
const Airtable = require('airtable');
const base = new Airtable({apiKey: this.airtable.$auth.api_key}).base(this.baseId);
const data = []
await base(this.tableId).select({
// pass optional config parameters here
}).eachPage(function page(records, fetchNextPage) {
// This function (`page`) will get called for each page of records.
records.forEach(function(record) {
data.push(record._rawJson)
});
// To fetch the next page of records, call `fetchNextPage`.
// If there are more records, `page` will get called again.
// If there are no more records, `done` will get called.
fetchNextPage();
})
return data
},
})
Community Posts#
