Skip to main content
Question

API not deleting attachments

  • July 17, 2025
  • 0 replies
  • 293 views

Forum|alt.badge.img+5

Hi all, hoping someone may be able to assist.

Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1'

The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist).

Has anyone else encountered this or possibly have a solution ?

Cheers in advance.

MarkShnierYou
Forum|alt.badge.img+24

A couple of years ago, there was a bug where if the file attachment was deleted by an API that the File management system  and also your statistics still showed that the file existed and you were consuming space against  your file attachment limits  

at the time, they definitely fix that bug because I had been working with a client to purge thousands of files attachments and they did fix the bug.  

If you can actually prove to Quickbase support that that is once again happening then that would be a legitimate bug.


Forum|alt.badge.img+5
  • Author
  • Registered
  • August 8, 2025

Hi all and thanks for input. Again i have attempted the above. The file itself is removed from the form, however it still appears in file attachments in app manager.

Below is the output from the pipeline call

Type:
action
Channel:
quickbase
Index:
b
Pipeline:
TRY TO REMOVE ONE SPECIFIC ATTACHMENT
Step:
Make Request
Run timestamp:
Fri Aug 08 2025 14:33:55 GMT+1000 (Australian Eastern Standard Time)

Input
url:
https://domain/db/bm6v8zsbw/?act=API_EditRecord&rid=179302&_fid_12=&delfile_fid_12=1
method:
POST
disable_ssl_verification:
false

Output
url:
https://domain/db/bm6v8zsbw/?act=API_EditRecord&rid=179302&_fid_12=&delfile_fid_12=1
status:
200
content:
<?xml version="1.0" ?> <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>179302</rid> <num_fields_changed>1</num_fields_changed> <update_id>1754627635259</update_id> </qdbapi>
elapsed:
0.125597

headers

json

qdbapi
action:
API_EditRecord
errcode:
0
errtext:
No error
rid:
179302
num_fields_changed:
1
update_id:
1754627635259

again any help appreciated...


MarkShnierYou
Forum|alt.badge.img+24

Have you tried going into the field properties for the File attachment field and setting the number of revisions to retain at 1?   Are you OK with not retaining previous versions?