Forum Discussion
BlakeHarrison
4 years agoQrew Captain
If you use Pipelines, you can capture the response in a text field and then parse the raw XML with a Formula Text (or Formula Numeric, since your value looks to be a number). You'll need to use a combination of SearchAndReplace and then Part. Probably something like this:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
var text a = SearchAndReplace([XML],"\">","*");
var text b = SearchAndReplace($a,"</","*");
Part($b,2,"*")
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- GeneStrelkov4 years agoQrew CadetThank you. I don't use pipeline, I'm using webbook straight from the table settings.
------------------------------
Gene Gene
------------------------------- BlakeHarrison4 years agoQrew CaptainWebhooks can't parse any responses. If you want to parse a response, you'll have to use Pipelines or a 3rd party system like Zapier or Workato. Pipelines has a Webhooks channel and the setup is very similar to the setup of a standard Webhook.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- GeneStrelkov4 years agoQrew CadetThank you. I will try pipelines.
------------------------------
Gene Gene
------------------------------