Analyze Data l Zoho Analytics Help

Analyze Data l Zoho Analytics Help Аналитика
Содержание
  1. What is the difference between Zoho Analytics and Zoho Creator?
  2. Add column
  3. Add group members
  4. Add lookup
  5. Add row
  6. Autogenerate reports
  7. Copy formula
  8. Copy reports
  9. Copy workspace
  10. Create similar views
  11. Create slide show
  12. Create table
  13. Create workspace
  14. Delete column
  15. Delete data
  16. Delete group
  17. Delete slide show
  18. Delete view
  19. Description
  20. Export data
  21. Folder list
  22. Get dashboards
  23. Get info
  24. Get plan info
  25. Get slide info
  26. Get slide list
  27. Get slide url
  28. Get view info
  29. Get view name
  30. Get view url
  31. Get workspace id
  32. Get workspace key
  33. Get workspace name
  34. Group info
  35. Hide column
  36. Import data
  37. Integration with external services
  38. What are the External applications Zoho Analytics integrates or provides a connection with?
  39. What are the External applications Zoho Analytics is planning to integrate with in the future?
  40. Do you offer integration with Google Ad?
  41. Does Zoho Analytics offer API’s to integrate with other applications?
  42. Does Zoho Analytics support Web (HTTP) APIs for adding, updating and querying the workspace?
  43. What are the operations supported in APIs?
  44. What are the programming languages wrappers (client library) offered for Zoho Analytics APIs?
  45. Does Zoho Analytics support APIs for sharing?
  46. Is column exist
  47. Is view exist
  48. Is workspace exist
  49. My workspace list
  50. Others
  51. Is Zoho Analytics supported on Mobile and Tablet devices?
  52. What is the difference between Zoho Analytics and Zoho Creator?
  53. How to choose between Zoho Analytics and Zoho Creator?
  54. Possible error codes in delete workspace
  55. Possible error codes in enable domain workspace
  56. Possible error codes in get view url
  57. Possible error codes in my workspace list
  58. Possible error codes in view list
  59. Recent items
  60. Remove lookup
  61. Rename column
  62. Rename view
  63. Response attributes
  64. Save as
  65. Show column
  66. Update data
  67. Update group
  68. Update slide show
  69. View list

What is the difference between Zoho Analytics and Zoho Creator?

The key difference between Zoho Analytics and Zoho Creator is in-depth reporting and analytics vs online custom database application creation.

Zoho Analytics enables you to easily create powerful and sophisticated reports with your data by creating online reporting applications. It enables you to slice & dice your data for in-depth visualization and business intelligence. Zoho Creator enables you to quickly create a powerful online database application to collect data and trigger work flows through forms and scripting.

Zoho Analytics could act as a convenient back-end reporting/analytical service for your application needs. You can get data into Zoho Analytics through manual data entry or bulk load data from files or upload data stored in your local databases (like MS Access, Oracle, SQL Server, MySQL, DB2, PostgreSQL & MS Access) or schedule for periodic upload of data or push data from your application through Web API (HTTP based) for reporting and analysis. Here the crucial difference is that, while Zoho Creator offers a hosted programming environment (with a DB backing), Zoho Analytics offers a powerful reporting layer for your application data.

Zoho Analytics also supports full-fledged relational modeling (similar to relational/analytical databases) for powerful reporting. It currently supports relational modeling functionalities through Lookup columns. With lookup columns you can relate one table with another. It also offers cascade-on-delete functionality whereby when a row in the parent table is deleted, it will automatically delete all the related rows in the child table(s). Click to know more on Zoho Analytics Relational Modeling Capabilities.

The other key difference is that Zoho Analytics embraces SQL, and supports all major dialects of it. This enables users to do sophisticated querying on the data for creating powerful reports. We will flesh out this functionality even further in future updates.

Add column

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidaddColumn(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);stringColumnName="Column Name";stringDataType="PLAIN";boolHideColumn=false;boolSkipSystemTableCheck=true;RepClient.AddColumn(tableURI,ColumnName,DataType,HideColumn,SkipSystemTableCheck,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.addColumn(rc);}}}

Add group members

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidaddGroupMembers(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();config.Add("groupName","");List<string>emailIds=newList<string>();emailIds.Add("");emailIds.Add("");config.Add("emailIds",emailIds);config.Add("inviteMail","");config.Add("mailSubject","");config.Add("mailMessage","");rc.AddGroupMembers(uri,config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.addGroupMembers(rc);}}}

