Get Zoho Analytics Data from the Table by Analytics API
Hello
If you are looking for a solution to get the data of Zoho Analytics Data by the API, Please have a look below
email = Zoho Analytics Owner Email
workspaceName = Zoho Analytics Work Space Name
viewName = Table / Report Name
Scope will be use:- ZohoAnalytics.data/ ZohoAnalytics.aLL
- email = zoho.encryption.urlEncode("");
- workspaceName = zoho.encryption.urlEncode("");
- viewName = zoho.encryption.urlEncode("");
- paramsMap = Map();
- paramsMap.put("ZOHO_ACTION","EXPORT");
- paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON");
- paramsMap.put("ZOHO_ERROR_FORMAT","JSON");
- paramsMap.put("ZOHO_API_VERSION","1.0");
- hearmap = Map();
- hearmap.put("Content-Type", "application/json");
- AnalyticsData = invokeurl
- [
- url: "https://analyticsapi.zoho.com/api/"+email+"/"+workspaceName+"/"+viewName
- type: GET
- parameters:paramsMap
- headers:hearmap
- connection: "zohocrm"
- ];
- data = AnalyticsData.get("response").getJSON("result");
In the Data Variable, all Results will be saved and you can use it anywhere.
if you facing any issues please let me know.