Connect to my local database and upload data to zoho report
Hi, I'm evaluating zoho Report for it apply in my organization a dashboard of information, but i want to connect my local sql server database to zoho report. I was reading that is process to do with an API, but a I dont know how to use this app. The Zoho wiki have information of this app, but I dont understand what i need configure for to begin.
zoho - magento database integration guide
hi i am trying to integrate the data taken from the zoho database and post it into a magento(e commerce frame work) all that i could find is a very expensive(400$) third party plugin for doing that can any one guide me in a step by step format of doing that .
Important changes in Zoho Reports API
We would like to bring it to your notice that we have introduced few mandatory changes in Zoho Reports API usage, for better usability and other technical considerations. This would require some minor, but mandatory, changes to be done in your existing applications. Introducing support for Permanent Authentication Token for API calls Zoho Reports now supports passing a permanent Authentication Token (AuthToken) to use Zoho Reports API methods. Using AuthToken is much simpler than the current
Is it possible to pull data from googledocs / zohodocs (Spreadsheets) into ZReports via API
Hi, Is it possible to pull data from googledocs / zohodocs (Spreadsheets) into ZReports via API ? Any help is great help thank you Best Regards -Deepa Govind http://homepreneur-online.com/
Upload data from SQL Server to Zoho Reports through vb.net App
Hi , How can i upload data from SQL server to Zoho reports through my VB.net application. I want to upload data when i hit the button in my application. My application and Sql server are sitting in two different servers.
Query Tables (Looking up data from another table to make 1 table)
I have 2 tables created by importing data on a nightly basis. One table lists sales. The other table lists refunds (which could happen up to 30 days after the sale). I want to create a table which lists all of this data in one shot. In essence you would have a date column, a thread column (this is the common value that ties sales and refunds together), and an amount column. All refunds would be negative and all sales would be positive numbers in the amount column. It would be like appending
Link to Excel
Hey, New User to this, I have an Excel Document that multiple user use to input the status of Tasks is there any way to link it to ZOHO Reports so that it creates a chart based on the information entered. Thanks
unable to login using UploadTool
login to https://accounts.zoho.com fails with uploadtool with user/password mismatch, but the error in logs are weird, because I am able to login manually over web-interface using the same credentials The login from zohoreport-uploadtool was working good for long time and fails suddenly any idea what would be wrong <error> Logging in Error!!! Could not login. Could be because of username/password mismatch Exception in thread "main" ServerException (HttpStatusCode 200 Error Code: 407 , URI: https://accounts.zoho.com,
CSV GUI Upload Tool
Hi, I'm trying to use the CSV Upload Utility, using Add, Replace if already exists as Import type. But when i try to upload i get the following error: "Error Occured. Column increment_id is present in match columns but not in selected columns" Columns to match is "increment_id,sku". Thank you! Julius
zoho reports with openbravo
How can we make zoho reports as pdf file in openbravo and forward it to users?
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.
Upload Tool and UPDATE query with condition for .CSV
Dear team, We want to use the Upload Tool to update a table in Zoho Reports. The source of the data is a .CSV file which is going to be generated by a third party application. This .CSV file will contain the entire database. When uploading the file in Zoho Reports, we would like to UPDATE the records based on a column with last modification (timestamp). We therefore would like to have something similar to a WHERE condition to select the appropriate records. Based on the documentation, I am not sure
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???
how can i know the ticket of the Reports is out of date through a code
how can i know the ticket of the Reports is out of date through a code,i need a code marking the ticket is out of date
Importing an XML
Hi, I have a file (available at http://www.sendspace.com/file/g5sjmm). It is a Zip archive containing XML and XSD files. Is there a way to bring this data into Zoho Reports? If so, how? Regards, Shaheed
Zoho Reports API Error Codes Reference
Hi, Is there documentation online which lists all possible error codes returned by the Zoho REPORTS API when it is being used? I did see this list for the CRM API: https://zohocrmapi.wiki.zoho.com/API-Error-Messages.html We are implementing a new reports tab in our web-app and would like to "gracefully" handle all errors returned from Zoho. Thanks, Colin Mooney Avego http://www.avego.com
Pricing Plan Question - few rows but lots of users
Hi, can someone help explain the plans. My database will have few rows, maybe around 5000. However I want to share the reports with potentially hundreds of different users. Do I really need to pay for every user to view their custom report? The reports will be tailored to show only the rows relevant to that user. I don't see an affordable way of doing this. If I had the standard plan ($35/month) and then had 100 users then the cost would be an extra $800/month for these users. Am I missing something
Zoho Reports API and database owners
Hi, I try to access a database via the Zoho Reports API. I am not the creator of the database but I am one of the owners. I receive the error "Database not found! Please check whether the database exists". So, is it possible for an owner to update a database using the API ? If there any specific configuration to apply ? Thanks, Cimballi
Can I still use "privatelink" instead of "ticket" with api calls?
I once received instructions from Zoho regarding using a "privatelink" instead of a "ticket" which expires every 7 days. I can't get that to work now, what am I doing wrong. The instructions from Zoho I am following are as follows: http://reports.zoho.com/api/ <yourloginname>/<your database name>/<your table or view name>? ZOHO_ACTION=EXPORT &ZOHO_OUTPUT_FORMAT=HTML &ZOHO_ERROR_FORMAT=JSON &ZOHO_API_KEY=<your api key> &privatelink=<The private link value that was taken from the URL for this view>
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
Chart Creation
Hello, Is there anyway to automate chart creation via the API? Ideally I would like to be able to create a client specific account, upload data and generate reports all in one go. The data and reports differs from client to client so the current database copy or backup / restore does not work for this scenario and I find myself having to build everything from scratch each time. If I could automate the process it would make my life so much easier :) Regards, Adrian.
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')
Zoho integration module with openbravo
Hi, i'm tring to tesk the ZOHO integration module for Openbravo and after following the directions suggested by the openbravo people an error appears: La acción de guardado falló. No registration for name OBUZOHO_Config This appears into the openbravo Integration module. Does this sounds familiar to an known error to the zoho people or is it an openbravo Error, Regards
Free Account's
Although signing up for a free account to see what the database contains it has given me 15 days of the full database. I would rather start with the basic free package to see what I can do before moving up the ladder HOW CAN I CHANGE IT TO THE FREE FOREVER I dont want to trial parts of the database that i would loose in 15 days Any help Please
Zoho reports PHP seems to no longer work
Hey gang, any help would be appreciated. Background: Built a site sometime ago where I ported over what I believe was the Zoho reports php api library code. In particular, I think there was one that did the POST. I have not touched this code in ages, and recently it seems to be broke. Offending code: $params = array('http' => array( 'method' => 'POST', 'content' => $data )); if ($optional_headers !== null) { $params['http']['header']
New in Zoho API Reports
Hi I'm new in this. I do not understand where I should put this: <URI>?ZOHO_ACTION=[IMPORT/EXPORT...]&ZOHO_OUTPUT_FORMAT=[XML/JSON/PDF/...] &ZOHO_ERROR_FORMAT=[XML/JSON]&ZOHO_API_KEY=<your key>&ticket=<your ticket> &ZOHO_API_VERSION=1.0 if my form is in php, I know what I should change the code, but maybe I am putting in place incorecto that is not working. I've seen the example of the help but still I have doubts. Someone could help me with an example of a single record in a field with php and