Templates / Extract AWS S3 data as JSON
Extract AWS S3 data as JSON
Overview
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.
Connectors Used
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:
End Result
This template will convert the data from an Excel sheet or a CSV file into a JSON format:
Prerequisites
This workflow assumes the following:
You can authenticate with AWS S3.
Getting Live
In order to configure this workflow for use:
Workflow logic
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.