[URGENT] Extract Rows from Text Value of Json Array

[leewe01 (Lee)]

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!

[arivu96 (Arivazhagan A)]

Hi @leewe01,

Refer this post

Extraction of Data from a JSON

Hi Guys, I still have some Problems with the orignal Operation. The JSON part is now okay. But i have still Problems to write the extracted JSON informations to csv file. The Export to a csv presume that the data Comes from a datatable. How can i Transfer data from the json Export to a datatable? Regards Timo

Regrads,
Arivu

[leewe01 (Lee)]

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.

[arivu96 (Arivazhagan A)]

Hi @leewe01,

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

Regards,
Arivu

[leewe01 (Lee)]

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)

[Christopher_Gomez (Christopher Gómez)]

Hello,
How was this issue solve? I am having the same problem so can someone explain it to me please.

Thanks