+12I 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 in Quickbase after.
What should be in the URL field, name field and value field?
Best answer by MarkShnierYou
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.
+24Here'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
+12So, I'm using make request correct? Should it be delete? Also, is the only thing I'm changing in the above is the field id and app token?
Are there any other fields in the make request that need to be completed?
+12Never mind, I got it.
https://MYCompany.quickbase.com/db/MYTABLEID?act=API_EditRecord&rid={{a.id}}&delfile_fid_19=1&apptoken=MYTOKEN
+24@carol. You're getting confused between syntax in a formula field in Quickbase and syntax in a pipeline string. In a pipeline string, you do not use the & for concatenation. you just run the elements together.
Notice in my suggested format above I don't have any quotes or extra & characters.
act=API_EditRecord&rid=" &refer to the [Record ID#] of the trigger record &_fid_9=&delfile_fid_9=1
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
