Extract AWS S3 data as JSON

Workflow

Universal

Intermediate

Use Template

This is a 'Workflow' template which means that it is a single standalone workflow.

Some workflow templates can be modified to work with other workflow templates - e.g. to convert a data sync between two services from uni-directional to bi-directional

Overview

Copy

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

Copy

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

Copy

This template will convert the data from an Excel sheet or a CSV file into a JSON format:

Prerequisites

Copy

This workflow assumes the following:

• You can authenticate with AWS S3.

Getting Live

Copy

In order to configure this workflow for use:

Workflow logic

Copy

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.

Step-by-step Explanation

Copy