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:

Link to the API:

Important Links:

Dear Learners, I need your support too! therefore please Subscribe to my channel and show your kind support!

Link to UiPath Beginners Playlist:

Link to UiPath Excel and DataTable Playlist:

Link to UiPath Key Technique Playlist:

Link to UiPath Email Automation Playlist:

Link to UiPath PDF Automation Playlist:

Link to UiPath ReFramework Playlist:

Link to UiPath Classic and Modern Excel Activities Playlist:

Link to UiPath Regular Expression Playlist:

Link to UiPath Orchestrator Playlist:

Link to Advance UiPath Orchestrator Playlist:

Link to UiPath VB dot Net PlayList:

Link to UiPath Use Case Playlist:

Link to UiPath Selectors Playlist:

Link to UiPath Enhanced Selectors Playlist:

Link to UiPath Computer Vision Playlist:

Link to UiPath Interview Series Playlist:

Link to UiPath Document Undestanding Playlist:

Link to UiPath Action Center Playlist:

Link to UiPath Error and Fix Playlist:

Link to UiPath Activities Playlist:

Link to UiPath Certification Playlist:

Link to UiPath Background Automation Playlist:

Link to UiPath Logs Playlist:

Link to UiPath GitHub Integration Playlist:

Link to UiPath API Integration Playlist:

Link to Python Playlist:

[SG-kzbq]

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

[PavanKumar-sgki]

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

[mikerajput]

Excellent, please need more videos on API. Thanks

[maniank]

Fantastic, Awesome, Superb my Guruvey

[akshaynewase]

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

[sagarspatil]

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

[vupender]

Superb Explanation .. i have done and it works perfectly

[VidyaSrinivasan]

Thank you Rakesh, great video and completed the task.

[SrinivasReddy-fcol]

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

[nukalasravanthi]

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

[phalgunvempati]

Great series of videos about API..very useful.

[rajasekhar]

completed one more video thank you rakesh

[ishwarps]

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

[srinivaspothula]

Great explanation guriji, I done it .

[minalpatil]

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

[irfanshaik]

Great Explanation Rakesh Thanks for the video😀

[vishnuvardhanreddy]

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

[purushothamreddy.j]

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<=counter):
print(n)
n=n+1

[srinivasreddy]

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.

[suryakiranaluru]

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