Http Response Parsing JSON string or stream

Question

Question

Jimmy Christian · Jul 16, 2019

Hello community,

I am trying to parse the below HttpResponse in Cache. Cannot get the Iterator to work. Is there a single loop which can parse both or single messages and grab the error?

{
error:[
{ txt1:'error msg1'},

{ txt2:'error msg2'},
]
}

{
error: {
txt1:[
'error msg1',

'error msg2'
]
}

Thanks,

Jimmy Christian

Discussion (16)0

Log in or sign up to continue

Eduard Lebedyuk · Jul 16, 2019

Well, the JSON you posted is not a valid JSON. Where did you get it?

Valid JSON looks like this:

{
   "error":[
      {
         "txt1":"error msg1"
      },
      {
         "txt2":"error msg2"
      }
   ]
}

0 0

Vladimir Iliychev · Jul 19, 2019

Yes, this works if you have one level. But what about if you have second level-something like this:

{
"statuses": [
"SW7=ON, SW6=OFF, SW5=OFF, SW4=OFF, SW3=OFF, SW2=OFF, SW1=OFF",
"Unique Printer ID and Fiscal Memory ID are set",
"The fiscal memory is formatted"
],
"warnings": [],
"errors": [],
"ok": true
}

0 0

score 0 · Answer 1 · 2019-07-16T11:47:44-04:00

Eduard Lebedyuk · Jul 16, 2019

What version are you on?

If it's 2016.2+ you can use dynamic objects.

0 0

score 0 · Answer 2 · 2019-07-16T12:27:17-04:00

Cache for Windows (x86-64) 2018.1.1 (Build 312_1_18937U) Fri Apr 26 2019 17:58:36 EDT

I tried dynamic objects but gives me an error, unless i am not doing it correctly or if syntax is not correct.

Set objStream = objHttpResponse.Data
     Set json =""
     While ('objStream.AtEnd) {
          Set json = json _ objStream.ReadLine()

     }

set iter = json.%FromJSON().%GetIterator()
   while iter.%GetNext(.key , .value )
    {
       write "key = "_key_" , value = "_value,!
         }

score 1 · Answer 3 · 2019-07-16T12:30:00-04:00

You can simplify your code to this:

set dynObj = {}.%FromJSON(objHttpResponse.Data)
set iter = dynObj.%GetIterator()
while iter.%GetNext(.key , .value )  {
       write "key = "_key_" , value = "_value,!

}

Also json is a string so in your code sample it won't have %FromJSON method.

score 0 · Answer 4 · 2019-07-16T13:26:29-04:00

Thank you Eduard.

So the message i posted is a response to an API call i make with JSON payload.

So i was assuming that the response would be JSON and i can try to parse it.

But if it is not a JSON, is there a utility to parse it or i need to use the provided STRING functions like ZSTRIP and so on?

Thanks,

Jimmy christian.

score 0 · Answer 5 · 2019-07-16T14:10:01-04:00

Can you make the same call to the API using Postman and show the response?

It's very strange that API returns non-json response.

Does my code snippet throw the same error?

score 0 · Answer 6 · 2019-07-16T14:18:58-04:00

The issue is the API is not set up yet on the project which i am working.

But the specs has the JSON PAYLOAD as request and then the response is what i pasted above.

So i am trying to get the code ready to parse in the meantime until the API is set up. Hopefully i will have something to work with POSTMAN as soon as API is set up.

Once i receive the response , i need to parse it for any error and then shutdown the operation. At the most i can convert the response to string and check for error.

score 0 · Answer 7 · 2019-07-16T14:21:32-04:00

Well, maybe it's a handwritten response?

I'd recommend contacting the API developer and verifying that API responses would be indeed JSON.

score 0 · Answer 8 · 2019-07-16T14:27:22-04:00

Jimmy Christian · Jul 16, 2019

Thank you. Yes, i am going to find out in a day or two.

Appreciate your help and time.

0 0

score 0 · Answer 9 · 2019-07-17T14:38:47-04:00

JSONStreamToObect should do it.

If you can just paste the exact json, I can write it for you. No biggy

You can use this site to verify if json is correct

http://jsonviewer.stack.hu/

score 0 · Answer 10 · 2019-07-17T15:23:26-04:00

Thank you Neerav.

The message i pasted doesnt look like JSON.

Looks like i may have to use some STRING functions to parse it.

I will let you know once i get the right specs of the response. Thank you for time.

Regards,

Jimmy Christian.

score 0 · Answer 11 · 2019-07-17T16:02:39-04:00

No, it is JSON . Just one simple missing bracket. Here is the correct json for the same

{
error:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
],
error2:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
]
}

score 0 · Answer 12 · 2019-07-17T17:16:48-04:00

How is it valid JSON?

1. JSON accepts only double quotes. Single quotes are not valid.

2. Property names must be quoted (in double quotes). error/txt are not quoted.

Here's JSON standard.

score 0 · Answer 13 · 2019-07-19T02:18:20-04:00

Neerav Adam Verma · Jul 19, 2019

Json parsers are parsing it.

However I haven't tried to run it by code to see if it works.

0 0

score 0 · Answer 14 · 2019-07-19T05:09:16-04:00

Eduard Lebedyuk · Jul 19, 2019

Check this post to see how you can access all levels of dynamic object.

0 0

Http Response Parsing JSON string or stream

Social networks

InterSystems resources