Need new API to get dependency details of all views in workspace
I want to request a new API to get source tables and query tables for all the views in a workspace. Feature Request Details: There needs to be an API which gives the following details for all views in the workspace in a single request: Dashboards What
Zoho analytics delete api
Hi, I am trying delete few records based on criteria, I was able to generate & refresh token however I am unable to delete records from the tables, receiving config params error. Thanks, Madhuri
8542 Error code in Zoho analytics API
In a single firebase cloud function, I want to fetch data from two different tables, but when I hit zoho analytics API using Zoho analytic's Nodejs client library, I get error as, { "errorCode": 8542, "errorMessage": "Unknown JSON attribute(s) found in
How to copy workspace from one account to another?
I want to copy a workspace from one account to another account. It is written in the description of Copy Workspace API - "The Copy Workspace API is used to copy the workspace from one Zoho Analytics Account to another Zoho Analytics Account". But the
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
Is there a postman collection for the Zoho Analytics API?
The title.
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
Zoho Projects Integration - Project Completion %
Hi everyone I've connected our Zoho Projects to Zoho Analytics to pull specific types of reporting. One area I am battling with is finding the field data that shows completion % of specific projects. In Zoho Projects I can see the complete % per project
Get info from "incorrect" JSON from Zoho Analytic
Hello all, When you get info from the Zoho Analytics API, the JSON sometimes comes in a incorrect form. I am getting info from a report and the JSON comes this way { "ID":"81921000005496719", "Name":"Product1", "Total":"110.00"},{ "ID":"", "Name":"",
Update column type/formatting via API
Greetings! I have a table with 107 columns and I want to change at least 20 fields from decimal number to currency and apply currency symbol and separator. As far as I know, I have to manually change the type of a column, wait, change the data formatting,
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
Combine 4 SQL sub-query into Single query (ZOHO Analytics)
ZOHO Analytics is a database which supports SQL syntax of MySQL, SQL server, Oracle, PostgreSQL, etc... I'm using syntax of MySQL. I am able to construct the whole SQL, it consists of 4 levels of sub-query, but here's the problem. ZOHO Analytics only
How to get the <OwnerEmail> using the API endpoints?
Hello! I'm trying to write some API integrations, but the endpoint I need to use requires the passing of the owner email, and I was wondering if it was possible to read this value by using a different endpoint, because the way our interface is designed,
i need help
I need to calculate the time zone converter from UTC to LOS Angelas time when the time zones change i know i need to use the following but I have no idea how to implement it into my query can you help. IF( CONVERT_TZ("timestamp_column", '+00:00', '-06:00')
Final Notice - Deprecating Authtokens in Zoho Analytics
In our commitment to continuous improvement, we've been working on to upgrade Zoho's authentication method from authtokens to a more secure OAuth. We have been communicating about this important migration process in the recent post. This is the final
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
Woocommerce Product Table List
Hello EveryOne, WooCommerce Product Listing Plugin is the Easiest, Fast & Awesome way to list your WooCommerce Products Items in responsive, user-friendly table view or order form with a quick view option.
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%'"
Problem with API request
I'm trying to make an API request but I keep getting an Error Response 7018 Invalid URL Format. I can't figure out what I'm doing wrong. This is the request: https://reportsapi.zoho.com/api/<e-mail>/<db name>?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=CSV&FORMAT=XML&authtoken=<auth-token>&ZOHO_API_VERSION=1.0&ZOHO_CRITERIA=(%22CDO%22%3D%27260000%27)&ZOHO_DELIMITER=0 As a test I'm trying to pull just the records that have "CDO" = '260000' in the CSV format, can anybody see what I'm doing wrong?
How to read time logs from people in analytics?
Is there a way to read the time logs from zoho people by employees in zoho analytics to create dashboard entries? Please let know if such process exists. Thanks in advance.
CNAME mapping in AWS
Can we do CNAME mapping for white label solution on AWS?
Zoho Analytics API Authtoken - Deprecation Notice
If you are using Zoho Analytics APIs and using authtokens for authentication, please note that the support for authtoken will be deprecated very soon. We recommend to use Zoho OAuthTokens instead, which are much more secure. Zoho OAuthTokens work much
Error while executing query
I am using this code for executing query, IReportClient RepClient = new ReportClient("1000.xxx", "xxx", refreshToken); //'Zoho CRM Analytics' //Enquiry , leads string tableURI = RepClient.GetURI("xxx",
How to use ZOHO CRITERIA on public panel url
Hello, I created a panel with different graphs that use different tables as a base but all of them got the same column called seller, I configured in all graph options filter parameters to link to the same filter. I want to use this filter in the URL so u show different panel for every seller.
Creatng/Updating a Table via API using a JSON (PHP)
Hello! So I've been attempting to import/update data into Analytics in PHP via its API, but I haven't been able to make the functions from the Library file (ReportClient.php) provided by the documentation (https://www.zoho.com/analytics/api/#php-library) work. For example, when trying to use the createTable() method, it says it needs these 2 parameters: - The workspace URI - How exactly?: "https://analytics.zoho.com/workspace/XXXXXXXXXXX"? Just the workspace ID? Or is it something else? - Table structure
SAP Business One SQL connector
Hello, is some solution to connect ZOHO Analytics to SAP Business One database? We wanna analyse data via ZOHO. There is any connector prepared for SAP B1? Anybody knows? Any idea? Thanks.
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
Strange UPDATEADD Error
I'm getting an Error when I try to do an UPDATEADD API call to reports with more than 300 records. I got Error!!! 7231 Column ID is present in match columns but not in selected columns I want to know how to trouble shoot this? As far as i know the selected column which needs to be matched in the zoho table must be available in the CSV file which is going to import and I've checked them both the zoho table and the CSV file twice both contain the matching column which is using for updatedadd API call
Embending API problem
We're having an issue with the underlying data, We're using the embedurl from de api indicating the underlying data permission to true & the columns that we want to show. The UD was previously showing on the portal where we embed the url. We don't know if some of the documentation regarding the API changed recently. I hope you can point us what we are doing wrong. Just to reiterate this was already working before today
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
How to find the number of API units consumed?
I am testing the Zoho Analytics API and I want to know how many API units have been consumed till now. I am not able to find this information anywhere in the UI.
Create Table JSON Spec
Hello, The API Documents explains that a ZOHO_ACTION= CREATETABLE is possible. https://www.zoho.com/reports/api/#create-table However the payload info only say ZOHO_TABLE_DESIGN (mandatory) Design content in JSON format Table structure in JSON format (includes table name, description, folder name, column and lookup details). There is no spec on how to actually design the table... Table name, column names, column types, etc ... Are there any guides or a examples how I can use a JSON table design
Problem with Imports on Zoho Reports C# api
I'm having no luck getting bulk Import function to work with the c# api library. I can add or update rows to a Zoho database table just fine but when I try to use the ImportData function I get nothing. I don't even get a response so I can debug what I'm sending. I am trying to import a JSON data string but I have had no luck importing from a file either. Does the free version of Zoho Reports not allow API Imports? I pasted my code snippet below. I have tried every combination of settings for
Consistently getting action: DELETE, error code: 7005
I have several integrations for different users. They were working fine, but a couple of days ago this error started coming up: { "response":{ "action":"DELETE", "error":{ "code":7005, "message":"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." } } } Is there something that can be done about this?
Geo Cluster Mapping as a Chart
I'm interested in having a report that I can use in a dashboard that will be a cluster map of data. I would want each point to contain the meta data from the fields of the table. As of right now, I am having to use batchgeo.com for mapping data, but everything else is generated from Zoho. Here is a sample to a live map.
Implementing Oauth 2.0 for my Application
Does Zoho Reports supports Oauth 2.0 authentication ?
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";
Database not found
Hello, I'm trying to connect to Sql Server 2008 in Zoho Reports using the upload tool but this is showing the error below. I already checked the information and it is correct. How can I solve this problem? database_connection_params.conf DBTYPE=sqlserver HOSTNAME=VIX-DB-001 PORT=1433 USERNAME=sa PASSWORD=samaster DBNAME=MMDB #MDBFILENAME= #SQLITEFILENAME= #FIREBIRDFILENAME= Follow the logs. 2017/11/08 18:02:36 BRST: OS : Windows NT (unknown) 6.2 x86 2017/11/08 18:02:36 BRST: JVM Version : 1.6.0_16
Next Page