Convert Json To DataTable, Get json data from Queus

Help Studio
1

I have converted the Data Table to Json and added to Queues and I am getting the data from Queues but when I am trying to convert the json data that I get from Queues I can’t convert the json to data table.

2

Hi @Saiprathap_kovuru

You can directly send the data from the datatable to queues. You can retrieve the data from Queues. In Queues the data will be stored in Dictionary type. The column name as Key and the row value as value.
You can call the data from Queues by using In_TransactionItem(“Key Name”).toString.

Hope it helps!!

3

which detailed steps did you try?

4

I am Getting the Data in Line item Like this
image
this i have to convert to Datatable

5

yeah, While i am inserting the datatable to Queues. In queues its shown in the image
image
then how can i get the data for Queues
when i try to get the data
image

6

then you will deserialize it back into a datatable

assign activity
myJSON = myTransactionItemVar.SpecificContent("YourKey").toString

Option 1:
Deserialize JSON activity - set TypeArgument to DataTable ans use myJSON string

Option 2:
myDT = Newtonsoft.Json.JsonConvert.DeserializeObject(of DataTable)(myJSON)

7

How you added the JSON into queue. Please help me