Hello, I’m deserialize a json for JOBJECT and would like to transform this JOBJECT straight to data table without looping due to high amount of information. Below the structure of my JSON, the data table information would only be the highlighted ones. { “name”: “relatorio”, “elements”:[ { “c…

give a try on following prepare a datatable with build datatable activity - dtData All cols similar to all properties from the JObject in elements parse the JSON string with Deserialize JSON activity - myJObject Use an assign acitvity left: dtData right (From x in myJObject("elements").Values…

UiPath.WebAPI.Activities contains methods and activities for converting things to and from JSON. About the WebAPI Activities Package This relatively small package enables users to perform SOAP or HTTP requests to any web APIs that support these protocols, including UiPath's Orchestrato…

you can simply parse it and convert to Datatable. Below thread is quite helpful on this topic [image] Convert json to Datatable Help { "Name": "Karan", "Adddress": "Kolkata", "Job_Description": "Software Developer", "request": { "createdBy": "unknown", "comment": "Sof…

Hi @joao_adelio1 , You can use below code to achieve the same. This use build datatable activity and invoke code activity, its quite fast. No need to run thorugh loops as that would be time consuming. Sequence.xaml (10.0 KB) Just make changes as required(few mentioned below for your quick referen…

Thank you in advance for your help. I tried to do as you told me, but my data table returns blank, I’ve attached the json and the code so you can see what I’m doing. TESTE.json (2.5 KB) Main.xaml (34.6 KB)

Thanks Peter, can you help me on this other topic Transform datatable string column into data time format (DD-MM-YYYY)

Convert Json to Datatable without using loop

Help Studio

rahulsharma (Rahul Sharma) October 1, 2021, 5:13pm 3

you can simply parse it and convert to Datatable.

Below thread is quite helpful on this topic

Topic		Replies	Views
Convert specific json data to datatable Studio studio , question , activities_panel	6	1932	September 5, 2022
How to convert Json to DT Help datatable , activities , question	3	1807	November 7, 2019
Help--Converting JSON Data into Data Table Activity Studio datatable , excel , studio , question , json , workflow_analyzer , activities_panel	11	2041	October 4, 2021
How to create datatable from Json object? Studio studio , question , project_panel	8	4686	September 27, 2021
Convert json from request to DataTable Academy Feedback	1	796	June 25, 2020

Convert Json to Datatable without using loop

Related topics