Hello! I'm discovering Retool with a first app where I'm trying to return rows in a table based on a JSON file. I've managed to create a RESTquery I've called answers to get a JSON file containing a list of answers to a thread posted in my Basecamp. The JSON file looks like this (short version): …

Hello @jeremy and welcome to the community! These are totally normal questions, don't feel too bad :slight_smile: For your filter question, there are a couple of ways to do this - the easiest for you is probably going to indeed be querying JSON with SQL. We use an open source package called AlaSQL …

How to select and format results returned in a JSON?

💬 Queries and Resources

Tess November 19, 2021, 12:40am 16

Got it! This community post may be more helpful: How to connect to Google APIs

We also have docs on rest apis here: Configure resource authentication | Retool Docs

Let us know what questions come up!

Topic		Replies	Views
Anyone else using Retool in conjunction with Integromat? 💬 App Building	11	2791	August 2, 2023
How to connect Retool with Zoho CRM 💬 Queries and Resources api	29	4312	June 8, 2023
How about rendering some Charts inside Retool AI Chat? 🤝 Community Show & Tell ai , dashboard	15	1407	February 6, 2025
Encountered an error: CSRF DETECTED 💬 Queries and Resources	10	5581	August 2, 2023
SQL search bar filter syntax in untouched query was valid yesterday, but now has syntax error 💬 Queries and Resources sql , query-json-with-sql	13	3347	August 3, 2023

How to select and format results returned in a JSON?

Related topics