What do you want to automate
with Database and ADP?
Prompt, edit and deploy AI agents that connect to Database, ADP and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
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;
},
};
Overview of ADP#
The ADP API provides access to a breadth of payroll and human capital management services. With Pipedream, you can automate workflows that bridge the gap between ADP and other apps, streamlining your HR processes. By leveraging Pipedream's serverless platform, you can orchestrate data flows, synchronize employee information, manage payroll events, and react to changes in ADP data in real-time without writing extensive code.
Connect ADP#
import { axios } from "@pipedream/platform"
import https from "https"
export default defineComponent({
props: {
adp: {
type: "app",
app: "adp",
}
},
async run({steps, $}) {
const httpsAgent = new https.Agent({
cert: this.adp.$auth.crt_file,
key: this.adp.$auth.key_file,
})
return await axios($, {
url: `${this.adp.$auth.environment}api.adp.com/hr/v2/workers`,
headers: {
Authorization: `Bearer ${this.adp.$auth.oauth_access_token}`,
},
httpsAgent: httpsAgent
})
},
})
Trusted by 1,000,000+ developers from startups to Fortune 500 companies