> ## Documentation Index > Fetch the complete documentation index at: https://doc.extole.com/llms.txt > Use this file to discover all available pages before exploring further. # List report types with their associated clients > Returns every report type alongside the ids of clients that have access to it. Equivalent to running `listReportTypes` and `listReportTypeClients` for every result, but in a single call. Requires the `client_superuser` scope - use this only when auditing cross-client access at the platform level. ## OpenAPI ````yaml /api-reference/management.json get /v6/report-types/clients openapi: 3.0.1 info: description: >- Configuration endpoints for the Extole platform: campaigns, components, audiences, persons, rewards, reporting, integrations setup, and administrative tooling. title: Management API version: '1.0' servers: - description: Production url: https://api.extole.io security: - HEADER: [] - QUERY: [] - COOKIE: [] tags: - name: Audiences - name: Authentication - name: Batch Jobs - name: Blocks - name: Campaigns - name: Components - name: Components Settings - name: Domains - name: Email - name: Erasure - name: Event Streams - name: File Validation Monitors - name: Optout - name: Profiles - name: Promotion Links - name: Report Schedules - name: Report Types - name: Reports - name: Reward Suppliers - name: Security Keys - name: Settings - name: User Notifications - name: User Subscriptions - name: Users - name: Webhooks paths: /v6/report-types/clients: get: tags: - Report Types summary: List report types with their associated clients description: >- Returns every report type alongside the ids of clients that have access to it. Equivalent to running `listReportTypes` and `listReportTypeClients` for every result, but in a single call. Requires the `client_superuser` scope - use this only when auditing cross-client access at the platform level. operationId: listReportTypesWithClients parameters: - in: query name: report_type_id schema: type: string - in: query name: display_name schema: type: string - in: query name: description schema: type: string - in: query name: visibility schema: enum: - EXTOLE_ONLY - PRIVATE - PUBLIC type: string - in: query name: tags schema: type: string - in: query name: exclude_tags schema: type: string - in: query name: search_query schema: type: string - in: query name: limit schema: format: int32 type: integer - in: query name: offset schema: format: int32 type: integer - in: query name: order_by schema: enum: - DISPLAY_NAME - ID - TYPE - VISIBILITY type: string - in: query name: order schema: enum: - ASCENDING - DESCENDING type: string responses: '200': content: application/json: schema: items: $ref: '#/components/schemas/ReportTypeWithClientsResponse' type: array description: Successful response '400': content: application/json: examples: binding_error: $ref: '#/components/examples/binding_error' invalid_json: $ref: '#/components/examples/invalid_json' invalid_limit: $ref: '#/components/examples/invalid_limit' invalid_offset: $ref: '#/components/examples/invalid_offset' invalid_parameter: $ref: '#/components/examples/invalid_parameter' max_fetch_size_1000: $ref: '#/components/examples/max_fetch_size_1000' missing_request_body: $ref: '#/components/examples/missing_request_body' schema: $ref: '#/components/schemas/RestExceptionResponse' description: Bad Request '401': content: application/json: examples: method_unauthorized: $ref: '#/components/examples/method_unauthorized' schema: $ref: '#/components/schemas/RestExceptionResponse' description: Unauthorized '402': content: application/json: examples: payment_required: $ref: '#/components/examples/payment_required' schema: $ref: '#/components/schemas/RestExceptionResponse' description: Payment Required '403': content: application/json: examples: access_denied: $ref: '#/components/examples/access_denied' method_unauthorized: $ref: '#/components/examples/method_unauthorized' missing_access_token: $ref: '#/components/examples/missing_access_token' schema: $ref: '#/components/schemas/RestExceptionResponse' description: Forbidden '415': content: application/json: examples: unsupported_media_type: $ref: '#/components/examples/unsupported_media_type' schema: $ref: '#/components/schemas/RestExceptionResponse' description: Unsupported Media Type '429': content: application/json: examples: too_many_requests: $ref: '#/components/examples/too_many_requests' schema: $ref: '#/components/schemas/RestExceptionResponse' description: Too Many Requests components: schemas: ReportTypeWithClientsResponse: description: >- Pairs a report-type definition with the ids of clients that have access to it. Returned by `GET /v6/report-types/clients`. properties: client_ids: description: >- Stable Extole identifiers for clients that have access to this report type. items: description: >- Stable Extole identifiers for clients that have access to this report type. type: string type: array report_type: $ref: '#/components/schemas/ReportTypeResponse' required: - client_ids - report_type type: object RestExceptionResponse: description: Represents the API error response properties: code: description: Specific error code for this error type, documented per endpoint type: string http_status_code: description: >- HTTP status code that was returned with this error, useful if client get response code format: int32 type: integer message: description: User readable English description of the error type: string parameters: additionalProperties: description: >- Attributes related to the error, varies be error code, documented per endpoint type: object description: >- Attributes related to the error, varies be error code, documented per endpoint type: object unique_id: description: >- Unique id associated with this error, useful for discussions with Extole type: string required: - code - http_status_code - message - parameters - unique_id type: object ReportTypeResponse: description: >- Report type definition. Polymorphic on `type`: SQL, SPARK, DASHBOARD, and CONFIGURED share the common metadata below (display name, description, scopes, parameters, formats, tags, data sources) and add their own type-specific fields. discriminator: mapping: CONFIGURED: $ref: '#/components/schemas/ConfiguredReportTypeResponse' DASHBOARD: $ref: '#/components/schemas/DashboardReportTypeResponse' SPARK: $ref: '#/components/schemas/SparkReportTypeResponse' SQL: $ref: '#/components/schemas/SqlReportTypeResponse' propertyName: type oneOf: - title: CONFIGURED allOf: - $ref: '#/components/schemas/ConfiguredReportTypeResponse' - title: DASHBOARD allOf: - $ref: '#/components/schemas/DashboardReportTypeResponse' - title: SPARK allOf: - $ref: '#/components/schemas/SparkReportTypeResponse' - title: SQL allOf: - $ref: '#/components/schemas/SqlReportTypeResponse' required: - allowed_scopes - categories - component_ids - component_references - data_sources - data_start - description - display_name - executor_type - formats - name - parameters - preview_columns - scopes - tags - type - visibility ConfiguredReportTypeResponse: allOf: - $ref: '#/components/schemas/ReportTypeResponseBase' - properties: created_date: $ref: '#/components/schemas/ZonedDateTime' type: enum: - CONFIGURED type: string updated_date: $ref: '#/components/schemas/ZonedDateTime' type: object required: - allowed_scopes - categories - component_ids - component_references - created_date - data_sources - data_start - description - display_name - executor_type - formats - name - parameters - preview_columns - scopes - tags - type - updated_date - visibility type: object title: CONFIGURED DashboardReportTypeResponse: allOf: - $ref: '#/components/schemas/ReportTypeResponseBase' - properties: type: enum: - DASHBOARD type: string required: - allowed_scopes - categories - component_ids - component_references - data_sources - data_start - description - display_name - executor_type - formats - name - parameters - preview_columns - scopes - tags - type - visibility type: object title: DASHBOARD SparkReportTypeResponse: allOf: - $ref: '#/components/schemas/ReportTypeResponseBase' - properties: type: enum: - SPARK type: string required: - allowed_scopes - categories - component_ids - component_references - data_sources - data_start - description - display_name - executor_type - formats - name - parameters - preview_columns - scopes - tags - type - visibility type: object title: SPARK SqlReportTypeResponse: allOf: - $ref: '#/components/schemas/ReportTypeResponseBase' - properties: created_date: $ref: '#/components/schemas/ZonedDateTime' database: enum: - ANALYTICS - CUSTOMER_PORTAL - INCENTIVES - LABS - OPTOUT type: string query: type: string type: enum: - SQL type: string updated_date: $ref: '#/components/schemas/ZonedDateTime' type: object required: - allowed_scopes - categories - component_ids - component_references - created_date - data_sources - data_start - database - description - display_name - executor_type - formats - name - parameters - preview_columns - query - scopes - tags - type - updated_date - visibility type: object title: SQL ReportTypeResponseBase: properties: allowed_scopes: description: Scopes the report type may be configured for. Superset of `scopes`. items: description: >- Scopes the report type may be configured for. Superset of `scopes`. enum: - CLIENT_ADMIN - CLIENT_SUPERUSER - CONSUMER_PUBLIC type: string type: array uniqueItems: true categories: description: >- Categories used to group report types in the dashboard report builder. items: description: >- Categories used to group report types in the dashboard report builder. type: string type: array component_ids: items: type: string type: array component_references: items: $ref: '#/components/schemas/ComponentReferenceResponse' type: array data_sources: description: Underlying data sources the report type reads from. items: description: Underlying data sources the report type reads from. enum: - AUDIT_EMAIL - BATCH - CLIENT - CLIENT_CHANGE - CONSUMER - CONSUMER_PROFILE - DASHBOARD - DATA_INTELLIGENCE - MESSAGE - NOTIFICATION - PROFILE - REWARD - REWARD_COMMAND - WEBHOOK - WEBHOOK_DISPATCH_RESULT type: string type: array data_start: $ref: '#/components/schemas/ZonedDateTime' description: description: Short description shown alongside the report type in the dashboard. type: string display_name: description: Human-readable name shown in the dashboard. type: string executor_type: description: Engine that executes the report (e.g. SQL, Spark). enum: - DASHBOARD - SPARK - SQL type: string formats: description: Output formats the report type can produce (e.g. CSV, JSON). items: description: Output formats the report type can produce (e.g. CSV, JSON). enum: - CSV - HEADLESS_CSV - HEADLESS_PSV - JSON - JSONL - PSV - XLSX type: string type: array name: description: >- Stable internal name. Use `display_name` for UI; `name` for programmatic lookup. type: string parameters: description: Declared parameters (static + dynamic) the report type accepts. items: $ref: '#/components/schemas/ReportTypeParameterDetailsResponse' type: array preview_columns: description: Column metadata for the report type's preview output. items: $ref: '#/components/schemas/ReportTypeColumnResponse' type: array scopes: description: Scopes the report type currently applies to (e.g. CLIENT, CAMPAIGN). items: description: >- Scopes the report type currently applies to (e.g. CLIENT, CAMPAIGN). enum: - CLIENT_ADMIN - CLIENT_SUPERUSER - CONSUMER_PUBLIC type: string type: array uniqueItems: true tags: description: Tags attached to the report type, used for filtering and grouping. items: $ref: '#/components/schemas/ReportTypeTagResponse' type: array uniqueItems: true type: description: Discriminator selecting the report-type shape. enum: - CONFIGURED - DASHBOARD - SPARK - SQL type: string visibility: description: Whether the report type is PUBLIC, PRIVATE, or restricted. enum: - EXTOLE_ONLY - PRIVATE - PUBLIC type: string type: object ZonedDateTime: description: >- [RFC 3339](https://datatracker.ietf.org/doc/html/rfc3339#section-5.6) or [RFC 9557](https://datatracker.ietf.org/doc/html/rfc9557#section-4) date-time with a numeric [UTC offset](https://datatracker.ietf.org/doc/html/rfc3339#section-5.6) and an optional [IANA time-zone](https://datatracker.ietf.org/doc/html/rfc9557#section-4) suffix in square brackets. Precision up to milliseconds. example: '2025-10-24T02:00:00-07:00' pattern: >- ^\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}(\.\d{1,3})?(Z|[+-](?:[01][0-9]|2[0-3]):[0-5][0-9])(\[[^\]]+\])?$ type: string ComponentReferenceResponse: properties: component_id: type: string socket_names: items: type: string type: array type: object ReportTypeParameterDetailsResponse: description: Declared parameters (static + dynamic) the report type accepts. properties: category: nullable: true type: string default_value: nullable: true type: string description: type: string display_name: type: string is_required: type: boolean name: type: string order: format: int32 type: integer type: $ref: '#/components/schemas/ReportParameterTypeResponse' type: object ReportTypeColumnResponse: description: Column metadata for the report type's preview output. properties: name: type: string note: nullable: true type: string sample_value: nullable: true type: string type: object ReportTypeTagResponse: description: Tags attached to the report type, used for filtering and grouping. properties: name: type: string type: enum: - GLOBAL - PRIVATE type: string type: object ReportParameterTypeResponse: properties: name: enum: - AUDIENCE_ID - AUDIENCE_IDS - AUDIENCE_MEMBERSHIPS_METRIC_MAPPING - AUDIENCE_MEMBERSHIPS_ROW_MAPPINGS - AUDIENCE_MEMBERS_ROW_MAPPINGS - BOOLEAN - CAMPAIGN_ID - CAMPAIGN_IDS - CHANNEL_MAPPING - CLIENT_EVENT_METRIC_MAPPINGS - CLIENT_ID - CLIENT_IDS - DATE - DATE_RANGE - DECIMAL - EMAIL_NAMES - ENUM - ENUM_LIST - EQUALITY - FILTER_MAPPINGS - FLOWS - FLOW_FILTER - GRANULAR_TIME_RANGE - ID - IDS - INPUT_RECORD_METRIC_MAPPING - INPUT_RECORD_ROW_MAPPINGS - INTEGER - LONG - MESSAGE_SUMMARY_METRIC_MAPPINGS - METRIC_MAPPINGS - MODEL_CONFIGURATION_METRIC_MAPPING - NORMALIZED_EMAIL - NOT_ARCHIVED_CAMPAIGN_ID - PERSON_DIMENSION_MAPPINGS - PERSON_MAPPINGS - PROGRAM_LABEL - PROGRAM_LABELS - REGEX - REWARD_EVENT_METRIC_MAPPINGS - REWARD_ROW_MAPPINGS - REWARD_SUPPLIER_DISPLAY_TYPES - REWARD_SUPPLIER_IDS - REWARD_SUPPLIER_TYPES - ROW_MAPPINGS - SORT_ORDER_MAPPINGS - SORT_ORDER_MAPPINGS_ON_STEPS - STEP - STEPS - STEP_COLUMN_LIST - STRING - STRING_LIST - TIERS - TIME - TIME_RANGE - WEBHOOK_DISPATCH_METRIC_MAPPING - WEBHOOK_DISPATCH_ROW_MAPPINGS - WEBHOOK_METRIC_MAPPING - WEBHOOK_ROW_MAPPINGS type: string value_type: enum: - DYNAMIC - STATIC nullable: true type: string values: items: type: string nullable: true type: array uniqueItems: true type: object examples: binding_error: summary: binding_error value: code: binding_error http_status_code: 400 message: Argument is not of the expected type parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 invalid_json: summary: invalid_json value: code: invalid_json http_status_code: 400 message: JSON is invalid parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 invalid_limit: summary: invalid_limit value: code: invalid_limit http_status_code: 400 message: Limit should be a non negative integer parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 invalid_offset: summary: invalid_offset value: code: invalid_offset http_status_code: 400 message: Offset should be a non negative integer parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 invalid_parameter: summary: invalid_parameter value: code: invalid_parameter http_status_code: 400 message: Parameter is invalid. parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 max_fetch_size_1000: summary: max_fetch_size_1000 value: code: max_fetch_size_1000 http_status_code: 400 message: Maximum allowed difference between limit and offset should be 1000 parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 missing_request_body: summary: missing_request_body value: code: missing_request_body http_status_code: 400 message: Missing request body parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 method_unauthorized: summary: method_unauthorized value: code: method_unauthorized http_status_code: 401 message: Unauthorized access to this endpoint parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 payment_required: summary: payment_required value: code: payment_required http_status_code: 402 message: The access_token provided is associated with an unpaid account. parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 access_denied: summary: access_denied value: code: access_denied http_status_code: 403 message: >- The access_token provided is not permitted to access the specified resource. parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 missing_access_token: summary: missing_access_token value: code: missing_access_token http_status_code: 403 message: No access_token was provided with this request. parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 unsupported_media_type: summary: unsupported_media_type value: code: unsupported_media_type http_status_code: 415 message: Request had an unsupported or no media type parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 too_many_requests: summary: too_many_requests value: code: too_many_requests http_status_code: 429 message: >- The server is unable to process your request at the moment, please retry later. parameters: {} unique_id: 00000000-0000-0000-0000-000000000000 securitySchemes: HEADER: in: header name: Authorization type: apiKey x-bearer-format: bearer QUERY: in: query name: access_token type: apiKey COOKIE: in: cookie name: extole_token type: apiKey ````