Logic App workflow that retrieves JSON data from an HTTP request and converts it into a CSV format

Step 1: Create a Logic App

1. Go to the Azure portal.
2. Click on Create a resource > Integration > Logic App.
3. Provide a name, subscription, resource group, and location for your Logic App.
4. Click Review + create and then Create.

Step 2: Add an HTTP Trigger

1. Open your Logic App in the designer.
2. Search for the HTTP Request trigger and add it.
3. Save the Logic App. This will generate a URL for the HTTP endpoint.
4. Copy the URL for testing later.

Step 3: Parse JSON Data

1. Add a new action after the HTTP trigger.
2. Search for Parse JSON and add it.
3. In the Content field, select the Body from the HTTP trigger.
4. Provide a JSON schema for the incoming data. For example:
   
    

   {
     "type": "array",
     "items": {
       "type": "object",
       "properties": {
         "id": { "type": "integer" },
         "name": { "type": "string" },
         "email": { "type": "string" }
       }
     }
   }

   This schema assumes the incoming JSON is an array of objects with id, name, and email fields.

Step 4: Create a CSV Table

1. Add a new action after the Parse JSON action.
2. Search for Create CSV table and add it.
3. In the From field, select the output of the Parse JSON action.
4. Specify the columns for the CSV table. For example:
   • Column 1: Id
   • Column 2: Name
   • Column 3: Email

Step 5:  Send the CSV File

1. Add a new action after the Create CSV table action.
2. Search for Gmail (or your email provider) and select Send email (V2).
3. Connect to your email account.
4. Fill in the email details (To, Subject, Body).
5. In the Attachments section:
   • Add the Create CSV table output as the attachment content.
   • Specify a file name (e.g., data.csv).