Convert JSON output into CSV table in logic apps

SPK545 36

hello,
I'm trying to execute the below use case by using logic apps

I'd like to design logic app flow where it connects with Azure resource graph explorer and provide me the list of virtual machines details in CSV format
As part of that, I'm testing the CSV table flow where I see the error as shown below

My flow:

please let me know how what I need to use to convert JSON out into a CSV table, later I need to move this into the database

JayaC-MSFT 5,606 Reputation points

2020-12-21T08:34:34.437+00:00

Hello @SPK545 , I see that the type of the variable is an "Object". As the values in the response is object you may try :

1) Parse the JSON response.
2) Create an Empty array variable.
3) Append the Parse JSON body into this array variable and then pass that value to the next action. Something similar to :

Let me know if this helps!
SPK545 36 Reputation points

2020-12-21T19:51:17.907+00:00

thank you @JayaC-MSFT , i did the above process, and i see the CSV file uploading into my blob container, the one

primary issue I'm seeing that data is not parsing correctly (attached the o/p CSV screenshot ), all the output data

coming as combined data in a
a
a single cell that's hard to read,

here is my flow

50074-image.png

I'm looking for something we can read as Key-value pairs such as below

I'm sure that I'm missing something in the JSON parsing part, but not sure what should be changed

Your answer