I’m currently using a connector function to integrate with out CMMS, Mainsaver. The request and response are both in XML instead of JSON.
The real problem is that the connector function only support Apache Freemarker 1.0 but Mainsaver uses a newer version, so I can’t parse out the response within the connector function . This requires me to process the whole response into variables using RegEx in App triggers.
I have it “working” but it’s saving both the full RegEx match (index 0), and the group match (index 1) as an array, which makes it more difficult to work with.
For example I’m using the following to extract the status of the response:
\<Status\>(.*)\<\/Status>
So for instance the resultant array index 0 is <Status>OK</Status>
, and index 1 is what I want, which is just OK
.
Is there a way to ONLY return index 1? Or if not, trim the output to index 1 and save to a variable?
I don’t want to paste private info here so sorry no screenshots but if I can find a way to sanitize the data I’ll try to add some examples.