> ## Documentation Index
> Fetch the complete documentation index at: https://docs.raul.ugps.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Get cursor-paginated subscription details (optimized for large datasets)

> Get cursor-paginated subscription details (optimized for large datasets)



## OpenAPI

````yaml /generated/specs/operations.json get /api/v1/subscription_details/all/cursor
openapi: 3.0.0
info:
  title: Raul API - Operaciones
  description: Suscripciones, GPS, actividades, visitas y operacion tecnica.
  version: 2.0.0
  contact: {}
servers:
  - url: https://api.raul.ugps.io
    description: Production
security: []
tags: []
paths:
  /api/v1/subscription_details/all/cursor:
    get:
      tags:
        - Subscription Details
      summary: Get cursor-paginated subscription details (optimized for large datasets)
      description: Get cursor-paginated subscription details (optimized for large datasets)
      operationId: SubscriptionDetailsController_getAllCursorPaginated
      parameters:
        - name: cursor
          required: false
          in: query
          description: >-
            Cursor del ultimo registro de la pagina anterior. null/undefined
            para primera pagina.
          schema:
            example: 150
            type: number
        - name: limit
          required: false
          in: query
          description: Cantidad de registros por pagina
          schema:
            minimum: 1
            maximum: 100
            default: 50
            type: number
        - name: client_id
          required: false
          in: query
          description: Filter by client ID
          schema:
            type: string
        - name: subscription_status_id
          required: false
          in: query
          description: Filter by subscription status ID
          schema:
            type: number
        - name: subscription_plan_id
          required: false
          in: query
          description: Filter by subscription plan ID
          schema:
            type: number
        - name: date_from
          required: false
          in: query
          description: Filter from date (ISO 8601)
          schema:
            type: string
        - name: date_to
          required: false
          in: query
          description: Filter to date (ISO 8601)
          schema:
            type: string
        - name: is_expired
          required: false
          in: query
          description: Filter by expiration status
          schema:
            type: boolean
        - name: search
          required: false
          in: query
          description: Search in client name, GPS details, license plate, IMEI
          schema:
            type: string
      responses:
        '200':
          description: Cursor-paginated list of subscriptions
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/CursorPaginatedSubscriptionsResponseDto'
      security:
        - bearerAuth: []
components:
  schemas:
    CursorPaginatedSubscriptionsResponseDto:
      type: object
      properties:
        data:
          description: Lista de subscriptions de la pagina actual
          type: array
          items:
            $ref: '#/components/schemas/SubscriptionDetailsResponseDto'
        nextCursor:
          type: object
          description: >-
            Cursor para la siguiente pagina (row_num del ultimo registro). null
            si no hay mas paginas.
          example: 200
          nullable: true
        hasMore:
          type: boolean
          description: Indica si hay mas registros disponibles
          example: true
        total:
          type: number
          description: >-
            Total de registros (opcional, puede ser costoso de calcular en
            datasets grandes)
          example: 1500
      required:
        - data
        - nextCursor
        - hasMore
    SubscriptionDetailsResponseDto:
      type: object
      properties:
        subscription_detail_id:
          type: string
        subscription_plan_id:
          type: object
        gps_detail_id:
          type: object
        client_id:
          type: object
        vehicle_id:
          type: object
        fecha_inicio:
          type: object
        fecha_termino:
          type: object
        subscription_status_id:
          type: object
        subscription_frequency_id:
          type: object
        creation_date:
          type: object
        update_date:
          type: object
        subscriptionPlan:
          $ref: '#/components/schemas/SubscriptionPlanResponseDto'
        subscriptionStatus:
          $ref: '#/components/schemas/SubscriptionStatusResponseDto'
        subscriptionFrequency:
          $ref: '#/components/schemas/SubscriptionFrequencyResponseDto'
        vehicle:
          $ref: '#/components/schemas/VehicleResponseDto'
        child_client_id:
          type: object
          description: Child client ID if assigned to a subsidiary
        childClient:
          description: Child client info if assigned
          allOf:
            - $ref: '#/components/schemas/ClientBasicInfoDto'
      required:
        - subscription_detail_id
    SubscriptionPlanResponseDto:
      type: object
      properties:
        id:
          type: number
        name:
          type: object
        subscription_currency_id:
          type: number
        currency_name:
          type: object
        currency_value:
          type: object
        description:
          type: object
      required:
        - id
        - subscription_currency_id
    SubscriptionStatusResponseDto:
      type: object
      properties:
        subscription_status_id:
          type: number
        name:
          type: string
      required:
        - subscription_status_id
        - name
    SubscriptionFrequencyResponseDto:
      type: object
      properties:
        id:
          type: number
        name:
          type: string
      required:
        - id
        - name
    VehicleResponseDto:
      type: object
      properties:
        id:
          type: string
        license_plate:
          type: object
        name:
          type: object
        model:
          type: object
        brand:
          type: object
      required:
        - id
    ClientBasicInfoDto:
      type: object
      properties:
        client_id:
          type: string
        client_name:
          type: string
      required:
        - client_id
        - client_name
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: Bearer token authentication

````