Quickbase Webhook to JSON

Question

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 replacing the semicolon with a comma using a formula, JSON ends up treating the list as a singular string. If I try adding double quotation marks, the backslash comes through on the webhook so the JSON still treats everything as a single value.Anyone ran into this problem before or know a way on getting the multi-select field to pass through proper JSON on the webhook?------------------------------Mark Laudon------------------------------

jeffpeterson1 · Answer

Figured it out:You can use that text formula I posted above,&nbsp; but when you are writing the webhook, you must write the field reference like this:{"key":[StringifyOne.raw]}the ".raw" will force it to pass over the raw value and ignore the formatting.You will get this as the output from the webhook:&nbsp;{ "key":"Test-App-1","Test-App-3" }&nbsp;------------------------------Jeff Peterson------------------------------

jeffpeterson1 · Answer

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
------------------------------

marklaudon · Answer

Thanks for the quick response! I currently don't have access to pipelines, but am looking to gain access to see if I do the way you said.

Do you have any other ideas/methods on achieving the same end result?

------------------------------
Mark Laudon
------------------------------

jeffpeterson1 · Answer

You need to 'stringify' the output of your field to a format that works in JSON.&nbsp; &nbsp;You would either need to use my method above,&nbsp; or write a text formula that can format it properly for JSON.&nbsp; &nbsp;&nbsp;
Can you share a example of what your field output looks like?------------------------------Jeff Peterson------------------------------

marklaudon · Answer

So currently, users use a multi select field and for example, choose Test-App-1 and Test-App-2.If that token is utilized in the webhook, it would be&nbsp;"variableId": "509215617581245","variableName": "Test","val": ["[testApps]"][testApps] ends up equating to "Test-App-1 ; Test-App-2" due to how multi select works in quickbaseI would need to change the semicolon into ", " (double quotation, comma, double quotation) so the JSON reads it properly.------------------------------Mark Laudon------------------------------

Forum Discussion

Quickbase Webhook to JSON

9 Replies

Related Content

Pipeline Make Request - Return Make Request JSON Output into fields

Introducing New Quickbase Navigation (beta)

Can I use quickbase actions within the same table?

Pushing JSON data to external API endpoint

Pipeline JSON Issue

Recent Discussions

Copied Field doesn't have the same usage as the original

Conditional formula url

Rollup Help

Empower Discussion

When the Expiration Date is On or Before Today, Change the Contract Status to Expired