How to convert JSON output in a CSV and store in Azure Blob storage using logic apps?

Question

We have a requirement where we need HR data in Microsoft Entra ID.
We have configured a logic app which gets the data using Rest API call and wants convert this data from JSON output to CSV.
Then we have to store this CSV in blob storage from which we can POST users in Microsoft Entra ID.
Below is my our logic app which returns the output every user but while creating blob the output shows something like : 2003,Arjun,Pandey2010,Saurabh,Shukla2009,Paul,Martin2001,Kunal,Khushwaha2007,Satish,KumarEMP001,IceHrm,Employee2006,Suraj,Varma2002,Ram,Kumar2008,Sam,Parker2004,Ajay,Patil3018,James,Smith3001,Rajiv,Shah3002,Ramesh,Dey2005,Sumit,Gurav2011,Vikram,Mehta2012,Mahesh,Jagtap3003,Sameer,Dev

Is there any way to store this as a .csv content.

Answer 1

Hi @Akash Thorat,

Instead of using a variable and appending the string, there is a data operation that will take an input and create a CSV table. Have a look at Perform operations on data - Azure Logic Apps | Microsoft Learn. You should be able to use the output from your Parse JSON from IceHrm as the input to this data operation.