Converting Json to Datatable

(1) Share

Report

Posted on by SB-03090954-0

Hi Team,

I have requirement where I will get Json content from API response, I need to convert this JSON to data table and add it to queue and perform next respective steps

But I am unable to convert JSON to data table

If anyone have idea on this, please help me out

Thanks,

Soumya

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

harish_sada 53 on at

Like (1)

Report
Copy link

Link copied!
Hi,
Please follow the steps below:

Convert the JSON string to a list using the Convert JSON to Custom Object action.

Load the same data into the queue in JSON format.

Was this reply helpful? Yes No
SB-03090954-0 8 on at

Like (1)

Report
Copy link

Link copied!

Hi @harish

We will get more number of rows in that case how can we add it to queue and also how can we loop Json object by using for each loop

Thanks,

Soumya

Was this reply helpful? Yes No
Suggested answer

harish_sada 53 on at

Like (0)

Report
Copy link

Link copied!

Hi Soumya,

You can copy and paste the code mentioned below into PAD

SET NewVar TO $'''[
{
\"Name\": \"Alice\",
\"Age\": 30,
\"Country\": \"USA\"
},
{
\"Name\": \"Bob\",
\"Age\": 25,
\"Country\": \"Canada\"
},
{
\"Name\": \"Charlie\",
\"Age\": 28,
\"Country\": \"UK\"
}
]
'''
Variables.ConvertJsonToCustomObject Json: NewVar CustomObject=> JsonAsCustomObject
LOOP FOREACH CurrentItem IN JsonAsCustomObject
@@'InputSummaryValue:WORKQUEUE': 'Test_Queue'
WorkQueues.EnqueueWorkQueueItem.WithoutUniqueId WorkQueue: $'''206787d4-555e-ef11-bfe4-6045bda56ea9''' Status: WorkQueues.WorkQueueItemEnqueueStatus.Queued Priority: WorkQueues.WorkQueueItemPriority.Normal Value: $'''{
\"Name\":%CurrentItem['Name']%,
\"Age\":%CurrentItem['Age']%,
\"Country\":%CurrentItem['Country']%
}''' WorkQueueItem=> NewWorkQueueItem
END

Was this reply helpful? Yes No