How to get the correct values in the JSON file?

[minhduc]

Hello everybody

I currently have a JSON file and I want to get the values ​​REQUESTOR, Group Leader, Section Manager, Purchased, Operation Manager.

But the one thing that is different is that my system is not order.

JSON example: REQUESTOR, Section Manager, Group Leader, …

Test.json (16.7 KB)

39/5000

And i also try read file JSON but error

So is there any way to get the values ​​I need?

Thank for all.

[Shikhar_Tandon]

Hi @minhduc,

Use deserialize JSON Array instead of Deserialize JSON

[minhduc]

Hi @Shikhar_Tandon

Sorry reply late time

It do active.

But you way any get values i want? Please share way any you think.

Could you example file .xml for me

Thanks you very much support me

[Shikhar_Tandon]

Hi @minhduc,

Can you provide a correct JSON file so that i can code it .

Thanks,
Shikhar

[minhduc]

Hi @Shikhar_Tandon

This is file JSON orgin
Test.json (16.7 KB)

Thanks you very much help me.

[Shikhar_Tandon]

Hi @minhduc,

try this it will give you all the values with request to what you wanted.
GetJsonVal.zip (36.6 KB)

let me know for any queries.
If this solves your problem mark it as a solution.

Cheers,
Shikhar

[minhduc]

Hi @Shikhar_Tandon

It work good

Thanks you very much