Automatically clear file attachment field?

Question

Hi,&nbsp;I'm attempting to automatically clear the file from a file attachment field. I've tried using actions, automations, and pipelines and I haven't been able to figure out a way to do this. Is there a way?------------------------------Thanks,Alex------------------------------

markshnier__you · Answer

here are some cheat notes that will help.
URL to delete a file attachment

URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_9="
& "&delfile_fid_9=1"
// & "&apptoken=<your apptoken>"

Because someone else might come along looking for this: here's the XML version:

<qdbapi>
<udata>mydata</udata>
<ticket>auth_ticket</ticket>
<apptoken>app_token</apptoken>
<rid>[record_id]</rid>
<field fid="[field_id]" filename="delete"></field>

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

justintorrence · Answer

@Alex Gale
It looks like there isn't any explicit support in Pipelines for deleting a file attachment.
You could use the "Make Request" action in the Quickbase Channel under "Quickbase APIs" for this. This basically allows you to create your own custom Quickbase Pipeline Action (You just have to know enough about the API to form the call)
@Mark Shnier (YQC) has done some of the heavy lifting for you in his reply, if you wanted to use the HTTP API instead of the Restful API.
​
​------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

markshnier__you · Answer

Here is an example of how to make a webhook to Quickbase

Webhook.
Make Request
a bunch of the top fields are left blank

URL
https://mycompany .quickbase.com/db/xxxxxxxx (ie the target table)

Method
POST

(more)

Content Type
Application/XML

(strangely, the Body is entered next but when saved comes back in the sequence below)

Headers (list)
Name
QUICKBASE-ACTION

Value
API_RunImport ( in your case API_EditRecord)

Body
<qdbapi>
<usertoken>bxv4tx_wve_dcxcxcxcxcxcxcxcxc</usertoken>
<id>10</id>
</qdbapi>

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

justintorrence · Answer

@Mark Shnier (YQC)
Do you know if Quickbase going to be deprecating Webhooks and Actions along with Automations? Or will those be here to stay?------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------

markshnier__you · Answer

Maybe "aspirationally"&nbsp; but likely many many years from now or never.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Automatically clear file attachment field?