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 - Full Tutorial - Examp...   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 - http://www.youtube.com/user/klogeande... 💼 LinkedIn -   / andersjensens   👥 Facebook -   / andersjensenorg   💌 Email Newsletter - https://andersjensen.org/email-newsle... #uipath #rpa #automation