API : Extract Data from API in UiPath | Extract Data From API and Store in Excel in UiPath

API : Is it possible to get data from API using UiPath?
Developers can use the API to extract the data they need and save it in files or feed it to other software once they have a basic understanding of how it operates. Therefore, you have a quick and simple approach to obtain data as long as a website offers an API that you can use.
Learn how to update the data in Excel and how to pull data from an api using a http request in this video. The user will be prompted in this demo to enter the number of data points they wish to retrieve using the API. After that, an Excel sheet will be updated with the supplied number of user data utilising the UiPath workflow. Building this automation in UiPath will be enjoyable. If you were able to finish and design this process in UiPath, kindly watch this video and comment below.
Link to UiPath API playlist:
• API | API in UiPath |...
Link to the API:
randomuser.me/...
Important Links:
🔥 Visit Channel : / automatewithrakesh
🔥 To Subscribe : bit.ly/3J6b48k
🔥 Python Videos : bit.ly/3r4AXzd
🔥 UiPath Videos : bit.ly/3udDx8a
🔥 Linkedin : bit.ly/3J6bMm0
🔥 Fb UiPath Grp : bit.ly/3x2iZ4d
🔥 Fb Page : bit.ly/3LMeXkn *****
Dear Learners, I need your support too! therefore please Subscribe to my channel and show your kind support!
Link to UiPath Beginners Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath Excel and DataTable Playlist:
• UiPath Tutorial | Buil...
Link to UiPath Key Technique Playlist:
• Move File Uipath | Uip...
Link to UiPath Email Automation Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath PDF Automation Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath ReFramework Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath Classic and Modern Excel Activities Playlist:
• UiPath Tutorial | UiPa...
Link to UiPath Regular Expression Playlist:
• Uipath Regex
Link to UiPath Orchestrator Playlist:
• Uipath Orchestrator Ho...
Link to Advance UiPath Orchestrator Playlist:
• How to Use Storage Buc...
Link to UiPath VB dot Net PlayList:
• UiPath VB.Net Complete...
Link to UiPath Use Case Playlist:
• UiPath Birthday Remind...
Link to UiPath Selectors Playlist:
• UiPath Introduction to...
Link to UiPath Enhanced Selectors Playlist:
• UIPath Enhanced Select...
Link to UiPath Computer Vision Playlist:
• Learn UiPath Computer ...
Link to UiPath Interview Series Playlist:
• UiPath Interview Quest...
Link to UiPath Document Undestanding Playlist:
• UiPath Document Unders...
Link to UiPath Action Center Playlist:
• UiPath Action Center i...
Link to UiPath Error and Fix Playlist:
• UiPath Error Message#1...
Link to UiPath Activities Playlist:
• Parallel For Each in U...
Link to UiPath Certification Playlist:
• UiPath DataTable Selec...
Link to UiPath Background Automation Playlist:
• Background Process Aut...
Link to UiPath Logs Playlist:
• UiPath Logs | UiPath L...
Link to UiPath GitHub Integration Playlist:
• How to Create a GitHub...
Link to UiPath API Integration Playlist:
• API | API in UiPath |...
Link to Python Playlist:
• How to Create a GitHub...

[@SG-kz5bq]

Completed.Thank you so much. You made this topic very simple and understandable for anyone new in this.

[@AutomatewithRakesh]

Well done, continue your learning journey and keep commenting! Shiyamala

[@PavanKumar-sg9ki]

I've just completed the task rakesh. Great work.

[@AutomatewithRakesh]

You are welcome, what else are you planning study around uipath?

[@mikerajput159]

Excellent, please need more videos on API. Thanks

[@nukalasravanthi3945]

Thank you rakesh for this api related concept.very usefull.i did this excercise it is working fine.

[@AutomatewithRakesh]

You are most welcome, Nukala

[@akshaynewase4623]

thank you sir this series is easily understand and easlily concept get clear sir

[@SrinivasReddy-fc5ol]

Eagerly Waiting for this series,, Great info Rakesh, Thanks

[@AutomatewithRakesh]

Thank you Srinivas, thank you for liking. Support our channel by liking and subscribing

[@ishwarps4209]

Hi Rakesh API+UiPath Combo videos are great ....Along with this I request you to add Deployment Life Cycle that is followed I mean ( While Deploying Bot from Dev Environment to UAT and to Production how it is achieved do we have a separate test instance of Orchestrator URL or only bot running machines are different for different environments how these licenses are maintained I mean is orchestrator is enough or a third party source control like Github is necessary and advantages of Github is used) I know these things different in different Projects Teams but based on your experience let us know we are not expecting practical demo but steps and details in standard

[@sagarspatil]

Thank you for these awesome videos. Liked and subscribed. Keep them coming.

[@VidyaSrinivasan2015]

Thank you Rakesh, great video and completed the task.

[@AutomatewithRakesh]

Glad it helped, Vidya, continue your learning journey

[@minalpatil5974]

These are awesome videos. Can you give more examples for extracting data from API?

[@vupender4155]

Superb Explanation .. i have done and it works perfectly

[@phalgunvempati]

Great series of videos about API..very useful.

[@AutomatewithRakesh]

Thank you Phalgun, continue to support our channel bu liking all our contents you watch

[@vishnuvardhanreddy6531]

Thanks Bro, I am done with fetching the data and write the data to the excel

[@AutomatewithRakesh]

