How to deserialize JSON array

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!

You can use this activity:

1 Like

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

3 Likes

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.