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

[@andersjensenorg]

Watch this quality REST API Tutorial as well: kzbin.info/www/bejne/fpq2kJ-HZtyVepY Then everything will be covered 😊

[@gattuakhil2319]

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

[@andersjensenorg]

Hey Gattu. Thank you very much and for letting me know 😊 Kind regads, Anders

[@thamizhthendral4221]

Thank you Anders! Very well explained 🙏

[@andersjensenorg]

Hey Thamizh. Thank you and very nice you took the time to write me. It helps me a lot 🙂 Kind regards, Anders

[@mayur3049]

Superb Great Going.

[@andersjensenorg]

Thank you for the nice words 🙂

[@mscoder9902]

Thank you Anders

[@andersjensenorg]

Hey MS Coder, I'm happy, that your're still around and giving me nice comments 🙂 Kind regards, Anders

[@ashwina.k5602]

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 KZbin as well! Kind Regards Hsa

[@andersjensenorg]

Hey hsa ok. Sorry for the late response. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@rajashrees992]

Good explanation!Thanks

[@andersjensenorg]

Thank you 🙂

[@aldoernestosalazarlavado2645]

thanks a lot

[@andersjensenorg]

Hey Aldo. I'm happy, that you can use it. Kind regards, Anders

[@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.

[@andersjensenorg]

Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@diegonoriega2797]

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

[@andersjensenorg]

Hey Diego. What's the exception message? Kind regards, Anders

[@diegonoriega2797]

@@andersjensenorg Hi Anders! It's: Main.xaml: Se encontraron errores del compilador al procesar la expresión "{row.Item("City").ToString, strTemperature, strSky, strHumidity, strWind}". Un valor de tipo '1-matriz dimensional de String' no se puede convertir en 'System.Data.DataRow'.

[@lakshmikanthlucky5559]

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

[@andersjensenorg]

Hey LakshmiKanth Lucky Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@varunshinde3437]

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.

[@andersjensenorg]

Hey varun shinde Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@amandeepkaur-ck3ti]

Hi Anders I am getting an error in deserialize JSON. Deserialize JSON : Unexpected character encountered while parsing value :

[@andersjensenorg]

Hey Amandeep. Can you paste in the JSON (anonymize private material)? Kind regards, Anders

[@amandeepkaur-ck3ti]

@@andersjensenorg "vejr.eu/api.php?location=London&degree=C"

[@rajalakshmihariharan6987]

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 ?

[@andersjensenorg]

Hey Rajalakshmi. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@Taushif448]

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) 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..?

[@andersjensenorg]

Hey Taushif. It's because it's a JSON array and not a string. You can use this guide: kzbin.info/www/bejne/qpLTnnhrjs6Cbrs Let me know, if that helps you? Kind regards, Anders

[@Taushif448]

@@andersjensenorg Thanks Anders for your quick response. I tried the same scenario(End point: vejr.eu/api.php?location=London&degree=C) as of yours with Deserialize JSON and Deserialize JSON Array activity (as mentioned by you). But getting the above mentioned error for Deserialize JSON activity and Deserialize JSON Array: Error reading JArray from JsonReader. Current JsonReader item is not an array: StartObject. Path '', line 1, position 1. for Deserialize JSON Array activity. Could you please mail([e-mail]) me the xaml file of the above scenario..?

[@sadigoubarry1175]

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 /v3/company//invoice Content type:application/json Production Base URL:quickbooks.api.intuit.com Sandbox Base URL:sandbox-quickbooks.api.intuit.com) ----- Sandbox Base company is a dummy company they create for you after you sign for a trial. please find below the link developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/invoice#create-an-invoice Thank you.

[@andersjensenorg]

Hey Sadigou Barry Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@shubhambhattacharya1618]

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

[@andersjensenorg]

Hey Shubham. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders