SFTP (password-based auth)
Interact with an SFTP (SSH File Transfer Protocol) Server using a username and password for auth
Integrate the SFTP (password-based auth) API with the Airtable API
Setup the SFTP (password-based auth) API trigger to run a workflow which integrates with the Airtable API. Pipedream's integration platform allows you to integrate SFTP (password-based auth) and Airtable remarkably fast. Free for developers.
Popular Ways to Connect SFTP (password-based auth) with Airtable#
Popular SFTP (password-based auth) and Airtable Triggers#
Emit new events when files get created, changed or deleted from a remote directory. See the docs
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 SFTP (password-based auth) and Airtable Actions#
Uploads a UTF-8 string as a file on an SFTP server
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 SFTP (password-based auth)#
SFTP (Secure File Transfer Protocol) is a network protocol that provides secure
file transfers over secure shell (SSH) connections. It is an extension of the
Secure Shell protocol, designed for secure file exchange between hosts. A user
can securely transfer files between systems without having to worry about
external threats, as the protocol is encrypted and authenticated.
With the SFTP API, you can build applications that securely transfer data, such
as files and documents, between two different systems. Some example
applications include:
- Secure document sharing between two systems
- Secure file synchronization between two systems
- Secure backups of data over the network
- Secure transfers of large files
- Secure uploads and downloads of data
- Media streaming between two systems
Connect SFTP (password-based auth)#
module.exports = defineComponent({
props: {
sftp_password_based_auth: {
type: "app",
app: "sftp_password_based_auth",
}
},
async run({steps, $}) {
const Client = require('ssh2-sftp-client');
const {
host,
username,
password,
} = this.sftp_password_based_auth.$auth
const config = {
host,
username,
password,
}
const sftp = new Client()
await sftp.connect(config)
this.cwd = await sftp.cwd();
return await sftp.end();
},
})
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#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
airtable: {
type: "app",
app: "airtable",
},
baseId: {
type: "$.airtable.baseId",
appProp: "airtable",
},
tableId: {
type: "$.airtable.tableId",
baseIdProp: "baseId",
},
},
async run({steps, $}) {
return await axios($, {
url: `https://api.airtable.com/v0/${this.baseId}/${this.tableId}`,
headers: {
Authorization: `Bearer ${this.airtable.$auth.api_key}`,
"accept": `application/json`,
},
})
}
})
Community Posts#
