UiPath | Make REST API calls, JSON parsing and write to Excel/CSV | Tutorial

This guide teaches you how to work with REST API calls, extract the data from the JSON string, deserialize the JSON string to a JSON object and finally write the data to Excel/CSV.
The case in the video is about reading data from an Excel/CSV sheet, making REST API calls, getting the JSON data, working with the data and finally writing the data in the corresponding Excel cells.
You could also watch:
🔵 UiPath Advanced Use Cases - • UiPath Advanced Use Cases
🔵 UiPath REFramework Full Tutorial - • UiPath REFramework - F...
01:30 How the UiPath Robot works in the user interface
Presenting the API/JSON parse use case.
02:35 Install package (JSON, REST, SOAM, XML)
We install the package web.activities in the UiPath Mangage Packages.
03:00 HTTP Request
In an HTTP Request we specify an endpoint and an output. We get the output in a JSON variable.
03:55 Deserialize JSON
Convert the JSON to data we can use.
04:14 Create JSON Object
04:35 Extract the data from the JSON Object
05:51 SelectToken (LINQ)
We can apply LINQ to our expression to simplify our expressions.
07:17 Read input data from Excel/CSV
Now we can create our use case, where we read data from Excel/CSV and use it to create several dynamic REST API Calls.
09:38 Creating a dynamic selector to the HTTP Request
Make the endpoint dynamic in the HTTP Request.
11:40 Get the individual data out
The data from the REST API call is stored into string variables.
13:58 Add Data Row
The string variables are written into DataRows.
15:49 Output the data to Excel/CSV
We add the DataRows to Excel.
Connect with me:
🔔 Subscribe - www.youtube.com...
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - andersjensen.o...
#uipath #rpa #automation