How to do API calls in UiPath | Full Tutorial

[@andersjensenorg]

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: kzbin.info/www/bejne/goGYqmhnlNNpeLs

[@valtallica]

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

[@andersjensenorg]

Hey V G. Thank you so much. Your comments, feedback and support are helping me a lot!! Kind regards, Anders

[@spiritualsecrets6725]

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

[@andersjensenorg]

Hey Venkatkumar. That's very kind of you 🙂 Have a great day, Anders

[@rs832]

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

[@andersjensenorg]

Hey r s. Wow, that you very much 😊 Kind regards, Anders

[@rs832]

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!

[@andersjensenorg]

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

[@rs832]

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

[@rs832]

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?

[@Maheshpatel-fy1tu]

Anders, You Teach with Passion Sir !

[@andersjensenorg]

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: kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@jatinnandwani6678]

Thanks so much, this was helpful

[@andersjensenorg]

You're very welcome, my friend 🙌🙂

[@ma82durga]

Thanks for sharing the lesson. Appreciate it!

[@andersjensenorg]

Hey Abhijit, thanks a ton for letting me know :) Kind regards, Anders

[@aishwaryadas4232]

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

[@andersjensenorg]

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.

[@sanjayprajapati1959]

very helpful video keep posting more

[@andersjensenorg]

Hey Sanjay. Thank you very much 😊 Do you have any specific wishes? Kind regards, Anders

[@deepaksagar1986]

Thanks for sharing the knowledge.

[@andersjensenorg]

Hey Deepak. Thanks a lot for your support :) Kind regards, Anders

[@soubarnobanerjee8257]

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?

[@andersjensenorg]

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: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@Mahesh-ye8sh]

Highly informative one, thanks for posting !!

[@andersjensenorg]

Thank you very much, Mahesh 🙂

[@bharathbm3545]

Very useful

[@andersjensenorg]

Many thanks 😊👍

[@amelieviennot5570]

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 ?

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@asramaa]

Thank you Anders.

[@andersjensenorg]

Thanks a lot, Fasulu Rahman 🤗 Your feedback helps me immensely. Kind regards, Anders

[@marcinwrobel9242]

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.

[@andersjensenorg]

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

[@ruiwu1575]

