Convert to JSON string

Question

Question

Bapu Hirave · Mar 24, 2017

#JSON #Object Data Model #Caché

here is my $ZV string "Cache for Windows (x86-64) 2016.2.1 (Build 803) Wed Oct 26 2016 12:43:35 EDT"

two questions

1. How do i convert any Persistent object to JSON String ?

2. How do i convert an y Register object to JSON string ?

3. Do i need to extend from any adaptor class for 1 & 2 ?

Discussion (11)0

Log in or sign up to continue

Fabian Haupt · Mar 25, 2017

%ToJSON() is only defined on objects extending %DynamicAbstractObject.
For example:

SAMPLES>s obj={"test":"42"}
SAMPLES>d obj.%ToJSON()
{"test":"42"}
SAMPLES>

To serialize arbitrary %Persistent/%Registered objects you'll have to use altJSONProvider
for example:

SAMPLES>s p=##class(Sample.Person).%OpenId(1)
SAMPLES>d ##class("%ZEN.Auxiliary.altJSONProvider").%WriteJSONFromObject(,.p)
{"_class":"Sample.Person","_id":1,"Name":"Love,Wolfgang A.","SSN":"917-96-1802","DOB":45275,"Home":{"_class":"Sample.Address","Street":"8360 First Street","City":"Zanesville","State":"WV","Zip":25788},"Office":{"_class":"Sample.Address","Street":"1842 Maple Court","City":"Hialeah","State":"NH","Zip":65893},"Spouse":"","FavoriteColors":[],"Age":"52"}

2 0

score 2 · Answer 1 · 2017-03-24T23:37:49-04:00

Bapu,

have a look at this article, it's explaining everything:

https://community.intersystems.com/post/introducing-new-json-capabilitie...

and this one explains the updates that have been made to the syntax: https://community.intersystems.com/post/json-changes-cach%C3%A9-20162

Cheers,
Fab

score 0 · Answer 2 · 2017-03-24T23:45:12-04:00

Hello Fab,

thanks for reply. Looks like in 2016.2, it has changed. I keep getting error when i execute

do myObject.$toJSON()

i tried to %ToJSON() as well. i get following error - <METHOD DOES NOT EXIST> *%ToJSON

score 0 · Answer 3 · 2017-03-25T01:58:08-04:00

But for that he needs to add an extending class to his classes. Using the native functions directly is less overhead.

score 0 · Answer 4 · 2017-03-27T10:37:10-04:00

Eduard Lebedyuk · Mar 27, 2017

Use %ZEN.Auxiliary.JSONProvider class.

0 0

score 0 · Answer 5 · 2017-04-04T13:40:21-04:00

When I attempt to use "%ZEN.Auxiliary.altJSONProvider").%WriteJSONFromObject() on a rather large Object (non-dynamic) I receive a FRAMESTACK error, anyone else have the same issue? If so, how did you overcome it?

score 0 · Answer 6 · 2017-04-04T13:54:05-04:00

Eduard Lebedyuk · Apr 4, 2017

What about %ZEN.Auxiliary.JSONProvider:%WriteJSONFromObject?

0 0

score 0 · Answer 7 · 2017-04-04T13:56:15-04:00

I am attempting to use this method to produce JSON output of my non-dynamic object, since non-dynamic objects do not provide a toJSON() method. I am running version Cache for Windows (x86-64) 2016.2.1 (Build 806_0_17136U) Tue Mar 7 2017 12:25:45 EST

score 0 · Answer 8 · 2017-04-04T13:58:27-04:00

I should say that when I use the %ZEN method and grab the output in a file, the file is over 12MB, which leads me to believe that the FRAMESTACK error is caused by the many references to child objects within the parent.

score 1 · Answer 9 · 2017-03-25T01:44:59-04:00

Eduard Lebedyuk · Mar 25, 2017

You can use RESTForms. It supplies converting object-to-JSON and JSON-to-object.

1 0

score 0 · Answer 10 · 2017-03-27T10:24:37-04:00

Don Rozwick · Mar 27, 2017

Anyone have pointers for 2014.1.5?

0 0