Skip to main content
GET
/
bases
/
{databaseId}
Get database by ID
curl --request GET \
  --url https://tables.fillout.com/api/v1/bases/{databaseId} \
  --header 'Authorization: Bearer <token>'
{
  "id": "bad4b276-f604-47ad-86e5-d2ae4f60968f",
  "organizationId": 109,
  "basePublicId": "abd6478f18b71637",
  "metadata": {
    "version": 1,
    "tables": [
      {
        "id": "<string>",
        "name": "<string>",
        "order": 123,
        "primaryFieldId": "<string>",
        "fields": [
          {
            "id": "<string>",
            "name": "<string>",
            "type": "<string>",
            "template": {},
            "order": 123
          }
        ],
        "views": [
          {
            "id": "<string>",
            "name": "<string>",
            "type": "<string>",
            "config": {
              "sorts": [
                {}
              ],
              "hiddenFieldIds": [
                "<string>"
              ],
              "fieldWidths": {},
              "orderedFieldIds": [
                "<string>"
              ]
            }
          }
        ]
      }
    ]
  },
  "createdAt": "2025-10-18T02:08:14.784Z",
  "updatedAt": "2025-10-18T02:08:14.784Z"
}
Retrieves detailed information about a specific database including all tables, fields, and views.
  • Returns complete database structure including table schemas
  • Includes field configurations and view definitions
  • Use this endpoint to understand database structure before making changes

Authorizations

​
Authorization
string
header
required

Enter your Fillout API key. Format: Bearer <api_key>

Path Parameters

​
databaseId
string
required

The unique identifier of the database

Response

Database details

​
id
string<uuid>
required

Unique UUID identifier for the database

Example:

"bad4b276-f604-47ad-86e5-d2ae4f60968f"

​
organizationId
integer
required

Organization ID that owns this database

Example:

109

​
basePublicId
string
required

Public identifier for the database

Example:

"abd6478f18b71637"

​
metadata
object
required
​
createdAt
string<date-time>
required

ISO timestamp of when the database was created

Example:

"2025-10-18T02:08:14.784Z"

​
updatedAt
string<date-time>
required

ISO timestamp of when the database was last updated

Example:

"2025-10-18T02:08:14.784Z"

⌘I