No results
Search failed
No results
Narrow your search with type:list, type:token, #tag…↑↓ to move · Enter to open · Esc to close

Fetch all item data

Fetch a page of items in a list.

This route only returns the data from each item.

GET https://api.jsonpad.io/lists/{listId}/items/data

Example

cURL
12curl https://api.jsonpad.io/lists/5dde1509-40ac-4017-a1b1-d7fb2c910367/items/data \ -H "x-api-token: <YOUR TOKEN>"

Parameters

  • required
    listIdstringA list id or path name.
  • optional
    pagenumberhttps://api.jsonpad.io/lists/14dfd906-96e2-4cf0-8b02-2d6166602755/items/data?page=1The page number to fetch. Defaults to 1.
  • optional
    limitnumberhttps://api.jsonpad.io/lists/c24f4331-de3d-42c1-8b6d-abba070bb9f5/items/data?limit=20The number of items to fetch per page. Defaults to 20.
  • optional
    orderstringhttps://api.jsonpad.io/lists/dbcb360b-2274-41e3-b7af-c18d79ff8ac0/items/data?order=createdAt

    The field to order the items by. Defaults to createdAt.

    Valid values are:

    • createdAt
    • updatedAt
    • alias
    • readonly
    • activated
    • identityId
    • {index.pathName}The path name of a sortable index in the specified list.
  • optional
    directionstringhttps://api.jsonpad.io/lists/403db207-340c-49c8-a336-d5ba71f83fde/items/data?direction=asc

    The direction to order the items by.

    Valid values are:

    • asc
    • desc
  • optional
    pathstringhttps://api.jsonpad.io/lists/a30d393b-9048-488c-aef3-cd90ebbdf7c9/items/data?path=%24.locations%5B%2A%5D.state

    Fetch only the specified path from each item's data.

    This parameter uses JSON path syntax to specify the data to fetch.

    Example

    Given the JSON path: $.locations[*].state, and 2 items containing the following data:

    Item #1:
    {
    name: "John Doe"
    age: 30
    locations: [
    0: {
    city: "New York"
    state: "NY"
    }
    1: {
    city: "Los Angeles"
    state: "CA"
    }
    ]
    }
    Item #2:
    {
    name: "Jane Doe"
    age: 40
    locations: [
    0: {
    city: "Chicago"
    state: "IL"
    }
    1: {
    city: "Houston"
    state: "TX"
    }
    ]
    }

    The JSON path will be applied to each item's data, resulting in:

    [
    0: [
    0: "NY"
    1: "CA"
    ]
    1: [
    0: "IL"
    1: "TX"
    ]
    ]
  • optional
    aliasstringhttps://api.jsonpad.io/lists/e8e5abdf-6a6a-43bd-827e-c7879d5275c2/items/data?alias=sampleFilter items by their alias-indexed value (partial match, only applies if the list has an alias index).
  • optional
    readonlybooleanhttps://api.jsonpad.io/lists/0f855a25-dab2-4895-a2a2-2ae91e68b37c/items/data?readonly=true

    Filter for readonly items. Can be true or false.

    This uses each item's own readonly setting. Items in a readonly list can't be modified either, but they aren't treated as readonly by this filter.

  • optional
    identityIdstringhttps://api.jsonpad.io/lists/c1e6ee64-4f19-44f4-b55c-7682ed7bb15f/items/data?identityId=798dcdc0-ad8c-4206-adc4-3b1458772244

    Filter for items owned by the specified identity.

    This parameter is ignored when using an identity token, since only items owned by that identity will be visible.

  • optional
    {index.pathName}string | numberhttps://api.jsonpad.io/lists/a4be1e79-b92f-4e18-90bf-5a0136cff5c9/items/data?index-name=sampleFilter items by an indexed value.
    Examples
    • ?index-name=lt:10 will filter items using the index-name index where the indexed value is a number less than 10.
    • ?index-name=lte:10 will filter items using the index-name index where the indexed value is a number less than or equal to 10.
    • ?index-name=gt:10 will filter items using the index-name index where the indexed value is a number greater than 10.
    • ?index-name=gte:10 will filter items using the index-name index where the indexed value is a number greater than or equal to 10.
    • ?index-name=before:2026-09-23 will filter items using the index-name index where the indexed value is a date before (or exactly equal to) 23rd September 2026.
    • ?index-name=after:2026-09-23 will filter items using the index-name index where the indexed value is a date after (or exactly equal to) 23rd September 2026.
  • optional
    includeGuardedboolean?includeGuarded=true

    Include values hidden by guard indexes in the response. Can be true or false.

    This only applies when the request is authenticated as an identity, and only to the items that identity owns. Without an identity, guarded values stay hidden.

    Defaults to false.

  • optional
    taggedstringhttps://api.jsonpad.io/lists/4b01b3e1-5620-4828-9bda-3194ed6bd9bb/items/data?tagged=recipe-app

    Only fetch items with a tag.

    Separate tags with commas to fetch items with any of the tags (?tagged=recipe-app,cookbook-app), or repeat the parameter to fetch items with all of them (?tagged=recipe-app&tagged=production).

Request headers

  • required
    x-api-tokenstringYour API token.
  • optional
    x-identity-tokenstringAn identity token.
  • optional
    x-identity-groupstringAn identity group.

Request body

No request body

Response body

200 OK
{
page: 1
limit: 20
total: 1
data: [
0: {
name: "John Doe"
age: 30
locations: [
0: {
city: "New York"
state: "NY"
}
1: {
city: "Los Angeles"
state: "CA"
}
]
}
]
}

Response headers

  • x-total1The total number of results available.
  • x-pages1The total number of pages available.
2024-10-29