How to deserialize JSON array

Help Robot
, , ,
1

Hello,
I’m trying to deserialize a JSON array. This is the data sample:

[{“F1”:“75153”,“F2”:“078409”,“F3”:“ABC Inc.”,“Status”:“IN”,“score”:“4.161”,“cf”:“1.000”},{“F1”:“12218”,“F2”:“218272”,“F3”:“XYZ llc”,“Status”:“AC”,“score”:“4.161”,“cf”:“1.000”}]

I need to populate a datatable with columns: F1, F2, F3, Status, score, cf pulling the data from the array.

How do I do that?

Thanks!

2

You can use this activity:

3

Hi,

You can also try this method
assign strJson= “[{“F1”:“75153”,“F2”:“078409”,“F3”:“ABC Inc.”,“Status”:“IN”,“score”:“4.161”,“cf”:“1.000”},{“F1”:“12218”,“F2”:“218272”,“F3”:“XYZ llc”,“Status”:“AC”,“score”:“4.161”,“cf”:“1.000”}]”
assign myDt = JsonConvert.DeserializeObject(of datatable)(strJson)

Thank you

4

Wow, that’s a very elegant solution and it worked great. Thanks!