Transform JSON

Question

Question

PILAR GUERRERO · Jun 1, 2017

Hi!

I have a question:

I create a Operation REST API , when I call to my client trough this REST API, my cliente returns list of object in JSON, like that:

[
    {
    "Center" : "aaaaaaaaaa",
    "Nif" : "00000000T",
    "NumberCenter" : "00000000",
    "Name" : "ppppp",
    },
    {
    "Center" : "aaaaaaaaaa",
    "Nif" : "00000000T",
    "NumberCenter" : "00000000",
    "Name" : "ppppp",
    },
    {
    "Center" : "aaaaaaaaaa",
    "Nif" : "00000000T",
    "NumberCenter" : "00000000",
    "Name" : "ppppp",
    }
]

On the other hand, I have in my Ensemble, Two class:

Class A --> lisf of class B

Class B --> Center, Nif,NumberCenter, Name

I need to iterate over JSON and capture de information a put this in my object A

I have been investigating... And I found a approximation that i want to do...

First of all, I want to iterate over JSON and capture de information

set a = "[{""Center"" : ""DKV"",""Nif"" :""00000001T"",""NumberCenter"" :""DKV_1"",""Name"" : ""Nombre_DKV""},{""Center"" : ""Vivisol"",""Nif"" : ""00000002T"",""NumberCenter"" : ""Vivisol_1"",""Name"" : ""Nombre_vivisol"",},{""Center"" : ""Stacks"",""Nif"" : ""00000003T"",""NumberCenter"" : ""Stacks_1"",""Name"" : ""Nombre_Stacks"",}]"
set JSON = ##class(%DynamicAbstractObject).%FromJSON(a) 
set iter = JSON.%GetIterator() 
while iter.%GetNext(.key,.value){write "Center = " _value.Center ,! }

can you give me tips to make it?

Discussion (9)0

Log in or sign up to continue

Dmitry Maslennikov · Jun 1, 2017

Next time, when you have a question, please create it from the main page, not as a comment to the post. In this case, you may get the response much quicker.

And to you question, on which side you have to do such transformation? Do you call some external REST API from Caché, or do you call some API written in Caché from your WebApplication which worked in Browser, or another way?

0 0

Dmitry Maslennikov · Jun 1, 2017

I would suggest that you working on frontend side in the browser, and call some REST API written in Caché or not, it does not matter. So, your code in JavaScript.

var data = getDateFromRest(); // you got some data from server, no so matter how you did it.

I suggest that your data is array, so, you could use map function and it contains something like this [{ "title": "car", "currency": "USD", "cost": "10000" }]

var newData = data.map(el => { return { name: el.title, value: el.cost + el.currency } })

will give you new array [{ "name": "car", "value": "10000USD" }]

2 0

score 0 · Answer 1 · 2017-06-01T06:22:02-04:00

PILAR GUERRERO · Jun 1, 2017

I call a external REST API and this returns a list of object in JSON

0 0

score 0 · Answer 2 · 2017-06-02T03:00:54-04:00

I'm sorry I think that i'm not explain very good. I'll try to do better...

I create a Operation REST API , when I call to my client trough this REST API, my cliente returns list of object in JSON, like that:

[
    {
    "Center" : "aaaaaaaaaa",
    "Nif" : "00000000T",
    "NumberCenter" : "00000000",
    "Name" : "ppppp",
    },
    {
    "Center" : "aaaaaaaaaa",
    "Nif" : "00000000T",
    "NumberCenter" : "00000000",
    "Name" : "ppppp",
    },
    {
    "Center" : "aaaaaaaaaa",
    "Nif" : "00000000T",
    "NumberCenter" : "00000000",
    "Name" : "ppppp",
    }
]

On the other hand, I have in my Ensemble, Two class:

Class A --> lisf of class B

Class B --> Center, Nif,NumberCenter, Name

I need to iterate over JSON and capture de information a put this in my object A

score 0 · Answer 3 · 2017-06-01T07:59:33-04:00

PILAR GUERRERO · Jun 1, 2017

Over Caché %Collection

0 0

score 1 · Answer 4 · 2017-06-01T08:08:00-04:00

  for i=1:1:collection.Count() {
    set item = collection.GetAt(i)
    // From this point it depends of the type of item you're storing.
    // You must know to fetch each property values.
    // Ex: set value = item.property (%ZEN.proxyObject)
    // set value = item.GetAt("property") (%ArrayOfDataTypes)
  }

Change the values and reassign it to each related property.

do item.SetAt("property", newValue)
set item.property = newValue

score 0 · Answer 5 · 2017-06-02T04:51:00-04:00

Ok!

I have been investigating...

I found a approximation that i want to do...

First of all, I want to iterate over JSON and capture de information

set a = "[{""Center"" : ""DKV"",""Nif"" :""00000001T"",""NumberCenter"" :""DKV_1"",""Name"" : ""Nombre_DKV""},{""Center"" : ""Vivisol"",""Nif"" : ""00000002T"",""NumberCenter"" : ""Vivisol_1"",""Name"" : ""Nombre_vivisol"",},{""Center"" : ""Stacks"",""Nif"" : ""00000003T"",""NumberCenter"" : ""Stacks_1"",""Name"" : ""Nombre_Stacks"",}]"
set JSON = ##class(%DynamicAbstractObject).%FromJSON(a) 
set iter = JSON.%GetIterator() 
while iter.%GetNext(.key,.value){write "Center = " _value.Center ,! }

Second i want to put it in my object... still investigating more about this

score 1 · Answer 6 · 2017-06-02T07:29:08-04:00

%DynamicAbstractObject instances have a method %Set(key, value) that you can use to insert new or update existing values.

set o = { "foo": "bar" }
write o.%ToJSON() // {"foo": "bar"}

do o.%Set("foo", "bars")
write o.%ToJSON() // {"foo": "bars"}

score 0 · Answer 7 · 2017-06-01T07:52:47-04:00

So do you need to iterate over a Caché %Collection or a Javascript array?
Which one?

If you need to iterate over Javascript arrays WHILE transforming each item, it's just like Dmitry said.