This full video tutorial will show, how to make API calls in UiPath, work with the data (JSON parsing) and update an Excel sheet with it. If you understand API calls, you will be a much better RPA developer and it's really easy if you follow this step-by-step guide.

You could also watch:
🔵 UiPath Rest API Calls & JSON Parsing -    • UiPath | Make REST API calls, JSON pa...  
🔵 UiPath REFramework Full Tutorial -    • UiPath REFramework - Full Tutorial - ...  

0:00 Intro to the UiPath API Case
We want to lookup addresses with the Google Cloud API and get the corresponding coordinates.

1:37 Create an API key in Google Cloud Platform

2:03 Using the Google Cloud Geocoding API
In the Developers Guide find the template for the API endpoint and the corresponding JSON.

2:59 Inspecting the JSON array
The endpoint is a JSON array, which we can work within UiPath.

4:18 Installing the Web Activities package in UiPath
Install the UiPath.Web.Activities package to use the API activities in UiPath.

4:52 HTTP Request activity
We paste in the endpoint in the HTTP Request property. The resulting JSON string is written out in a simple Write Line.

7:25 Deserialize JSON
UiPath has a buildin activity for deserializing JSON's. The input is our JSON Object from our HTTP Request.

8:22 SelectToken with LINQ
We use the LINQ function SelectToken to refer to the JSON three. The SelectToken lets us use a simple hierarchical syntax.

12:20 Reading our Excel data
Use the UiPath activity 'Excel Application Scope' to work with the Excel activities. Again use a Read Range to read the Excel sheet into a Data Table.

13:46 Dynamic HTTP Request
Using a For Each Row to iterate through our Data Table and do dynamic REST API Calls.

16:40 Write our REST API results to Excel
We are using the 'Write Cell' from the Excel activities combined with an index counter.

--
👨‍👩‍👧‍👦 Join the Discord family:   / discord  

--
Follow me on:
👉 LinkedIn:   / andersjensenorg  
👉 Twitter:   / andersjensenorg  
👉 Instagram:   / andersjensenorg  
👉 Facebook:   / andersjensenorg  
💌 Email Newsletter: https://andersjensen.org/email-newsle...

#uipath #rpa #automation