%JSONExport - ID export

Question

Question

Yuri Marx · Apr 12, 2021

#JSON #REST API #InterSystems IRIS

Hi Community,

How Can I do to return ID when I call %JSONExport()?

Product version: IRIS 2020.3

Discussion (9)3

Log in or sign up to continue

Robert Cemper · Apr 12, 2021

create a calculated property and it looks like any other one

Property MyId As %Integer [ Calculated, SqlComputeCode = { set {*}={%%ID}}, SqlComputed ];

1 0

score 1 · Answer 1 · 2021-04-12T08:54:05-04:00

This is the right answer. It would be nice if there was a more built-in way to include row IDs in %JSONExport without having to do this though.

score 0 · Answer 2 · 2021-04-12T11:14:45-04:00

Yuri Marx · Apr 12, 2021

I agree with you, a Parameter for example

0 0

score 0 · Answer 3 · 2021-04-12T14:43:00-04:00

Hi, @Timothy Leavitt .#

What's about a prodlog ?

"JSONid public" would be nice pairing with "rowid privat" ?

score 0 · Answer 4 · 2021-04-12T14:46:48-04:00

Timothy Leavitt · Apr 12, 2021

I filed it June 18, 2019.

0 0

score 0 · Answer 5 · 2025-04-23T10:35:03-04:00

Evgeny Shvarov · Apr 23

Is it implemented yet? Found the need for it too :)

0 0

score 0 · Answer 6 · 2021-04-12T11:15:01-04:00

Yuri Marx · Apr 12, 2021

Thanks Cemper.

0 0

score 0 · Answer 7 · 2021-04-12T15:03:14-04:00

While I do agree, what's the use case?

If you're requesting objects en masse it's usually via sql and it's easy to provide id there.

In a case of a singular object you usually request it by ID so it's known beforehand.

score 0 · Answer 8 · 2021-04-12T16:03:48-04:00

I followed https://openexchange.intersystems.com/package/iris-rest-api-template to construct some API and the GetAll used JSONExport, but when you work with JavaScript projections to the objects is nice convert the JSON to object. With no ID return you need write an additional instruction to set the ID. After the insert operation, in the master detail forms, get the ID after persist the master, help us to build conditional detail forms.