Add lookup

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidaddlookup(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);stringcolumnname="Column Name";stringreftable="Ref Table Name";stringrefcolumn="Ref Column Name";stringonerror="ABORT";rc.AddLookup(uri,columnname,reftable,refcolumn,onerror,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.addlookup(rc);}}}

Add row

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidaddRow(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);Dictionary<string,string>ColumnValues=newDictionary<string,string>();Dictionary<string,string>Config=newDictionary<string,string>();ColumnValues.Add("Region","South");Dictionary<string,string>addRowRes=RepClient.AddRow(tableURI,ColumnValues,Config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.addRow(rc);}}}

Autogenerate reports

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidautogenreports(IReportClientrc){try{stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);Dictionary<string,string>param=newDictionary<string,string>();param.Add("ZOHO_CREATEAGAIN","true");stringsource="TABLE";varresult=rc.AutoGenReports(uri,source,param);}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.autogenreports(rc);}}}

Copy formula

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcopyformula(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);stringformula="Formula1,Formula2";stringdbname="Destination Workspace Name";stringdbkey="***********";rc.CopyFormula(uri,formula,dbname,dbkey,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.copyformula(rc);}}}

Copy reports

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcopyreports(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);stringviews="View1,View2";stringdbname="Destination Workspace Name";stringdbkey="************";rc.CopyReports(uri,views,dbname,dbkey,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.copyreports(rc);}}}

Copy workspace

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcopyDatabase(IReportClientRepClient){stringdbURI=RepClient.GetURI(EMAIL,DBNAME);stringnewDBName="newdbname";stringnewDBDesc="dbdesc";boolwithData=true;stringcopyDBKey="************";longdbid=RepClient.CopyDatabase(dbURI,newDBName,newDBDesc,withData,copyDBKey,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.copyDatabase(rc);}}}

Create similar views

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcreatesimilarviews(IReportClientrc){try{stringuri=rc.GetURI(EMAIL,"Workspace name","Table Name");stringrefview="Reference Table Name";stringfoldername="Folder Name";boolcopycusformula=false;boolcopyaggformula=false;rc.CreateSimilarViews(uri,refview,foldername,copycusformula,copyaggformula,null);}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.createsimilarviews(rc);}}}

Create slide show

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidcreateSlideShow(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();config.Add("slideName","");List<string>viewNames=newList<string>();viewNames.Add("");viewNames.Add("");config.Add("viewNames",viewNames);config.Add("accessWithoutLogin","");rc.CreateSlideShow(uri,config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.createSlideShow(rc);}}}

Create table

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcreatetable(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);stringtabledesign="{"TABLENAME":"SysteTable","TABLEDESCRIPTION": "Testing Purpose","FOLDERNAME": "NewFolder", "COLUMNS":[{"COLUMNNAME":"SrNo","DATATYPE": "NUMBER","DEFAULT": "null","MANDATORY" : "Yes","DESCRIPTION" : "Testing"}]}";rc.CreateTable(uri,tabledesign,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.createtable(rc);}}}

Create workspace

Дополнительный анализ:  Восточное партнерство: новый этап в развитии отношений Европейского союза со странами постсоветского пространства – тема научной статьи по политологическим наукам читайте бесплатно текст научно-исследовательской работы в электронной библиотеке КиберЛенинка

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";DBDESC="Workspace Description";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcreatedatabase(IReportClientRepClient){stringuri=RepClient.GetURI(EMAIL);RepClient.CreateBlankDB(uri,DBNAME,DBDESC,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.createdatabase(rc);}}}

Delete column

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoiddeleteColumn(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);stringColumnName="Column Name";boolDeleteDependentView=false;boolSkipSystemTableCheck=true;RepClient.DeleteColumn(tableURI,ColumnName,DeleteDependentView,SkipSystemTableCheck,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.deleteColumn(rc);}}}

Delete data

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoiddeleteRow(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);stringcriteria=""Region"='South'";RepClient.DeleteData(tableURI,criteria,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.deleteRow(rc);}}}

Delete group

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoiddeleteGroup(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();List<string>groupNames=newList<string>();groupNames.Add("");groupNames.Add("");config.Add("groupNames",groupNames);rc.DeleteGroup(uri,config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.deleteGroup(rc);}}}

Delete slide show

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoiddeleteSlideShow(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();List<string>slideNames=newList<string>();slideNames.Add("");slideNames.Add("");config.Add("slideNames",slideNames);rc.DeleteSlideShow(uri,config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.deleteSlideShow(rc);}}}

