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

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?

      • 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/