/retool-integration

Kentico and Retool: Complete Integration Guide 2024

Learn how to integrate Retool with Kentico using API keys, configure data sources, create apps, and manage data flow with step-by-step instructions.

Matt Graham, CEO of Rapid Developers

Book a call with an Expert

Starting a new venture? Need to upgrade your web or mobile app? RapidDev builds Retool apps with your growth in mind.

Book a free No-Code consultation

How to integrate Retool with Kentico?

 

Integrating Retool with Kentico

 

Integrating Retool with Kentico requires a clear understanding of both platforms to ensure a smooth data flow between your applications. Below is a detailed, step-by-step guide to set up this integration effectively.

 

Prerequisites

 

  • Ensure you have access to a Kentico CMS instance (either on-premises or Kentico Cloud) with appropriate permissions to create new API keys.
  • Have a Retool account with admin rights to create and configure new resources.
  • Basic understanding of APIs and data models in Kentico and Retool's interface for building applications.

 

Setting Up API Access in Kentico

 

  • Log into your Kentico CMS instance and navigate to API Keys or the Kentico Cloud administration.
  • Create a new API key: Ensure this key has read permissions to the data you wish to access from Retool.
  • Securely store this API key as it will be needed for configuring Retool.

 

Configuring a Data Source in Retool

 

  • Log into your Retool account and go to the 'Resources' section from the admin panel.
  • Click on 'Create New', and select 'REST API' as your resource type to connect with Kentico.
  • Provide a name for your resource and enter the base URL for your Kentico instance. For Kentico Cloud, this will be something like https://deliver.kenticocloud.com/{project_id}.
  • Under the 'Authentication' section, select 'Bearer Token' and paste the API key generated from Kentico.
  • Save your settings and test the connection to ensure everything is working correctly.

 

Building Retool Apps with Kentico Data

 

  • After your API connection is established, create a new application in Retool.
  • Use the 'Query Library' to build a new query that retrieves data from your Kentico API Resource. Use the endpoint you want to access, like /items to fetch content items.
  • Test your query to make sure it returns data correctly.
  • Use Retool's drag-and-drop components to display this data. You can use tables, lists, or custom components as needed to fit your use case.

 

Handling API Requests and Responses

 

  • Ensure your queries handle responses correctly. Retool provides built-in support for handling JSON data, which is the default response format from Kentico APIs.
  • If you need to send data back or perform updates, ensure your API key from Kentico has appropriate write permissions and use appropriate HTTP methods (POST, PUT, DELETE) in your Retool queries.

 

Adding Custom Logic

 

  • Leverage Retool's JavaScript Editor to add custom logic to your data handling processes. This is helpful for data transformation or validation before displaying it or sending it to Kentico.
  • You can create transformers to process data before it is used by components or to prepare data for API requests.

 

Testing Your Integration

 

  • Once you have your application logic set up, use Retool's internal testing tools to verify data integration is successful.
  • Check for any errors in API calls and confirm data is correctly displayed and updated through your Retool application interface.
  • Debug any issues by inspecting API requests/responses and adjusting your queries or API permissions in Kentico as necessary.

 

Deploying Your Retool Application

 

  • After testing, make your Retool app available to users. Adjust permissions and access controls to ensure only authorized users can view and modify data from Kentico.
  • Monitor the app's performance and data flow to fix any emerging integration issues promptly.

 

By following these steps, you should be able to accomplish a seamless integration of Retool with Kentico, enabling dynamic data presentation and interaction within your Retool applications.

Want to explore opportunities to work with us?

Connect with our team to unlock the full potential of no-code solutions with a no-commitment consultation!

Book a Free Consultation

Client trust and success are our top priorities

When it comes to serving you, we sweat the little things. That’s why our work makes a big impact.

Rapid Dev was an exceptional project management organization and the best development collaborators I've had the pleasure of working with. They do complex work on extremely fast timelines and effectively manage the testing and pre-launch process to deliver the best possible product. I'm extremely impressed with their execution ability.

CPO, Praction - Arkady Sokolov

May 2, 2023

Working with Matt was comparable to having another co-founder on the team, but without the commitment or cost. He has a strategic mindset and willing to change the scope of the project in real time based on the needs of the client. A true strategic thought partner!

Co-Founder, Arc - Donald Muir

Dec 27, 2022

Rapid Dev are 10/10, excellent communicators - the best I've ever encountered in the tech dev space. They always go the extra mile, they genuinely care, they respond quickly, they're flexible, adaptable and their enthusiasm is amazing.

Co-CEO, Grantify - Mat Westergreen-Thorne

Oct 15, 2022

Rapid Dev is an excellent developer for no-code and low-code solutions.
We’ve had great success since launching the platform in November 2023. In a few months, we’ve gained over 1,000 new active users. We’ve also secured several dozen bookings on the platform and seen about 70% new user month-over-month growth since the launch.

Co-Founder, Church Real Estate Marketplace - Emmanuel Brown

May 1, 2024 

Matt’s dedication to executing our vision and his commitment to the project deadline were impressive. 
This was such a specific project, and Matt really delivered. We worked with a really fast turnaround, and he always delivered. The site was a perfect prop for us!

Production Manager, Media Production Company - Samantha Fekete

Sep 23, 2022