Error in Json Data

Help Studio
, ,
1

Hi All,
I am using Action Centre Activity . Inside Parallel for each I have used Wait for Form Task and Resume activity. I got the output data in Json Format Output.txt and I am trying to create data table with following data from JSON File and convert to data table.How ever I was getting the following error"

image
image1905×92 77.1 KB

1)"subscriptionId":"0068Y00001GhTfhQAF
2)in_TotalRolloverCredit
3)out_Approvedamount\

Output.txt (1.5
Output.txt (1.5 KB)

Can any one help me on this?

image
image838×762 21.2 KB

image
image1014×761 22.5 KB

image
image1014×761 22.5 KB

image
image1014×761 22.5 KB

image
image1014×761 22.5 KB

2

@marina.dutta

I believe it is failing in serializing the datatable variable

can you please check properly

cheers

3

Pass Json as String

Use the Assign Activity variable as “DataTable”

jsonList = JsonConvert.DeserializeObject(Of List(Of JObject))(jsonData)

In Assign activity:


dataTable = (From item In jsonList
             Select New With {
                 .Column1 = item("property1").ToString(),
                 .Column2 = item("property2").ToString(),
                 .Column3 = item("property3").ToString()
             }).ToDataTable()

Regards,

Prasanth Kumar Manivannan

BattleBots!!

@ marina.dutta

4

@PrasanthManivannan

In my case can you help how to get the Json fields according to the output attached.I have attached the Output Json Txt
Output.txt (1.5 KB)

2)in_TotalRolloverCredit
3)out_Approvedamount\

5

@Anil_G

How should I deserialize to get data table output?attached my Json output. I need the below three fields
Output.txt (1.5 KB)

2)in_TotalRolloverCredit
3)out_Approvedamount
subscriptionId

6

@marina.dutta

Use deserialize json activity and from output jobj use as below

in_TotalRolloverCredit - jobj("ItemData")("Data")("in_TotalRolloverCredit").ToString
out_Approvedamount - jobj("ItemData")("Data")("out_Approvedamount").ToString

Could not find the other you need please point it if needed or follow same steps

cheers

7

@Anil_G

My in_TotalRolloverCredit is of type (Integer/Double) . Trying to convert to String. Getting error.

image
image866×200 73.2 KB

8

@marina.dutta

Please use cint(value) value is the remaining formula

Cheers

9

@Anil_G
cint(dt_Output(“ItemData”)(“Data”)(“in_TotalRolloverCredit”).ToString) ?

10

@Anil_G

Tried something like this .

image
image1486×320 68.4 KB

11

@marina.dutta

May I know what type is dt_output

Cheers

12

@Anil_G

Its System.Data.DataTable

13

@marina.dutta

The above formula is for deserialized output which is the output of deserialize json activity and type is jobject and not datatable

Cheers

14

@Anil_G

dt_output should be Object type ot Data Table ?

15

@Anil_G

image
image2808×728 159 KB

Is this correct?

16

@marina.dutta

You have to reqd the text file into a string variable…

Then use deserialize activity on that string variable and the type should be jobject and not datatable…

From that you need to get the objects as above and add to datatable as needed

Cheers

17

Hi,

It’s double serialize json string. Can you try the following sample?

image
image797×1244 26.5 KB

image

Sample20230626-4Lv2.zip (3.2 KB)

Regards,