Get te data from an array in JSON

(0) Share

Report

Posted on by William_Lima

Hey guys,

Can someone help me out?. Im trying to parse a Json that looks like this:

{
Campos: [
"Prefixo",
"DataHora",
"GPS_Latitude",
"GPS_Longitude",
"GPS_Direcao",
"Linha",
"GTFS_Sentido",
"Velocidade",
"IMEI"
],
Dados: [
[
"442526",
"25/06/2020 14:06:31",
-15.83956,
-48.128787,
0,
"361.1",
1,
0,
"358197040754337"
],
[
"444731",
"25/06/2020 14:07:08",
-15.786168,
-47.943036,
67,
"0.383",
0,
56,
"358197040769939"
],

The problem is, i need to separate all values of every array to use in a report later on. As the data dont have a label, im not sure how to do it.

Does someone have any idea on how to work on this?

Thank you in advance.

All responses (2)

Answers (0)

William_Lima 2 on at

Like (0)

Report

Re: Get te data from an array in JSON

Hey Doug,

Thanks for responding, but my problema is really bigger. My request now has 500 arrays in "DADOS", and im not sure how to do the steps you mentioned it.

Could you help me all the way?

Thanks.
Doug_Apicella 45 on at

Like (0)

Report

Re: Get te data from an array in JSON

@William_Lima You can use multiple Parse JSON actions to parse each section so one ParseJSON would be the Campos element and the next would be Dados and so on. Odd that your JSON doesn't have any labels as that would be the easiest option to referencing them once you parse each section. Once you parse the JSON section you can do a Compose to split the values:

split(body('NameofParseJsonActionHere')',')

That gets you about half way as you will probably then need to do a count of how many values you get out of it.
You can then reference each item later in your flow: outputs('compose')?[0], where [0] is the index position of the element we want to get.

Hope that helps!

Doug

Community site session details

Get te data from an array in JSON

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Using Connectors

Featured topics

Product updates

Community site session details

Get te data from an array in JSON

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Using Connectors

Featured topics

Product updates