7005 Error on ZohoQuery

7005 Error on ZohoQuery


We are experiencing some api issues since 27th Decemeber 2017 and wondered if you have changed the api requirements?


Adding and updating rows works fine using ZOHO_IMPORT_TYPE, but query commands like ZOHO_SQLQUERY have stopped working completely


We make the api calls are made via php (using sample code originally taken from your forum) and have been unchanged for a few years. The code example of one of the calls is as follows:

 

 

$url = "https://reportsapi.zoho.com/api/yyyyyyyy/tttttttt?ZOHO_ACTION=EXPORT&ZOHO_API_VERSION=1.0&authtoken=xxxxxxxxx&ZOHO_OUTPUT_FORMAT=CSV";

 

$ch1 = curl_init();

$data = array('ZOHO_SQLQUERY' => 'SELECT max(extract_time) as extract_time from "Standard import"',

              'ZOHO_INCLUDE_HEADER' => 'false'    

                  );

curl_setopt($ch1, CURLOPT_URL,$url);

curl_setopt($ch1, CURLOPT_POST, 1);

curl_setopt($ch1, CURLOPT_POSTFIELDS,$data);

curl_setopt($ch1, CURLOPT_RETURNTRANSFER, 1);


$rows = curl_exec($ch1);

 

It should return $rows as a date, instead, the response this gives me is:

 

<!doctype html>

<html>

<head>

<link href="https://css.zohostatic.com/db/v1_zr/themes/common/images/favicon.28528e6fcd65189b6883efa9f80a14f2.ico" rel="SHORTCUT ICON">           

<style>

.footer a{

font-family:Arial, Helvetica, sans-serif; 

font-size:11px; 

color:#0000FF; 

text-decoration:underline

}

....