Quick Books to Zoho Analytics integration issue
We have observed that few transactions are not flowing from Quick Books to Zoho Analytics when we integrate. There is no specific pattern observed. For Ex: In an accrual transaction a row is created for both Credit & Debit but for either of one row the
Unknown JSON attribute(s) found in the parameter CONFIG - Error Code 8542 - Facing this while try to update a row in analytics
temp.put("NeedAlyz",NeedAlyz); finalBody = Map(); finalBody.put("columns",temp); //info open+" "+closed+" "+answered+" "+awaitCusRes+" "+wfl+" "+solution+" "+onhold+" "+high+" "+medium + " view id : "+vid+" contact id : "+conid; //info overDue+" conid
Unable to import data into zoho analytics using the post man APIs of udemy for business
Hi Can some one help me with the following Unable to import data into zoho analytics using the post man APIs of udemy for business through API beta feature, I have created the sample report in zoho analytics through the table structure but i am unable
Report Data Table in Microsoft Excel or Zoho Sheet
we are built automatically generate po order as per our item qty reorder level etc... in excel sheet prepared for po import in zoho book. I create item-related report in zoho analyst. i was daily report download excel sheet in my folder and this excel
ERROR DECLARING DATEFORMAT IN ZOHO ANALYTICS
I am using the Zoho Analytics API (https://www.zoho.com/analytics/api/v2/data-api/add-row.html) and, as mentioned in the documentation, to record date and time data, the data must be formatted if you want to store it in a custom format. By default, the
PDF Include Options and Formatting using API bulk export
Hi all, I am successfully calling to export a dashboard from our Analytics workspace using the Analytics API from within a CRM function, however I have come across the following issues that we want to address: Include either: a custom header which displays
Zapier and Zoho Analytics API
I'm having a problem setting up a Zap using the Zoho API. I'm currently using the Zoho analyticz API to get data and write data into tables using Power Automate Desktop but for a certain task i need to connect it to Zapier to get the last row from a table
Error while importing an excel sheet to Zoho Analyitcs using PHP Library API
We are facing issue when we are trying to upload a csv file to zoho via the api integration (version: "2.1.0"). Organisation ID: 679207784 Workspace ID: 1861560000007540051 View ID: 1861560000020340002 We have already contacted your support and they requested
API Export Dashboard as PDF with Filter Criteria from Multiple Tables
When exporting a PDF of a Dashboard using the API, it accepts ZOHO_CRITERIA which comes from a single table, but won't export when the criteria contains more than one table. For example, imagine a simple dashboard with two charts, one showing sales by
map a key
email = zoho.encryption.urlEncode("email "); workspaceName = zoho.encryption.urlEncode("Book"); viewName = zoho.encryption.urlEncode("Stock_Sum"); paramsMap = Map(); paramsMap.put("ZOHO_ACTION","EXPORT"); paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON"); paramsMap.put("ZOHO_ERROR_FORMAT","JSON");
ZOHO API Analytics: Add new record if it not exist, else update row existing
Is possible to add a new record if it does not exist in my table, otherwise update existing record. I'm using ZOHO API Analytics V1. Thanks.
Dashboard Filters Disappeared! -- Resolved
I have Dashboards embedded in several websites via the Embed API. Just today, the filter boxes are no longer showing up. I contact ZoHo support with no answers as of yet. Anyone else?
Analytics Bulk API - Export Data (Asynchronous) JSON_PARSE_ERROR only on first try
Hello, inside a custom function in Zoho Flow I want to create an export job, but I get an error when I send the request. However, this error only occurs the first time, if I call the same custom function again in the flow I don't get an error message
Analytics-Update row; criteria
Hello Trying to update row in Analytics from Desk: headersMap = Map(); headersMap.put("ZANALYTICS-ORGID",orgId); config = Map(); config.put("columns",columnsMap); criteria = "(\"salesorder_id\"=" + creteria_salesorder_id + " and \"package_id\"=" + creteria_package_id
Zoho Analytics "Bulk API - Import Data". MORE_THAN_MAX_LENGTH
I have encountered a problem with "Bulk API - Import Data", it return { "status": "failure", "summary": "MORE_THAN_MAX_LENGTH", "data": { "errorCode": 8507, "errorMessage": "The length of the parameter FILE is more than required
Call modeling API
I am developing a wordpress plugin that will create a new workspace in Zoho Analytics through the Modeling API. So I am using PHP. I have the refresh token, client_id and client_secret, but i always have a fatal error in the client librairy. Here's my
Another import is in progess in UploadTool. No other imports.
Suddenly started getting an error message when running UploadTool: Another import is in progess in this table started by the user 'yourstruly' at '24 Sep 2014 04:33:23(GMT)'. Please try again after some time or contact the Reporting Database ("mydb") Administrator. There are no other imports in progress. Uploading multiple tables. The failure is NOT on the first one. The setup was working fine for quite some time. No changes were made. - Best Regards
ZOHO_CRITERIA not working with LIKE
API is working fine pulling data when using ZOHO_CRITERIA as $critera = "column = 'value'". However, in the API docs, it says that you can pass any SQL WHERE arguments including LIKE statements, which are not working. $critera = "column LIKE '%val%'"
Getting 500 server error for table creation request
Hi all, I am trying to create a table using Zoho analytics API in my workspace using vanilla Python but getting error with code 7005 which says "Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into.\n\nIt would be of great help if you could provide us with additional information using the \'\'Feedback\'\' link.". It seems to be a server problem but i guess i must be doing something wring because same API would have been used by hundreds
Internal error While making api call
I am getting the following error while making api call to add row to my table Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into.nnIt would be of great help if you could provide us with additional information using the ''Feedback'' link. Error_code: 7005 Can you please check why am i getting the following error?
7005 Error on importDataAsString request
In februari this year we created an importDataAsString functionality which was working at that time. Now I was running this functionality again and I got a 7005 error: Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into.nnIt would be of great help if you could provide us with additional information using the ''Feedback'' link. Error Code: 7005 HTTP_status_code: 500 From line 1368 on ReportClient.php Below a part of the php script
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?
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
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.
ZohoReports/Advanced CRM Analytics Issues
hi I have created an java program that extracts my data from zohoreports and inserts it my sql server database. the problem is that the data from zohocrm that is sync to zohoreports wont allow me to extract it. When i make a copy of that data it works so i dont know why it wouldnt work i get this error when i try to pull data from the zoho crm tables: xception in thread "main" java.sql.SQLException: Sorry, an unexpected error occurred when performing this operation. The error has been logged and
Upload Tool suddenly stopped working
I don't get any errors log, the only thing I get is the last line of the shell script: ./UploadFromDB.sh: línea 37: 26153 Terminado (killed) $JAVABIN $JAVA_OPTS com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB $1 $2 $3 $4 $5 The file has all permissions and I'm running it directly from console.
Today I started getting an API_ACCESS_REQUEST_BLOCKED error when the CSV upload program tries to log in
It doesn't happen all the time, but enough that I can't get all my data uploaded. Nothing on my side changed. What is wrong? Here is what I get in the log file: 2014/12/19 16:07:26 MST:Logging in 2014/12/19 16:07:26 MST:logging into https://accounts.zoho.com 2014/12/19 16:07:27 MST:IAM Error: Response status: 200 IAM Response: # #Fri Dec 19 15:07:27 PST 2014 CAUSE=API_ACCESS_REQUEST_BLOCKED RESULT=FALSE 2014/12/19 16:07:27 MST:Error!!! Could not login. Could be because of API_ACCESS_REQUEST_BLOCKED
Report Client returning empty rows, on exportDataUsingSQL call
Hello, A program just started failing last night at 1:28am EST, which for the past several weeks worked successfully. The issue using the report client actual call rc.exportDataUsingSQL(self.uri, "JSON", stream, sql, None) where the sql is a simple "select column from query-table" However, the query-table is currently empty. The report client, however, seems to be creating an empty row [u'', u'', u'', u'', u''] I am expecting no results to create a "rows" JSON array, with zero elements. Not a single
Lookup Columns not behaving properly on Joins and / or Query Tables
I am using the Report Client. exportDataUsingSQL method call. The SQL I am using is joining a few tables, one of the columns involved in the JOIN clause is a Lookup Column. This JOIN is now failing on that column. It is a relatively simple join Select .... From Table A a JOIN Table B b on a.col1 = b.col2 In this case, b.col2 is actually a lookup column, but I am getting an error stating that "col2" is an invalid Column. Using the create query table feature, I try "Select * from B" ...and
10,000 row limitation exceeded
I am evaluating Zoho reports for my company with the free trial. I have been importing and deleting in testing. I have no data in Zoho reports but says I cannot import as I have exceeded 10,000 rows. Can you explain how pricing and row count is calculated? Best regards Edith
Importing from a "New" Google Spreadsheet creates duplicate records
We have several Google spreadsheets that are automatically imported into our Zoho Reports tables. We use the criteria "Add records and replace if already exists". We always use the record ID as the unique identifier. Since setting up some imports from the "New" Google Spreadsheets, duplicate records are created in our Zoho Reports tables on subsequent import runs, but the duplicates have blank record ID's (the field we're using as the unique identifier) Attached are screenshots of the: Duplicates
BUG in JSON Exporter - Unnecessary escaping of single-quote producing invalid JSON data
I am trying to export data from one of tables using the JSON exporter... I've found that Zoho Reports exporting is escaping single-quote characters. e.g. the export produces output like this... "today\'s" but based on the JSON Spec... http://www.json.org Go to state machine diagram for string you'll see that a single-quote does not need to be escaped (i.e. no slash \ ) The JSON as it is is produced by Zoho Reports, fails validation. If I replace the \' with just a single quote ' the validation
HTTP 400 Error when using API
Hi, I'm trying to upload data through the API calls, about 80% of the time this works but the other 20% of calls return HTTP 400 errors. If the program waits 10 seconds and retries the identical data, it works. Unfortunately this makes importing data extremely slow. Is there a limit to how many calls can be executed and what is the maximum upload size? I have noticed the chance of it occurring is bigger if you upload more lines at once, but it can also give you an error when uploading as few as 10.
Reports
Made report one day, went to go acces the next day and it would not allow me access it. This is what it showed when I tried to click on it: View/Table is not present in the database 1. It is possible that you typed the address incorrectly. 2. The page you are looking for does not exist. Go Back | Provide Feedback / Error Report | Home | Forums | Contact Us CAN YOU FIX???
Query Zoho HTTP API on Query table
Hi, I am having a problem on executing queries on a Query Table using HTTP API. My code works fine, my query get total o rows in a query table. The problem: - I have one table called "Visits" and a query table based on this one. When I execute the query using HTTP API (select count(*) ....) I got the total of rows. But If I add new rows on table "Visits", and execute new query (on query table) using API, the total of rows is not refreshed. It refresh only when I manually open the query table and
ZOHO_CRITERIA STOPPED WORKING ON DASHBOARDS
Hi, The link below was working perfectly until some hours ago, when it started to show the following message: The view cannot be displayed since the associated criteria is not valid https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=272046000000797758&STANDALONE=true&privatelink=697a90cebec169368d0aa6ad2b9672e9&WIDTH=400&HEIGHT=300&ZDB_THEME_NAME=blue&ZOHO_CRITERIA=(COORDENADOR='REGIS ARTUR DE CASTRO AMARAL' OR SUPERVISOR='REGIS ARTUR DE CASTRO AMARAL' OR PROMOTOR='REGIS ARTUR DE CASTRO AMARAL')