Connecting To Zoho Using The Zoho Reports API
Summary: A participant initiated a discussion about connecting to Zoho using the Zoho Reports API but did not provide any content in the post.
Introduction
This article will explain how to set up the Zoho Reports API and extract CSV data using an automated python script.
Purpose/Benefit
Zoho is a cloud based CRM and HR tool. It has many modules that help create better workflows for businesses such as Sales & Marketing, Project Management, and Help Desk. Using the Zoho Reports Module API we are able to extract CSV data and stage it so it can easily be added to a SiSense ElastiCube.
In this Example we have set up a table in the Zoho_CRM_Reports database called accounts.
Steps
Setup of Reports API in Zoho
Create a Zoho account (For whatever Module you need, CRM, Campaigns, Sites, etc)
Sign into that account (Example CRM - https://crm.zoho.com)
Click on Reports Tab
Get the API AuthToken specifically for Zoho Reports. Steps to get API AuthToken here.
Create your API URL. Steps to create the URL here. The URL you create can be pasted into the browser at any time to download the table.
Automating the Download using Python script
Follow the steps to download/setup Python3.4.
Setup the attached Python Script with the corresponding credentials/information from your Zoho Reports (explanations in the script).
Set up a batch file (example below) to either run as a pre-build plugin or a Windows scheduled task explained here.
Easily add the data to the ElastiCube using CSV format.