Webhook for Deleting Multiple Attachment File

Question

Hi All,&nbsp;
I am new for the Webhook / API. I would like to create a webhook to delete attachment for a portion of the records. A new field called "Webhook Trigger" is created (containing 0 or 1), to determine which records should trigger the webhook.&nbsp;
By referencing this discission (Automatically Delete File Attachments Upon Data Change), I have created below Webhook for modified records with "Webhook Trigger" = 1.
HTTP method: POST
Message format: XML
Message header: QUICKBASE-ACTION&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; API_EditRecord
&lt;qdbapi&gt;&lt;usertoken&gt;xxxSAMPLE_USERTOKENxxx&lt;/usertoken&gt;&lt;rid&gt;[Record ID#]&lt;/rid&gt;&lt;field fid="189" filename="delete"&gt;&lt;/field&gt;&lt;/qdbapi&gt;

However, it only works for the first record, and no effect for the rest of the records. Is there any other way so that multiple record deletion of attachment can be performed? Thanks so much!------------------------------Alex Wong------------------------------

markshnier__you · Answer

This thread discusses your issue.&nbsp; It's probably by far the most efficient method in terms of the load on your app and the speed of execution.
https://community.quickbase.com/discussion/webhook-behavior-expected#bmf285a62c-005f-41b6-8e68-01872a7eefd2
BUT, I doubt that it can delete a file attachment using that method, so maybe the above is "just FYI" for a future use case.
So Plan B is to use a Pipeline for this as it will handle the multiple record changes.&nbsp;&nbsp;
You can use the native Quickbase make Request Channel, and if you like use the shortcut format to just make a long URL.

Here is an example of running an API to Run a saved T2T import.&nbsp; Just look at the help notes for API
https://mycompany.quickbase.com/db/xxxxxxx?a=API_RunImport&amp;id=11
METHOD=POST
Or you can also use the similar syntax to the webhook but I think that the URL approach is simpler.
the URL syntax is likely

https://mycompany.quickbase.com/db/xxxxxxx?a=API_EditRecord&amp;rid={{a.id}}&amp;_fid_189=&amp;filename=delete

Please post back and let us know if that works.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

Forum Discussion

Webhook for Deleting Multiple Attachment File

Related Content

Attachment - file name

Using Grid Edit to Edit Multiple Records at Once

Deleting Orphaned Children (records)

Deleting Attachments

Notification with attachment

Recent Discussions

How do I unhide an app that I have no idea what it is named?

Expanded URL from Reports

Pipeline Error --> "Quickbase reported an error: No error"

View query record if single record otherwise view query list

Gnatt plugin