How to convert json to csv inside logic app inline javascript

Question

Hi I am new to azure logic app and recently there is a requirement to convert incoming messages from service bus queue to csv. There are going to be 500 records. We have already js code to convert to csv and mapped to fields as per our mapping file. But in my case the json records coming are multiple record and the existing code expects only one object. I want a javascript code to handle multiple records. Uploading my input json as well as the existing js code. Can anybody help me with js code please

Below is the existing js code we use

Answer 1

Thanks for posting your question in the Microsoft Q&A forum. May this model can help you to do dynamic assignment

function jsonToCsv(records) {
    // CSV header (extract field names from the first record)
    var header = Object.keys(records[0]).join(",");
    var csv = header + "\n";

    // Iterate over each record and add to CSV string
    records.forEach(function(record) {
        var values = Object.values(record).join(",");
        csv += values + "\n";
    });

    return csv;
}

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

Answer 2

Hello @Shama - Thanks for reaching out, and engaging us on the MS Q&A community.

Logic Apps provides an easier way to handle the JSON to CSV conversion, please review the following doc: Create CSV table action

We recommend using the solution described in that doc, and moving away from the Javascript-based approach which may be error-prone and slow for large data sets. Inline Code is great for quick, stateless code/logic.

Hope this helps. Feel free to tag me in the comments below if you have any follow-up questions

---

Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.