Question
Maantic Inc
US
Last activity: 5 May 2021 23:07 EDT
do we have any OOTB to convert JSON array to JSON object
Hi,
do we have any OOTB to convert JSON array to JSON object
JSON input
{
"id": "addressLine1",
"value": "123 main road"
},
{
"id": "city",
"value": "Boston"
}
expected output in clipboard
Property value
addressLine1 123 main road
city Boston
Pegasystems Inc.
FR
Hello,
Would that be helpful: https://collaborate.pega.com/question/how-set-value-arrays-json-objects-activity
Maantic Inc
US
Thank you @MarcLasserre_GCS. I tried with adoptJSONArray, it is not converting what expected
JSON input
{
"id": "addressLine1",
"value": "123 main road"
},
{
"id": "city",
"value": "Boston"
}
expected output in clipboard
Property value
addressLine1 123 main road
city Boston
Pegasystems Inc.
AU
This will be a two-stage data transformation.
- Use a JSON Data Transform on the Embed-NameValuePair class to map your JSON Array to a Page List of Embed-NameValuePair instances (deserializing your JSON objects as pyName <-> id and pyValue <-> value)
- Use a regular (Clipboard) Data Transform to iterate over your Page List and map each instance to a property on your target Address page.
The Data Transform for #2 can call #1 as the first step in its logic. You will need to pass the raw JSON as a parameter, and pass another parameter asking for the JSON Data Transform to be run in DESERIALIZE mode (i.e. turn JSON data into Pega clipboard data).
Maantic Inc
US
@BraamSmithCLSA sorry for late reply.
it works, thank you.
any idea about this method? addNameValuePair
assigning id as property and value as property value