How to de seralize the Jason data

[Baby123 (Baby)]

Hi Team,

I have one Jason data when I try to deserialze the Jason data i getting below format.
Input file
![

Error output file.

Previously I am getting correct format after some time I am getting different above format.

Can any one Suggest the solution

Thank You

[ppr (Peter Preuss)]

we would recommend to sort out the

vs

About the second screenshot: when JSON is deserialized sucessfully and we dump it out to the immediate panel we got this correct output.

in case we want to to cross-check the structures we would append a toString()

But to finalize the work

• please share with us the origin JSON as text file
• a description on what is needed & expected processing output

[Baby123 (Baby)]

@ppr ,
I am unable to share the input data.

But can you please tell me the solution.
I want know why I am getting Jproperty 1,2 etc …

[ppr (Peter Preuss)]

@Baby123

I want know why I am getting Jproperty 1,2 etc …

@ppr

when JSON is deserialized sucessfully and we dump it out to the immediate panel we got this correct output.

as mentioned above, this is the representation of the JObject within the immediate panel and also correct.

We also mentioned:

@ppr

in case we want to to cross-check the structures we would append a toString()

yourJObjectVar.toString()

[Baby123 (Baby)]

Hi @ppr ,

When I try to get the Value date from the Jobject after desterilise I was used Deserialze.SelectToken(“Value Date”)
Then I got correct values .

But it’s showing object reference not set an instance of an object.

In the immediate panel its showing Jproperty (1) {[02/03/2024]}.

How to get the value date from above one

[Jayesh_678 (Jayesh)]

Hi,

Check this:-

Deserialize JSON Response & Access properties

from an api response i am getting some data i am able to retrieve data using after deserialize and then using selecttoken(“yourvalue”).tostring but few them in response are coming like [ “id” ] now i want caputure that id only how can do that

Thanks

[Baby123 (Baby)]

I was used Get Task Data activity to get the queue data after I was used the Task data.GetDataJasonOjbect command to get the Jason format.

That is my input Jason format 1st screenshot in above.

The I need to extract the few details from the Jason. Loke Transction Id ,value date and invoice amount etc…

Note: Some times we got multiple Jason values in queue.

I need to extract all the Jason information one by one

Please suggest

[ppr (Peter Preuss)]

@Baby123

But it’s showing object reference not set an instance of an object.

when working with the SelectToken have a look here for the JSONPath Syntax
https://goessner.net/articles/JsonPath

especially pay attention on starting with . or ..

@Baby123

I need to extract all the Jason information one by one

in such case we define a retrieval to the loop element like myJObject(“data”).Values(Of JObject)
But it depends on the details and structures

@Baby123

I am unable to share the input data.

data can also be anonymized / redacted and then shared with us.