[URGENT] Extract Rows from Text Value of Json Array

datatable
excel
csv
activities
json

#1

Hi,

Is there any solution to extract rows from text data (json array) to data table?

From Text data (json array):
[{“id”: 1, “name”: “xxx”, “status”: “Y”},
{“id”: 2, “name”: “xxx”, “status”: “N”},
{…},
{…}]

To data table like this is csv:

id name status
1 xxx Y
2 xxx N

Thanks in advance!


#2

Hi @leewe01,

Refer this post

Regrads,
Arivu


#3

Hi @arivu96,

Thank you for your respond.

I am able to extract the text value of Json Array and transfer it into excel file. However, I have a problem with transferring it into data table using add data row activity. Please advice.

Thanks.


#4

Hi @leewe01,

can you send the xaml file, i ll check and update you.

Regards,
Arivu


#5

Hi,

Sorry that I can’t share the file as it has confidential information. Hence, I am sharing across the example of my workflow. Thanks!

Example.zip (8.0 KB)