How to do API calls in UiPath | Full Tutorial

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:

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.

--

--
Follow me on:

#uipath #rpa #automation

[valtallica]

I cannot express how much these videos have helped me learn the software. Thank you for making it easy!

[spiritualsecrets]

One of the best explanation about web services of Uipath in you tube

[rs]

Outstanding! To the point, easy to follow, easy to understand - thank you, thank you, thank you!

[soubarnobanerjee]

Excellent Anders. The greatness behind your videos knows no bounds. Hats off to you to bring out your skills like this. I just have a small question: To make the Google Map API work, do I need to create a Google Map Billing account?

[aishwaryadas]

Am so thankful to find this video. Keep posting more videos related to UiPath.
Thanks a lot. :)

[amelieviennot]

Great demonstration on how to import data to uipath from the web using an API, read through that data with a json query to pick and choose what information we need and then write this data down in an excel sheet with a nice little trick of creating a row index variable to increment the cell lign for where the data needs to be written. What about exporting data from Uipath to the web ? I would like some data produced by uipath to be displayed live on a web page, how can we do that ?

[madurga]

Thanks for sharing the lesson. Appreciate it!

[marcinwrobel]

Outstanding video! I am doing API call with addresses which are repetitive and I wonder how would change for each activity so it wouldn't do API call in case it was already done in previous cell.

[anburenganathan]

Hi -
Thanks a lot. This is more one kind suggestion could you please zoom in so that we can see a video even more better.

[imitbunts]

It was really a great presentation, very informative and also simple to understand for a beginner like me.

However I have a noticed that in this use case you have not modified the "DataTable" and rewrote the "Excel Sheet" instead you have directly modified int the "Excel Sheet", Could you please explain the difference in both the approach.

[jgill]

Hello Anders, thanks a lot for this explanation. Do you have any advice on making an API call to google cloud natural language services, e.g. entity extraction? From what I understand it requires a google service account and using a json file as authentification, however I am having trouble making this work from an HTTP request & so far as I can see there is no pre-existing integration like there is with maps, speech etc. Thanks for your time. Jake

[sarahalshawkani]

Thank you Andres for sharing the knowledge. Very Appreciated.

[Mahesh-yesh]

Highly informative one, thanks for posting !!

[АнастасияКузьмина-ро]

Thank you, Anders, very interesting video!

[wearerunnersw.a.r]

Hi Anders,

Thank you for this information.

The one question have is when connecting to supplier or OEM APIs there is a .wadl file that I had to download.

What is the purpose of these files and how would I incorporate them into the process you illustrated in the video.

[indiagnit]

Hi Anders, Very helpful to understand API.

[jessicamiller]

Hi Anders, while taking json format it's showing like {
"error_message" : "This API project is not authorized to use this API.",
"results" : [],
"status" : "REQUEST_DENIED"
}, can you suggest solution for this, thank you

[anujdhoot]

Can you please create a POST API video, POST API with the usage of all options such as body, headers, parameter, resource type?

[ndeyefatoudiouf]

thank you for this video. i want to install API to verify IBAN Bank, is it possible?

[crazycats]

Hello there, thanks for the video. Really helped a lot! Wish you success. +1 like and subs for you