How to do API calls in UiPath | Full Tutorial
ฝัง
- เผยแพร่เมื่อ 19 มิ.ย. 2024
- 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:
🔵 UiPath Rest API Calls & JSON Parsing - • UiPath | Make REST API...
🔵 UiPath REFramework Full Tutorial - • UiPath REFramework - F...
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.
--
👨👩👧👦 Join the Discord family: / discord
--
Follow me on:
👉 LinkedIn: / andersjensenorg
👉 Twitter: / andersjensenorg
👉 Instagram: / andersjensenorg
👉 Facebook: / andersjensenorg
💌 Email Newsletter: andersjensen.org/email-newsle...
#uipath #rpa #automation
![[FULL EP.69] #เอิร์นจิรวรรณ เปิดบ้านหมื่นล้านทุกมุม ครั้งแรก! l เคหสถานบานปลาย l One Playground](http://i.ytimg.com/vi/_J4_nw8c64o/mqdefault.jpg)
You should learn UiPath REFramework. That's the template for developing UiPath enterprise automations. It is fairly easy to learn and I have created this 1 hour tutorial: th-cam.com/video/LP5y51_n6BY/w-d-xo.html
I cannot express how much these videos have helped me learn the software. Thank you for making it easy!
Hey V G. Thank you so much. Your comments, feedback and support are helping me a lot!! Kind regards, Anders
Am so thankful to find this video. Keep posting more videos related to UiPath.
Thanks a lot. :)
Wow, thanks for the very kind words, Aishwarya 🙂 I'm always on the look for new ideas to videoes, so if you have some particular subjects, that could be good for videoes, please let me know.
Thanks for sharing the lesson. Appreciate it!
Hey Abhijit, thanks a ton for letting me know :) Kind regards, Anders
Thank you Andres for sharing the knowledge. Very Appreciated.
Hey Sarah - thank you 😊
Highly informative one, thanks for posting !!
Thank you very much, Mahesh 🙂
One of the best explanation about web services of Uipath in you tube
Hey Venkatkumar. That's very kind of you 🙂 Have a great day, Anders
Anders, You Teach with Passion Sir !
Hey Mahesh patel. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hi Anders, Very helpful to understand API.
Thank you, Sajid 😊 Kind regards, Anders
Outstanding! To the point, easy to follow, easy to understand - thank you, thank you, thank you!
Hey r s. Wow, that you very much 😊 Kind regards, Anders
And responsive, incredible! I'll take this opportunity to ask a question I've been struggling with (and what led me to your video). I'm using Airtable's API and Im trying to get all of the key:value pairs into a datatable to perform some activities with it but, i cant seem to figure it out. My Airtable data is too large to call each token into the sequence, and the attempts ive made have been unsuccessful.
Could you kindly point me in the right direction to accomplish my goal of getting key:value pairs from JSON into Ui Path as a datatable? A million thanks kn advance, Cheers!
@@rs832 Hey r s. Can you paste in a part of the JSON here AND tell me exactly, what you want out? Kind regards, Anders
@@andersjensenorg Here is a snippet of the json, there are another 20 fields following I didn't include. I'm trying to extract "status", "AP" & "Ad_URL" for about 600 records. Thank you in advance!
{
"records": [
{
"id": "rec06327beu58",
"fields": {
"Status": "ACTIVE",
"AP": 864,
"[BD]_Title": "widget",
"[BD]_Descrip": "widget details",
"Ad_Seller": "John Smith",
"Ad_Seller_Yr": "2018",
"Ad_Location": "Denver, CO",
"Ad_URL": "www.somedomain.com,
It may be worth noting the [BD] is not an array, its just the name of the field.
It seems like I need to loop through the array using a counter+1 to get the desired key:value pairs into a datatable - am I on the right track?
Thank you, Anders, very interesting video!
My pleasure!
very helpful video keep posting more
Hey Sanjay. Thank you very much 😊 Do you have any specific wishes? Kind regards, Anders
Nice lesson!
Many thanks 😊
Thanks for sharing the knowledge.
Hey Deepak. Thanks a lot for your support :) Kind regards, Anders
Thanks so much, this was helpful
You're very welcome, my friend 🙌🙂
Cool stuff Thanks for sharing
Hey ajish. Thanks a lot for writing, this help me a lot and pip up my mood :) Kind regards, Anders
Thank you Anders.
Thanks a lot, Fasulu Rahman 🤗 Your feedback helps me immensely. Kind regards, Anders
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?
Hey Soubarno. Thanks for the question and sorry for the late reply. 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: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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
Hey Jake. Thanks a lot for writing. Unfortunately not. Usually I have people around to tell me how humans would do (like make the Postman API call) and then I "just" replicate it in UiPath/Power Automate. Sorry, I cant help you further. Kind regards, Anders
very useful. thx !
Thanks, buddy! Now a subscriber for your channel, please deliver som nice hacks 😍🙂
@@andersjensenorg thx ! same for you, let us keep in touch :)
Thanks for sharing```
Thanks a lot, Rui Wu 🤗 Your feedback helps me immensely. Kind regards, Anders
superb
Hey Jagannath. Your many positive comments are valuable to me, both in terms of personal mood and in terms of the reach of my channel. Have a great day 🙂 Kind regards, Anders
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 ?
Hey Amelie
Great question. 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 simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
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.
Hey We are Runners. Thanks a lot! We need it do define the relationship in the contract between the two system (oh hello google search). In my experience, I've used it a lot in our legacy systems. Kind regards, Anders
@@andersjensenorg thank you for your response
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.
Hey Marcin. Thanks a lot 🙂 We need a way of keeping track of what has been done before, e.g. either remove duplicates from the sheet before the process is done or keeping a simple log, where we add the adress to a DataTable and before each call check if it's there. Let me know, if you need help. Kind regards, Anders
Very nice content Anders :)
Hey Taurus. Nice to see you around and thanks for attending the GK live session 🙂 Kind regards, Anders
@@andersjensenorg Thank you Anders😊
Nice
You're very welcome, Alberto Cavalcante - your support helps me a lot 😍
Hi -
Thanks a lot. This is more informative....... one kind suggestion could you please zoom in so that we can see a video even more better.
Hey anbu. Thanks for the nice feedback. And yes, I should be better to zoom on the code - sorry! Have a great weekend 😀 Kind regards, Anders
thanks Anders Jensen
Hey Saurabh. You're very welcome. Kind regads, Anders
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.
Hey i'M IT Bunts
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Hello there, thanks for the video. Really helped a lot! Wish you success. +1 like and subs for you
Hey Liu! Thanks a lot for the nice comment and help 🙋♂️😊
Will I need to create seperate flow for every API.. can we create a flow which can we used for multiple API.
Hey Amit. You can just create one flow and then have your endpoints in a list/array. If you're not sure, how to do it, I gladly make a video. Kind regards, Anders
Hi Anders,
Can you make a video on how to call external webhooks using uipath?
For example: We need to send post and get requests to external Webhooks.
Hey Sandesh. Check this: th-cam.com/video/6aDAKbC0Gjs/w-d-xo.html I'll make a longer one in September :) Kind regards, Anders
thank you for this video. i want to install API to verify IBAN Bank, is it possible?
Hey ndeye fatou Diouf
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
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
Hey Jessica. That is a problem with the API. You probably need to provide a key, before you can get the response. Kind regards, Anders
Can you please create a POST API video, POST API with the usage of all options such as body, headers, parameter, resource type?
Hey anuj dhoot
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
with end point to http protocol url i would like to post a json file and in the json file i have to parameterize some attributes can you tell me how,
Hey Srihari. Sure, check this: th-cam.com/video/HKxrAPxn5jA/w-d-xo.html 🙂 Kind regards, Anders
Hi. There is a website called eledo.online for pdf automation and I think they provide a api key. Can you make a video on how to use uipath on that site. They have integration with other rpa platforms but I think that uipath can do it but I would like to see how.
Hey Tobie. Sure. I can find this: eledo.online/documentation/api_reference But I am not sure, what to do with the application? Can you describe the case a little bit more? 😊 Kind regards, Anders
@@andersjensenorg That website I believe does document automation like filling in pdfs. They provide an api key and then you use another automation platform with the key. I can provide link to a vba automation combined with another automation platform to describe what I mean.
@@tobiewaldeck7105 Hey Tobie. Please do so, it sounds like an interesting video for me to make. Please remember to tag my name, as you do, otherwise I am missing the answer 😊 Kind regards, Anders
@@andersjensenorg Hi Anders.
Hai jensen
can you make a video on "How to find the duplicate values in a row".
Sure, I'll make it later today and let you know 😊
Hey arjunreddy0, is this a help for you? th-cam.com/video/DfsyF80ro1M/w-d-xo.html
Can you please help me to iterate this 'JSON_Object.SelectToken("data[0].title")' until data finishes?
Can you send the entire json here?
Hi Anders,
Can you tell me how to consume REST API using cookies as authentication?
It works on other clients, but Uipath returns 0
Ouch, can you post a screenshot in either my FB group or on the Discord: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@@andersjensenorg Hi Anders, Thankyou for your reply.
I try to post it on your FB group.
As it is all confidential data, I might need to retract some data.
Hi Andres, I have a doubt..I'm working on api call in http request and in the end point, once I type the url a trailing back slash"/" is getting appended which changes the url path and hence giving error " page not found". Could please suggest me how to handle this issue?
Hey Neeti Narvekar
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
how i can update a value in JSON is it through string or any option to upate using json deserilizer
Hey sruhari. Can you do a jsonString.replace("originalValue","newValue"? Kind regards, Anders
@@andersjensenorg it is working thank you very much
Very nice 🙏👍😀
And if I had to type the API Key into the HTTP Request properties panel instead of typing it directly into the endpoint, how would I do it?
Hey Felipe Lopes
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Hello Anders,
Nicely Explained ! :) :)
can you please add one video with API process in RE-Framework
Regards
Ritu.s
Hey Ritu. That is an awesome idea, which I would like to make a video of, I will add it to my to do list 😊 For starters, I can recommend this REFramework tutorial, th-cam.com/video/LP5y51_n6BY/w-d-xo.html Kind regards, Anders
How to handle error ‘Deserialized JSON: unexpected character…’ i think this was caused by the xrate limiting of the api im trying to access which then the http requests is providing an error (html format).. how to handle this error, i used jsonreaderexception in the try catch but it is not catching the error
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 5800+ 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
Hello Anders, I received this error message---
{"error_message" : "This API project is not authorized to use this API.",
"results" : [],
"status" : "REQUEST_DENIED"}
I followed your steps, could you please help in identifying the issue?
Hey Ashutosh. What API are you trying to access? Kind regards, Anders. Ps. Remember to tag me in you answer otherwise, I will not get noticed about your answer.
@@andersjensenorg Hi Anders, the API i tried to access was the exact same API as in your video "maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&key=YOUR_API_KEY" but as per what I see , the project needs to be billed to the account and I am not willing to make it a billed account as of now. Is that an issue for this error?
Are there any free API's that we can use in this case?
Any leads would be appreciated.
@Anders Jensen, @Ashutosh khantwal, Now I'm facing the same issue can you please help me how to resolve this
The API I tried to access was the exact API as in your video
maps.googleapis.com/maps/api/geocode/json?address=1600+Amphitheatre+Parkway,
+Mountain+View,+CA&key=YOUR_API_KEY
Error:
{
"error_message" : "This API project is not authorized to use this API.",
"results" : [],
"status" : "REQUEST_DENIED"
}
@@ashutoshK5 @Anders Jensen I activate and linked a billing account to my project and I am still receiving this same error. Do you guys know what the issue is?
@@tejaswinerella5223 did you ever figure out what the issue is?
Can I get a link to the resource where I can read about API's. Especially SharePoint list API and service now API
Hey Rohan. I am not sure about some written resources about API's, but I can reccomend this video with Cristian Negulescu for the ServiceNow part, th-cam.com/video/fzN0jmCUYls/w-d-xo.html Kind regards, Anders Ps. If you find something, I would be very happy, if you could send me the link/links 😊
@@andersjensenorg This was really a great video. Please keep posting such cool videos ! Sure I will search for some document resources and let you know if I find one
Thank you, Rohan. I will try. If you have any questions or ideas for future videos, please let me know 😊 Kind regards, Anders
Hi Andres, I got stuck at the beginning, I copied the API key generated in the Google Platform to the JSON output flag and got " "error_message" : "This API project is not authorized to use this API.",
"results" : [],
"status" : "REQUEST_DENIED""
Do you know what might be the reason?
Hey kobrel
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
Facing error, write cell: Object reference not set to an instance of an object.
@ Anders please suggest
the variable you are writing inside cell must be empty. check weather you are getting any data from API or check weather you have destructred the JSON object properly
Rohan is giving a great answer. Can you try to write the variable out to a write line? That way you can check, if there is an actual value. Otherwise we face an error, which is most likely due to one of the reasons, Rohan states. Kind regards, Anders
Resolved thanks
I don't write row.item("adress") but row("address") is there a difference, i dont understand this item
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 10,000+ 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
This is the error message i am getting Any idea? when i use the API key it gave me
{
"error_message" : "This API project is not authorized to use this API.",
"results" : [],
"status" : "REQUEST_DENIED"
}
Hey Marc R
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: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
Have a great day.
Kind regards,
Anders
I get an error when I use the API key error messages API project is not authorized to use this API. what should I do about this? Can you please help me?
Your need to authorize your API access. You can get it at the API site. Which one is it? :) Kind regards, Anders
@@andersjensenorg its showing like this "error_message" : "You must enable Billing on the Google Cloud Project at console.cloud.google.com/project/_/billing/enable Learn more at developers.google.com/maps/gmp-get-started",
@@andersjensenorg if u r in the forum I will send the screenshot can I get u r address.
@@andersjensenorg is this API is free
I had the same issue, but I just solved it. Go to your Developer console, navigate to Library and make sure you enable Geocoding API. Hope it works for you as well.
Watch this 60 inch monitor, not tablet
Haha 👍😀
Fufhgfhvhv🎉🌈🎉🌈🎉🌈🎉🌈🎉🌈🎉🌈
🙌🙌🙌
I have a question: the deserialize activity type argument is the "Newtonsoft.Json.Linq.JObject". correct or something similar? I am getting an error in the Write Line activity with the object "JsonObject.SelectToken("results[0].geometery.location.lat").ToString", stating "Write Line: Object reference not set to an instance of an object." ?
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 5800+ 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): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders
@@andersjensenorg Thank for your response and the link that you've created. Looking forward to more learning from your great tutorials.
Need help. Got some error on the API upon pasting on the browser :( "This API project is not authorized to use this API."
Hey Knals. You need to use auth/credentials for your api. What does the api documentation say? Kind regards, Anders
I had the same issue, but I just solved it. Go to your Developer console, navigate to Library and make sure you enable Geocoding API. Hope it works for you as well.
@@cedricpendji4972 Thanks a lot Cedric 😍