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:

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)

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:

#uipath #rpa #automation

[thamizhthendral]

Thank you Anders! Very well explained 🙏

[gattuakhil]

You are always the best. Thanks Anders for the awesome video

[rekp]

Wondering how to input parsered data into same data table(columns pre-created) instead of create a new DT?
I've tried using Update Row Item to write JsonObject into CurrenRow item, but error BC30574 Option Strict On disallows late binding occurs.

[ashwina.k]

Wonderful tutorial Anders!
I was wondering, when you first drag in the HTTPS Activity, an HTTPS Wizard shows up correct? But once we add values/parameters and close it, we can't open it again right? Or is there a way to reopen the wizard without having to delete it and drag in a fresh HTTPS Activity?

Reason being, I can test the response within the Wizard itself, which is pretty convenient. If this isn't possible, then what is your go to method for testing API responses? I think there is some quality content that can be made out of this for YouTube as well!

Kind Regards
Hsa

[diegonoriega]

Hi @Anders, I've an error in the ArrayRow in input in "Add data row" and I put it exactly as you said it, the expresion is: {row.Item("City").ToString, strTemperature, strSky, strHumidity, strWind} Regards

[rajalakshmihariharan]

Hi I am not able to set the Output variable as mentioned. Its just gives me set of predefined options and not allowing to to create a variable with ctrl k. Any clue ?

[amandeepkaur-ckti]

Hi Anders
I am getting an error in deserialize JSON.
Deserialize JSON : Unexpected character encountered while parsing value : <. Path", line 0, position 0.

[shubhambhattacharya]

Getting error in Multiple Assign activity. "RemoteException wrapping Object reference not set to an instance of an object". Any idea how to resolve it

[Taushif]

Hi Anders
I am getting below error in Deserialize JSON
Deserialize JSON: Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'Newtonsoft.Json.Linq.JToken' because the type requires a JSON array (e.g. [1, 2, 3]) to deserialize correctly.
To fix this error either change the JSON to a JSON array (e.g. [1, 2, 3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.
Path 'error.code', line 1, position 117.
Could you please help me..?

[varunshinde]

Hi Anders!!! Varu nfrom India/. Please make Complete Tutorial on AI Call. like how API call is made in Ui Path and how data from APi Call is used within the workflow.

[lakshmikanthlucky]

Very Helpful video:) Can u pls share the xmal file here

[sadigoubarry]

Hey Anders, Thank you for this tutorial. Have you ever tried to connect uipath to QuickBooks? The preview response always give an error. for example to post an invoice they give 3 different url (POST

Content type:application/json

Sandbox Base company is a dummy company they create for you after you sign for a trial.
please find below the link

Thank you.