How to extract the ByDesign Odata Report in iRPA

[Janarthanan]

Hi Everyone,

I have Business ByDesign OData report, The ODATA URL with username and password, it displays the records in JSON format which I have to download in an excel file Presently this manual option. Now I am looking iRPA bot to execute the below manual procedure and download the JSON file automatically using, below is my manual procedure

1. Enter the URL in Browser

2. Login with a username and password

3. Download the report in JSON format

Can anyone help me with how to do the above procedure to build the iRPA?

Regards

Janarthanan

[vishal]

Hi janarthanan_iss,

Please check if below helps..

• Web Services Best Practices
• Reading/Writing JSON Files

Regards,

Vishal Rathi