Zoho Remote API: Sheets OK, Writer & Show problems
Hi all.
I've been integrating the Remote API in a custom application for some days.
First I added the Zoho Sheet functionality. Basically all it does is read the contents of an XLS file, and then it makes a PHP Curl call via POST to pass the file to your system and get the URL of the editor, which is loaded as soon as your server returns a response.
With Zoho Sheet I found zero problems. Everything works perfectly! Great job.
But today I started working with Zoho Writer and Zoho Show (via Remote API) and started finding a lot of problems. With Zoho Show sometimes I get an "API Key is not valid" error (code 3890), other times I get a "null" url without error or warning message, just RESULT=FALSE.
With Zoho Writer I found other problems loading a file... it doesn't accept TXT or PDF format (altought it is said in the documentation) and sometimes does not even return an URL, simply "null" with no Warning or Error message.
My call to Zoho Writer is like this:
$url = 'http://export.writer.zoho.com/remotedoc.im?apikey='.$ZOHO_API_KEY.'&output=url'.'&lang='.$langcode;
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, array( 'id' => $file_id,
'filename' => $f->name,
'persistence' => 'false',
'format' => $format,
'saveurl' => $save_file_destination,
'content' => $fcontent
)
);
$result = curl_exec($ch);
curl_close($ch);
This same code works with Zoho Sheet but not with Zoho Writer or Zoho Show... how is that possible? In fact, I have yet to see Zoho Show application using the remote API.
What am I doing wrong? Please help me.
Thank you.
I've been integrating the Remote API in a custom application for some days.
First I added the Zoho Sheet functionality. Basically all it does is read the contents of an XLS file, and then it makes a PHP Curl call via POST to pass the file to your system and get the URL of the editor, which is loaded as soon as your server returns a response.
With Zoho Sheet I found zero problems. Everything works perfectly! Great job.
But today I started working with Zoho Writer and Zoho Show (via Remote API) and started finding a lot of problems. With Zoho Show sometimes I get an "API Key is not valid" error (code 3890), other times I get a "null" url without error or warning message, just RESULT=FALSE.
With Zoho Writer I found other problems loading a file... it doesn't accept TXT or PDF format (altought it is said in the documentation) and sometimes does not even return an URL, simply "null" with no Warning or Error message.
My call to Zoho Writer is like this:
$url = 'http://export.writer.zoho.com/remotedoc.im?apikey='.$ZOHO_API_KEY.'&output=url'.'&lang='.$langcode;
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, array( 'id' => $file_id,
'filename' => $f->name,
'persistence' => 'false',
'format' => $format,
'saveurl' => $save_file_destination,
'content' => $fcontent
)
);
$result = curl_exec($ch);
curl_close($ch);
This same code works with Zoho Sheet but not with Zoho Writer or Zoho Show... how is that possible? In fact, I have yet to see Zoho Show application using the remote API.
What am I doing wrong? Please help me.
Thank you.
Topic Participants
coolwind
Ahmed Hussain
solers
Sticky Posts
Zoho Office Integrator: Moving to the all-new Zoho Sheet
We introduced the latest version of Zoho Sheet—Sheet 5—in early 2019. This new version consists of a new user interface, improved performance, and an array of useful features. As a part of this, we will upgrade our Remote API integrations to the new version's editor interface on February 29, 2020. Update: The remote API integrations upgrade to the new version's interface will be done on April 15, 2020. Here are some exciting enhancements the new version of Sheet offers for our API users: An AI-poweredBusinesses prefer Zoho Office Integrator over Microsoft WOPI - Here's why
Businesses often have difficult decisions to make when building web applications that provide document management capabilities for their users. For example, what's the best solution to integrate with online office editors— Zoho Office Integrator or Microsoft