Is there any way to call REST API and put result into in excel

Hi,

I need to call the API from other application and store resultant data into the excel sheet.

How can we call rest API through the custom scripting?

Hi @abhimanyu_thit , you can use Custom Action - Script to call a REST api, save the result in a variable and then use Excel - Set Range to get all the data in excel sheet. You have to tread your way in the middle of this processs i.e. how will you read your resultant data i.e. json/xml and then convert it into tabular data.

1 Like

Thank you very much @stuti.verma !!, found your code base How to add my working code sample to Knowledge Base?

2 Likes