Templates / Universal / Get CSV or Excel File from AWS S3 and Return as JSON
Get CSV or Excel File from AWS S3 and Return as JSON
This callable workflow allows builders to easily extract data from CSV or Excel files stored in AWS S3.
This data is returned to your Workflow in JSON format, which is easy to work with.
The following connectors are used in this template. This is provided for reference only - there is no need to read through the linked connector pages, as all you need to know for this template is explained here:
This template will convert the data from an Excel sheet or a CSV file into a JSON format:
This workflow assumes the following:
You can authenticate with AWS S3.
In order to configure this workflow for use:
The overall logic of the workflow is:
The workflow is triggered by another workflow calling it via the callable trigger.
A file is downloaded from the specified AWS S3 bucket, based on the file name received through the trigger.
The Branch connector determines the type of the downloaded file and sends the downloaded file on the appropriate branch.
Next, a CSV file is created and stored in a Data Storage.
Later, this CSV file is fetched and converted into a JSON file.
This JSON data is then returned to the calling WF.