Pipelines | Dropbox & Webhooks assist.
Goal: Utilize a third-party file storage service due to the economics of storing photos on Quickbase, but still maintain the ability to display the photos in a notification email. Method: Using pi...
Forum Discussion
I know this is an old post but hoping for one additional item out of this. I was able to take this and get my file uploaded to DB. The reason I need this function is to be able to send a file larger than one that can be emailed. I know want to create the share link from the file in DP, bring that link back into QB, and send that link in a notification. Pipelines does not have a Get File Link option so thinking this is going to have to be done with some API code on the DB side to get the link.
------------------------------
Joey Zint
------------------------------
------------------------------
Joey Zint
------------------------------
QuickBaseJunkie
Qrew Legend
Qrew Legend@Joey Zint I believe your answer is already in this thread (reply 7) when used in combination with the Dropbox API Documentation.
But let me expand.
You'll need 2 steps to access the sharable link.
2) Iterate over JSON records
Please note I'm not currently using this Pipeline but set it up for testing purposes. At which time it was functioning as expected.
Let me know if this helps 👍
-Sharon
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
But let me expand.
You'll need 2 steps to access the sharable link.
1) Fetch JSON
Type: POST
Headers:
Authorization: Bearer XXXXXXXXXX <-- Replace with your Dropbox authorization
Content-Type: application/json
Body:
{
"path": "{{b.path}}", <-- where b.path is the path from a prior Dropbox Upload File step
"settings": {
}
}
JSON URL: https://api.dropboxapi.com/2/sharing/create_shared_link_with_settings
Headers:
Authorization: Bearer XXXXXXXXXX <-- Replace with your Dropbox authorization
Content-Type: application/json
Body:
{
"path": "{{b.path}}", <-- where b.path is the path from a prior Dropbox Upload File step
"settings": {
}
}
JSON URL: https://api.dropboxapi.com/2/sharing/create_shared_link_with_settings
2) Iterate over JSON records
JSON Sample Schema:
Copied "Return" sample from this Dropbox API Documentation:
From the iterate JSON step, you can then access the URL to populate in your Quickbase/email.Please note I'm not currently using this Pipeline but set it up for testing purposes. At which time it was functioning as expected.
Let me know if this helps 👍
-Sharon
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
- Thank you so much....that was what I needed. Everything is working. I just need to refine the process to create a folder, place the file there, and update the existing file if there are changes in QB. This is not a process that is going to run very much. I just need an option to place large files that cannot be emailed into DropBox and send a link in a notification for them to download.
This is my first pipeline, so pretty stoked that it works. I have done some Microsoft Flows with QuickBase and this is very similar.
------------------------------
Joey Zint
------------------------------ - QuickBaseJunkieFantastic @Joey Zint! 🥳
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------