What do you want to automate
with Harvest and Database?
Prompt, edit and deploy AI agents that connect to Harvest, Database and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Harvest and Database Actions#
Creates a new time entry object. Create a time entry via duration documentation, Create a time entry via start and end time documentation
Overview of Harvest#
Harvest is a time tracking and invoicing tool that can streamline the way freelancers and businesses record time for various projects and tasks. By leveraging the Harvest API on Pipedream, you can automate complex workflows that integrate time tracking data with other business tools. Generate reports, sync project data, and manage invoices with minimal manual intervention. Pipedream's serverless platform lets you create these automations using simple, code-driven components, enabling a seamless connection between Harvest and a multitude of other apps.
Connect Harvest#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
harvest: {
type: "app",
app: "harvest",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://id.getharvest.com/api/v2/accounts`,
headers: {
Authorization: `Bearer ${this.harvest.$auth.oauth_access_token}`,
"User-Agent": `Pipedream (pipedream.com)`,
},
})
},
})
Overview of Database#
The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.
Connect Database#
import postgresql from "@pipedream/postgresql";
export default {
props: {
postgresql,
sql: {
type: "sql",
auth: {
app: "postgresql",
},
label: "PostreSQL Query",
},
},
async run({ $ }) {
const args = this.postgresql.executeQueryAdapter(this.sql);
const data = await this.postgresql.executeQuery(args);
return data;
},
};
Trusted by 1,000,000+ developers from startups to Fortune 500 companies