How to move RestApi data to excel

Help Activities
, , , ,
1

Hi Team,

I have RestApi key , i just want to call api output to excel file, i tried to add endpoint and row number, but i couldn’t able to get success status in HTTP request

Apl data like,

“Abcd”:7878, “email":"abc@gmail.com”, “mobile”:“88888777”

Excel:
Abcd email mobile
7878 abc@gmail.com 88888777

Please help anyone to get out from this.

Regards,
Raja G

2

Use Deserialize JSON and store object into a data table and copy that to Excel using Write range activities!

1 Like
3

@naveenchvm ,

I have followed the same procedure but in that example endpoint(http:abcd123/+row.item(“columnname”).tostring) this type of endpoint i pass to http req but i couldnt able to get status code 200

i am getting 404 error

Regards,
Raja G