UiPath: Json to DataTable

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:

Dear Learners, I need your support too!
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:

#uipath Tutorial

[echonow]

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

[yhonatan]

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

[hoit]

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

[SG-kzbq]

Very clear explanation sir.Thank you so much.

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

[tanzilarahman]

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.

[srinivasreddy]

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

[mohdqamaruddin]

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

[Amituday]

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

[niyask]

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.

[aweitz]

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?

[kmuthuraj]

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

[nikhilsapkal]

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

[hurmetnoka]

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

[abhilashkodali]

Hi Rakesh,

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

[mindroceanu]

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: Error reading JArray from JsonReader. Current JsonReader item is not an array: StartObject. Path '', line 1, position 1. at reader, JsonLoadSettings settings).

Please revisit the video.

[linourtcd]

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

[nukalasravanthi]

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

[saravananba]

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

[Mrreddy-luen]

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