API : Extract Data from API in UiPath | Extract Data From API and Store in Excel in UiPath
HTML-код
- Опубликовано: 13 дек 2024
- 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...
Excellent, please need more videos on API. Thanks
I've just completed the task rakesh. Great work.
You are welcome, what else are you planning study around uipath?
Completed.Thank you so much. You made this topic very simple and understandable for anyone new in this.
Well done, continue your learning journey and keep commenting! Shiyamala
Eagerly Waiting for this series,, Great info Rakesh, Thanks
Thank you Srinivas, thank you for liking. Support our channel by liking and subscribing
Great Explanation Rakesh Thanks for the video😀
Thank you Irfan
Fantastic , Awesome, Superb my Guruvey
Great series of videos about API..very useful.
Thank you Phalgun, continue to support our channel bu liking all our contents you watch
thank you sir this series is easily understand and easlily concept get clear sir
Thank you for these awesome videos. Liked and subscribed. Keep them coming.
Thank you Rakesh, great video and completed the task.
Good job Pooja
Thank you rakesh for this api related concept.very usefull.i did this excercise it is working fine.
You are most welcome, Nukala
Superb Explanation .. i have done and it works perfectly
Happy Guru Purnima Sir
Hey thank you Bhupendra!
Done .. VEry nicely explained
Great explanation guriji , I done it .
Haha 😂 thank you Srini, continue to support our channel by liking all our contents you watch
completed one more video thank you rakesh
Great 😊
Please continue your learning!!
Completed Successfully
Good Job, continue the learning journey!
These are awesome videos. Can you give more examples for extracting data from API?
Thanks Bro, I am done with fetching the data and write the data to the excel
Thank you Vishnu, keep liking and subscribe to our channel
Sure bro
Great explanation keep it up
Thank you Saahil, continue to like our channels content
@@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.😀
This is really awesome
Successfully Completed
Hi Rakesh, are you planning to add any RPA BlurPrism Training videos. please let me know
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
If i give JsonObject("results")(0)("name")("first").ToString - It says Option Strict On disallows latebinding. My FirstName variable in string only
You mean json object variable is string?
For this problem just set the variable "JsonObject" to variable type "Newtonsoft.Json.Linq.JObject"
Pure smart work
You are awesome
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
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.
can we iterate jobject data using for each activity in dynamic way , could you please help on the same?
awesome!!!!the best!!
Thank you
please give us some manipulation and extraction on xaml files. thanks! the music is great btw!
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
am done.thanks
Awesome great job keep moving there are multiple topics you can take benefits keep commenting upon completion
@@AutomatewithRakesh ok i will always ,
Bro, why is that "counter-1", I'm not understand. Please can you explain that?
can we do hardcode in json
Can we convert entire json data to datatable?
Hi Madhu, that's a good thought again! yes we can convert the entire json to data table. JsonConvert.DeserializeObject(of DataTable)(JsonText Variable)
@@AutomatewithRakesh overload resolution failed, it's showing error rakesh
I think this unstrustered json of array data
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
If we don't know exact value of data and it is daily coming dynamic way ,how can we extract data to excel
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.
@@AutomatewithRakesh can you please explore it more
with syntax please
Done! @rakesh , Thanks
Great job! Continue the learning journey!
Thanks
Completed
Rpa uipath production videos upload like L1, L2andL3
Sure Sai i took a note
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
hi i m done this
Good job Sagar
Can u please remove the background music. it's annoying!
Stop Background Music Please in Next Time.
Music is so annoying
Just don't forget to set the variable "JsonObject" to variable type "Newtonsoft.Json.Linq.JObject"
Thank you Rakesh, great video and completed the task.
Glad it helped, Vidya, continue your learning journey