JSON API Array


#1

Guys,

I need help, i have a API that i need extract to extract objects and arrays and input the values on Excel, the objects and arrays with 1 object i can extract fine, but when i have a array with more then one object i cannot.
I’ve tried for each loop, but couldn’t get it done.

Exemple:
In “qsa” array there is more then one object named “nome” , but i cant get all of them.

API exemple Link: https://www.receitaws.com.br/v1/cnpj/27865757000102/

Can u guys help me?

Thanks!


#2

Hi @Carlospolli,

Check the following .xaml file. Let me know if you have any doubts in this.

Steps followed:

  • Used HTTP Request to retrive the response from the endpoint URL https://www.receitaws.com.br/v1/cnpj/27865757000102/
  • Deserialised JSON to Jobject type
  • Looped through Jobject(“qsa”) and inside the body of the loop, get “nome” attributes value using item(“nome”).ToString

Test.xaml (10.9 KB)

Let me know if you have any issues.

Thanks & Regards,
Dominic


#3

Thanks, Dominic!

That was super helpful.

Regards,
Carlos


#4