Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Officer
2 months ago
Solved

Delete file attachment after moving to sharepoint

I have a pipeline created to take a file attachment and move it to sharepoint and then update the quickbase record with url link. I'm having a problem trying to get it to delete the file attachment ...
Pipelines
  • MarkShnier__You's avatar
    MarkShnier__You
    2 months ago

    Yes it would be a Make Request.

    The URL would be like

    https://mycompany.quickbase.com/db/MyTableIdHere?act=API_EditRecord&rid=" &refer to the [Record ID#] of the trigger record &_fid_9=&delfile_fid_9=1

     

    ... replace the 9 with the fid of the file atatchment field.

    Then just select POST instead of GET.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

Here's an example of the syntax to edit a record and delete a file attachment. 

 

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

 

In a Pipeline you will need to hard code the actual URL.  Feel free to post back here if this does not get you unstuck