Skip to main content

How to connect an automatic data source

Stop uploading files manually. Connect a FTP, SFTP, URL, or API source and let WeTransform fetch your data automatically.

Written by StΓ©phane Jauffret
Updated over 2 weeks ago

Uploading files manually works well when you're getting started. But once your transformation is configured and working, there's no reason to keep doing it by hand.

WeTransform lets you connect a dynamic source β€” an external location where your files live β€” so it can fetch them automatically, on demand or on a schedule.

πŸ“‘ Supported source types

πŸ—‚οΈ FTP / SFTP β€” connect to a file server and point WeTransform to the file or folder to retrieve. Ideal for supplier feeds, daily exports, or any system that drops files on an FTP.

🌐 URL β€” provide a direct URL to a file (CSV, Excel, XML, JSON). WeTransform fetches it every time the transformation runs. Works well for public or authenticated data feeds.

⚑ API β€” trigger the transformation programmatically via the WeTransform API. Your system pushes or signals when a new file is ready, and WeTransform processes it immediately. See API documentation.

πŸ“§ Email β€” coming soon. You'll be able to send files directly to a WeTransform email address to trigger a transformation automatically.

βš™οΈ How to connect a source

From your transformation, go to Integrations β†’ Source feeds and click "Create a source configuration".

Select your source type and fill in the connection details:

  • For FTP/SFTP: host, port, username, password, and the path to the file or folder

  • For URL: the direct URL to the file, and any authentication headers if needed

  • For API: generate your API token in your account settings and use the WeTransform API to push source updates

πŸ’‘ Test your connection before saving. WeTransform will attempt to reach your source and confirm it can read the file β€” catching authentication or path errors before you try to schedule anything.

πŸ” What happens after connection

Once a dynamic source is connected to a transformation, you have two options:

πŸ‘‰ What to do next

Did this answer your question?