Get Zoho Analytics Data from the Table by Analytics API

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
  1. email = zoho.encryption.urlEncode("");
  2. workspaceName = zoho.encryption.urlEncode("");
  3. viewName = zoho.encryption.urlEncode("");
  4. paramsMap = Map();
  5. paramsMap.put("ZOHO_ACTION","EXPORT");
  6. paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON");
  7. paramsMap.put("ZOHO_ERROR_FORMAT","JSON");
  8. paramsMap.put("ZOHO_API_VERSION","1.0");
  9. hearmap = Map();
  10. hearmap.put("Content-Type", "application/json");
  11. AnalyticsData = invokeurl
  12. [
  13. url: "https://analyticsapi.zoho.com/api/"+email+"/"+workspaceName+"/"+viewName
  14. type: GET
  15. parameters:paramsMap
  16. headers:hearmap
  17. connection: "zohocrm"
  18. ];
  19. 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.

Thanks & Regards
Piyush Goyal
Zoho Developer || 3+ years Experience
+91-8619164837

    • Sticky Posts

    • Tip of the Week - Spot Risky Sales with Conditional Formatting

      In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to apply