Ability to schedule CSV exports on an hourly basis

Please sign in to leave a comment.

• 

  Sara Kaplow, Community Manager

  Hi James,

  I think there's a way to do this through Zapier, but I haven't had a chance to figure it out just yet. Stay tuned and I'll try to work up a way to do this soon!

  August 06, 2019 17:25

  0
• 

  Kevin Willis

  You can do this with a CRON job and PHP.   If you use the begin_second and end_second feature you can generate something like this.  This example is for 1 hour.  Just set your CRON job to run every 1 hour or whatever interval you want.

  <?PHP

  $timenow=time();
  $tminus1hour = time() - 3600;
  
  

  $url = "https://www.gocanvas.com/apiv2/csv.xml?form_id=xxxxx&begin_second=" .$tminus1hour. "&end_second=" .$timenow. "&username=username&password=password";
  $source = file_get_contents($url);
  file_put_contents('/somedirectoryonyourserver/filename.csv', $source);

  ?>

   

   

  October 31, 2019 18:00

  2