Pipeline to remove file attachments

You should be able to use a Make Request Step in A Pipeline.

First make a formula URL field on the table to have it generate the code.

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

Then expose that code result and copy paste it into the Pipeline make request URL.

The carefully hand edit it in the Pipeline step as you need to get rid of the hard coded record ID that you see, and instead drag down the reference to the record ID to be deleted form the trigger step.

for example it would probably need to be {{a.id}}

Also I think you need to select it as POST and not GET method.

Feel free to post back it you have any issues as I did not recently test this.

HI MarkShnier__You 

Thanks for posting the technique. A small heads up , we can directly post this URL in pipeline without making URL formula too.

https://xxx.quickbase.com/db/btb5popo?act=API_EditRecord&rid={{a.id}}&_fid_261=0&_fid_83=&delfile_fid_83=1

{{a.id}} being the record ID
fid_83 attachment field

I had this problem with a build I did. I ended up using Sharepoint to store the file, that way we didn't use document space on Quickbase. Then I made a URL button to "view the document" so you could pull it up from sharepoint straight from QB.

Since I can't delete the post, please disregard what I said below this.  I was using GET and not POST when running my Make Request. 

Also keep in mind that when using this technique, Quickbase still keeps a backup of these files that utilizes your attachment space.  You can find this in App Management > Manage File Attachments.

I am attempting to do this as well, but the version parameter easily breaks because I can't seem to find a way to dynamically populate that into the URL.  The JSON Restful API does a great job to deleting the version if you identify it...but the moment someone uploads new, the table gives it a new version number...not "1"...even if you tell the field to only keep 1.