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

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:

end-results-sheet-to-json

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:

  1. The workflow is triggered by another workflow calling it via the callable trigger.

  2. A file is downloaded from the specified AWS S3 bucket, based on the file name received through the trigger.

  3. The Branch connector determines the type of the downloaded file and sends the downloaded file on the appropriate branch.

  4. Next, a CSV file is created and stored in a Data Storage.

  5. Later, this CSV file is fetched and converted into a JSON file.

  6. This JSON data is then returned to the calling WF.

complete-wf

Step-by-step Explanation