2 Replies Latest reply on Aug 10, 2018 9:11 AM by Igor Ignatov

Automated Data Imports from SFTP

4fe3365d8f0c268556e5458f762903f72f21dc7d Jan 18, 2017 2:07 AM

I'm looking to creat an automated data import that would pick up an excel or CSV file from an SFTP server and import it into Marketo. Right now, the only way to do this appears to be with the API - so I'd need to create an app that would need to sit on a server somewhere and run periodically to do the import.

Unless I'm missing something. Is there an easier way to do this?

Re: Automated Data Imports from SFTP

Sanford Whiteman Jan 18, 2017 7:13 AM (in response to 4fe3365d8f0c268556e5458f762903f72f21dc7d)

Question should be moved to Products. "Community" is for questions about the Marketo Nation website itself -- and yes, this is confusing.

Anyway, your impression is correct. Marketo does not have a scheduler for import jobs, and does not support pulling from SFTP. You'd have to build an integration tier that downloads on a schedule from SFTP, transforms, and uploads via API.
Like Show 0 Likes(0)

Actions
Re: Automated Data Imports from SFTP

Igor Ignatov Aug 10, 2018 9:11 AM (in response to 4fe3365d8f0c268556e5458f762903f72f21dc7d)

The easier way for export CSV from SFTP to Marketo automatically is to use any of these 3rd-party services available on Marketo Launchpoint:

- https://launchpoint.marketo.com/devart/marketo-integration-by-skyvia
- https://launchpoint.marketo.com/empathy-logic-inc/empathy-logic-cloud
- https://launchpoint.marketo.com/trayio/tray-io
Like Show 0 Likes(0)

Actions

Go to original post