I've been stuck on this for a bit. So I am trying to pass JSON from a quickbase webhook to Everbridge, but quickbase is separating the multi-select values by semicolons instead of commas. If I try ...
Use a pipeline to convert that field using: {{a.your_field|tojson}} and store the output in another field. That should format it correctly. I do something similar with a few fields that I use to build a JSON to send to an external service.
Your pipeline will have 2 steps - A. Triggers on record updated, when that field is updated. B. Update record, write the value to your JSON holding field using {{a.your_field|tojson}}
Example:
Here I am stringifying the field [Technical Instructions] and writing the output to [Technical Instructions JSON] (which is a text type field) for later use.
------------------------------ Jeff Peterson ------------------------------
You need to 'stringify' the output of your field to a format that works in JSON. You would either need to use my method above, or write a text formula that can format it properly for JSON.
Can you share a example of what your field output looks like?
------------------------------ Jeff Peterson ------------------------------