Mapping Connect REST - Dynamically generated payload
Hi ,
We are facing an issue with mapping the JSON Response which is generated dynamically from the client end. The payload is having a product list which is different for each client,
Sample JSON is as follows. Under “resources” object there are list of objects which are not included with list notation. The “TEST 1” and “TEST 2” are dynamically generated resources.
Since resources name tags “TEST 1” , “TEST 2” are dynamic we are unable to map them to a Page. Appreciate your suggestions on this.
{
"products": [
{
"resources": {
"TEST 1": {
"Identification": "TEST 1",
"annotationSpecId": "42962317343719424",
"classification": {
"score": 0.026214128
},
"displayName": "thanks"
}
}
},
{
"resources": {
"TEST 2": {
Hi ,
We are facing an issue with mapping the JSON Response which is generated dynamically from the client end. The payload is having a product list which is different for each client,
Sample JSON is as follows. Under “resources” object there are list of objects which are not included with list notation. The “TEST 1” and “TEST 2” are dynamically generated resources.
Since resources name tags “TEST 1” , “TEST 2” are dynamic we are unable to map them to a Page. Appreciate your suggestions on this.
{
"products": [
{
"resources": {
"TEST 1": {
"Identification": "TEST 1",
"annotationSpecId": "42962317343719424",
"classification": {
"score": 0.026214128
},
"displayName": "thanks"
}
}
},
{
"resources": {
"TEST 2": {
"Identification": "TEST 2",
"annotationSpecId": "42962317343719424",
"classification": {
"score": 0.026214128
},
"displayName": "thanks"
}
}
}
]
}
Deutsche Bank Operations International (DBOI)
IN
@DOLUWEEG - I don't see any problem in this. Please try below steps:
1. Save the JSON response in a clipboard property. In connect-rest rule, you will see this option in response mapping tab.
2. In processing activity, call below Data transform.
2. Create a data-transform and choose 'JSON' while creating. Select auto map and save.
3. Pass the property having JSON response (from S1) as input to data transform. Select DESERIALIZE in execution mode.
This should map the response to clipboard.
The only problem I see in your question is JSON text. "TEST 2" is not valid as it has space in between. The tag should be like "TEST2".
Let me know if that does not work.