UiPath: Json to DataTable

[@echonow5157]

No words sir..your videos are one stop in need.

[@AutomatewithRakesh]

Thank you thank you thank you

[@RaviSharma-rs5hj]

Crystal clear explanation. Thank you.

[@yhonatan1789]

Thank you very much, you are a boss, I spent several days with this problem and I finally found the solution with your video

[@AutomatewithRakesh]

awesome it’s great to know!

[@niyask536]

This video is very helpful to understand how we can extract the data from json to data table. It is really outstanding.!! I have a suggestion, can you please also post a video how we can export the data from Json to oracle data base . I have created a table in database so I would like to export the json data to the database table. Thanks.

[@mohdqamaruddin6197]

Thank you so much for your support and training sir. God bless you always.

[@AutomatewithRakesh]

Thank you so much it’s great to hear

[@nikhilsapkal4638]

Hi Rakesh great video, even using "JsonObject" we can write directly to datatable no need of using JsonArray

[@SG-kz5bq]

Very clear explanation sir.Thank you so much.

[@tanzilarahman4060]

This is a wonderful tutorial. My next steps is to use this json data and fill out a pdf form, however I do not see many resources on that task. If you are able to create a tutorial on that process, I would really appreciate it.

Bhai it was very clear and easy to understand. Appreciate it!!

[@Amit4u4365day]

Wonderful video early I used for each loop to get data from JArray

[@hoit4147]

this video, the json to data table explanation is over. It's perfect.😍

[@AutomatewithRakesh]

Thank you for watching!

[@srinivasreddy9172]

No Words, This helps me a lot in solving my Issue with in 20 minutes. You are awesome Rakesh

[@AutomatewithRakesh]

Thank you

[@kmuthuraj34]

Thank you so much Rakesh 😊. Much needed topic for me.

[@AutomatewithRakesh]

You are welcome

[@abhilashkodali5986]

Hi Rakesh, I have a doubt that why we are using "Excel Process Scope" instead of directly using "Write Range"?

[@AutomatewithRakesh]

To best of my understanding the excel application scope works like an integration between UiPath and Microsoft Excel. The excel application scope also very helpful let’s say while execution the specific excel file doesn’t exist then it creates a file with the name provided in the Automation

[@nukalasravanthi3945]

Hi rakesh thank you for this concept.it is very helpfull .

[@AutomatewithRakesh]

Thank you Sravanthi

[@hurmetnoka9434]

Thank you Rakesh, your video helped me. Appreciate it!

[@rajurec2721]

excellent explanation rakesh

[@nikhilpawar1896]

Hi Rakesh I got compiler error in deserialize json array when I write in it DJson("data").ToString Compiler error(s) encountered processing expression "DJson("data"). ToString

[@Ashok-e9x4v]

5:38 am also getting same error , could please help me DserializeJsonarry not taking as input Djson("data).toString

[@sadhuvijay]

Thank you Rakesh.

[@deadboy164]

This is perfect. It works! Thanks

[@mansi3055]

Hi Rakesh, I am getting this error "Sample_Tests/PhysicalRisk.xaml: Compiler error(s) encountered processing expression "Newtonsoft.Json.JsonConvert.DeserializeObject(of DataTable)(TestArray.ToString)".(2) : error BC30561: 'DataTable' is ambiguous, imported from the namespaces or types 'System.Data, DocumentFormat.OpenXml.Drawing.Charts, Microsoft.Office.Interop.Excel'." Can you please let me know why i am getting this

[@santoshsai7545]

hello mansi i have tried today this i got similar problem like you i think once check if the data type of data table variable is data table or not if thats correct then your problem might be solved

[@votrunghieu167]

Hello Mansi, I have got the same problem you can try Newtonsoft.Json.JsonConvert.DeserializeObject(of System.Data.DataTable)(TestArray.ToString) to resolved.

[@aweitz225]

Is it possible to iterate over each property of each of its arrays? In your case your property is “data” and you have a key values for it. But what if you had another property called “system info” with key values? I’m looking at a situation that has 7 or more properties and rather that access the DJson(“data”) I’m looking to replace “data” with its iterative property. Is this allowable?

[@Mrreddy-lu2en]

HI @Rakesh, can you please do a video on how to Enable & Disable triggers in Orchestrator using "Orchestrator HTTP Request" activity

[@linourtcd1144]

Thank you, how can i solve this in deserialize json array Deserialize JSON Array: Object reference not set to an instance of an object.

[@vedamshvanja7331]

Thank you for the great explanation

[@chanduchikky]

is this done using modern activities?

[@saravananba748]

Hi bro, I have my json data in a variable in my controller , how to send it to my datatable in jsp page and how can(syntax and option like data or column used )give json data to datatable version 1.13.x

[@santoshsai7545]

got the solution thank you very much completed

[@muktharvalli741]

Excellent sir thanks

[@AutomatewithRakesh]

You are most welcome Mukthar

[@parassingh9969]

Great video..Rakesh is that possible like if we only need or fatch new data from api which is not duplicate in excel.

[@AutomatewithRakesh]

I think we can add another activity to clear the duplicates post writing to excel “remove duplicates”

[@airtonpereira6418]

What if we had another table within this "data" table in the example?

[@H3artless_43ver]

Can i store to sql database instead?

[@yashobantadash6670]

awesome bro! but why it was written deserializeObject when converting jarray to datatable

[@AutomatewithRakesh]

Hi Yashobanta, the json data is a complex type, initial it has Json Objects and than it has JSON Array. using deserializeObject I need to identify the array from the entire JSON file and tried feedig that into the Deserialize JSON Array activity.

[@yashobantadash6670]

@@AutomatewithRakesh yah .but deserialise means converting string to object na..so confusing in this case..not getting it

[@zishansk1754]

thanks Appreciate

[@Chandra_Shekhar_G]

Hi Rakesh, in real time project can we get the json data from the client? or need to get it ourselves. Can we get json data from any website?

[@AutomatewithRakesh]

While you will be dealing with web automations and if you have to extract data or send it out to the web application those times you have to use the available a PI for the website that may very from client to client and the application that they use. The client should provide you the API link and the required parameters if it is an internal application

[@Chandra_Shekhar_G]

@@AutomatewithRakesh Thank you!!!👍🏻

[@niravgajera3726]

It is wonderfull but let's say I have Json array like this [{"A1":"A2","B1":[{"B2":"B3"},{"B2":"B4"}]},{"A1":"A3","B1":[{"B2":"B5"},{"B2":"B6"}]} than it will throw error. In that case we have to go in for each loop right, Please correct me If there is any better way to go about it when there are multiple arrays and json in one Json response.

[@Amit4u4365day]

Hi Nirav, It will not get an error and get the output. The only concern is that you will get blank data under header B1 means under A1 [A2,A3] & B1 [] To get all data you have to use for each loop or any other linq queries

[@saravananba748]

I have my json data using Jackson library

[@rajurec2721]

useful content

[@AutomatewithRakesh]

Thank you Raju

[@mjfanankit]

Completed….

[@AutomatewithRakesh]

Good job 👏

[@Nagendra0912]

Datable to json how to convert

[@AutomatewithRakesh]

Sure will try to create a content

[@pranjalidhore1387]

Please try to be specific.