with SFTP (password-based auth) and Retool?
Emit new events when files get created, changed or deleted from a remote directory. See the docs
Uploads a file or string in UTF-8 format to the SFTP server. See the documentation
SFTP on Pipedream enables secure file management on remote servers directly from your workflows. Utilize this app to automate file uploads, downloads, and synchronization tasks between your systems and SFTP servers. Implement robust data pipelines or deploy content to web servers without manual intervention, all while maintaining a high level of security with password-based authentication.
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();
},
})
Retool is a platform that makes it faster to build internal tools with a drag-and-drop interface. The Retool API allows you to programmatically manage various aspects of your Retool applications, such as triggering queries, updating apps, or retrieving data from your custom tools. In Pipedream, you can utilize this API to automate workflows between Retool and other apps, creating powerful integrations that streamline your internal processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
retool: {
type: "app",
app: "retool",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.retool.com/api/v1/resources`,
headers: {
Authorization: `Bearer ${this.retool.$auth.access_token}`,
"Accept": `application/json`,
},
})
},
})