Import Data from REST API & Convert the JSON response to CSV output file

Question

Attaching an example of how the JSON Response would be, I now want to use Logic Apps to convert this Json output to a CSV File.

273044-samplepayload.txt

• I'm interested in only Data properties from the sample payload
• Data property array elements is not always the same, in this example it is 1440 but actually it keeps changing and it can be anything

Expected output as below -

CSV output example, when the data: Array1 -
"Time","Total"
"1671321610000","490"

CSV output example, when the data: Array[5] -
"Time","Total"
"1671321610000","490"
"1671321670000","494"
"1671321730000","480"
"1671321790000","476"
"1671321850000","470"

Answer 1

1. get the file content with the action OneDrive or OneDrive for Business, or get the data from a REST API with the action HTTP
2. parse the JSON data with the action Data Operations
3. create the CSV file, also with Data Operations. To specify the columns' name and the data, you need to choose the option "custom" in the field "columns" and enter the headers and values.
   See the screenshot:

result: