canonical: https://jentic.com/apis/glideapps.com/glideapps # Glideapps Glide Big Tables API The Glide Big Tables API gives programmatic access to the data layer behind Glide's no-code app builder. Through it, applications and agents can create Big Tables, read and write rows in bulk or individually, monitor long-running data jobs, manage stash buffers for staged writes, and upload files that back image and document columns. It is the supported way to keep an external system of record (a warehouse, ETL job, or LLM pipeline) in sync with the data that Glide apps render to end users. ## For AI agents Read, write, and bulk-update rows in Glide Big Tables, manage staged stash uploads, and attach files to Glide app data. ## Scope Does not render Glide app UI, run Glide actions, or edit columns/schema fields - use for Big Tables row data, file uploads, and job status only. ## Capabilities - Provision a new Glide Big Table with a typed column schema for a no-code app - Append rows to a Big Table in batch from an upstream warehouse or scheduled job - Patch a single row in a Big Table by row ID without rewriting the rest of the table - Replace a Big Table's schema and data wholesale via PUT /tables/{tableId} - Initiate and complete multi-part file uploads that back image or document columns - Track asynchronous data jobs via GET /jobs/{jobId} until completion ## Use cases ### Warehouse-to-Glide ETL Operations teams running a Glide front-end on top of a warehouse can keep tables in sync by writing scheduled jobs that POST new rows to /tables/{tableId}/rows and PATCH changed rows in place. The Big Tables API supports bulk writes and exposes a job ID per long-running operation, so the pipeline can wait for completion before notifying users. Setup is typically half a day for a single table. Example prompt: POST 200 rows to /tables/{tableId}/rows, capture the returned job ID, and poll /jobs/{jobId} until status is complete. ### AI-Generated Content Loaded Into a Glide App An LLM pipeline producing summaries, tags, or images can write its output rows into a Big Table so a Glide-built internal tool surfaces the results to non-technical users. Files generated by the model (charts, PDFs) are uploaded via /uploads then referenced by URL in the row payload, keeping the no-code app fully data-driven. Example prompt: Initiate POST /uploads, complete the upload via POST /uploads/{uploadId}/complete, then POST /tables/{tableId}/rows with a row referencing the uploaded file URL. ### Agent-Maintained Operational Database An AI agent given a Glide Big Table as its scratchpad can append research findings, update row status, and delete stale entries through the Big Tables API. Because each row CRUD operation is a single endpoint with a typed schema, the agent can write deterministically without parsing HTML or driving a UI. Example prompt: Search Jentic for 'add row to glide big table', load the schema for POST /tables/{tableId}/rows, and write a new finding row with the agent's research output. ## Key endpoints | Method | Path | Description | | --- | --- | --- | | POST | /tables | Create a new Big Table | | GET | /tables/{tableId}/rows | Get rows from a Big Table | | POST | /tables/{tableId}/rows | Add rows to a Big Table | | PATCH | /tables/{tableId}/rows/{rowId} | Update a single row | | DELETE | /tables/{tableId}/rows/{rowId} | Delete a row | | POST | /uploads | Initiate a file upload | | GET | /jobs/{jobId} | Check status of a long-running job | ## Key resources - **Tables** — Create, list, and replace Big Tables and their schemas. - **Rows** — Read, append, patch, and delete rows within a Big Table. - **Jobs** — Poll long-running data operations until completion. - **Stashes** — Stage batches of data before committing them to a table. - **Uploads** — Multi-step file upload flow for image and document columns. ## Why Jentic - **Setup:** Wiring the Glide Big Tables API by hand means learning its bearer auth and coordinating the row, upload, and async job endpoints yourself. Through Jentic you install once, import the Glide Big Tables API from the API Directory, store the token once, and your agent calls it. - **Permission scoping:** Glide puts the table id in the URL path (/tables/{tableId}/rows/...), so a rule can pin your agent to one table: it can read and add rows there and nothing else. You choose the operations it may call, so destructive ones like deleting a row are not included unless you add them. - **Credential handling:** Your Glide bearer token is stored once, encrypted, by your own Jentic One instance and injected at execution time. It never enters the agent's prompt, logs, or context. - **Discovery method:** Agents search Jentic by intent such as 'add a row to a Glide table' or 'upload a file to Glide', and Jentic returns the matching Big Tables operation with its input schema so the agent calls the right endpoint without browsing the reference docs. ## Related APIs - **Airtable API** — Spreadsheet-database with deeper formula and view tooling versus Glide's app-builder-first Big Tables. - **NocoDB API** — Open-source no-code database with a similar table+row API surface that you self-host. - **Smartsheet API** — Project-grid API often pulled into a Glide app for status reporting. ## FAQ ### What authentication does the Glide Big Tables API use? Glide uses HTTP bearer token authentication. Generate a token in the Glide dashboard and send it as Authorization: Bearer {token} on each request. Through Jentic the bearer token is held in the vault and never exposed to the agent. ### Can I bulk-insert rows into a Glide Big Table? Yes. POST /tables/{tableId}/rows accepts an array of rows in a single call and returns a job ID. Poll GET /jobs/{jobId} until the job reports complete to confirm the rows landed. ### What are the rate limits for the Glide Big Tables API? Glide does not publish a fixed rate limit in the OpenAPI spec; limits depend on your Glide plan. For high-volume jobs use the stash flow (PUT /stashes/{stashId}/data) so writes are buffered before commit instead of hammering /rows. ### How do I update a single Glide row through Jentic? Search Jentic for 'update glide row', load the schema for PATCH /tables/{tableId}/rows/{rowId}, and execute with the changed columns only. Run pip install jentic to start. ### Can the Big Tables API attach files to row cells? Yes. Initiate the upload with POST /uploads, complete it with POST /uploads/{uploadId}/complete, then write the resulting file URL into the relevant column when you POST or PATCH a row. ### Is the Glide Big Tables API free? API access is part of Glide's paid plans rather than the free tier. Check your Glide subscription before integrating; the API itself does not bill per call but is gated to plan eligibility. ### Can I limit what my agent is allowed to do with the Glide Big Tables API? Yes. Because you run Jentic One yourself, your own rules decide which Glide Big Tables operations and credentials the agent may use. Since the table id lives in the URL path, such as /tables/{tableId}/rows, you can pin the agent to a single table and grant only the calls you intend, for example reading rows with GET /tables/{tableId}/rows and adding rows with POST /tables/{tableId}/rows. Destructive operations like DELETE /tables/{tableId}/rows/{rowId} stay out of reach unless you explicitly include them.