Zoho Remote API: Sheets OK, Writer & Show problems

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.


































    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation
                                              • 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-powered
                                              • Businesses 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


                                              Manage your brands on social media



                                                    Zoho TeamInbox Resources

                                                      Zoho DataPrep Resources



                                                        Zoho CRM Plus Resources

                                                          Zoho Books Resources


                                                            Zoho Subscriptions Resources

                                                              Zoho Projects Resources


                                                                Zoho Sprints Resources


                                                                  Qntrl Resources


                                                                    Zoho Creator Resources



                                                                        Zoho Campaigns Resources


                                                                          Zoho CRM Resources

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now