Thanks for sharing```

[@andersjensenorg]

Thanks a lot, Rui Wu 🤗 Your feedback helps me immensely. Kind regards, Anders

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

Thank you, Anders, very interesting video!

[@andersjensenorg]

My pleasure!

[@imitbunts8124]

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.

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@sarahalshawkani4358]

Thank you Andres for sharing the knowledge. Very Appreciated.

[@andersjensenorg]

Hey Sarah - thank you 😊

[@anburenganathan8369]

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.

[@andersjensenorg]

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

[@indiagnit]

Hi Anders, Very helpful to understand API.

[@andersjensenorg]

Thank you, Sajid 😊 Kind regards, Anders

[@АнтонМакаров-ъ5е]

Nice lesson!

[@andersjensenorg]

Many thanks 😊

[@ajishjoy3778]

Cool stuff Thanks for sharing

[@andersjensenorg]

Hey ajish. Thanks a lot for writing, this help me a lot and pip up my mood :) Kind regards, Anders

[@jessicamiller4281]

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

[@andersjensenorg]

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

[@taurean.abhishek]

Very nice content Anders :)

[@andersjensenorg]

Hey Taurus. Nice to see you around and thanks for attending the GK live session 🙂 Kind regards, Anders

[@taurean.abhishek]

@@andersjensenorg Thank you Anders😊

[@sriharikurakula7686]

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,

[@andersjensenorg]

Hey Srihari. Sure, check this: kzbin.info/www/bejne/fnzbo3SGrdNooKM 🙂 Kind regards, Anders

[@jaggukiran08]

superb

[@andersjensenorg]

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

[@ashutoshK5]

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?

[@andersjensenorg]

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.

[@ashutoshK5]

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

[@tejaswinerella5223]

@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" }

[@morpheousneotrinity]

@@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?

[@morpheousneotrinity]

@@tejaswinerella5223 did you ever figure out what the issue is?

[@jgill0]

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

[@andersjensenorg]

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

[@wearerunnersw.a.r5613]

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.

[@andersjensenorg]

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

[@wearerunnersw.a.r5613]

@@andersjensenorg thank you for your response

[@tobiewaldeck7105]

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.

[@andersjensenorg]

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

[@tobiewaldeck7105]

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

[@andersjensenorg]

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

[@tobiewaldeck7105]

@@andersjensenorg Hi Anders.

[@UiPathHacks]

very useful. thx !

[@andersjensenorg]

Thanks, buddy! Now a subscriber for your channel, please deliver som nice hacks 😍🙂

[@UiPathHacks]

@@andersjensenorg thx ! same for you, let us keep in touch :)

[@ndeyefatoudiouf8306]

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

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@AmitKumar-pc8wr]

Will I need to create seperate flow for every API.. can we create a flow which can we used for multiple API.

[@andersjensenorg]

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

[@Alberto_Cavalcante]

Nice

[@andersjensenorg]

You're very welcome, Alberto Cavalcante - your support helps me a lot 😍

[@anujdhoot7804]

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

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@brisadeirogourmet]

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?

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@heathengaming8461]

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

[@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 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@neetinarvekar1968]

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?

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@crazycats08]

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

[@andersjensenorg]

Hey Liu! Thanks a lot for the nice comment and help 🙋‍♂️😊

[@kobrel]

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?

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@sriharikurakula7686]

how i can update a value in JSON is it through string or any option to upate using json deserilizer

[@andersjensenorg]

Hey sruhari. Can you do a jsonString.replace("originalValue","newValue"? Kind regards, Anders

[@sriharikurakula7686]

@@andersjensenorg it is working thank you very much

[@andersjensenorg]

Very nice 🙏👍😀

[@SaurabhYadav-kg7kx]

thanks Anders Jensen

[@andersjensenorg]

Hey Saurabh. You're very welcome. Kind regads, Anders

[@TuhinBagh]

Hi Anders, Can you tell me how to consume REST API using cookies as authentication? It works on other clients, but Uipath returns 0

[@andersjensenorg]

Ouch, can you post a screenshot in either my FB group or on the Discord: kzbin.info/door/Pdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

[@TuhinBagh]

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

[@majetysunil]

Facing error, write cell: Object reference not set to an instance of an object. @ Anders please suggest

[@rohantammewar6337]

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

[@andersjensenorg]

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

[@majetysunil]

Resolved thanks

[@sandeshreddy303]

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.

[@andersjensenorg]

Hey Sandesh. Check this: kzbin.info/www/bejne/bJKncn6YeJV6oNU I'll make a longer one in September :) Kind regards, Anders

[@abhinavshukla5628]

Can you please help me to iterate this 'JSON_Object.SelectToken("data[0].title")' until data finishes?

[@andersjensenorg]

Can you send the entire json here?

[@knalsgtes6684]

Need help. Got some error on the API upon pasting on the browser :( "This API project is not authorized to use this API."

[@andersjensenorg]

Hey Knals. You need to use auth/credentials for your api. What does the api documentation say? Kind regards, Anders

[@cedricpendji4972]

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.

[@andersjensenorg]

@@cedricpendji4972 Thanks a lot Cedric 😍

[@rohantammewar6337]

Can I get a link to the resource where I can read about API's. Especially SharePoint list API and service now API

[@andersjensenorg]

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, kzbin.info/www/bejne/nKuxYZ2jeLqMotU Kind regards, Anders Ps. If you find something, I would be very happy, if you could send me the link/links 😊

[@rohantammewar6337]

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

[@andersjensenorg]

Thank you, Rohan. I will try. If you have any questions or ideas for future videos, please let me know 😊 Kind regards, Anders

[@kaijisan1206]

I don't write row.item("adress") but row("address") is there a difference, i dont understand this item

[@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 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@arjunreddy0]

Hai jensen can you make a video on "How to find the duplicate values in a row".

[@andersjensenorg]

Sure, I'll make it later today and let you know 😊

[@andersjensenorg]

Hey arjunreddy0, is this a help for you? kzbin.info/www/bejne/epfWqnluZdeiZ68

[@marcr2204]

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" }

[@andersjensenorg]

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: kzbin.info/www/bejne/eWfbnnqcerFjbas Have a great day. Kind regards, Anders

[@itsmechethan6105]

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?

[@andersjensenorg]

Your need to authorize your API access. You can get it at the API site. Which one is it? :) Kind regards, Anders

[@itsmechethan6105]

@@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",

[@itsmechethan6105]

@@andersjensenorg if u r in the forum I will send the screenshot can I get u r address.

[@itsmechethan6105]

@@andersjensenorg is this API is free

[@cedricpendji4972]

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.

[@siddtalk]

I am not able to use geo api , it says I need to purchase it . Anyone else facing same issue

[@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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@aireviewforyou]

In Modern design API dose not work like you. Can you Please make a New Video About API Integration Please.

[@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 13,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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@ritusahu7729]

Hello Anders, Nicely Explained ! :) :) can you please add one video with API process in RE-Framework Regards Ritu.s

[@andersjensenorg]

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, kzbin.info/www/bejne/goGYqmhnlNNpeLs Kind regards, Anders

[@Esp1fs]

Watch this 60 inch monitor, not tablet

[@andersjensenorg]

Haha 👍😀

[@georgef.williams3504]

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

[@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 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): kzbin.info/www/bejne/roipq2CJbpuLfdE Kind regards, Anders

[@georgef.williams3504]

@@andersjensenorg Thank for your response and the link that you've created. Looking forward to more learning from your great tutorials.