SFTP (key-based auth)
Interact with an SFTP (SSH File Transfer Protocol) Server using a private key for auth
Integrate the SFTP (key-based auth) API with the Airtable (OAuth) API
Setup the SFTP (key-based auth) API trigger to run a workflow which integrates with the Airtable (OAuth) API. Pipedream's integration platform allows you to integrate SFTP (key-based auth) and Airtable (OAuth) remarkably fast. Free for developers.
Popular Ways to Connect SFTP (key-based auth) with Airtable (OAuth)#
Popular SFTP (key-based auth) and Airtable (OAuth) Triggers#
Emit new events when files get created, changed or deleted from a remote directory. See the docs
Emit new event each time a record is added, updated, or deleted in an Airtable table. See the documentation
Emit new event for each new or modified field in a table
Emit new event for each new or modified record in a table
Popular SFTP (key-based auth) and Airtable (OAuth) Actions#
Uploads a file or string in UTF-8 format to the SFTP server. See the documentation
Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs. See the documentation
Overview of SFTP (key-based auth)#
The SFTP (key-based auth) app on Pipedream allows you to securely transfer and manage files over a network. It uses SSH for data transfer and provides the same level of security as SSH, without requiring password authentication, making automation workflows more secure and less prone to human error. You can automate file uploads, downloads, synchronization tasks, and efficiently manage your remote files in a serverless environment. Integrating this with other Pipedream-supported apps enables you to craft powerful and secure data flow systems.
Connect SFTP (key-based auth)#
module.exports = defineComponent({
props: {
sftp: {
type: "app",
app: "sftp",
}
},
async run({steps, $}) {
const Client = require('ssh2-sftp-client');
const {
host,
username,
privateKey,
} = this.sftp.$auth
const config = {
host,
username,
privateKey,
}
const sftp = new Client()
await sftp.connect(config)
this.cwd = await sftp.cwd();
return await sftp.end();
},
})
Overview of Airtable (OAuth)#
Airtable (OAuth) API on Pipedream allows you to manipulate and leverage your Airtable data in a myriad of powerful ways. Sync data between Airtable and other apps, trigger workflows on updates, or process bulk data operations asynchronously. By using Airtable's structured databases with Pipedream's serverless platform, you can craft custom automation solutions, integrate with other services seamlessly, and streamline complex data processes.
Connect Airtable (OAuth)#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
airtable_oauth: {
type: "app",
app: "airtable_oauth",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.airtable.com/v0/meta/whoami`,
headers: {
Authorization: `Bearer ${this.airtable_oauth.$auth.oauth_access_token}`,
},
})
},
})