Upload files to Google Drive using Make

[Barry]

Hello all,

In the new release of Caspio, 48, we have finally a new method to get files using only the file path! If you have been doing this with Make, it was required to use a complex scenario to get the file as it needed two calls to the APIand iterators(to get the externalKey and then to get the file). Now all of this can be done with a simpler scenario. I am sharing one simple setup that I am using to upload files to Google Drive when they are inserted at my Caspio table.

First, I have a Webhook in Caspio that sends the File field to Make when a record is inserted on my table that handles the files. This can be done by selecting the Webhooks module and using the url in Caspio to create the Webhook:

 

Then, after that module we add a custom API module, add module > Caspio > Make an API call(it is at the bottom of the list):

 

That module has to be configured with the following options:

URL: /rest/v2/files/path

Method: GET

Headers,
Key: Content-Type
Value: application/octet-stream

Query String,

Key: filePath
Value:  {{1.data[].File_}}

In filePath we have to select the file field from the Webhook module:

 

 

 

Then we can add any module that uploads files(like Google Drive) and use the response body and headers to upload:

 

Hope this Post helps any of you that have struggled to upload files to other services using Caspio Webhooks/API.