Forum Discussion

damienpage's avatar
damienpage
Qrew Cadet
28 days ago

API not deleting attachments

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.

4 Replies

  • 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.

    • hueyal's avatar
      hueyal
      Qrew Trainee

      I have a pipeline that ran yesterday and deleted a file attachment.  The format I am using is:
      API_EditRecord&rid={{a.id}}&_fid_6=&delfile_fid_6=1&vid=1

      How many revisions of the file do you retain?  (See field definition.) In my configuration, only 1 revision of the files are retained; therefore, vid=1 deletes the only revision.  See:  Upload and download files – Quickbase Help

  • 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...

  • 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?