How to convert Newtonsoft.Json.Linq[] to String

[tharani.natarajan]

Hi All ,

How to convert DeserialiseOp(“data”).ToArray into string

Kindly help

[Gokul001 (Gokul Balaji)]

HI @tharani.natarajan

Can you try to change the type of the argument, your passing string as a input to that activity

Regards
Gokul

[ppr (Peter)]

@tharani.natarajan

DeserialiseOp(“data”).ToArray

depending on the JSON we can check the different possible strategies. Can you share the JSON Data / sample data with us? Thanks

[tharani.natarajan]

Pfa the json output.I need preview,SentAt,Channel into datatable .I was planning to use Json to datatable activity .But Json to datatable activity requires string input .

Kindly help.
OP.Txt (66.0 KB)

[tharani.natarajan]

Pfa the json output.I need preview,SentAt,Channel into datatable .I was planning to use Json to datatable activity .But Json to datatable activity requires string input .

OP.Txt (66.0 KB)

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@tharani.natarajan Deserializeop(“data”)(3)(“preview”)

[ppr (Peter)]

@tharani.natarajan

.I need preview,SentAt,Channel into datatable .

we would recommend the following:

Prepare your data table with the 3 cols structure using Build Datatable

Then process the JSON:

• Deserialize JSON - out: myJObject
• For each activity | item in JObject(“data”) | TypeArgument: JObject
  • then acces the fields and add it to the datatable

Access example: item.("attributes")("preview").Value(Of String)