Smartsheet + Zoho
I am looking to connect Smartsheet to Zoho using API Integration to get Timesheet data. I understand Zoho provides APIs for this.
Has anyone implemented any such solution before? Also, any references or links to technical documentation\ POC\ guide on how to implement custom API integrations from Smartsheet?
Answers
-
-
@jalajgupta
We do lots of external integrations for time keeping systems. I also have lots of familiarity with zoho as it was used by my last organization. If there is something you are specifically interested in grabbing let us know.
https://www.zoho.com/projects/help/rest-api/log-time.html#all-timelogs
Your general approach is going to be,
1. Get all zoho employee records
2. tie zoho records to smar user records via some key
3. define what roll up you want from zoho
4. grab time log data and post back to SMAR
The main consideration for time keeping integrations is scoping. If you want extreme granularity you need to work with the 20k row limitations. This is normally done by sharding results to project level. It can also be done less effectively by sharding on name keys or other parameters.Principal Consultant | System Integrations
Prime Consulting Group
Email: info@primeconsulting.com
Follow us on LinkedIn!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.6K Get Help
- 472 Global Discussions
- 159 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives