UiPath: Json to DataTable
Вставка
- Опубліковано 5 лют 2025
- Learn how to convert uipath JSON to DataTable. Complex JSON files which contains an array of data and how we can convert the JSON to data table we are going to learn in this video.
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!
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...
#uipath Tutorial
Thank you very much, you are a boss, I spent several days with this problem and I finally found the solution with your video
awesome it’s great to know!
No words sir..your videos are one stop in need.
Thank you thank you thank you
Crystal clear explanation. Thank you.
Thank you so much for your support and training sir.
God bless you always.
Thank you so much it’s great to hear
Bhai it was very clear and easy to understand. Appreciate it!!
Very clear explanation sir.Thank you so much.
Can i store to sql database instead?
No Words, This helps me a lot in solving my Issue with in 20 minutes. You are awesome Rakesh
Thank you
Wonderful video early I used for each loop to get data from JArray
this video, the json to data table explanation is over.
It's perfect.😍
Thank you for watching!
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.
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.
Thank you so much Rakesh 😊. Much needed topic for me.
You are welcome
excellent explanation rakesh
Thank you Rakesh, your video helped me. Appreciate it!
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?
Hi rakesh thank you for this concept.it is very helpfull .
Thank you Sravanthi
Hi Rakesh great video, even using "JsonObject" we can write directly to datatable no need of using JsonArray
This is perfect. It works! Thanks
Thank you for the great explanation
Thank you Rakesh.
Hello. Following your video step by step, the error: "Assign: Unexpected JSON token when reading DataTable: StartObject. Path ‘[0].entry’, line 1, position 0" is visible.
Also if some changes are made, different error: Newtonsoft.Json.JsonReaderException: Error reading JArray from JsonReader. Current JsonReader item is not an array: StartObject. Path '', line 1, position 1. at Newtonsoft.Json.Linq.JArray.Load(JsonReader reader, JsonLoadSettings settings).
Please revisit the video.
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
Thank you,
how can i solve this in deserialize json array
Deserialize JSON Array: Object reference not set to an instance of an object.
Hi Rakesh,
I have a doubt that why we are using "Excel Process Scope" instead of directly using "Write Range"?
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
got the solution thank you very much completed
Excellent sir thanks
You are most welcome Mukthar
is this done using modern activities?
HI @Rakesh, can you please do a video on how to Enable & Disable triggers in Orchestrator using "Orchestrator HTTP Request" activity
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
5:38 am also getting same error , could please help me
DserializeJsonarry not taking as input Djson("data).toString
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
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
Hello Mansi, I have got the same problem you can try Newtonsoft.Json.JsonConvert.DeserializeObject(of System.Data.DataTable)(TestArray.ToString) to resolved.
Great video..Rakesh is that possible like if we only need or fatch new data from api which is not duplicate in excel.
I think we can add another activity to clear the duplicates post writing to excel “remove duplicates”
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?
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
@@AutomatewithRakesh Thank you!!!👍🏻
useful content
Thank you Raju
What if we had another table within this "data" table in the example?
awesome bro! but why it was written deserializeObject when converting jarray to datatable
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.
@@AutomatewithRakesh yah .but deserialise means converting string to object na..so confusing in this case..not getting it
thanks
Appreciate
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.
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
I have my json data using Jackson library
Completed….
Good job 👏
Datable to json how to convert
Sure will try to create a content
Please try to be specific.