Set a Chart Name via API
Hi I'm new to Zoho reports (I know, RTFM, right?) and have been banging around with the API, interfacing successfully with Ruby. What I haven't found is a way to title a report/chart at runtime. For instance, I've got a sample report showing the number of jobs opened between two dates (selected by the user on the previous screen) - the title of the chart is simply Number of Jobs Opened By Job Type Over a Date Range. I'd like to replace this title with "Number of Jobs Opened Between October 1 and
Running CSVUploadConsole.sh on PHP
Hi, Can anyone help me on this issue. When i run CSVUploadConsole.sh on PUTTY or some SSH, it works perfect. But when i want to run this on a PHP page it doesnt work. I get null. Here is my code; " shell_exec('sh CSVUploadConsole.sh mycsvfile.csv mydatabase mytable APPEND myuserforcrmreports -A myAuthKey')" Note: i run my php page at the same folder with CSVUploadConsole.sh Thanks, Umut
Select fields of API Zoho Reports in PHP
Hello everyone :) How I can Select a field of a table zoho report with API in PHP and I show it (Date field)? I find a lot of documentation on PHP Thanks
Importing time data to table with api
Hi, i am trying to add a row to reports using URL request. But i got bad request error all the time. i have a data which is dateandtime, format like YYY-MM-dd HH:mm:ss but when i add this data to a url, i think ":" syntax is a problem, i got bad request error. how can i post this data with url request. thanks umut. Edit: sorry i got "HTTP request failed! HTTP/1.1 505 HTTP Version Not Supported" error.
Dashboard Needed - Expert at Zoho Reports?
I own a marketing firm and we want to migrate many of our clients to Zoho. Our first client we want to move over needs a Dashboard built out. We would prefer not to have one of our in house people have to learn Zoho. Are any of you doing freelance agency work? Let me know joey@stickywrapper.com
Zoho Reports - API - Limit on number of records in a page when importing into Zoho reports.
The API I'm using only allows a maximum of 500 records per page. Eventually I'm going to have 1,000's of records to import and currently I only get one page. I'd like to be able to have all the records stored in a single table. So far the only idea I have is to have a separate table per page and then have a function which combines all the separate pages into a single table. I'd like to know if firstly my idea is possible and secondly is there a better way. For instance having multiple API calls
Error when importing URL
I get the following error when trying to import from URL. Error while reading the URL contents. Please verify whether the server (host machine) containing the URL is connectable. I know the URL works because I can paste it in a browser and see the information, so it is connecting to the host machine. I can't find any information regarding this error. Thanks, Dan
Opportunities over time
Dear, We are in a project related business and our opportunities do stay active for more then 120 days on average. To analyse our quote and opportunity activity we would like to know the total opportunity development over time. So what I would like to know if it's possible and how to create a report in ZOHO Advanced Analytics which shows the following content: - Per month or date the QTY of opportunities - Per month or date the amount and Expected Revenue of opportunities. So this should give the
Zoho Reports Bulk Import API error
Hi, I need help. I am getting following error when using Zoho Report Bulk Import API action: code error 7127 - 100 exceeded maximum length for a column any solution for this error ? Thanks!
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
.NET Zoho RepClient.ImportData doesn't release the file after the import.
.NET Zoho RepClient.ImportData doesn't release the file after the import. Is there some way to make it release so that the file can be deleted after?
How do i pass parameter and store it into zoho's local variable ?
How do i pass parameter and set it into zoho reports ? i want the chart to be generated on the basis of user input. The user input will match with a field value and according to that graph should be generate.
Zoho CRM Inventory Module Integration with Zoho Reports
Was wondering if there is a release date for zoho reports integration with the Zoho CRM inventory module.
Import csv/json file into zoho reports
Hi, Im unable import CSV file into ZohoReports using API. It was displaying below error. java.io.UnsupportedEncodingException: multipart/form-data please help how to resolve this issue.
Report
I want to pull a report of my leads by date of birth. When I try to customize it, it pulls all my leads. What am I doing wrong?
INNER Join With Concatenation
SELECT 'Task' as "Type","A"."Project Name","A"."Task Name","A"."Actual time Taken","B"."Work" FROM "Tasks" as "A" INNER JOIN "Task Estimated Hours" as "B" on CONCAT("A"."Project Name",' - ',"A"."Task Name") = "B"."CK" Above Query not returning even single row, need help in resolving the same. Thanks, GAURAV ARYA
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.
Adding data using Java API - Only Time column in a table
How to store only time like HH:mm:ss in zoho reports. I have changed my column type to Date and given the format as "HH:mm:ss" on dashboard, but I try to insert data, it gives me error.
API v3.0 has a feature to add/rename/remove columns
Two questions:- 1. When will the API docs be updated to see the details of these new API endpoints? 2. Is there an API call to create a new table, so that columns can then be added to it? If not that would provide a way to automate data upload including table management. Many thanks. Best regards Keith
DB name have spaces
How can I get my DB_name and name_report to use in the API URL when they have spaces. I have tried different was and in documentation there is nothing regarding how get the DB_name valid for the API
Connecting to a SQL Server database issue
Hi all, I am trying to connect to my SQL server database to upload a file to the new user interface. I believe that I have everything set up but I keep getting the same error which is too generic for me to do anything with. the error I am getting from my log is this: 2015/02/05 15:08:55 GMT: ============================================================================================================================================ 2015/02/05 15:16:41 GMT:#################### ERROR OCCURRED WHILE
Problems with C# Client Library
Hi, I am new to Zoho API. I have a requirement to import data into tables from CSV files through the API. I have tried the sample code given on the site, but it does not work. It does not return any error, but data not get imported in the destination table. Here is the same code I am using IReportClient RepClient = new ReportClient("-----Auth Token-----"); string tableURI = RepClient.GetURI("<email>", "<db name>", "<table name>"); Dictionary<string, string> ImportConfig = new Dictionary<string,
API Import
I am trying to get Zoho Reports to retrieve data from my cloud based scheduling tool. The cloud based tool has a REST API and Authentication key but cannot get the data to import into a Table or database. I am trying to create scheduled reports to send to clients
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
Backslash characters removed on import
It sounds like backslash "\" characters are removed on CSV import. We have an input CSV containing the value Electric-PC\Electric, we import the CSV using the API, and in the table we see Electric-PCElectric. Any idea what the problem is ? Thanks !
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
Import Tool - Import from relational database
Hi, Please can somebody explain how to use this tool? Thanks
Custom Formula times
Hello, I need to create 30 custom formulas in my table. Is there a way to do this quickly? Currently I am having to select custom formula enter the info and press save and it is taking a long time to process and sometimes crashing.
Importing data into a column with more than 100 characters using the API
I’m using the API to upload data into an existing database and I’m running into a problem with source data longer than 100 characters. When my python script hits one of these conditions it aborts. I can see that using the upload utility there are parameters that can be edited in the common_params.conf file to deal with these types of conditions ZOHO_TRUNCATE_COLNAMES TRUE or FALSE ZOHO_ON_IMPORT_ERROR ABORT or SKIPROW or SETCOLUMNEMPTY I've tried using
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
Python Report Client, Update Record Count
Hi Zoho Foks, Is there any way to tell the number of record updated when using the Python Report Client ? In a perfect world I'd be able to do something like result = rc.updateData(prodURI, updateInfo, updateCriteria, None); have a dictionary return with something like {'RecordCount':0} or whatever the number of updated records actually is. What I am trying to do, is figure out if my Update command, actually updated 0 records, in which case I actually need to insert the record. However, since
Zoho Reports API error
I am getting following error when using Zoho Report Bulk Import API action { "response":{ "action":"IMPORT", "error":{ "code":8509, "message":"The parameter ZOHO_ON_IMPORT_ERROR does not match the accepted input pattern" } } } This is what I have for my hidden field (name="ZOHO_ON_IMPORT_ERROR" value="ABORT")
Upload tool is failing to add new tables
Upload tool is failing to add new tables It is reporting a success, but the tables do not show in Zoho. If I try to manually add a table with the same name, it says that the table already exists. Obviously it uploaded and there is a disconnect in works. Please advise.
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
UploadTool The content of the element must contsist of well-forme character data or markup
Hi i'm having this error when work with some queries from MS SQL Server. Apparently the problems is regarding with the comparison operator (<> not equal to & <= less than), please i need assistance with this. By the way i attached the database_sql_query.xml and logs. Best regards, RR [Fatal Error] database_sql_queries.xml:138:647: The content of elements must consist of well-formed character data or markup. Error !!! Exception occured while parsing the import options XML. The content of elements
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
Single Sign On to zoho reports
Hi I have one SharePoint 2010 application hosted in internet. Recently we plan to use Zoho Reports for our reporting purpose. And my requirement is I am using FBA authentication for my SharePoint site and I want a single sing on future to be activated for both Zoho Repots site and my SharePoint application. Can you please suggest how I can achieve this as this is only question that we need to solve to use Zoho.
Zoho Reports Upload from DB Java Exception
As of last night, our zoho reports upload from DB feature stopped working. Log shows we are able to log in to zoho, the csv is generated fine, and is uploaded to zoho, but then it throws an exception when Zoho is added the rows - even with a really simple (new) test table. I have tried installing zoho upload tool on a new machine and get the same problem. Can you tell us what's happening? ------------------------------------------------------------------- ---Extract from Log (full log attached) -------------------------------------------------------------------
Upload file using java swing application to zoho??
I have created a Java Swing Application which selects files from my computer. I want to upload these files directly to Zoho database instead of uploading it from Zoho Application. Is it possible? I have heard about Zoho API calls. But have no idea, how to use it. I will appreciate your help, if someone can explain the procedure step wise. Thanks in Advance.
Next Page