Post Webhook Response In The Record

Question

I currently have a POST webhook setup in QuickBase with Endpoint to our 3rd party software.

The way it triggers, is when New Client record is added in Quickbase, it runs the webhook, that creates a user name in our 3rd party software.

When I run that webhook via Postman, if it's successful, it would display a response value (the value would be the user ID that it created in our 3rd party software).

Response:
<?xml version="1.0" encoding="utf-8"?>
<string xmlns="http://www.tempuri.org/">1079</string>

How can I have QuickBase see that response value (1079), because I want that value integrated in a specific field, from New Client record in Quickbase.

------------------------------
Gene Gene
------------------------------

justintorrence · Answer

@Gene StrelkovIt doesn't appear as though you can parse the response you get from a webhook. Generally speaking, webhooks are meant to be one way only. Pushing updates as they happen to another system to parse and process. The JSON Handler channel provides more of a back and forth, but it looks like your third party system responds with XML​------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

blakeharrison · Answer

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:
var text a = SearchAndReplace([XML],"\"&gt;","*");
var text b = SearchAndReplace($a,"&lt;/","*");

Part($b,2,"*")

​
------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

genestrelkov · Answer

Thank you. I don't use pipeline, I'm using webbook straight from the table settings.------------------------------Gene Gene------------------------------

blakeharrison · Answer

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

genestrelkov · Answer

Thank you. I will try pipelines.------------------------------Gene Gene------------------------------

Forum Discussion

Post Webhook Response In The Record