Discussion

3
Replies
5756
Views
Close popover
Shivendra Kumar (shivendrak6931)
Cognizant
Shivendra Kumar
Cognizant
IN
shivendrak6931 Member since 2015 11 posts
Cognizant
Posted: May 19, 2016
Last activity: July 7, 2017
Closed

Parsing json responses in to a pagelist

Hi,

I am using below API in a java step in an activity to parse a json response. It is working. But the the results are not coming into pagelist mode property.

ClipboardPage stepPage=tools.getStepPage();
try
{
stepPage.adoptJSONObject(jsonResponse);
}

catch(Exception e)
{
throw new PRRuntimeException(e);
}

sample jaon is as below,

{
"name": "Sample JSON Response",
"version": "1.0",
"date": "2015-05-16 14:38:48",
"data": {
"A": "Value A",
"B":
[
{
"RequestID": "WO-234",
"statusCode": "010",
"statusDescription": "On hold",
"messageTypeID": "Info",
"destination": "Destination 1",
"recipientName": "Recipient 1"
},
{
"RequestID": "WO-235",
"statusCode": "011",
"statusDescription": "Cancelled",
"messageTypeID": "Notif",
"destination": "Destination 2",
"recipientName": "Reciepent 2"
}
]
}
}

When I do data mapping using the schema for json it creates a property which is a pagelist. but when i run the activity it goes in error with message that the property is page list.

Looking for any inputs.

TIA

Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.