SCIM D. Zollner, Ed. Internet-Draft Microsoft Intended status: Standards Track A. Sehgal Expires: 10 November 2023 D. H. Saxe Amazon Web Services 9 May 2023 Cursor-based Pagination of SCIM Resources draft-ietf-scim-cursor-pagination-01 Abstract This document defines additional SCIM (System for Cross-Domain Identity Management) query parameters and result attributes to allow use of cursor-based pagination in SCIM implementations that are implemented with existing code bases, databases, or APIs where cursor-based pagination is already well- established. Status of This Memo This Internet-Draft is submitted in full conformance with the provisions of BCP 78 and BCP 79. Internet-Drafts are working documents of the Internet Engineering Task Force (IETF). Note that other groups may also distribute working documents as Internet-Drafts. The list of current Internet- Drafts is at https://datatracker.ietf.org/drafts/current/. Internet-Drafts are draft documents valid for a maximum of six months and may be updated, replaced, or obsoleted by other documents at any time. It is inappropriate to use Internet-Drafts as reference material or to cite them other than as "work in progress." This Internet-Draft will expire on 10 November 2023. Copyright Notice Copyright (c) 2023 IETF Trust and the persons identified as the document authors. All rights reserved. Zollner, et al. Expires 10 November 2023 [Page 1] Internet-Draft SCIM Cursor Pagination May 2023 This document is subject to BCP 78 and the IETF Trust's Legal Provisions Relating to IETF Documents (https://trustee.ietf.org/ license-info) in effect on the date of publication of this document. Please review these documents carefully, as they describe your rights and restrictions with respect to this document. Code Components extracted from this document must include Revised BSD License text as described in Section 4.e of the Trust Legal Provisions and are provided without warranty as described in the Revised BSD License. Table of Contents 1. Introduction . . . . . . . . . . . . . . . . . . . . . . . . 2 1.1. Notational Conventions . . . . . . . . . . . . . . . . . 3 2. Query Parameters and Response Attributes . . . . . . . . . . 3 2.1. Pagination errors . . . . . . . . . . . . . . . . . . . . 6 2.2. Sorting . . . . . . . . . . . . . . . . . . . . . . . . . 6 2.3. Cursors as the Only Pagination Method . . . . . . . . . . 6 3. Querying Resources using HTTP POST . . . . . . . . . . . . . 7 4. Service Provider Configuration . . . . . . . . . . . . . . . 8 5. Change Log . . . . . . . . . . . . . . . . . . . . . . . . . 10 Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . 10 Normative References . . . . . . . . . . . . . . . . . . . . . . 10 Authors' Addresses . . . . . . . . . . . . . . . . . . . . . . . 10 1. Introduction The two common patterns for result pagination are index-based pagination and cursor-based pagination. Rather than attempt to compare and contrast the advantages and disadvantages of competing pagination patterns, this document simply recognizes that SCIM service providers are commonly implemented as an interoperability layer on top of already existing application codebases, databases, and/or APIs that already have a well- established pagination pattern. Translating from an underlying cursor-based pagination pattern to the index-based pagination defined in Section 3.4.2.4 of [RFC7644] ultimately requires the SCIM service provider to fully iterate the underlying cursor, store the results, and then serve indexed pages from the stored results. This task of "pagination translation" dramatically increases complexity and memory requirements for implementing a SCIM Service Provider, and may be an impediment to SCIM adoption for some applications and identity systems. Zollner, et al. Expires 10 November 2023 [Page 2] Internet-Draft SCIM Cursor Pagination May 2023 This document defines a simple addition to the SCIM protocol that allows SCIM service providers to reuse underlying cursors without expensive translation. Support for cursor-based pagination in SCIM encourages broader cross-application identity management interoperability by encouraging SCIM service provider implementations for applications and identity systems where cursor-based pagination is already well-established. 1.1. Notational Conventions The key words "MUST", "MUST NOT", "REQUIRED", "SHALL", "SHALL NOT", "SHOULD", "SHOULD NOT", "RECOMMENDED", "NOT RECOMMENDED", "MAY", and "OPTIONAL" in this document are to be interpreted as described in BCP 14 [RFC2119] [RFC8174] when, and only when, they appear in all capitals, as shown here. 2. Query Parameters and Response Attributes The following table describes the URL pagination parameters requests for using cursor-based pagination: +===========+===================================================+ | Parameter | Description | +===========+===================================================+ | cursor | The string value of the nextCursor attribute from | | | a previous result page. The cursor value MUST be | | | empty or omitted for the first request of a | | | cursor-paginated query. | +-----------+---------------------------------------------------+ | count | A positive integer. Specifies the desired | | | maximum number of query results per page, e.g., | | | count=10. When specified, the service provider | | | MUST NOT return more results than specified, | | | although it MAY return fewer results. If count | | | is not specified in the query, the maximum number | | | of results is set by the service provider. | +-----------+---------------------------------------------------+ Table 1: Query Parameters The following table describes cursor-based pagination attributes returned in a paged query response: Zollner, et al. Expires 10 November 2023 [Page 3] Internet-Draft SCIM Cursor Pagination May 2023 +================+===============================================+ | Element | Description | +================+===============================================+ | nextCursor | A cursor value string that MAY be used in a | | | subsequent request to obtain the next page of | | | results. Service providers supporting | | | cursor-based pagination MUST include | | | nextCursor in all paged query responses | | | except when returning the last page. | | | nextCursor is omitted from a response only to | | | indicate that there are no more result pages. | +----------------+-----------------------------------------------+ | previousCursor | A cursor value string that MAY be used in a | | | subsequent request to obtain the previous | | | page of results. Use of previousCursor is | | | OPTIONAL. | +----------------+-----------------------------------------------+ Table 2: Response Attributes Cursor values are opaque; clients MUST not make assumptions about their structure. When the client wants to retrieve another result page for a query, it should query the same Service Provider endpoint with all query parameters and values being identical to the initial query with the exception of the cursor value which should be set to a nextCursor (or previousCursor) value that was returned by Service Provider in a previous response. Cursor values must follow the unreserved characters set defined in section 2.3 of [RFC3986] For example, to retrieve the first 10 Users with username starting with "J", use an empty cursor and set the count to 10: GET /Users?filter=username%20sw%20J&cursor&count=10 Host: example.com Accept: application/scim+json Authorization: Bearer U8YJcYYRMjbGeepD The SCIM provider in response to the query above returns metadata regarding pagination similar to the following example (actual resources removed for brevity): Zollner, et al. Expires 10 November 2023 [Page 4] Internet-Draft SCIM Cursor Pagination May 2023 HTTP/1.1 200 OK Content-Type: application/scim+json { "totalResults":100, "itemsPerPage":10, "nextCursor":"VZUTiyhEQJ94IR", "schemas":["urn:ietf:params:scim:api:messages:2.0:ListResponse"], "Resources":[{ ... }] } Given the example above, to request the next page or results, use the same query parameters and values except set the cursor to the value of nextCursor ("VZUTiyhEQJ94IR"): GET /Users?filter=username%20sw%20J&cursor=VZUTiyhEQJ94IR&count=10 Host: example.com Accept: application/scim+json Authorization: Bearer U8YJcYYRMjbGeepD HTTP/1.1 200 OK Content-Type: application/scim+json { "totalResults":100, "itemsPerPage":10, "previousCursor: "ze7L30kMiiLX6x" "nextCursor":"YkU3OF86Pz0rGv", "schemas":["urn:ietf:params:scim:api:messages:2.0:ListResponse"], "Resources":[{ ... }] } In the example above, the response includes the OPTIONAL previousCursor indicating that the Service Provider supports forward and reverse traversal of result pages. As described in Section 3.4.1 of [RFC7644] Service Providers SHOULD return an accurate value for totalResults which is the total number of resources for all pages. Service Providers implementing cursor pagination that are unable to estimate totalResults MAY choose to omit the totalResults attribute. Zollner, et al. Expires 10 November 2023 [Page 5] Internet-Draft SCIM Cursor Pagination May 2023 2.1. Pagination errors If a Service Provider encounters an invalid pagination query parameters (invalid cursor value, count value, etc), or other error condition, the Service Provider SHOULD return the appropriate HTTP response status code and detailed JSON error response as defined in Section 3.12 of [RFC7644]. Most pagination error conditions would generate HTTP response with status code 400. Since many pagination error conditions are not user recoverable, error messages SHOULD focus on communicating error details to the SCIM client developer. For HTTP status code 400 (Bad Request) responses, the following detail error types are defined. These error types extend the list of error types defined in RFC 7644 Section 3.12, Table 9: SCIM Detail Error Keyword Values. +===============+==================================+===============+ | scimType | Description | Applicability | +===============+==================================+===============+ | invalidCursor | Cursor value is invalid. Cursor | GET (Section | | | value should be empty to request | 3.4.2 of | | | the first page and set to the | [RFC7644]) | | | nextCursor or previousCursor | | | | value for subsequent queries. | | +---------------+----------------------------------+---------------+ | expiredCursor | Cursor has expired. Do not wait | GET (Section | | | longer than cursorTimeout (600 | 3.4.2 of | | | sec) to request additional | [RFC7644]) | | | pages. | | +---------------+----------------------------------+---------------+ | invalidCount | Count value is invalid. Count | GET (Section | | | value must be between 1 - and | 3.4.2 of | | | maximimPageSize (500) | [RFC7644]) | +---------------+----------------------------------+---------------+ Table 3: Pagination Errors 2.2. Sorting If sorting is implemented as described Section 3.4.2.3 of [RFC7644] , then cursor-paged results SHOULD be sorted. 2.3. Cursors as the Only Pagination Method A SCIM Service Provider MAY require cursor-based pagination to retrieve all results for a query by including a "nextCursor" value in the response even when the query does not include the "cursor" parameter. Zollner, et al. Expires 10 November 2023 [Page 6] Internet-Draft SCIM Cursor Pagination May 2023 For example: GET /Users Host: example.com Accept: application/scim+json The SCIM Service Provider may respond to the above query with a page containing defaultPageSize results and a "nextCursor" value as shown in the below example (Resources omitted for brevity): HTTP/1.1 200 OK Content-Type: application/scim+json { "totalResults":5000, "itemsPerPage":100, "nextCursor":"HPq72Pax3JUaNa", "schemas":["urn:ietf:params:scim:api:messages:2.0:ListResponse"], "Resources":[{ ... }] } 3. Querying Resources using HTTP POST Section 3.4.3 of [RFC7644] defines how clients MAY execute the HTTP POST method combined with the "/.search" path extension to issue execute queries without passing parameters on the URL. When using "/.search", the client would pass the parameters defined in Section 2 in the body of the request as shown below. POST /User/.search Host: example.com Accept: application/scim+json Authorization: Bearer U8YJcYYRMjbGeepD { "schemas": [ "urn:ietf:params:scim:api:messages:2.0:SearchRequest"], "attributes": ["displayName", "userName"], "filter": "displayName sw \"smith\"", "cursor": "", "count": 10 } Zollner, et al. Expires 10 November 2023 [Page 7] Internet-Draft SCIM Cursor Pagination May 2023 Which would return a result containing a "nextCursor" value which may be used by the client in a subsequent call to return the next page of resources HTTP/1.1 200 OK Content-Type: application/scim+json { "totalResults":100, "itemsPerPage":10, "nextCursor":"VZUTiyhEQJ94IR", "schemas":["urn:ietf:params:scim:api:messages:2.0:ListResponse"], "Resources":[{ ... }] } 4. Service Provider Configuration The /ServiceProviderConfig resource defined in Section 4 of [RFC7644] facilitates discovery of SCIM service provider features. A SCIM Service provider implementing cursor-based pagination SHOULD include the following additional attribute in JSON document returned by the /ServiceProviderConfig endpoint: pagination A complex type that indicates pagination configuration options. OPTIONAL. cursor A Boolean value specifying support of cursor-based paginations. REQUIRED. index A Boolean value specifying support of index-based pagination. REQUIRED. defaultPageSize Non-negative integer value specifying the default number of results returned in a page when a count is not specified in the query. OPTIONAL. maxPageSize Non-negative integer specifying the maximum number of results returned in a page regardless of what is specified for the count in a query. OPTIONAL. cursorTimeout Non-negative integer specifying the maximum number seconds that a cursor is valid between page requests. Clients waiting too long between cursor pagination requests may receive an invalid cursor error response. OPTIONAL. Zollner, et al. Expires 10 November 2023 [Page 8] Internet-Draft SCIM Cursor Pagination May 2023 Before using cursor-based pagination, a SCIM client MAY fetch the Service Provider Configuration document from the SCIM service provider and verify that cursor-based pagination is supported. For example: GET /ServiceProviderConfig Host: example.com Accept: application/scim+json A service provider supporting both cursor-based pagination and index- based pagination would return a document similar to the following (full ServiceProviderConfig schema defined in Section 5 of [RFC7643] has been omitted for brevity): HTTP/1.1 200 OK Content-Type: application/scim+json { "schemas": [ "urn:ietf:params:scim:schemas:core:2.0:ServiceProviderConfig"], ... "pagination": { "cursor": true, "index": true }, ... } Service Provider implementors SHOULD ensure that misuse of pagination by a SCIM client does not deplete Service Provider resources or prevent valid requests from other clients being handled. Defenses for a SCIM Service Provider are similar those used to protect other Web API services -- including the use of a "Web API gateway" layer, to provide authentication, rate limiting, IP allow/block lists, logging and monitoring, response caching, etc. For example, an obvious protection against abuse is for the Service Provider to require client authentication in order to retrieve large result sets and enforce an overriding totalResults limit for non- authenticated clients. Another example, would be for a Service Provider that implements cursor pagination to restrict number of cursors that can be allocated by a client or enforce cursor lifetime. Zollner, et al. Expires 10 November 2023 [Page 9] Internet-Draft SCIM Cursor Pagination May 2023 5. Change Log v01 - May 2023 - Updated after Httpdir review. v00 - December 2022 - Adopted by SCIM WG. Acknowledgments The editor would like to acknowledge the contribution and work of Matt Peterson for his work in authoring the original version of this draft. Matt Peterson matt.peterson@oneidentity.com Normative References [RFC2119] Bradner, S., "Key words for use in RFCs to Indicate Requirement Levels", BCP 14, RFC 2119, DOI 10.17487/RFC2119, March 1997, . [RFC3986] Berners-Lee, T., Fielding, R., and L. Masinter, "Uniform Resource Identifier (URI): Generic Syntax", STD 66, RFC 3986, DOI 10.17487/RFC3986, January 2005, . [RFC7643] Hunt, P., Ed., Grizzle, K., Wahlstroem, E., and C. Mortimore, "System for Cross-domain Identity Management: Core Schema", RFC 7643, DOI 10.17487/RFC7643, September 2015, . [RFC7644] Hunt, P., Ed., Grizzle, K., Ansari, M., Wahlstroem, E., and C. Mortimore, "System for Cross-domain Identity Management: Protocol", RFC 7644, DOI 10.17487/RFC7644, September 2015, . [RFC8174] Leiba, B., "Ambiguity of Uppercase vs Lowercase in RFC 2119 Key Words", BCP 14, RFC 8174, DOI 10.17487/RFC8174, May 2017, . Authors' Addresses Danny Zollner (editor) Microsoft Email: zollnerd@microsoft.com Zollner, et al. Expires 10 November 2023 [Page 10] Internet-Draft SCIM Cursor Pagination May 2023 Anjali Sehgal Amazon Web Services Email: anjalisg@amazon.com Dean H. Saxe Amazon Web Services Email: deansaxe@amazon.com Zollner, et al. Expires 10 November 2023 [Page 11]