How to Show API Response under a Drop Down
I have configured REST - Connect Using Designer Studio == > Integration ==> Connectors ==> Create REST Integration .
The Response from API Call is
{"status":"SUCCESS","envm":["DEV1","QA","UAT"]}
Under the Integration Layer , it has generated Service , all corresponding Request and Response classses and a Data Page by name D_SearchCatalog .
When i ran the DataPage , it runs fine and returns me data as shown in the attached picture .
2. I also created a Activicty , and was calling the above created using Connect-REST Method
This was the response from the Activicty (show -page with response_GET )
<pagedata>
<status>SUCCESS</status>
<pxObjClass>Mine-Int-SearchCata-SearchCatalog_Response_GET</pxObjClass>
<envm REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pyValue>DEV1</pyValue>
<pxObjClass>SingleValue-Text</pxObjClass>
</rowdata>
<rowdata REPEATINGINDEX="2">
<pyValue>QA</pyValue>
<pxObjClass>SingleValue-Text</pxObjClass>
</rowdata>
<rowdata REPEATINGINDEX="3">
<pyValue>UAT</pyValue>
<pxObjClass>SingleValue-Text</pxObjClass>
</rowdata>
</envm>
</pagedata>
I have configured REST - Connect Using Designer Studio == > Integration ==> Connectors ==> Create REST Integration .
The Response from API Call is
{"status":"SUCCESS","envm":["DEV1","QA","UAT"]}
Under the Integration Layer , it has generated Service , all corresponding Request and Response classses and a Data Page by name D_SearchCatalog .
When i ran the DataPage , it runs fine and returns me data as shown in the attached picture .
2. I also created a Activicty , and was calling the above created using Connect-REST Method
This was the response from the Activicty (show -page with response_GET )
<pagedata>
<status>SUCCESS</status>
<pxObjClass>Mine-Int-SearchCata-SearchCatalog_Response_GET</pxObjClass>
<envm REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pyValue>DEV1</pyValue>
<pxObjClass>SingleValue-Text</pxObjClass>
</rowdata>
<rowdata REPEATINGINDEX="2">
<pyValue>QA</pyValue>
<pxObjClass>SingleValue-Text</pxObjClass>
</rowdata>
<rowdata REPEATINGINDEX="3">
<pyValue>UAT</pyValue>
<pxObjClass>SingleValue-Text</pxObjClass>
</rowdata>
</envm>
</pagedata>
My question is , from the API response , i need to extract the envm array and show the values in a drop down
For now , i just created a dropDown under UI Section .
I am comfortable with java , if java can help under Activicty , please let me know after getting the JSON under java , how to show it in UI
Could you please tell me how should i procceed ??
Pegasystems Inc.
US
Hi Ravi,
You can try with the below code to convert your JSON string into the ClipboardPage and then use the ClipboardPage content in your UI to source the list data into the dropdown.
Tested Sample Code:
PublicAPI tools = ThreadContainer.get().getPublicAPI();
ClipboardPage decryptedDataPage;
String JSON = "{\"AzDIntEncryptionFWEncryptedData\": \"Duo2EZA5o8iEJobDMMZFaOlE6LCyyasza+j+MVRP2cY=\",\"AzDIntEncryptionFWEncryptionTimeStamp\": \"20160525T093142.110 GMT\",\"AzDIntEncryptionFWMD5Checksum\": \"q/DI0a9pPJ1k2qvc3lQ5zQ==\",\"pxObjClass\": \"AzD-Int-EncryptionFW\"}";
oLog.infoForced("Input string: " + JSON);
try{
decryptedDataPage = tools.createPage("Gcsm-MaheshApp-Work-CodeTest", "decryptedDataPage");
decryptedDataPage.adoptJSONObject(JSON);
oLog.infoForced("Code ran successfully");
}
catch(InvalidStreamError e){
oLog.infoForced("Error string: " + e);
}
Hope this might help you to achieve your requirement.
Regards
Mahesh
MSoft
IN
Thanks Mahesh ,
What is the first parameter that is Gcsm-MaheshApp-Work-CodeTest ??
Also under the UserIntercae , i created a DropDown UI Control , how can i source this DropDown with the above JSON ?
Pegasystems Inc.
US
Gcsm-MaheshApp-Work-CodeTest - this is the class which contains the properties used in your json content i.e. Mapping class
For a DropDown UI control you can source with Data Page/Report Definition/ClipboardPage as shown in the attachment.