I understand to use the Data loader for working with CSV files but those don't allow for lookups and branching. Is it not possible to use a csv file load on an integration flow without having to create an FTP connection? We just need to load the file locally and run the flow that way.
You would need a file provider to place the file and have a normal flow grab it from there. That could be NetSuite file cabinet, S3, FTP, Box, Google Drive, Dropbox, Azure Blob, etc.
@Daniel_P , We are working on a releasing a new connector that lets you pick files from your local system and gives you ability to schedule and configure just like a regular flow where you could use all the existing feature.
2 Likes
@Daniel_P You can also create an API which contains the lookups, branching, etc, and have the single step of the data loader flow be to call the API.
@friendoftuesday that’s a great idea
Sounds like a great idea but I am a bit confused how to connect the data loader to the API. Any help would be appreciated.
Here is some documentation on API Builder. Essentially you would make this API, then the import on data loader would call it.
https://docs.celigo.com/hc/en-us/articles/29494547815579-Create-and-manage-APIs-using-API-builder
@Daniel_P After you create the API following @tylerlamparter's link, you would need to create a connection to Celigo (just like any other application, except it doesn't count against your subscription).
The Celigo connector doesn't load API's created from API builder automatically yet, so you would need to use the HTTP view and enter the URL manually.
Hope that makes more sense!