Delete view

Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

Sample Request:

Copy

usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";VIEWNAME="View Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoiddeleteview(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,string>param=newDictionary<string,string>();param.Add("ZOHO_DELETE_DEPEND_VIEWS","true");rc.DeleteView(uri,VIEWNAME,param);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.deleteview(rc);}}}

Description

The criteria follows the SQL SELECT WHERE condition like format. You could also use SQL in-built functions as part of the criteria. These built-in functions should be the functions supported by any of Oracle, MS SQL Server, MySQL, DB2, Sybase, ANSI SQL, Informix and PostgreSQL databases.

  • =
  • !=
  • <
  • >
  • <=
  • >=
  • LIKE
  • NOT LIKE
  • IN
  • NOT IN
  • BETWEEN
  • NameDescription
    column nameRefers to the name of the column in table or query table on which you are applying a criteria
    SQL ExpressionYou could provide any valid SQL Expression.
    The above expression subtract the value in the “Cost” column from value in the “Sales” column. You could use any of the Arithmetic operator supported in an SQL SELECT WHERE clause.Supported
    Arithmetic Operators:
    , -, *, /
    SQL Function callOracle, MS SQL Server, MySQL, DB2, Sybase, ANSI SQL, Informix and PostgreSQL databases
    Eg.: year(date_column) = 2008 .
    Note: All supported in-built function from different databases will be documented soon.
    relational operatorThis could be any of the relational operators supported in an SQL SELECT WHERE clause.
    Supported Relational Operators:
    valueRefers to the exact value to match.
    Eg.: “Department” = ‘Finance’
    here ‘Finance’ is a literal value to match.

    Export data

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidexport(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);Dictionary<string,object>resObj=RepClient.ExportDataAsDictionary(tableURI,""Region" ='West'",null);Object[]columns=(Object[])resObj["column_order"];Object[]rows=(Object[])resObj["rows"];}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.export(rc);}}}

    Folder list

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";WORKSPACENAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidfolderlist(IReportClientrc){stringuri=rc.GetURI(EMAIL,WORKSPACENAME);stringresult=rc.FolderList(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.folderlist(rc);}}}

    Get dashboards

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetdashboards(IReportClientRepClient){stringuri=RepClient.GetURI(EMAIL);stringformat="XML";stringresult=RepClient.GetDashboards(uri,format,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getdashboards(rc);}}}

    Get info

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetinfo(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);varresult=rc.GetInfo(uri,null);foreach(KeyValuePair<string,long>kvpinresult){Console.WriteLine(kvp.Key " " kvp.Value);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getinfo(rc);}}}

    Get plan info

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetplaninfo(IReportClientrc){try{stringuri=rc.GetURI(EMAIL);varresult=rc.GetPlanInfo(uri,null);}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getplaninfo(rc);}}}

    Get slide info

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidgetSlideInfo(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();config.Add("slideName","");stringresult=rc.GetSlideInfo(uri,config);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getSlideInfo(rc);}}}

    Get slide list

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidgetSlideList(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);stringresult=rc.GetSlideList(uri);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getSlideList(rc);}}}

    Get slide url

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidgetSlideUrl(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();config.Add("slideName","");config.Add("autoplay","");config.Add("slideInterval","");config.Add("includeTitle","");config.Add("includeDesc","");config.Add("includeSocialWidgets","");stringresult=rc.GetSlideUrl(uri,config);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getSlideUrl(rc);}}}

    Get view info

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetviewinfo(IReportClientRepClient){stringuri=RepClient.GetURI(EMAIL,DBNAME);longviewid=9999999999999999;stringformat="XML";stringresult=RepClient.GetViewInfo(uri,viewid,format,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getviewinfo(rc);}}}

    Get view name

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Дополнительный анализ:  Биржевые трейдеры ошибаются слишком часто – Новости – Научно-образовательный портал IQ – Национальный исследовательский университет «Высшая школа экономики»

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";OBJID=************;classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetviewname(IReportClientrc){stringuri=rc.GetURI(EMAIL);stringresult=rc.GetViewName(uri,OBJID,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getviewname(rc);}}}

    Get view url

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetviewurl(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);stringresult=rc.GetViewUrl(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getviewurl(rc);}}}

    Get workspace id

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetdbid(IReportClientrc){stringuri=rc.GetURI(EMAIL);longresult=rc.GetDatabaseID(uri,DBNAME,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getdbid(rc);}}}

    Get workspace key

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidcopyDatabaseKey(IReportClientRepClient){stringdbURI=RepClient.GetURI(EMAIL,DBNAME);stringkey=RepClient.GetCopyDBKey(dbURI,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.copyDatabaseKey(rc);}}}

    Get workspace name

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBID=999999999999999;classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetdbname(IReportClientrc){stringuri=rc.GetURI(EMAIL);stringresult=rc.GetDatabaseName(uri,DBID,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getdbname(rc);}}}

    Group info

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidgroupinfo(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);stringresult=rc.GroupInfo(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.groupinfo(rc);}}}

    Hide column

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidhidecolumn(IReportClientrc){try{stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);string[]columnNames=newstring[3];columnNames[]="COlumn1";columnNames[1]="COlumn2";columnNames[2]="Column3";varresult=rc.HideColumn(uri,columnNames,null);}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.hidecolumn(rc);}}}

    Import data

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidimportData(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);Dictionary<string,string>ImportConfig=newDictionary<string,string>();ImportConfig.Add("ZOHO_ON_IMPORT_ERROR","ABORT");ImportConfig.Add("ZOHO_CREATE_TABLE","TRUE");ImportConfig.Add("ZOHO_AUTO_IDENTIFY","TRUE");Dictionary<string,string>ImportRes=RepClient.ImportData(tableURI,ZohoReportsConstants.APPEND, "C:\workspace\mydata.csv",ImportConfig);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.importData(rc);}}}

    Integration with external services

    1. What are the External applications Zoho Analytics integrates or provides a connection with?
    2. What are the External applications Zoho Analytics is planning to integrate with in the future?
    3. Do you offer integration with Google Adwords?
    4. Does Zoho Analytics offer API’s to integrate with other applications?

    What are the External applications Zoho Analytics integrates or provides a connection with?

    Currently, Zoho Analytics is integrated with Google Analytics, Salesforce CRM, Teamwork Projects, QuickBooks, Xero and much more.

    What are the External applications Zoho Analytics is planning to integrate with in the future?

    Zoho Analytics is planning to integrate with many other popular business applications. If you would like Zoho Analytics to offer integration with any specific on-demand service/application, please do drop us an email to support@zohoanalytics.com.

    Do you offer integration with Google Ad?

    Yes, we do. Refer to the Advanced Analytics for Google Ads page, for more details. 

    Does Zoho Analytics offer API’s to integrate with other applications?

    Does Zoho Analytics support Web (HTTP) APIs for adding, updating and querying the workspace?

    What are the operations supported in APIs?

    What are the programming languages wrappers (client library) offered for Zoho Analytics APIs?

    Does Zoho Analytics support APIs for sharing?

    Yes, Zoho Analytics supports API for sharing. To know more details about share API, refer to Sharing section in the API documentation – https://www.analitik-expert.ru/analytics/help/api/index.html.

    Is column exist

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TABLENAME="Table Name";COLUMNNAME="Column Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidiscolumnexist(IReportClientRepClient){stringuri=RepClient.GetURI(EMAIL,DBNAME,TABLENAME);boolresult=RepClient.IsColumnExist(uri,COLUMNNAME,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.iscolumnexist(rc);}}}

    Is view exist

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";VIEWNAME="View Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidisviewexist(IReportClientRepClient){stringuri=RepClient.GetURI(EMAIL,DBNAME);boolresult=RepClient.IsViewExist(uri,VIEWNAME,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.isviewexist(rc);}}}

    Is workspace exist

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidisdbexist(IReportClientrc){try{stringuri=rc.GetURI(EMAIL);boolresult=rc.IsDbExist(uri,"Workspace Name",null);Console.WriteLine(result);}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.isdbexist(rc);}}}

    My workspace list

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidmyWorkspacelist(IReportClientrc){stringuri=rc.GetURI(EMAIL);stringresult=rc.MyWorkspaceList(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.myWorkspacelist(rc);}}}

    Others

    1. Is Zoho Analytics supported on Mobile and Tablet devices?
    2. What is the difference between Zoho Analytics and Zoho Creator?
    3. How to choose between Zoho Analytics and Zoho Creator?

    Is Zoho Analytics supported on Mobile and Tablet devices?

    Yes. Zoho Analytics offers mobile optimized apps for iPhones, Android Phones, iPad, and Android Tablets available in the Apple App Store and Google Play Store respectively.

    What is the difference between Zoho Analytics and Zoho Creator?

    The key difference between Zoho Analytics and Zoho Creator is in-depth reporting and analytics vs online custom database application creation.

    Zoho Analytics enables you to easily create powerful and sophisticated reports with your data by creating online reporting applications. It enables you to slice & dice your data for in-depth visualization and business intelligence. Zoho Creator enables you to quickly create a powerful online database application to collect data and trigger work flows through forms and scripting.

    Zoho Analytics could act as a convenient back-end reporting/analytical service for your application needs. You can get data into Zoho Analytics through manual data entry or bulk load data from files or upload data stored in your local databases (like MS Access, Oracle, SQL Server, MySQL, DB2, PostgreSQL & MS Access) or schedule for periodic upload of data or push data from your application through Web API (HTTP based) for reporting and analysis. Here the crucial difference is that, while Zoho Creator offers a hosted programming environment (with a DB backing), Zoho Analytics offers a powerful reporting layer for your application data.

    Zoho Analytics also supports full-fledged relational modeling (similar to relational/analytical databases) for powerful reporting. It currently supports relational modeling functionalities through Lookup columns. With lookup columns you can relate one table with another. It also offers cascade-on-delete functionality whereby when a row in the parent table is deleted, it will automatically delete all the related rows in the child table(s). Click to know more on Zoho Analytics Relational Modeling Capabilities.

    The other key difference is that Zoho Analytics embraces SQL, and supports all major dialects of it. This enables users to do sophisticated querying on the data for creating powerful reports. We will flesh out this functionality even further in future updates.

    How to choose between Zoho Analytics and Zoho Creator?

    Please read the FAQ #2 before you read further. If you require a quick application development environment, with forms, scripting, workflows and basic reporting, opt for Zoho Creator. If you require a powerful online reporting and analytics service with an inbuilt analytical database support, opt for Zoho Analytics. Zoho Analytics also supports Web based APIs using which you can build your own forms and push/update/pull data into Zoho Analytics from any of your applications.

    Дополнительный анализ:  Сколько зарабатывает wms аналитик в России. Средняя зарплата wms аналитик по стране на

    Possible error codes in delete workspace

    7103 , 7138 , 7165 , 8504 , 8506 , 8516 , 8533

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidenabledomaindb(IReportClientrc){try{stringuri=rc.GetURI(EMAIL);stringdbname="Workspace Name";stringdomainname="Domain Name";varresult=rc.EnableDomainDB(uri,dbname,domainname,null);foreach(KeyValuePair<string,string>kvpinresult){Console.WriteLine(kvp.Key " = " kvp.Value);}}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.enabledomaindb(rc);}}}

    Possible error codes in enable domain workspace

    7103 , 7138 , 8023 , 8025 , 8504 , 8506 , 8516 , 8533

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoiddisabledomaindb(IReportClientrc){try{stringuri=rc.GetURI(EMAIL);stringdbname="Workspace Name";stringdomainname="Domain Name";varresult=rc.DisableDomainDB(uri,dbname,domainname,null);foreach(KeyValuePair<string,string>kvpinresult){Console.WriteLine(kvp.Key " = " kvp.Value);}}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.disabledomaindb(rc);}}}

    Possible error codes in get view url

    7103 , 7138 , 8504 , 8506 , 8516 , 8533

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidgetEmbedURL(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);stringresult=RepClient.GetEmbedURL(tableURI,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.getEmbedURL(rc);}}}

    Possible error codes in my workspace list

    8504 , 8506 , 8516 , 8533

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidsharedWorkspacelist(IReportClientrc){stringuri=rc.GetURI(EMAIL);stringresult=rc.SharedWorkspaceList(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.sharedWorkspacelist(rc);}}}

    Possible error codes in view list

    7103 ,8504 , 8506 , 8516 , 8533

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";VIEWNAME="View Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidviewmetadata(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME,VIEWNAME);stringresult=rc.ViewMetadata(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.viewmetadata(rc);}}}

    Recent items

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidrecentitems(IReportClientRepClient){stringuri=RepClient.GetURI(EMAIL);stringformat="XML";stringresult=RepClient.RecentItems(uri,format,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.recentitems(rc);}}}

    Remove lookup

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidremovelookup(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);stringcolumnname="Column Name";rc.RemoveLookup(uri,columnname,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.removelookup(rc);}}}

    Rename column

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidrenameColumn(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);stringOldColumnName="Old Column Name";stringNewColumnName="New Column Name";boolSkipSystemTableCheck=true;RepClient.RenameColumn(tableURI,OldColumnName,NewColumnName,SkipSystemTableCheck,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.renameColumn(rc);}}}

    Rename view

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidrenameview(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);stringviewname="Old Name";stringnewviewname="New Name";stringviewdesc="Description";rc.RenameView(uri,viewname,newviewname,viewdesc,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.renameview(rc);}}}

    Response attributes

    In this section, we have described the detailed explanation of the attribute / property we used in DATABASEMETADATA APIs.

    Attribute/PropertyDescription
    IS_DEFAULT/isDefaultIndicates whether a Zoho Analytics workspace is set as the default. Can be used to set default workspace for third party tools that loads Zoho Analytics Workspaces using JDBC Driver.
    TABLE_CAT/tableCatZoho Analytics workspace name (ex: SalesDB)
    COLUMN_NAME/columnNameName of the column in table type views (ex: Region)
    LITERAL_PREFIXPrefix character used when literal values found (ex: ’45’)
    NULLABLEWill be true if the column can contain null value, false otherwise.
    MAXSIZEMaximum size of the column (ex: 20)
    TYPE_NAMEZoho Analytics name for the data type (ex: Positive Number)

    Note:N in XML response refer to the NULL value

    In case you are using a Java application then Zoho Analytics offers a JDBC Driver and which can be used to fetch all the Zoho Analytics metadata information. Refer to the page JDBC Driver for details.

    7102 , 7103 , 8504 , 8506 , 8516 , 8533

    Save as

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";VIEW_TOCOPY="Existing View Name";NEW_VIEWNAME="New View Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidsaveas(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,string>param=newDictionary<string,string>();rc.SaveAs(uri,VIEW_TOCOPY,NEW_VIEWNAME,param);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.saveas(rc);}}}

    Show column

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidshowcolumn(IReportClientrc){try{stringuri=rc.GetURI(EMAIL,DBNAME,TBNAME);string[]columnNames=newstring[3];columnNames[]="Column1";columnNames[1]="Column2";columnNames[2]="Column3";varresult=rc.ShowColumn(uri,columnNames,null);}catch(Exceptione){Console.WriteLine(e);}}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.showcolumn(rc);}}}

    Update data

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";TBNAME="Table Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidupdateRow(IReportClientRepClient){stringtableURI=RepClient.GetURI(EMAIL,DBNAME,TBNAME);Dictionary<string,string>ColumnValues=newDictionary<string,string>();ColumnValues.Add("Region","North");stringcriteria=""Region"='South'";RepClient.UpdateData(tableURI,ColumnValues,criteria,null);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.updateRow(rc);}}}

    Update group

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidupdateGroup(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();config.Add("groupName","");config.Add("newGroupName","");config.Add("newGroupDesc","");rc.UpdateGroupInfo(uri,config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.updateGroup(rc);}}}

    Update slide show

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";DBNAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID,CLIENT_SECRET,REFRESH_TOKEN);returnRepClient;}publicvoidupdateSlideShow(IReportClientrc){stringuri=rc.GetURI(EMAIL,DBNAME);Dictionary<string,object>config=newDictionary<string,object>();config.Add("slideName","");List<string>viewNames=newList<string>();viewNames.Add("");viewNames.Add("");config.Add("viewNames",viewNames);config.Add("newSlideName","");config.Add("accessWithoutLogin","");config.Add("regenerateSlideKey","");rc.UpdateSlideShow(uri,config);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.updateSlideShow(rc);}}}

    View list

    Download client libraries : C# | GO | JAVA | PHP | PYTHON | NODEJS

    Sample Request:

    Copy

    usingZReports;namespaceTest{CLIENT_ID="************";CLIENT_SECRET="************";REFRESH_TOKEN="************";EMAIL="Email Address";WORKSPACENAME="Workspace Name";classProgram{publicIReportClientgetClient(){IReportClientRepClient=newReportClient(CLIENT_ID, CLIENT_SECRET, REFRESH_TOKEN);returnRepClient;}publicvoidviewlist(IReportClientrc){stringuri=rc.GetURI(EMAIL,WORKSPACENAME);stringresult=rc.ViewList(uri,null);Console.WriteLine(result);}staticvoidMain(string[]args){Programobj=newProgram();IReportClientrc=obj.getClient();obj.viewlist(rc);}}}
    Оцените статью
    Аналитик-эксперт
    Добавить комментарий