CSV Export
The CSV Export node allows data in the form of JSON Maplist to be passed into the node, along with a destination S3 bucket.
CSV Export is a utility node which can accept inbound data as a JSON Maplist. If this data is successfully converted to a CSV file, using the standard Python CSV module, it creates a CSV file with a unique name that is generated during run-time, followed by its upload to the destination S3 bucket.
It subsequently returns this S3 bucket along with the actual key (CSV File name) to the caller workflow.
CSV Export in a Spot Connect workflow enables you to:
- Export raw tabular data coming from another source as CSV.
- Perform simple conversion of JSON Maplist to CSV.
- Upload the converted data into an S3 bucket which can then be accessed from subsequent steps.
Configure CSV Export in Spot Connect
From the workflow builder in the left panel, drag and drop the CSV Export node in the workflow editor.
Details needed to set up a CSV Export node in Spot Connect:
| Parameter | Description | Required | |
|---|---|---|---|
| Input Data | Inbound data in the form of JSON Maplist, which may be fed manually, or from one of the last steps of a workflow. | True | |
| S3 Bucket | The destination S3 bucket where the output CSV would be placed. | True |
CSV Export node in action, with the input data fetched from the last step.
Sample JSON Maplist Data
When the execution is complete, the output of the node can be found in the Executions page.
- In the left main menu, click Connect and Executions.
- Click Executions and Execution Detail
<Workflow Name: Version>. - Click the Outputs tab.