Question
Srinsoft Technology
IN
Last activity: 2 Apr 2024 7:56 EDT
How to Map JSON response in excel (Having Pages and list)
Hi All,
I have requirement to download excel by following below structure, it should follow JSON response.
JSON Response like:
{
"Response": "",
"Page1": {
"Property": "X",
},
"Page2": {
"Property": "Y",
},
"Page3": {
"Property": "Z",
},
"PageList": [{
"Text": "1",
"Text": "2",
}
],
}
Getting results like below in excel:
| Response | |||
| Page1 | Page2 | Page3 | PageList |
| X | Y | Z | 1 |
| 2 |
If we are having more then one Array getting below.
Hi All,
I have requirement to download excel by following below structure, it should follow JSON response.
JSON Response like:
{
"Response": "",
"Page1": {
"Property": "X",
},
"Page2": {
"Property": "Y",
},
"Page3": {
"Property": "Z",
},
"PageList": [{
"Text": "1",
"Text": "2",
}
],
}
Getting results like below in excel:
| Response | |||
| Page1 | Page2 | Page3 | PageList |
| X | Y | Z | 1 |
| 2 |
If we are having more then one Array getting below.
| Response | |||
| Page1 | Page2 | Page3 | PageList |
| X | Y | Z | 1 |
| X | Y | Z | 2 |
| 1 | |||
| 2 |
Expecting results like below format:
| Response | |||
| Page1 | Page2 | Page3 | PageList |
| X | Y | Z | 1 |
| 2 | |||
| X | Y | Z | 1 |
| 2 |
Could you please let me know how can we achive this ?
Evonsys
IN
Hi @SREENIVASKALALI,
Please form the pagelist from the JSON response, here you can use the function @(Pega-RULES:Page).pxConvertStringToPage(tools,myStepPage,Param.ResponseMessage,"json").
After getting the Pagelist you can create a temporary pagelist and loop over it to customize how you want the exact output in the excel. Then in the step page, use that customized pagelist and use the activity pxGenerateExcelFile to get the required output.
Please go through the link if you are getting any problem using the activity:
https://docs-previous.pega.com/case-management/87/activities-integrating-cases-excel-documents
Srinsoft Technology
IN
@SrijitaB Thanks for your input, Yes we are following the same using the activity "pxGenerateExcelFile",
But my question is how the excel read start from specific row (after Completion of the list)?
| Curent Response in excel | |||
| Page1 | Page2 | Page3 | PageList |
| X | Y | Z | 1 |
| X | Y | Z | 2 |
| 1 | |||
| 2 | |||
| Expecting | |||
| Page1 | Page2 | Page3 | PageList |
| X | Y | Z | 1 |
| 2 | |||
| X | Y | Z | 1 |
| 2 |
Updated: 2 Apr 2024 7:56 EDT
Evonsys
IN
Hi @SREENIVASKALALI,
Can you share the sample response JSON file in order to understand in a better way? The JSON you have provided in the question seems invalid.