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
@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
------------------------------
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
------------------------------
- Fantastic @Joey Zint! 🥳
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
