Modify reponse JSON fields

[Enzo Fusca]

Hi all,

the need is to modify responses (JSON format), by applying a mathematical expression to some fields.

The developed solution is the following:

For each field in the response to be modified (we have a list of the fields to be modified)

- "Evaluate JSON expression" to find all occurrences of the field (could be even hundreds with different values for one field)

- for each occurrence found, apply the "math expression" to obtain the new value

- for each occurremce set the new value with "regular expression"

This approach increases the mean response time up to many seconds, as the occurrences to be processed are many hunreds, and it is not acceptable.

Does someone have an idea about a possible alternative solution to be applyed? The response does not have a fixed schema with fixed fields, so the occurrences and their position can change.

Thanks in advance!

Enzo

[Ronald Dsouza]

if you are using version 9.4 onwards
//you could use javascript assertion -- jsonbody should be text
//https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-1/policy-assertions/assertion-palette/service-availability-assertions/execute-javascript-assertion.html

var json = context.getVariable('jsonBody');
var json = JSON.parse(json);

// -- after that you use your json manipulation

//finally save json 

context.setVariable("jsonBody",JSON.stringify(json))

[Ronald Dsouza]

Option 2:-

JSON to XML
--- XPATH manipulation using XSL

https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-1/policy-assertions/assertion-palette/message-validation-transformation-assertions/apply-xsl-transformation-assertion.html

XML to JSON again
-- or just use xslt to convert the entire body to JSON. This is quicker but need a lot of manipulation