Quickbase Webhook to JSON
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 ...
Forum Discussion
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
------------------------------
Do you have any other ideas/methods on achieving the same end result?
------------------------------
Mark Laudon
------------------------------
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
------------------------------
- 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
"variableId": "509215617581245",
"variableName": "Test",
"val": [
"[testApps]"
]
[testApps] ends up equating to "Test-App-1 ; Test-App-2" due to how multi select works in quickbase
I would need to change the semicolon into ", " (double quotation, comma, double quotation) so the JSON reads it properly.
------------------------------
Mark Laudon
------------------------------Try this formula in a formula text field:
var text ReplaceSemi =SearchAndReplace(ToText([TestApps]), ";",",");
var text InnerQuotes =SearchAndReplace(ToText($replacesemi), " ","\"");
var text OuterQuotes = "\""&$innerquotes&"\"";
$OuterQuotes
You should get a JSON friendly output like this:
it also works if you add more choices:
------------------------------
Jeff Peterson
------------------------------- Yeah, I tried something very similar to that and it looks great in quickbase, but sadly the webhook json output displays it with the backslashes
{
"val": \"*Test-App-1\",\"*Test-App-2\",
"variableId": "534916701880710",
"variableName": "Impacted Application(s)"
}
}
I did get access to pipelines so I will see if I can get it working with the way you first suggested.
------------------------------
Mark Laudon
------------------------------