How to extract values from Json and save in excel

[thima (Himabindu)]

Hi All,

I need to extract phone number,service provider id and groupid from json file.
iam trying to extract errors are coming.

Can someone help me.
jason.txt (83.1 KB)

Thanks,
Hima

[AdityaVN (Aditya Vaddiraju)]

Hi @thima

based on the attached file, it is a JSON arrya, you need to use Deserialize JSON Array activity.
If you could share the errors may we can understand what is going wrong

[thima (Himabindu)]

Hi,

I tried above method getting issue.
“Object reference not set to an instance of an object”

[AdityaVN (Aditya Vaddiraju)]

Hi @thima

each element in JSON array is xml. So you need to use Deserialize XML (on item within for each loop) to get service id, phone no. etc