Parse dynamic JSON object in REST API response
Is there any OOTB functionality to parse dynamic JSON object from REST API Response ? I have the JSON like below. If you use pzExternalName qualifier value is hardcoded (00002237711), it is mapping correctly. Is there any way to pass pzExternalName qualifier value dynamically ?
"formulary_attributes": {
"00002237711": {
"abc_xyz": null,
"xyz_days_supply": null,
"abc_therapy": null,
"xyz_generic": null
}
"00003452711": {
"abc_xyz": null,
"xyz_days_supply": null,
"abc_therapy": null,
"xyz_generic": null
}
}
HCA Healthcare
US
Yes, you can dynamically parse JSON objects from a REST API response without hardcoding the keys by iterating through the keys programmatically. For example, in JavaScript, you can use Object.keys() to get all the dynamic keys and then process each one. Here’s a simple approach:
fetch('your-api-endpoint')
.then(response => response.json())
.then(data => {
const formularyAttributes = data.formulary_attributes;
Object.keys(formularyAttributes).forEach(externalName => {
const attributes = formularyAttributes[externalName];
console.log(`External Name: ${externalName}`);
console.log(`Attributes:`, attributes);
// You can further process each attributes object as needed
});
})
.catch(error => console.error('Error fetching data:', error));
Yes, you can dynamically parse JSON objects from a REST API response without hardcoding the keys by iterating through the keys programmatically. For example, in JavaScript, you can use Object.keys() to get all the dynamic keys and then process each one. Here’s a simple approach:
fetch('your-api-endpoint')
.then(response => response.json())
.then(data => {
const formularyAttributes = data.formulary_attributes;
Object.keys(formularyAttributes).forEach(externalName => {
const attributes = formularyAttributes[externalName];
console.log(`External Name: ${externalName}`);
console.log(`Attributes:`, attributes);
// You can further process each attributes object as needed
});
})
.catch(error => console.error('Error fetching data:', error));
In this code, fetch retrieves the API response, response.json() parses it, and Object.keys() extracts all dynamic pzExternalName keys like "00002237711" and "00003452711". You can then loop through each key to access and handle the corresponding attributes. Most modern programming languages offer similar functionalities, so you don’t need special OOTB tools. Frameworks like JavaScript’s native methods, Python’s json module, or libraries in other languages can easily manage dynamic JSON structures by iterating over the keys and processing the values as required.
BizArch Solutions
US
Thank you for the response. Are you talking about writing custom code in Pega ? Currently our response is mapped to JSON in our connector rule. When we ran the wizard, Pega created a page with that dynamic attribute (from sample response) and if the same attribute is given it is mapping, since in the pzexternalname qualifier has that dynamic attribute value. Is there any Pega way with out customization ?
HCA Healthcare
US
@ManRaj you can handle dynamic JSON keys from a REST API response without writing custom code by using built-in features. First, define formulary_attributes as a dictionary in your data model, where each key is the dynamic pzExternalName (like "00002237711") and its value holds the related attributes (abc_xyz, xyz_days_supply, etc.). When setting up your REST connector, use the JSON mapping wizard to map formulary_attributes to this dictionary property, allowing Pega to recognize and handle varying keys automatically. Next, create a Data Transform that uses a For Each loop to iterate through each entry in the dictionary, processing each pzExternalName and its attributes without needing to specify the keys manually. In your process flows or UI components, access these dynamic keys and their attributes using Pega’s expression language, such as .formulary_attributes.<dynamicKey>.abc_xyz. Additionally, use When rules to manage conditions based on these dynamic keys or their values, ensuring your application remains flexible. Use this approach which avoiding the need for custom coding and making your solution easier to maintain and adapt to changes. Thanks
BizArch Solutions
US
Sorry, I am not following you.
define formulary_attributes as a dictionary -- You mean create a Page list. What do you mean by dictionary in Pega ?
HCA Healthcare
US
@ManRaj yup Page list, you can parse dynamic JSON objects from a REST API response without custom coding. My approach is to start by creating a Page list property named formulary_attributes in your data model. Inside this Page list, define properties such as pzExternalName, abc_xyz, xyz_days_supply, abc_therapy, and xyz_generic. When setting up your REST connector, use the JSON mapping wizard to map the formulary_attributes from the JSON response to this Page list and now Pega will automatically create a new page for each dynamic pzExternalName key like "00002237711" or "00003452711". Next create a Data Transform to iterate through each page in the Page List, allowing you to access and process each set of attributes without knowing the keys in advance. In your process flows or UI components, use Pega’s expression language to loop through the Page List and display the data, such as .formulary_attributes.pzExternalName and .formulary_attributes.abc_xyz. Additionally, apply When rules to handle any conditional logic based on the dynamic keys or their values. I think this approach will avoid need for custom code.
BizArch Solutions
US
@Sairohith I believe we can't set pz properties in the code.