Thank you Vishnu, keep liking and subscribe to our channel

[@vishnuvardhanreddy6531]

Sure bro

[@RahulJain-lj8kf]

Done .. VEry nicely explained

[@irfanshaik2698]

Great Explanation Rakesh Thanks for the video😀

[@AutomatewithRakesh]

Thank you Irfan

[@maniank]

Fantastic , Awesome, Superb my Guruvey

[@rajasekhar0990]

completed one more video thank you rakesh

[@AutomatewithRakesh]

Great 😊 Please continue your learning!!

[@srinivaspothula6243]

Great explanation guriji , I done it .

[@AutomatewithRakesh]

Haha 😂 thank you Srini, continue to support our channel by liking all our contents you watch

[@kumarkumaresan6672]

This is really awesome

[@loveyoutube22]

please give us some manipulation and extraction on xaml files. thanks! the music is great btw!

[@tarakkatakam3786]

You are awesome

[@suryakiranaluru6212]

Hi Rakesh, are you planning to add any RPA BlurPrism Training videos. please let me know

[@bhupendra6789]

Happy Guru Purnima Sir

[@AutomatewithRakesh]

Hey thank you Bhupendra!

[@purushothamreddy.j5613]

Hi Rakesh, I tried after watching this video, I found you have used while loop (counter>0) ,so Let's take an example in the input dialog box i have given counter as 5 , since 5 is greater than 0.The bot will be going to infinite loop, how will the bot stops at 5th count and write 5 times in the excel like your bot. this approach didn't bring me the exact result, can you please check it again if possible, Thanks. This approach works: counter=5 n=1 while(n

[@abhilashkodali5986]

Completed Successfully

[@AutomatewithRakesh]

Good Job, continue the learning journey!

[@srinivasreddy9172]

Can we be able to find the total count dynamically? like how many parameters are available in the API Link? instead of providing the count statically.

[@mallikram9911]

Successfully Completed

[@genepallyramshiva2982]

Hi Rakesh, I'm getting an issue within API. I have a URL followed with registration number by which I'm getting data. If I pass the variable I'm unable to fetch the data into excel. Please help me sorting out this issue

[@spritualseek]

Hello sir, I have a question related to this, from Jobject I have stored value in variables(string) by using multiple assign activity. But now while I am creating data table and adding data row into it am getting error..string can not be converted to object. Please help me to solve this

[@saahilshaikh7445]

Great explanation keep it up

[@AutomatewithRakesh]

Thank you Saahil, continue to like our channels content

[@saahilshaikh7445]

@@AutomatewithRakesh Yes why not Rakesh i like your content so much and the way you explain things are very good if i want to know something i first search on your channel and if i do not find here will search on others.😀

[@ankitasakhare7395]

can we do hardcode in json

[@rajurec2721]

can we iterate jobject data using for each activity in dynamic way , could you please help on the same?

[@yashobantadash6670]

awesome!!!!the best!!

[@AutomatewithRakesh]

Thank you

[@sundararamans7705]

If i give JsonObject("results")(0)("name")("first").ToString - It says Option Strict On disallows latebinding. My FirstName variable in string only

[@purushothamreddy.j5613]

You mean json object variable is string?

[@mirceameszaros7723]

For this problem just set the variable "JsonObject" to variable type "Newtonsoft.Json.Linq.JObject"

[@AbdulRahman-lm6ly]

read an excel contains 4 columns. member name, age, amount and status read excel and group all the rows with status as completed group all rows with status as error create two tabs in the same sheet as error and completed write the above group of rows to corresponding tabs and save the excel

[@rakeshhalpati2427]

Pure smart work

[@madhumano8089]

If we don't know exact value of data and it is daily coming dynamic way ,how can we extract data to excel

[@AutomatewithRakesh]

I think in such case if you need entire Json data, you can convert the Json data to a data table entirely and write it back to excel.

[@rajurec2721]

@@AutomatewithRakesh can you please explore it more with syntax please

[@happyblackie01]

am done.thanks

[@AutomatewithRakesh]

Awesome great job keep moving there are multiple topics you can take benefits keep commenting upon completion

[@happyblackie01]

@@AutomatewithRakesh ok i will always ,

[@harshajoshi7102]

Completed

[@riteshburman9348]

Done! @rakesh , Thanks

[@AutomatewithRakesh]

Great job! Continue the learning journey!

[@madhumano8089]

Can we convert entire json data to datatable?

[@AutomatewithRakesh]

Hi Madhu, that's a good thought again! yes we can convert the entire json to data table. JsonConvert.DeserializeObject(of DataTable)(JsonText Variable)

[@madhumano8089]

@@AutomatewithRakesh overload resolution failed, it's showing error rakesh

[@madhumano8089]

I think this unstrustered json of array data

[@SaiKumar-ev3fc]

Rpa uipath production videos upload like L1, L2andL3

[@AutomatewithRakesh]

Sure Sai i took a note

[@kaluvasagar2131]

hi i m done this

[@AutomatewithRakesh]

Good job Sagar

[@aireviewforyou]

Stop Background Music Please in Next Time.

[@mirceameszaros7723]

Just don't forget to set the variable "JsonObject" to variable type "Newtonsoft.Json.Linq.JObject"

[@seconds_cooking]

Thank you Rakesh, great video and completed the task.

[@AutomatewithRakesh]

Good job Pooja