Zoho Report DELETE API changes
Hi Zoho, For about a year we have an application going that uses the Delete API to delete everything in a Zoho Table. This was working for the entire year until early last week when something changed. We noticed that previously we called an HTTP DELETE action to trigger the delete but looks like the API was changed to use HTTP Post. Was something changed recently as I have tested this on my business and personal Zoho account and receive the same error "7005 unexpected error" Do you have any idea
Python library ZOHO_IMPORT_TYPE error
Hi, I get the error com.adventnet.zoho.client.report.python.ReportClient.ServerError: u'ZOHO_IMPORT_TYPE is not present in the request parameters list' My code: def importData(self,rc,uri): try: with open('biexporttozoho.csv', 'r') as f: importContent = f.read() except Exception,e: print "Error Check if file biexporttozoho.csv exists in the current directory!! " print "(" + str(e) + ")" return impResult =
Zoho Reports API Import Error 7005
The Zoho Reports API import has not been working for the past week. The response is always Error 7005 "Sorry, an unexpected error occurred when performing this operation". Is there any way to make the API import work again?
Ability to specify database_sql_queries.xml file to execute for UploadTool
Hi. We have multiple databases that we want to update periodically with UploadTool. I generate own database_sql_queries.xml file for every database. What I want is to be able to specify file to execute like: ./bin/UploadFromDB.sh ~/sql_xml_files/database_sql_queries_organization_123.xml As I understand, what I can do right now is to either replace conf/database_sql_queries.xml file after previous import completes and start import again or duplicate whole UploadTool folder each with own database_sql_queries.xml
CSVUploadConsole.sh java not found error
Hi, I try to use UploadTool for linux. When i want to run CSVUploadConsole.sh i got this error " TOOLHOME/jre/bin/java: Permission Denied" and then i change permission to 777 for this java file then i got this error "TOOLHOME/jre/bin/java: not found" i search in form and google but i couldnt find any thing. I need help ASAP Thanks Umut.
Unable to run reports without error
Of recent, when trying to run a report and not customizing anything other than selecting Current Month, I receive "Unable to Process Your Request". I've logged out, back in, and using the standard report, Tickets by Account and again, only changing the date range to Current Month. I am an Admin to this account and have successfully run various reports in the most recent past w/o issue. All other functionality outside of Reports works w/o issue. Thank you for your thoughts and help as to why this
Zoho UploadTool connect Heroku database issue
Hi. I have an issue with connection to Heroku PostgreSQL database from UploadTool. I'm getting an error: no pg_hba.conf entry for host ... Looks like an additional parameter should be passed in with connection string sslmode=require as stated in Heroku docs. But I cannot find how can I set this configuration in ZohoUpload Tool. Does any one know how to deal with it? https://devcenter.heroku.com/articles/connecting-to-relational-databases-on-heroku-with-java#connecting-to-a-database-remotely https://devcenter.heroku.com/articles/heroku-postgresql#external-connections-ingress
Data API via curl
Dears, I have a very strange problem with Zoho data API via curl. I have a database called Monitoring which contains a Table called Test with two columns (ID, Value). If I try to add an element via curl with the command curl -d "ZOHO_ACTION=ADDROW&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=JSON&ZOHO_API_VERSION=1.0&authtoken=<my token>&ID=2&Value=3" https://reportsapi.zoho.eu/api/<my e-mail>/Monitoring/Test I always obtain the answer { "response":{ "action":"ADDROW", "error":{ "code":8518,
ADD Column API call with DEFAULT , MANDATORY values
Is it possible to set a default value and columns mandatory when using the ADDCOLUMN zoho action in the REST API ? I could not figure it out based on the documentation: https://www.zoho.com/reports/api/?shell#add-column THanks.
The required action param is missing
I have passed data using node and every time i got the error "The required action param is missing". Reference URL : https://www.zoho.com/reports/api/?php#import-data API URL : https://reportsapi.zoho.com/api/xyz@gmail.com/testDB/Accounts POST PERAMETER : 'ZOHO_ACTION' : 'IMPORT', 'ZOHO_OUTPUT_FORMAT' : 'JSON', 'ZOHO_ERROR_FORMAT' : 'JSON', 'authtoken' : '38f207ac4a8a5b73ce427***********', 'ZOHO_API_VERSION' : '1.0', 'ZOHO_FILE' : 'Accounts.csv', 'ZOHO_IMPORT_FILETYPE'
Whitelabel Solution Implementation
Hello! We've recently bought Zoho Whitelabel solution. We've implemented all the other technical things like domain mapping and all. Can anyone suggest how we can implement login for the solution?
Error 7309 when sending REST call to API
Hello, My compagny is currently starting to use Zoho report. We need to automaticaly send and get data from Zoho report so I am using the API. I ran into error 7309 which is not documented. I use the command curl : curl -d "ZOHO_ACTION=EXPORT&ZOHO_API_VERSION=1.0&authToken=fc7737f589d6ee8353b0fd396bbce16a&ZOHO_OUTPUT_FORMAT=HTML&ZOHO_ERROR_FORMAT=XML" https://reportsapi.zoho.com/api/bastien.a.meunier@capgemini.com/SalesTest/sales I am just trying to get table "sales" from database "SalesTest" which
GET XML via API to Bubble only getting 1 column
Good Afternoon, I'm trying to GET data from Zoho Reports using the Bubble development API. The results I'm getting are getting stuck at the first column Here's how I've set up the Bubble API connector to Zoho Reports: The rest of the parameters are: ZOHO_ACTION = EXPORT ZOHO_OUTPUT_FORMAT = JSON ZOHO_ERROR_FORMAT = XML ZOHO_API_VERSION = 1.0 ZOHO_DELIMITER = 2 (this sets the delimiter to a semicolon) And finally, the Bubble results when I initialize the call: You can see that columns 0, 1, 2, 3...
Force decimal numbers type when creating tables trhough API's bulk import
I'm importing data trough API's bulk import, automaticaly creating tables. I've ran into serious problem: when table is created and incoming data has some integer values (say, "total": 500), the type of a column will be set as 'Positive Number'. But if in later imports to this already exising tables "total" becomes decimal ("total": 550.6), request fails with "Bad request" error, because decimal value in being inserted into integer column. I don't see a way to force Zoho to create numeric columns
Invalid JSON in API response
Every API action that returns field "criteria" (EXPORT, FETCH), returns it like this: "(\"Id\"=\'id_2\')", which is invalid. Here's a full response that fails JSON validation: { "response": { "uri":"....", "action":"EXPORT", "criteria":"(\"Id\"=\'id_2\')", "result": { "column_order":["Id","table1field1","table1field2","table1field3"], "rows":[
Python Library for Zoho Reports
Hi, I use the Python Client Library (https://zohoreportsapi.wiki.zoho.com/Python-Client-Library.html) to run Zoho Reports API at home. It works great. However, when I try to run it my office it throws an error. I believe this is because my work place uses a proxy server that authenticates with my windows login account. Can you confirm if the Python Client Library can support API calls via a proxy server? If yes, how do I do this? Do I need to change the ReportClient.py file to support this? Thanks
Does the Zoho report API support the GET action?
I'm trying to GET data from Zoho Reports using the Skuid REST API connector. And I wanted to ask if the Zoho Reports API supports the GET action? I do not see this anywhere in the documentation....I would like to GET data from my Zoho reports database and into my Skuid application....Thanks for any help or advice Skuid APP REST Connection https://docs.skuid.com/latest/en/data/rest/index.html?highlight=rest
Response to a HTTP POST request that cannot be processed
Hello everybody: I am making an app for Android that sends many HTTP POST requests to my Zoho Reports account and I would like to know if there is any special or diferent response to those HTTP POST requests that cannot be processed because there are not more API units available. I want my app to be aware of this for the user to be notified about this in order he is able to make proper decision. Thanks in advance!
Using Zoho Reports python API, database not found when uploading to shared database of which I am not the owner
Hi, I get this "'Database not found!" error with the python Zoho reports API when adding a row to a shared database, one where I have write access but I am not the owner. Could someone recommend how to fix this? Thanks Rick Full message: Traceback (most recent call last): File "ZohoAccessor.py", line 102, in <module> ZohoAccessor().test() File "ZohoAccessor.py", line 29, in test self.addSingleRow(rc,uri) File "ZohoAccessor.py", line 65, in addSingleRow result = rc.addRow(uri, rowData,
Activity RELATEDTOID, SEMODULE
Currently, the CRM to Reports integration does not appear to provide the ability to pull over SEMODULE or RELATEDTOID fields. This prevents any sort of robust reporting on activity vs revenue. Is this on the radar, did I miss a checkbox somewhere?
How to import bulk data using custom function from JSON Array
Hi, Hope you are doing good. I am having an array of JSON data fetched from an external API through GetUrl method. I just want to import this JSON Array data into ZOHO Report new table by writing code on Custom Functions. I tried many ways and also gone through many articles but still no luck. I checked below URL and pasted the html form with JSON data FORM uploading but it didn't work showing xml error : https://zohoreportsapi.wiki.zoho.com/importing-bulk-data.html <response action="IMPORT"> <script id="_rf_8ahd_nua75_vl0asd_"/>
Bad request when calling ADD_ROW api
I have a web application that uses Spring client to send data do Zoho reports tables, when I run the development server with the same data and same code, all the commands are called correctly and I get 200 response. However, on production server, I am receiving 400 error (bad request), and I'm not understanding what is wrong with the data I send: This is the url I send the data: https://reportsapi.zoho.com/api/xxx@xxx.com.br/cervaki-app/Engajamento?ZOHO_ACTION=ADDROW&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=JSON&authtoken=xxxxxxxxxx&ZOHO_API_VERSION=1.0
Unicode / UTF-8 Support in Zoho Reports
Hi Support, We have a Google Form which stores input from people into a Google Sheet, we then have a hourly "Imported" in Zoho Reports, we takes the udpated data and updates a Zoho Reports Table. however, it seems UTF-8 Characters are being stripped out from the text entered into the Google Forms / Google Sheets. The specific example I have is the "See No Evil Monkey" character.
TIME data is clipping. i.e. does not support MySQL documented '838:59:59' with Table Joins (Advanced Report Engine)
I've been informed one of our databases has been migrated to "Advanced Reports Engine" I've noticed strange behavior: According to MySQL: MySQL retrieves and displays TIME values in 'HH:MM:SS' format (or 'HHH:MM:SS' format for large hours values). TIME values may range from '-838:59:59' to '838:59:59'. https://dev.mysql.com/doc/refman/5.5/en/time.html Secnario 1: No Tables - On Advanced Report Engine ( Works as expected) Create a new Query Table with the following SQL SELECT SEC_TO_TIME(86399) as
Bulk Import via API failing, HTTP Status 500, Error code 7005
HI Zoho reports... I am trying to copy from one database into another. I select a query from database 1, table A and insert into database 2, table A. This works fine for "Table A"...but is failing for "Table B"... However, when I iterate through the list and call "addRow" on a record by record basis the data can be loaded. Here are my API parameters for the IMPORT: bulk_params={'ZOHO_ACTION':'IMPORT', 'ZOHO_API_VERSION':'1.0', 'ZOHO_OUTPUT_FORMAT':'JSON', "authtoken": Config.AUTHTOKEN, 'ZOHO_ERROR_FORMAT':'JSON',
Bulk Import with "String" (instead of File) / Add Multiple Rows
I would like the ability to add multiple rows in a single API call. My API code runs in a cloud task worker environment and I have a list of JSON objects in memory, that I can easily marshall / convert into a string ... I would like to be able to pass that String (list of rows to be added) to the API. Due to the restrictions of my virtual cloud file, I am not even allowed to create a temp file, to dump this list ot a file and then IMPORT the file. I am currently iterating the list calling the ReportClient
Date datatype in the update criteria
Hi, I am trying to update a row in a table using a column of the data type Date in the update criteria. The update query doesn't work for me when the data type of the column in the update criteria is Date but works perfectly fine when I change the type to Plain Text. Specifying update criteria as follows - "(EmailID = 'abc@xyz.com') and (\"newdate\" = '12 Sep 2016')" I'm using this in Java and the specified date format is correct. Please advise. Regards, Sagar
Cant execute UploadFromDB.sh
Hi, I have configured upload tool according to guidelines given. But when i run "sh UploadFromDB.sh" in /bin directory of Upload tool, i get this message: Unable to launch "/Users/zodi91/Downloads/ZohoReports/UploadTool/jre/bin/java" (8) Please help.
Reports Cap
Are the reports viewed per page always capped at 500? Seem like too perfect a number to not be
Configuring the Zoho upload toll to run on the Server with rhe scheduled cron.
Can i configure Zoho Upload tool to be running on My Linux server. I want it to automatically be uploading data with the cron Job on my Linux server...
Can you make report for Outstanding Sale Invoices for Customers & Bills for Vendors
HiCan you make report for Outstanding Sale Invoices for Customers & Bills for Vendors which only show fully or partially unpaid Sales Invoices and Vendor Bills. Currently there is statement which showing all transaction which are closed (Payment received and payment made). Regards Muhammad Younas
Zoho Reports - Books Help required
Any experts out there who'd like a challenge. We want to have job costing reports pulled from Zoho Books for our construction company. It shouldn't be too hard if someone knows the product well. We will pay any one who can do this successfully.
How To Restore Accidentally Deleted Report
I inadvertently deleted a standard report on accounts. How can I restore this? i am using the free edition?
Error Api <code>7005</code>
<response action="ADDCOLUMN"> <error> <code>7005</code> <message> Lo lamentamos, se produjo un error inesperado al llevar a cabo esta operación. Se ha registrado el error y se revisará el problema. Sería de gran ayuda si nos proporcionara información adicional mediante el enlace de comentarios en la parte superior de esta página. </message> </error> </response>
Integrate Data into Zoho Reports
I want to be able to get my ticket data from Zoho Support and have it loaded into Zoho Reports so I can include it with our other reports on some KPI dashboards. I see we can use the API to communicate between the two but I don't know where to begin. Are there any examples of how to do this? I am not opposed to paying a reasonable price to have someone set this up for me.
ASP.NET C# Insert Records
Hi , From previous posts I could not find a sample to insert records in Zoho from a .NET app. Can anyone provide a sample on how to insert records from ASP.NET C# app to Zoho
Zoho Reports importErrors - ERROR: Invalid Date value
I am having problems importing Date data via the API. Initially, my table had one Date column (called `date_of_birth`) and the data imported fine. However, I have just added a second Date column (called `datetime_registered`) to the table and when I try importing data, I get the following error... "importErrors":"<nobr>[Line: 2 Field: 7] (04 Mar, 2016 15:17:34) -ERROR: Invalid Date value<\/NOBR><br><nobr>Import error, row skipped 2<\/nobr><\/br>" ...and that is despite my two date formats being
API Throttling ?
Hi Support, I am processing about 800 rows of data. I am looping through the data and doing a database API call (via Python Reports Client) After about 100 or so calls, I get the following error 2016-01-06 22:28:37,196 q2msgbldr.service DEBUG : Adding IO record [{'SeasonId': 2016, 'TransactionId': '1452119317196', 'ProcessingMessage': 'Queue2MsgBldr: Add / New Initial Create.', 'WeekId': 15, 'AthleteId': 2851}]
Traceback (most recent call last):
File "queueToMessageBuilder.py", line 95, in <module>
Pivot table ideas
Are there any plans in the pipeline to be able to show values in rows and colunns similar to excel. Also being able to see more than 100 distinct values?
Zoho Report error
Hi Support, I am logging into Zoho reports using user id: nonregressionuser@test.runmyprocess.com but am unable to create database in my account.Every time I try,I get the below error: Although,I can do the same successfully in my another account(bidisha.fci@gmail.com) without any error. Could you please let me know the cause of the error?
Next Page