Using Dynamic Content to get data from Zoho Creator does not work

I have gone through the PDF for creating Dynamic Content in Zoho Sites that Zoho has provided, and I'm trying to set up a very simple Dynamic Content function on my Zoho Sites website to get records from our Zoho Creator app.

In Settings-->Connections from my Zoho Sites website, I added a connection to Zoho Creator called "zohocreator" with all scopes enabled. Then I went to Settings-->Dynamic Content in Zoho Sites and added a Dynamic Content app. In the main view for that app, I call a function called "fetchCoaches" so I can display a list of coaches. In the Functions section of my Dynamic Content app, I created a simple function called "fetchCoaches" with the following code:

records = zoho.creator.getRecords("productivitycoach", "bkbpc", "Coaches_Report", "" , 1, 10, "zohocreator");

return records;

I confirmed all of the parameters are correct and it should return several records. However, no matter what report link I use (and I've tried this with several different report links), it always returns a list with two null elements (where records.size() = 2, records.get(0) = null, and records.get(1) = null).

Why does this not work?

Access your files securely from anywhere

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
david
Logaraj M

Sticky Posts
Unveiling Zoho Sites 2.0 - A new dimension in website building
Dear Zoho Sites Users, We are thrilled to announce the launch of Zoho Sites 2.0 today! This refresh represents a significant step forward in the capabilities of Zoho Sites and is crucial for creating a lasting and positive impact on our customers' businesses.
Website Accessibility
I have two sites created in Zoho Sites which are both live. Some questions: 1. Are any of the template themes WCAG 2.1 AA compliant? 2. How do I change the format of a sub-heading in the header section? 3. Is there any way to add focus indication for
Visual Editor Webinar
Join our FREE live webinar to learn how to use the Zoho Sites Visual Editor to easily design your website. Our product specialist will demonstrate how this tool will help you customize your website to suit your requirements. Register here: https://www.zoho.com/sites/webinars/
SEO for your Zoho Sites Website
Join our live webinar to learn how to use Zoho Sites' SEO tools to boost your website's ranking. Our product specialist will demonstrate everything you need to know about optimizing your web pages to make them search engine friendly. Register here for free: https://www.zoho.com/sites/webinars/
Zoho Sites Webinar | Integrations
Join our FREE live webinar to learn how to integrate both Zoho and third-party products with your Zoho Sites website. Our product expert will demonstrate how to use these integrations to grow, manage, and retain the customers you bring in. Learn how to take your business forward and build stunningly robust and efficient websites. Register here: https://www.zoho.com/sites/webinars/