Can Celigo produce csv output and the csv file be sent to a specific location or email address?

Integrator.io
1

I am curious. Can Celigo produce csv outputs and the csv file be sent to a specific URL location or to an email address periodically?

2

bump I also would love to know this

3

When you say "to a specific URL," what do you mean?

As for sending to an email, this is possible as well. What email service are you using?

4

We've done this with SFTP and email.

5

Specific URL I mean an end point like for example ( website.org). For email, I am using custom email service or own domain. Thanks!

6

Lee, It's great to hear that you've accomplished such a task. Some guidance on how to achieve this would be highly appreciated. Thanks!

7

If you're using an HTTP connector, there are a few caveats. The HTTP connector will not aggregate multiple pages of data into a single CSV file to be sent, but it can send a CSV file per page of records. If you need lots of data to be aggregated and sent, it's best to make one flow that gets all records and creates a CSV file in a file provider location like FTP, S3, Google Drive, NetSuite file cabinet, etc., then have a second flow to pull that file and not parse it, then send it off. Alternatively, if your record volume is low, you could just increase your page size on the export so more records get into a single page.

The image shows a form interface for configuring HTTP import settings, including fields for HTTP method, request media type, and headers. (Captioned by AI)
The image shows a form interface for configuring HTTP import settings, including fields for HTTP method, request media type, and headers. (Captioned by AI)1536×1510 152 KB

The image shows a "Create import" interface with options for configuring CSV file imports, including settings for headers, delimiters, and text replacements. (Captioned by AI)
The image shows a "Create import" interface with options for configuring CSV file imports, including settings for headers, delimiters, and text replacements. (Captioned by AI)1532×1548 153 KB

8

Thank you, Tyler. This info gives me a head start. I dont have many records but about 350 records aggregated together. Increasing the page size on the export seems like a better option to get more records on a single page. Otherwise, I'll create a flow to gather all records and generate a CSV file in a file provider location like FTP, S3, Google Drive, or NetSuite. Thanks again for your guidance. Much appreciated.

9

Sorry about that @Zachary_Kagunda I had to jump on a call. We create the csv, then separately we push the file to a secure directory. It's relatively straightforward, once we were up and running, these processes pretty much just go without too much worry. Every once in a while something times out, but it really doesn't happen that often for us.

10

No worries @Lee_Epstein. Thank you for the information you have provided—it's incredibly helpful.

1 Like