Hi can anyone help me into this please, I want to convert this , I have this set of Data: #json { "49bb546y-35C0-48b4-93fe-bd0824e4fa97-Filepath": "D:\\A\\B\\Process.xaml", "49bb546y-35C0-48b4-93fe-bd0824e4fa97-errorCode": "IV-AnjuMDL-001", "49bb546y-35C0-48b4-93fe-bd0824e4fa97-errorSeverity": …

@Anjali_Rani we assume that every 5 Properties should form the datarow Prepare an empty DataTable with Build DataTable [grafik] Iterate over all properties and use a set of 5 properties for creating a datarow which will be added to the datatable [grafik] Result: [grafik] Find starter help h…

Hi Pls give a try with this component from market place JSON / JArray Conversion Activities - RPA Component | UiPath Marketplace A pack of 3 activities which can handle any nested and complex Json / JArray and converts it into XML, CSV files and Data Table. …

may we ask you to share the JSON as txt file with us or just reformat your post with the help of </> button. > Thanks

Testt.txt (1.2 KB) this is the text file, i want filepath, error code,desc… all are come in columns for all data. Please help.

You may refer below link which can help… [Convert Simple JSON To DataTable With Just One Activity In UiPath]

Dear Anjali, Do you want to convert each of the keys into distinct columns and place the value under them,if so you can refer the attached xaml. Import Newport.Json namespace from imports panel ForumJSONToTable.xaml (5.7 KB) Sample.txt (1.2 KB)

Thank you so much, [image] but i am getting this error while execution :frowning:

try with updated XAML from above

Thank you so much. It is working :slight_smile:

Help--Converting JSON Data into Data Table Activity

Help Studio

geetishree.rao (Geetishree Rao) October 4, 2021, 10:06am 4

Dear Anjali,

You can refer the below post in forum with similar query:
Convert json to Datatable - Help - UiPath Community Forum

and
How to Convert JSON data to DataTable UiPath - RPA LEARNERS

Topic		Replies	Views
Convert specific json data to datatable Studio studio , question , activities_panel	6	1932	September 5, 2022
Convert Json to Datatable without using loop Studio studio , question , activities_panel	7	3144	October 10, 2021
How to convert Json to DataTable Activities datatable , excel , uiautomation , orchestrator , activities , studio , api , studiox , question , python , json	9	2447	October 25, 2021
Convert Json to Datatable (Specific data) Activities excel , activities , question	22	6350	September 11, 2021
Json Array to data table using assign activity Studio	17	1924	December 15, 2022

Help--Converting JSON Data into Data Table Activity

Related topics