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.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Doug_Apicella 45 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
William_Lima 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No