Back

List Database Records

List/Filter Records in a PixieBrix Database

by @pixies

How to Use

Filters:

  • start_date: The start date (without time), e.g. 2024-01-01
  • end_date: The end date (without time), e.g. 2024-01-01
  • data__*: The record data using underscores to traverse nested fields. For example, let's say we have the following record data:
{
  "event": "ButtonClick",
  "user": {
    "name": "PixieBritt",
    "flags": [ "admin", "member" ],
    "scope": null,
  }
}

The following filters will select this record:

data__event=ButtonClick
data__user__name=PixieBritt
data__user__flags__0=admin
data__user__flags__1=member
data__user__scope__isnull=True
data__missingKey__isnull=True

Inputs

Name Required Type Description
filters object
service @pixiebrix/api integration
databaseId integration

Outputs

Name Required Type Description
No outputs for this brick defined.