Webhook behavior expected?
I created a webhook that changes a field in a record, based on if a different field is modified. I chose a webhook because it works instantaneously, and it is such a simple thing I hate using an enti...
Forum Discussion
That should work, so I suggest a ticket to support. A webhook is supposed to trigger at the database level so it should not matter how the edit was done.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Customer support is saying webhooks do not support multiple record changes, unless you use API_ImportFromCSV utilizing the %repeaton% command.
??? So webhooks essentially dont work in grid edit I guess..?? Any webhook experts think otherwise or have a workaround (I can just use a pipeline....just wondering if anyone knows how to make it work with a webhook).
------------------------------
Mike Tamoush
------------------------------
Confirmed. API_Edit Record cannot be used in a webhook for multi record changes. But Kirk Trachy has a video on how to leverage API_importfromcsv
https://www.youtube.com/watch?v=-eY6ZAivCZY
Ill try it and report back!
------------------------------
Mike Tamoush
------------------------------Hi Mike,
This is true, below is the format we use. Not only does it only work on one record in Grid Edit but API_EditRecord also doesn't work on multiple record changes using Quickbase features like import/export, Pipelines, Workato or QuNect.
We stopped using API_EditRecord completely because it is limited and instead use API_ImportFromCSV for every Webhook.
<qdbapi>
<usertoken></usertoken>
<apptoken></apptoken>
<records_csv>
<![CDATA[
%RepeatOn%
[Record ID#],true,
%RepeatOff%
]]>
</records_csv>
<clist>3.123</clist>
</qdbapi>
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------Thanks Jim. So in your formula, in the clist I take it you include the Record ID, and then the field you want to change? How do you set the field you want to update?
For example, if I want to set field 100 to the word 'Test', how does that look?
------------------------------
Mike Tamoush
------------------------------
