List entity records

<Info>This API is in beta. Endpoints, fields, and behavior may still change, so avoid depending on it in production.</Info>

Returns the records held in one of the app's entities. Deleted records are left out.

Row-level security applies, so an entity whose rls read rule narrows what a caller sees returns only the records that credential can read. An entity with no rls rules returns all of its records.

Filter with q, or by passing one of the entity's own fields as a query parameter of that name. Any parameter this endpoint doesn't define is read as a filter, so a misspelled one narrows the result to nothing rather than failing the call.

Base44 returns at most 5000 records per call. It caps the result at 5000 both when you leave limit out and when you ask for more, and the response doesn't tell you it was cut short, so page through a bigger entity with skip.

Records come back in no particular order unless you set sort.

Pass the entity name exactly as List entity schemas reports it. The User entity is served by its own endpoints and never reaches this one.

This endpoint is limited to 100 requests per minute per app, shared with the app's other entity listing calls.

<Note>This endpoint accepts a personal API key belonging to a user with access to the app, including a read-only key. Workspace API keys are not accepted.</Note>

get/api/apps/{app_id}/entities/{entity_name}

Path parameters

app_idstring required

ID of the app that owns the entity.

entity_namestring required

Name of the entity, exactly as List entity schemas reports it.

Query parameters

qstring

Filter as a JSON object of field names and values, for example {"status": "paid"}. A value can be a comparison rather than an exact match, as in {"amount": {"$gt": 100}}, and $and, $or, $nor and $not combine conditions. Keep the nesting shallow. Base44 wraps your filter in its own row-level-security conditions before it checks the depth, so how deep you can go depends on the entity's rules.

limitinteger

Maximum number of records to return, as a whole number of at least 1. Defaults to 5000, and Base44 returns at most 5000 records however high you set this.

skipinteger

Number of records to skip before the ones you get back, as a whole number of 0 or more. Defaults to 0. Use it with limit to page through an entity.

sortstring

Single field to sort by, prefixed with - for descending. For example, -created_date returns newest first. Sorting by more than one field isn't supported.

fieldsstring

Comma-separated list of fields to return, which reduces the response size on a wide entity. Reach a field inside an object with dots, as in customer.email. Each record still carries its id whether you ask for it or not.

Response

The entity's records.

idstring nullable

ID of the record. Pass it as entity_id to Get entity record, Update entity record or Delete entity record.

created_datestring nullable

When the record was created, as a UTC timestamp in ISO 8601 format. A record Base44 has just created carries a Z suffix, and a record read back from storage does not.

updated_datestring nullable

When the record last changed, as a UTC timestamp in ISO 8601 format. A record Base44 has just created carries a Z suffix, and a record read back from storage does not.

created_bystring nullable

Email of the app user who created the record, or anonymous when a visitor created it on an app that needs no login. Apps that hide record authorship leave this field out of the response.

created_by_idstring nullable

ID of the app user who created the record, or anonymous when a visitor created it on an app that needs no login.

is_sampleboolean nullable

Whether Base44 stored the record as sample data while the app was being built. A record you create reports false.

Example response

[
  {
    "id": "6886b8d390dc7e2f4a2c91b3",
    "created_date": "2026-06-01T09:23:41.481000",
    "updated_date": "2026-06-04T14:07:02.115000",
    "created_by": "jane@acme.com",
    "created_by_id": "6874b0c2e1a94d0031bb77de"
  }
]

Changes

No recorded changes to this endpoint across all 1 revision of this API.