Interact with an SFTP (SSH File Transfer Protocol) Server using a username and password for auth
Emit new events when files get created, changed or deleted from a remote directory. See the docs
Emit new events each time a row or rows are added to the bottom of a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Row Added (Shared Drive, Instant) source instead.
Emit new events each time a row or rows are added to the bottom of a spreadsheet in a shared drive
Emit new event each time a row or cell is updated in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Updates (Shared Drive, Instant) source instead.
Emit new event each time a row or cell is updated in a spreadsheet in a shared drive
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:
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();
},
})
Some examples of things you can build using the Google Sheets API include:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_sheets: {
type: "app",
app: "google_sheets",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/oauth2/v1/userinfo`,
headers: {
Authorization: `Bearer ${this.google_sheets.$auth.oauth_access_token}`,
},
})
},
})