How to do REST API calls and update Excel in UiPath - Full tutorial

This video guide shows, how to do REST API calls based on an Excel sheet, do JSON parsing and write the wanted information back to Excel.

🔔Subscribe if you enjoyed

🤖UiPath AdvancedTutorial

#uipath #rpa #tutorial

[bhuvaneshwarijeyakumaravel]

U have the brilliant way to teaching things step by step . Thank you so much 😊

[plasaferstone]

Hey Anders! I like your tutorial all the time, it's very useful. In this tutorial using Second Datatable(dtSWoutput), we can use dtSW alone, and in For each row activity instead of intIndex we can simply use row.Item("Column Name") in normal assign activity, its work perfectly. Now the code is optimized!!!

[LuisECP]

Is it posible to make it in PowerAutomate with a onedrive excel file?

[Far_Ken]

Thanks Anders,
great tutorial as always. I am continually picking up hints and tricks with every one of your videos.
*07:26** "We cannot update in the same data table, we are iterating through"*
That is not entirely correct, though there might be a best practice reason why you wouldn't want to update the input reference data being worked upon.
So instead of initiating a second output data table, and using index references, you could simplify the For Each Loop to:
Assign (or Multiple Assign)
row.Item("Title") =
or even shorter:
row("Title") =

Cheers
Ken