Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved JsonPackage.Setvalue Failed

  1. How-to
0
Votes
Undo
  1. André Monz
    André Monz
  2. PowerBuilder
  3. Tuesday, 3 September 2019 09:22 AM UTC

Hello,

i'm trying to merge 2 JSON Strings with jasonpackage.setvalue.
Unfortunately the key 'aeao' will be appended not be replaced.
Maybe somebody see what am i doing wrong?

 

JsonPackage ljs_pack
string ls_Json
string ls_aeao
integer li_rc

ls_Json='{"data":{"aeao":{}},"state":"ACTIVE","type":"RECEIPT","client_id":"d64e8056-0cba-43aa-9ba2-e9e563f12166"}'
ls_aeao='{"receipt_type":"RECEIPT"}'

ljs_pack=create JsonPackage
ljs_pack.LoadString( ls_Json)

ljs_pack=create JsonPackage
ljs_pack.LoadString( ls_Json)
li_rc=ljs_pack.setvalue( "aeao",ls_aeao)

/*
Result:
 
{"data":{"aeao":{}},"state":"ACTIVE","type":"RECEIPT","client_id":"d64e8056-0cba-43aa-9ba2-e9e563f12166","aeao":{"receipt_type":"RECEIPT"}}

but i need:

{"data":{"aeao":{"receipt_type":"RECEIPT"}},"state":"ACTIVE","type":"RECEIPT","client_id":"d64e8056-0cba-43aa-9ba2-e9e563f12166"}

*/

 

Using O10 DBMS to connect to oracle 12c database
Precision lost when exporting large numbers using ...
Accepted Answer
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 4 September 2019 04:05 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi André，

 

You can use the below code to set the data's value directly:

ls_aeao = '{"aeao":{"receipt_type":"RECEIPT"}}'

li_rc=ljs_pack.setvalue( "data",ls_aeao)

 

Or you can use the following code to assemble aeao json first and then set the data's value:

JsonGenerator lnv_JsonGenerator

Long ll_RootObject, ll_ChildObject

 lnv_JsonGenerator = Create JsonGenerator

ll_RootObject = lnv_JsonGenerator.CreateJsonObject ()

ll_ChildObject = lnv_JsonGenerator.AddItemObject(ll_RootObject,'aeao')

lnv_JsonGenerator.AddItemString(ll_ChildObject, "receipt_type", "RECEIPT")

ls_aeao = lnv_JsonGenerator.getjsonstring( )

li_rc=ljs_pack.setvalue( "data",ls_aeao)

 

Regards,

Ken

 

Comment
André Monz
  1. André Monz
  2. Wednesday, 4 September 2019 11:04 AM UTC
Hello Ken,



thank you very much.

I got i running with your code examples.



Regards,

André

  1. Helpful
There are no comments made yet.
Responses (2)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 3 September 2019 14:51 PM UTC
  2. PowerBuilder
  3. # 1

Don't know too much about JSON but:

If you do ljs_pack.GetValue("data") you get:

{"aeao":{}}

 

if you do ljs_pack.GetValue("aeao") you get 

nothing !

 

In other words, "aeao" does not really seem to be a key on which you can do a SetValue().

 

 

Comment
Load more comments
André Monz
  1. André Monz
  2. Wednesday, 4 September 2019 04:03 AM UTC
Ups, my bad, should be just one create and loadstring.

  1. Helpful
André Monz
  1. André Monz
  2. Wednesday, 4 September 2019 11:06 AM UTC
Hi Miguel,

Thank you for your Comment.

The json-Script i finally want to insert consists of many Arrays.

I'm not sure, replace() will handle such json-Strings correkt.



Regards,

André
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 4 September 2019 14:29 PM UTC
Yw,

I've learned something here :)
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.