I am able query the data that I want from an integration within a process model, but when I try to map the Json results to a CDT process variable, all of the fields are blank. The keys from the Json dictionary are identical to the names for each field in the CDT. How can I map the Json dictionary into the CDT process variable?
Alternatively, how can I create an expression rule to parse each field from the Json and map each of them to a text process variable?
the following expression returns all key, value pairs from the Json: a!fromJson(rule!<rule_name>().result.body)
However, the following returns a null value:
a!fromJson(rule!<rule_name>().result.body).keyname1
Discussion posts and replies are publicly visible
My recommendation is to encapsulate the integration into an expression rule. There you can do all the data conversion, casting and testing. This is our way of doing integrations. Just put two applications into production which completely run on integrations for data persistence.
Yeah that's what I've been trying to do. It took no effort to create an ER that returns the entire Json response, but have spent many hours trying to parse out individual values of the response or map them to a CDT.