Has anyone ran into the need of automating data loading?
The usage here will be that we frequently run into the need to load leads into the database, with files ranging from a few tenths to thousands of records. We want to use Marketo instead for salesforce since marketo performs deduplications and handles fields update better.
The columns header can be standardized as necessary so that field mapping could be made automatic. What needs to be automated is the ability to send a file (or a file URL) to marketo and have marketo launch the import. We could imagine to have the URL containing information such as the list and/or program into which the files has to be imported.
Has anyone run into the same need? Has anyone come with a solution? Do you know if Marketo's API can be used for this?