UseSQL
  • Introduction
  • Getting Started
    • Source Formats
    • Output Formats
    • Managing Keys
    • Sandbox
    • Saved Queries
  • Client Libraries
    • HTML Templating
    • JavaScript Web Client
  • Tutorials
    • Integrate With Your Static Site
    • Share Data In Slack
    • Show external query results in a Google Sheet
    • Query across a Google Sheet and a CSV file
    • Securing Your Key
    • Querying Airtable
    • Integrate With ProcFu
    • Integrate with a private Google Sheet
    • Updating Google Sheets
    • Retrieving data from tables on a web page
    • Displaying reports in Google Sheets from MySQL
    • Querying StackBy Tables
  • Resources
    • Demo Sandbox
    • OpenAPI Docs
    • Redoc API Docs
    • Roadmap
    • Changelog
Powered by GitBook
On this page
  • Step 1: Find The StackBy Table You Want To Include
  • Step 2: Retrieve Your StackBy API Key
  • Step 3: Build Your SQL Query

Was this helpful?

  1. Tutorials

Querying StackBy Tables

PreviousDisplaying reports in Google Sheets from MySQLNextChangelog

Last updated 4 years ago

Was this helpful?

Step 1: Find The StackBy Table You Want To Include

Create or find a table that you would like to query, and copy it's url from the browser.

Step 2: Retrieve Your StackBy API Key

Login to your StackBy account, and navigate to your Account page.

Once on the account page if you havent created an API Key click the Create API Key button.

Once you have this key, make it visible, and save it somewhere for the next step where we build our query.

Step 3: Build Your SQL Query

After this you just need to add the url as the table you want to query from with the api key provided as a query parameter. An example is shown below along with a link to the query in the sandbox.

SELECT * FROM "https://stackby.com/stack/stJMXZMzvH293NHq3S/tbl1575000948100df97c5?api-key={YOUR-KEY}"

[ sandbox ]