Is it possible to access the API like this and then go to excel using uipath studio?

Help Studio
, ,
1

Please Help !!
i have API access request with token. API access to retrieve certain data in the form of Json files.

After getting the JSON file from the API, take certain data again to copy it into an Excel file.

is it possible to access the API like this and then go to excel using UiPath studio?

Thankyou

2

Yes you would use the HTTP Request activity to make the API call, then parse the JSON, then Use Excel File and Write Range to write to an Excel file.

There are free tutorials for these things at academy.uipath.com as well as tons of information in the forums and documentation.

3

I have successfully carried out an HTTP Request and output data in the form of json

then how can I take only some data from Json data in HTTP and convert it into Excel data and then save it.

4

Before that can be answered, you have to show us the JSON. How to parse it depends on the format.

In general what you do is convert the data to a datatable, then use Write Range to write to Excel.