Answered

Convert CSV file to JSON

(0) Share

Report

Posted on by karenlacey

Hi, I have created a flow which converts a CSV file into JSON. however the JSON file is not in the correct format required.

It is creating the .JSON file in this format

It should look something like this

Any ideas around this?

Thanks

Karen

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Can you show the actions you are using to convert the CSV to JSON? There are third party actions that can do this, but nothing built in that will do it directly.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Verified answer

karenlacey 58 on at

Like (0)

Report

Hi Paul, I just found this solution and built it within Power Automate and the output is what I am after. How To Parse any CSV to JSON Array - DamoBird365

The output is this which I can use.

[
{
"lineItemID": "Line1",
"previousLineItemID": "NULL",
"employeeID/employeePpsn": "1234567X",
"employeeID/employmentID": "1",
"employerReference": "RefLinkX",
"name/firstName": "Alpha",
"name/familyName": "Bloggs",
"address/addressLines/0/addressLine": "LaneX",
"address/addressLines/1/addressLine": "NULL",
"address/addressLines/2/addressLine": "NULL",
"address/county": "Dublin",
"address/eircode": "A12B3C4",
"address/countryCode": "IRL",
"dateOfBirth": "01/01/1960",
"category": "SMALL_BENEFITS_EXEMPTION",
"subCategory": "NULL",
"numberOfDays": "NULL",
"paymentDate": "01/01/2024",
"amount": "100.789"
},
{
"lineItemID": "Line2",
"previousLineItemID": "NULL",
"employeeID/employeePpsn": "1234567Y",
"employeeID/employmentID": "1",
"employerReference": "RefLinkY",
"name/firstName": "Bravo",
"name/familyName": "Bloggs",
"address/addressLines/0/addressLine": "LaneY",
"address/addressLines/1/addressLine": "StreetY",
"address/addressLines/2/addressLine": "NULL",
"address/county": "Galway",
"address/eircode": "A12B3C4",
"address/countryCode": "IRL",
"dateOfBirth": "01/01/1960",
"category": "TRAVEL_AND_SUBSISTENCE",
"subCategory": "TRAVEL_VOUCHED",
"numberOfDays": "NULL",
"paymentDate": "01/01/2024",
"amount": "100"
},
{
"lineItemID": "Line3",
"previousLineItemID": "NULL",
"employeeID/employeePpsn": "1234567Z",
"employeeID/employmentID": "1",
"employerReference": "RefLinkZ",
"name/firstName": "Charlie",
"name/familyName": "Bloggs",
"address/addressLines/0/addressLine": "LaneZ",
"address/addressLines/1/addressLine": "StreetZ",
"address/addressLines/2/addressLine": "TownZ",
"address/county": "Cork",
"address/eircode": "A12B3C4",
"address/countryCode": "IRL",
"dateOfBirth": "01/01/1960",
"category": "REMOTE_WORKING_DAILY_ALLOWANCE",
"subCategory": "NULL",
"numberOfDays": "30",
"paymentDate": "01/01/2024",
"amount": "100"
},
{
"lineItemID": "",
"previousLineItemID": null,
"employeeID/employeePpsn": null,
"employeeID/employmentID": null,
"employerReference": null,
"name/firstName": null,
"name/familyName": null,
"address/addressLines/0/addressLine": null,
"address/addressLines/1/addressLine": null,
"address/addressLines/2/addressLine": null,
"address/county": null,
"address/eircode": null,
"address/countryCode": null,
"dateOfBirth": null,
"category": null,
"subCategory": null,
"numberOfDays": null,
"paymentDate": null,
"amount": null
}
]

Was this reply helpful? Yes No