About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Download Report from Mode to place on SFTP

  • 30 August 2023
  • 4 replies
  • 39 views
jduffy

Hi there,

I am trying to create a zap that initiates a report run in Mode, then moves the .csv report to a Google Cloud Storage bucket. Neither Mode or GCS have connectors in Zapier, so I’m attempting to do this all through custom API calls.

I’ve gotten as far as kicking off the Mode report, but am unable to actually access the report (over 100mb). Does anyone know of a way I can get to the report and then move it to GCS?

Thanks!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @jduffy 

Good question.

FYI: Files larger than 100 MB may result in a time out error.

https://help.zapier.com/hc/en-us/articles/8496288813453-Send-files-in-Zaps

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jduffy

Thanks @Troy Tessalone 

I don’t think it’s a timeout error I’m getting:

Failed to create a request in Webhooks by Zapier
<html> <head><title>502 Bad Gateway</title></head> <body> <center><h1>502 Bad Gateway</h1></center> <hr><center>nginx</center> </body> </html> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page --> <!-- a padding to disable MSIE and Chrome friendly error page -->

Here is my setup:

 

Troy Tessalone
Userlevel 7
Badge +14

@jduffy

A 502 bad gateway message indicates that one server got an invalid response from another.

 

What is the link to the API documentation endpoint you are referencing to configure the GET request?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
raydeck
Userlevel 2
Badge +1

Hey! Did you solve this in the last few days? If not:

 

  1. Did you try copying that URL and pasting it into your address bar? Does it work from your browser when it doesn’t work in Zapier?
  2. Zapier has an interesting bit of kit where you can just make the _upload_ request (presumably a signed PUT) to GCS and pass the URL from Mode as an attached files argument. Zapier takes care of downloading from Mode in that case. Maybe that works better?
  3. You could outsource this heavy lifting part to a third party system. My go-to is Xano. You can set up an endpoint there in which you could pass it the URL for the CSV from Mode, have it take care of the download/upload using its built-in file resource and external API support, and then return your the new object key back to Zapier where you can continue on your journey. 
Founder, Statechange.ai
Terms & Conditions