Skip to main content

How To Automatically Upload a Zoho File Attachment to Dropbox from Zoho Creator using Dropbox API v2 and Zoho postUrl

I'm an idiot, so this took about 6 hours for me to figure out, but apparently many people have not been able to figure this out, and I could not find a complete and working solution online anywhere.

If you want to be able to upload a file to Dropbox from Zoho Creator, you have to create a custom function like below (here I called the function "Dropbox", under namespace "Create"). In the function, the ID is being passed to it from the underlying form entry.

void Create.Dropbox(int id)
{
url = "https://api.dropboxapi.com/2/files/save_url";
headers = {"Authorization":"Bearer XXXXX","Content-Type":"application/json"};
data = {"path":"/FFFF/TTTT.XXX","url":"YYYY"};
datastring = data.toString();
response = postUrl(url,datastring,headers,false);
}


... where XXXXX is your secret Dropbox Token, and YYYY is the url of the file you are uploading, and FFFF is the Dropbox folder to which the file is being uploaded, TTTT is the desired filename, and XXX is the desired extension.

This uses v2 of the Dropbox API. You can get your Dropbox token and use the very helpful Dropbox API  Explorer here:

https://dropbox.github.io/dropbox-api-v2-explorer/#files_save_url

The key thing that was difficult to figure out and is not well documented is that the function toString() is necessary because Dropbox is expecting JSON and although the variable "data" above looks like JSON, it is not.

Comments

Popular posts from this blog

MasteringMedicare Medicare Cheat Sheet updated

 I'm excited to share the newest version, for 2021, of our MasteringMedicare Medicare Cheat Sheet. Feel free to share and provide feedback with suggestions and corrections.  Link to download the Medicare Cheet Sheet:  https://drive.google.com/file/d/1Nu45djmYDln7mSNG0v2Q57pkiACFvRv4/view?usp=sharing

Mastering Medicare Cheat Sheet

Amy Schiffman and I have created an awesome 1-page Medicare Cheat Sheet. You can get it for free by joining the Mastering Medicare subscriber list . Here's a sneak peak

Information about Medicare Advantage plans, coverage and benefits

Information about Medicare Advantage plans, coverage and benefits is available on this website, Medicare Advantage Information . Some topics covered include: additional benefits for medicare additional medicare benefits medicare advantage blue medicare advantage blue cross medicare advantage blue cross blue shield advantage c medicare advantage care plan medicare advantage cost medicare advantage d medicare advantage dental plan medicare advantage health care plans medicare advantage health plan medicare advantage insurance medicare advantage insurance plans medicare advantage of medicare advantage plan advantage of plan advantage plan insurance advantage plans with dental advantage policy advantages of medicare advantage advantages of medicare for all advantages of original medicare benefit medicare