List a user's roles

Your app's unique id. Find it in the console under the app's Settings, or in the URL of any app page.

A JSON filter tree, URL-encoded. {"status":"open"} matches equality and {"col":null} IS NULL. Compare with {"col":{"$gt"|"$gte"|"$lt"|"$lte"|"$ne":v}}, {"$in":[...]} (up to 100 values) or {"$between":[low,high]}; match text with {"$contains":"text"} or {"$startsWith":"text"} (literal text, following the column's collation). Combine with {"$and":[...]} / {"$or":[...]}. A reference is filtered by its <name>_uid column and uids; id, the scope columns, raw foreign-key columns and redacted columns are refused. At most 20 conditions, nested 3 deep.

Up to 3 sort columns, comma-separated, each column.asc or column.desc (asc by default). <name>_uid sorts by the reference. Not with after.

Return only these columns, comma-separated (the row's uid always comes back). A redacted column comes back masked.

Up to 3 references to return the referenced row for, comma-separated, named without _uid (assignee for assignee_uid). Each is read as you, under that table's own permissions: a row you cannot read comes back null.

Rows per page: 50 by default, at most 1,000.

Rows to skip. Pair with order. For a large table use after instead.

Keyset paging in creation order: empty for the first page, then the previous page's paging.nextCursor. A row added or removed between pages never shifts another onto two pages, and a deep page costs what the first does. Takes no order or offset.

1 to also count every matching row into paging.total (a second query). Otherwise paging.total is null.

Older form of where for one equality, column:value. ANDed with where when both are given.

Older form of order for one column, column [ASC|DESC]. Ignored when order is given.