How to convert CSV table data output to JSON?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

csv data.png

Above image is the output of the CSV table. How can I convert it to JSON so I can parse it? Thank you!

Categories:

Building flows

All responses (22)

Answers (0)

Sort by

SCTdan 604 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately Flow is still completely lacking the ability to work with CSV data in this manner. Last I checked, this is about the only option- https://sergeluca.wordpress.com/2018/10/28/microsoft-flow-advanced-tutorial-creating-a-csv-converter-from-scratch/
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

So are you confirming that CSV data can only be converted if the values are declared and not the data on my screenshot which is from an external system? Thanks!
SCTdan 604 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, it can be, just not easily. In cases where I need to work with csv data, I do whatever I can to convert it to a more usable format before it hits flow. Ideally you'd want to get the data in as JSON, or as an actual excel document with the data in a table.

I suppose I should ask, are you meaning to fully automate this from your external system into flow? Because you can use powershell to convert csv to json in a single command as an intermediary step.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, with Flow as much as possible cause this is the app that we use as bridge for data exchange of our two systems.
SCTdan 604 on at

Like
a
(0)

Report
Copy link

Link copied!

Let's step back. How are you getting the data into the flow, and how are you getting it into the csv table? Can you post the flow up to that point?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Above are the pictures of my flow and the detailed flow.
SCTdan 604 on at

Like
a
(0)

Report
Copy link

Link copied!

Based on that it appears you already have the JSON. Your 'Parse items' step should be giving you the parsed JSON from the HTTP call. I'm assuming you created the schema there by pasting in what you got from the HTTP call?

Can you post the output from the HTTP call and the Parse items action?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

My obective is to create a CSV table in Flow then make the API calls run multiple times in getting data on the created CSV table instead of getting the from the external system so I can reduce the number of API calls per day. Thank you.
SCTdan 604 on at

Like
a
(0)

Report
Copy link

Link copied!

There's no need to put it into a csv table, you can work with the parsed JSON data as is.

What do you want to do with the data next? We can go through an example of how to access it.

edit: Flow itself cannot store data between runs if that's what you mean. Each time you call the flow, it's going to make the API call. You would need to store the data externally (spreadsheet, sharepoint, etc) and reference it from the flow.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Originally, my flow after the parsed items would be a POST method that runs to each record and makes the API calls count for every record. I would like it to happen only once so the API call would count only one.