1. Communication Service
  2. Best Practices
  3. Converting a JSON list result returned by the JSONPath query from the Assembly Template to a String

Converting a JSON list result returned by the JSONPath query from the Assembly Template to a String

The following JSONPath query returns result as a list within square brackets.

Reference: https://github.com/json-path/JsonPath#what-is-returned-when

Query:
 
$.documentSet.document.formData.medicalEvents[?(@.medicalEvent == \"Provider's Office\")].medicalEventServices[?(@.medicalEventService == \"Primary
Care\")].I_copay
Result: ["$25"]

By updating the query to include the concatenation function, and concatenating empty text at the end of the query result, the resulting format is converted to a string.

Updated Query:

$.concat($.documentSet.document.formData.medicalEvents[?(@.medicalEvent== \"Provider's Office\")].medicalEventServices[0,1].I_copay,\"\")
Updated Result: $25