%JSON.Adaptor and relationship property

Question

Question

Matjaz Murko · Jul 23, 2022

#InterSystems IRIS

Hi.

Why are relationship properties not included in %JSONExportToString() method even they have cardinality one or parent?

Regards,
Matjaž

Product version: IRIS 2022.1

Discussion (3)1

Log in or sign up to continue

Matjaz Murko · Jul 24, 2022

I did some research... Relationship properties with cardinality one or parent are not included by default in JSON serialization. If property is included with parameter %JSONINCLUDE is not enough, because serialization causes infinitive recursion. XData Mapping or %JSONINCLUDE="NONE" in related class should be used to avoid infinitive recursion.

Regards,
Matjaž

0 0

score 0 · Answer 1 · 2022-07-24T00:00:55-04:00

As far as I know, they should be included in the output. If you want to force it you can add a property parameter on the relationship. https://docs.intersystems.com/irisforhealth20221/csp/docbook/DocBook.UI....

// Relationship to be includeed in JSONExport using JSON adaptor
Relationship Ingredients as Food.Item(%JSONINCLUDE = "inout", %JSONREFERENCE = "object") [ Cardinality = one, Inverse = Recipe ];

score 0 · Answer 2 · 2022-07-24T11:19:38-04:00

Hi.

I tried to include both of paramaters, but with no success. It looks like %JSON.Adaptor has some limitations...

Regards,
Matjaž