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

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

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

[@vupender4155]

Superb Explanation .. i have done and it works perfectly

[@maniank]

Fantastic , Awesome, Superb my Guruvey

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

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

[@sagarspatil]

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

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

[@irfanshaik2698]

Great Explanation Rakesh Thanks for the video😀

[@AutomatewithRakesh]

Thank you Irfan

[@seconds_cooking]

Thank you Rakesh, great video and completed the task.

[@AutomatewithRakesh]

Good job Pooja

[@RahulJain-lj8kf]

Done .. VEry nicely explained

[@srinivaspothula6243]

Great explanation guriji , I done it .

[@AutomatewithRakesh]

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

[@rajasekhar0990]

completed one more video thank you rakesh

[@AutomatewithRakesh]

Great 😊
Please continue your learning!!

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

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

[@minalpatil5974]

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

[@bhupendra6789]

Happy Guru Purnima Sir

[@AutomatewithRakesh]

Hey thank you Bhupendra!

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

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

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

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

[@rajurec2721]

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

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

[@abhilashkodali5986]

Completed Successfully

[@AutomatewithRakesh]

Good Job, continue the learning journey!

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

[@suryakiranaluru6212]

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

[@santhoshrsb4747]

Bro, why is that "counter-1", I'm not understand. Please can you explain that?

[@ankitasakhare7395]

can we do hardcode in json

[@mallikram9911]

Successfully Completed

[@kumarkumaresan6672]

This is really awesome

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

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

[@tarakkatakam3786]

You are awesome

[@rakeshhalpati2427]

Pure smart work

[@loveyoutube22]

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

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

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

[@SaiKumar-ev3fc]

Rpa uipath production videos upload like L1, L2andL3

[@AutomatewithRakesh]

Sure Sai i took a note

[@yashobantadash6670]

awesome!!!!the best!!

[@AutomatewithRakesh]

Thank you

[@riteshburman9348]

Done! @rakesh , Thanks

[@AutomatewithRakesh]

Great job! Continue the learning journey!

[@harshajoshi7102]

Completed

[@kaluvasagar2131]

hi i m done this

[@AutomatewithRakesh]

Good job Sagar

[@dhirendraswain4554]

Thanks

[@komatineniharisainadh2196]

Can u please remove the background music. it's annoying!

[@aireviewforyou]

Stop Background Music Please in Next Time.

[@mariamabdelmonem9960]

Music is so annoying

[@mirceameszaros7723]

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

[@VidyaSrinivasan2015]

Thank you Rakesh, great video and completed the task.

[@AutomatewithRakesh]

Glad it helped, Vidya, continue your learning journey