Lists

Get all List Entries on a Saved View

Changed on

Paginate through the List Entries (AKA rows) on a given Saved View. Use this endpoint when you need to filter entities or only want some field data to be returned: This endpoint respects the filters set on a Saved View via web app, and only returns field data corresponding to the columns that have been pulled into the Saved View via web app.

Though this endpoint respects the Saved View's filters and column/Field selection, it does not yet preserve sort order. This endpoint also only supports sheet-type Saved Views, and not board- or dashboard-type Saved Views.

See the Data Model section for more information about Saved Views.

Requires the "Export data from Lists" permission.

get/v2/lists/{listId}/saved-views/{viewId}/list-entries

Request

  • Base URL
    https://api.affinity.co
  • URL
    https://api.affinity.co/v2/lists/{listId}/saved-views/{viewId}/list-entries
  • Auth
    HTTP bearer

Path parameters

listIdinteger required

List ID

viewIdinteger required

Saved view ID

Query parameters

cursorstring
Example:ICAgICAgYmVmb3JlOjo6Nw

Cursor for the next or previous page

limitinteger
Example:100

Number of items to include in the page

Response

OK

Example response

{
  "data": [
    {
      "id": 1,
      "type": "company",
      "listId": 1,
      "createdAt": "2023-01-01T00:00:00Z",
      "creatorId": 1,
      "entity": {
        "id": 1,
        "name": "Horizon Technologies",
        "domain": "horizontech.com",
        "domains": [
          "horizontech.com"
        ],
        "isGlobal": true,
        "fields": []
      }
    }
  ],
  "pagination": {
    "prevUrl": "https://api.affinity.co/v2/foo?cursor=ICAgICAgYmVmb3JlOjo6Nw",
    "nextUrl": "https://api.affinity.co/v2/foo?cursor=ICAgICAgIGFmdGVyOjo6NA"
  }
}

Changes

    • info

      added authentication authorization bad-request conflict method-not-allowed not-acceptable not-found not-implemented rate-limit server timeout unprocessable-entity unsupported-media-type validation discriminator mapping keys to the / response property for the response status

    • info

      added bad-request validation discriminator mapping keys to the / response property for the response status

    • info

      added chat-message email meeting call discriminator mapping keys to the ///////// response property for the response status

    • info

      added chat-message email meeting call discriminator mapping keys to the ///////// response property for the response status

    • info

      added chat-message email meeting call discriminator mapping keys to the ///////// response property for the response status

    • info

      added company company-multi datetime dropdown dropdown-multi number number-multi filterable-text filterable-text-multi formula-number interaction location location-multi person person-multi ranked-dropdown text discriminator mapping keys to the ////// response property for the response status

    • info

      added company company-multi datetime dropdown dropdown-multi number number-multi filterable-text filterable-text-multi formula-number interaction location location-multi person person-multi ranked-dropdown text discriminator mapping keys to the ////// response property for the response status

    • info

      added company company-multi datetime dropdown dropdown-multi number number-multi filterable-text filterable-text-multi formula-number interaction location location-multi person person-multi ranked-dropdown text discriminator mapping keys to the ////// response property for the response status

    • info

      added company opportunity person discriminator mapping keys to the / response property for the response status

    • info

      removed the hidden enum value from the ////// response property for the response status

    • info

      removed the hidden enum value from the ////// response property for the response status

    • info

      removed the hidden enum value from the ////// response property for the response status