I am trying to convert a Json response from web but when I try to run it I get the error Deserialize JSON Array: Object reference not set to an instance of an object.
In the deserialize json the TypeArgument is: Newtonsoft.json.linq.jobject
And JsonInput is the output from the HTTP Request
in such a case we would:
ensure that the retrieval: DeserializedJson(“entries”) is valid and the property is accessible. Feel free to share the JSON with us
we hope that jsonString vs JsonInput is not a missmatch on the variable names
{
“list”: {
“pagination”: {
“count”: 96,
“hasMoreItems”: false,
I dont have JsonInput
you mentioned:
can you use write text file activity and export the json response. It is easier for us to review the json on text file base. Thanks
Oh you are right, I meant JsonString
TestDjson.txt (342.5 KB)
This is the Deserialized Json
TypeArgument: JObject - out: myJObject
we replicated, while working with your JSON sample:
And did some analysis RnDs:
So list is parent to entries
For looping over all entries items which are of JObject we can also do (and avoid the JArray Parsing)
myJObject("list")("entries").Values(Of JObject)
@ppr Thank You, This has solved my problem
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
