**API versions** · **V2 (Latest)** · [V1](/integrations/v1/docs?lang=en)

# Explorer reports

OpenAPI 3.0.3 · API 2.0.0

```json
[
  {
    "url": "https://api.unisoft.world/integrations/v2",
    "description": "API"
  }
]
```

Read bounded reports through the existing explorer, with dataset and relation permissions checked independently.

## Operations

## GET /explorer/reports/datasets

Discover authorised explorer report datasets

`list_explorer_report_datasets`

Requires statistics:read plus every source scope advertised for the selected dataset and each used relation; these scopes are checked again on execution. Dataset mapping: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms_submit:read AND forms:read, cerfas=receipts:read. A source reference never grants another source's rights. Any campaign restriction, including an empty list, is rejected with EXPLORER_CAMPAIGN_SCOPE_UNSUPPORTED: the current explorer owner cannot enforce it across all lookups. Uses the authenticated organisation and owner read permissions without an administrator principal. For forms_submit execution, formId must identify a current non-deleted form in the same organisation; a historical submission reference does not admit its parent. A missing, deleted or foreign form returns 404 EXPLORER_FORM_NOT_FOUND: choose a current form from this organisation before retrying. No pipeline, database path, collection, JavaScript, arbitrary expression, custom field, reusable payment instrument or private configuration is accepted or returned. No business write, save, export, billable document issuance, provider call or persistent initialisation occurs; authentication may update key usage telemetry. Returns only datasets readable by the key. An empty catalogue is valid. No query parameters or non-empty request body are accepted. Fetch the dataset detail before constructing a report; this catalogue is separate from the statistic-definition catalogue and does not assert drilldown equivalence.

### Authentication

```json
[
  {
    "bearerAuth": []
  },
  {
    "apiKeyHeader": []
  }
]
```

### Required permissions

```json
{
  "accepted": "statistics:read",
  "additional": []
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Authorised explorer report result.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportDatasetsResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown parameter, field, operator, value type, limit or form context. Refine the request using the authorised dataset catalogue.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Missing or invalid authentication.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Missing statistics:read, invalid organisation or campaign-limited key. Campaign-limited reports cannot be safely executed by the current owner.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "Dataset unknown or not authorised by the key's source scopes; required form missing, deleted or outside the organisation.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "The owner rejected this report; no partial result is returned.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "The owner is unavailable or its bounded query could not complete. No business mutation was attempted; reduce the report before retrying.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [],
  "x-unisoft-scopes-by-dataset": {
    "contacts": [
      "contacts:read"
    ],
    "interactions": [
      "contacts:read"
    ],
    "paiements": [
      "paiements:read"
    ],
    "abonnements": [
      "abonnements:read"
    ],
    "promesses": [
      "promesses:read"
    ],
    "forms_submit": [
      "forms_submit:read",
      "forms:read"
    ],
    "cerfas": [
      "receipts:read"
    ]
  },
  "x-unisoft-mcp": {
    "category": "read",
    "readOnly": true,
    "destructive": false,
    "idempotent": true,
    "warn": false
  }
}
```

## GET /explorer/reports/datasets/{dataset}

Read authorised fields and relations for an explorer dataset

`get_explorer_report_dataset`

Requires statistics:read plus every source scope advertised for the selected dataset and each used relation; these scopes are checked again on execution. Dataset mapping: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms_submit:read AND forms:read, cerfas=receipts:read. A source reference never grants another source's rights. Any campaign restriction, including an empty list, is rejected with EXPLORER_CAMPAIGN_SCOPE_UNSUPPORTED: the current explorer owner cannot enforce it across all lookups. Uses the authenticated organisation and owner read permissions without an administrator principal. For forms_submit execution, formId must identify a current non-deleted form in the same organisation; a historical submission reference does not admit its parent. A missing, deleted or foreign form returns 404 EXPLORER_FORM_NOT_FOUND: choose a current form from this organisation before retrying. No pipeline, database path, collection, JavaScript, arbitrary expression, custom field, reusable payment instrument or private configuration is accepted or returned. No business write, save, export, billable document issuance, provider call or persistent initialisation occurs; authentication may update key usage telemetry. Advertises only safe scalar logical fields and authorised relations with their filter operators, sorting/grouping support and raw money units. One-to-many relations expose only selected owner count/first/last-date aggregates, never nested documents. Private metadata and database paths are omitted. forms_submit supports submission rows within one required form UUID; dynamic answers, product, participant and place rows are not exposed. No query parameters or non-empty request body are accepted.

### Authentication

```json
[
  {
    "bearerAuth": []
  },
  {
    "apiKeyHeader": []
  }
]
```

### Required permissions

```json
{
  "accepted": "statistics:read",
  "additional": []
}
```

### Parameters

```json
{
  "name": "dataset",
  "in": "path",
  "required": true,
  "schema": {
    "type": "string",
    "enum": [
      "contacts",
      "interactions",
      "paiements",
      "abonnements",
      "promesses",
      "forms_submit",
      "cerfas"
    ]
  },
  "description": "Dataset id from the authorised explorer catalogue."
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Authorised explorer report result.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportDatasetResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown parameter, field, operator, value type, limit or form context. Refine the request using the authorised dataset catalogue.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Missing or invalid authentication.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Missing statistics:read, invalid organisation or campaign-limited key. Campaign-limited reports cannot be safely executed by the current owner.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "Dataset unknown or not authorised by the key's source scopes; required form missing, deleted or outside the organisation.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "The owner rejected this report; no partial result is returned.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "The owner is unavailable or its bounded query could not complete. No business mutation was attempted; reduce the report before retrying.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [],
  "x-unisoft-scopes-by-dataset": {
    "contacts": [
      "contacts:read"
    ],
    "interactions": [
      "contacts:read"
    ],
    "paiements": [
      "paiements:read"
    ],
    "abonnements": [
      "abonnements:read"
    ],
    "promesses": [
      "promesses:read"
    ],
    "forms_submit": [
      "forms_submit:read",
      "forms:read"
    ],
    "cerfas": [
      "receipts:read"
    ]
  },
  "x-unisoft-mcp": {
    "category": "read",
    "readOnly": true,
    "destructive": false,
    "idempotent": true,
    "warn": false
  }
}
```

## POST /explorer/reports/run

Read a bounded page of an authorised explorer report

`run_explorer_report`

Requires statistics:read plus every source scope advertised for the selected dataset and each used relation; these scopes are checked again on execution. Dataset mapping: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms_submit:read AND forms:read, cerfas=receipts:read. A source reference never grants another source's rights. Any campaign restriction, including an empty list, is rejected with EXPLORER_CAMPAIGN_SCOPE_UNSUPPORTED: the current explorer owner cannot enforce it across all lookups. Uses the authenticated organisation and owner read permissions without an administrator principal. For forms_submit execution, formId must identify a current non-deleted form in the same organisation; a historical submission reference does not admit its parent. A missing, deleted or foreign form returns 404 EXPLORER_FORM_NOT_FOUND: choose a current form from this organisation before retrying. No pipeline, database path, collection, JavaScript, arbitrary expression, custom field, reusable payment instrument or private configuration is accepted or returned. No business write, save, export, billable document issuance, provider call or persistent initialisation occurs; authentication may update key usage telemetry. Supply dataset and 1–40 unique fields from its catalogue; optional filters are ANDed, each with an allowed operator and scalar values. Numeric filters require JSON numbers in owner raw units; money is minor units for payments/subscriptions and major units for pledges. Calendar dates use YYYY-MM-DD and date-time filters use ISO instants with an explicit offset; no implicit reporting timezone or period is applied. Empty/boolean operators need values:[], between needs exactly two values. At most 20 filters, 20 values/filter and 4 sort keys; id is added as a stable tie-break. page=1..500 and pageSize=1..200 are integers. Only requested cells and their currencies are projected; malformed historical cells stay null. The owner paiements dataset includes only COMPLETED records, which can be an Axepta authorisation before capture; it is not a bank settlement report. Cached pledge-balance computed fields are excluded. readAt is response observation time, sourceComputedAt stays null, LIVE_QUERY describes database execution and does not assert snapshot freshness of source fields. Page and total use separate queries and are not one consistent snapshot. Query timeout is bounded to 15 seconds per owner aggregate. Unknown parameters or query strings are rejected.

### Authentication

```json
[
  {
    "bearerAuth": []
  },
  {
    "apiKeyHeader": []
  }
]
```

### Required permissions

```json
{
  "accepted": "statistics:read",
  "additional": []
}
```

### Request body

```json
{
  "required": true,
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/UnisoftRequest_729f4d152ef616c77bcd"
      }
    }
  }
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Authorised explorer report result.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportRunResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown parameter, field, operator, value type, limit or form context. Refine the request using the authorised dataset catalogue.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Missing or invalid authentication.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Missing statistics:read, invalid organisation or campaign-limited key. Campaign-limited reports cannot be safely executed by the current owner.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "Dataset unknown or not authorised by the key's source scopes; required form missing, deleted or outside the organisation.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "The owner rejected this report; no partial result is returned.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "The owner is unavailable or its bounded query could not complete. No business mutation was attempted; reduce the report before retrying.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [],
  "x-unisoft-scopes-by-dataset": {
    "contacts": [
      "contacts:read"
    ],
    "interactions": [
      "contacts:read"
    ],
    "paiements": [
      "paiements:read"
    ],
    "abonnements": [
      "abonnements:read"
    ],
    "promesses": [
      "promesses:read"
    ],
    "forms_submit": [
      "forms_submit:read",
      "forms:read"
    ],
    "cerfas": [
      "receipts:read"
    ]
  },
  "x-unisoft-mcp": {
    "category": "read",
    "readOnly": true,
    "destructive": false,
    "idempotent": true,
    "warn": false
  }
}
```

## POST /explorer/reports/aggregate

Aggregate an authorised explorer report by one field

`aggregate_explorer_report`

Requires statistics:read plus every source scope advertised for the selected dataset and each used relation; these scopes are checked again on execution. Dataset mapping: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms_submit:read AND forms:read, cerfas=receipts:read. A source reference never grants another source's rights. Any campaign restriction, including an empty list, is rejected with EXPLORER_CAMPAIGN_SCOPE_UNSUPPORTED: the current explorer owner cannot enforce it across all lookups. Uses the authenticated organisation and owner read permissions without an administrator principal. For forms_submit execution, formId must identify a current non-deleted form in the same organisation; a historical submission reference does not admit its parent. A missing, deleted or foreign form returns 404 EXPLORER_FORM_NOT_FOUND: choose a current form from this organisation before retrying. No pipeline, database path, collection, JavaScript, arbitrary expression, custom field, reusable payment instrument or private configuration is accepted or returned. No business write, save, export, billable document issuance, provider call or persistent initialisation occurs; authentication may update key usage telemetry. The owner's full filtered dataset is used, independently of any page. Explicit operation=count|sum|avg|min|max; count forbids field, other operations require one numericAggregate:true root/computed NUMBER field. MONEY and relation metrics are unsupported, never silently converted. Optional groupBy is one groupable scalar field, without date buckets, arbitrary expressions or multi-axis grouping. At most 30 groups, ordered by owner value descending then count and group; truncated signals additional groups. Without groupBy, items is empty and value/valueCount contain the overall aggregate; with grouping, value/valueCount are null. Numeric aggregates ignore non-number source values; count is all matching source rows, not the number of numeric values. Owner empty numeric aggregates can yield zero with valueCount=0; this is not an observed zero-valued source. Same filter/raw-unit and required form UUID rules as run_explorer_report. readAt is observation time, sourceComputedAt is unknown and consistentSnapshot is false because count and aggregate are separate reads. Query timeout is 15 seconds per owner aggregate. Unknown parameters or query strings are rejected.

### Authentication

```json
[
  {
    "bearerAuth": []
  },
  {
    "apiKeyHeader": []
  }
]
```

### Required permissions

```json
{
  "accepted": "statistics:read",
  "additional": []
}
```

### Request body

```json
{
  "required": true,
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/UnisoftRequest_411efe4dbeaae4a40e62"
      }
    }
  }
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Authorised explorer report result.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportAggregateResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown parameter, field, operator, value type, limit or form context. Refine the request using the authorised dataset catalogue.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Missing or invalid authentication.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Missing statistics:read, invalid organisation or campaign-limited key. Campaign-limited reports cannot be safely executed by the current owner.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "Dataset unknown or not authorised by the key's source scopes; required form missing, deleted or outside the organisation.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "The owner rejected this report; no partial result is returned.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "The owner is unavailable or its bounded query could not complete. No business mutation was attempted; reduce the report before retrying.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ExplorerReportError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [],
  "x-unisoft-scopes-by-dataset": {
    "contacts": [
      "contacts:read"
    ],
    "interactions": [
      "contacts:read"
    ],
    "paiements": [
      "paiements:read"
    ],
    "abonnements": [
      "abonnements:read"
    ],
    "promesses": [
      "promesses:read"
    ],
    "forms_submit": [
      "forms_submit:read",
      "forms:read"
    ],
    "cerfas": [
      "receipts:read"
    ]
  },
  "x-unisoft-mcp": {
    "category": "read",
    "readOnly": true,
    "destructive": false,
    "idempotent": true,
    "warn": false
  }
}
```

## Schemas

```json
{
  "components": {
    "schemas": {
      "ExplorerReportDatasetsResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/ExplorerReportDataset"
            }
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ExplorerReportDataset": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "id": {
            "type": "string",
            "enum": [
              "contacts",
              "interactions",
              "paiements",
              "abonnements",
              "promesses",
              "forms_submit",
              "cerfas"
            ]
          },
          "label": {
            "type": "string"
          },
          "requiredScopes": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "requiresFormId": {
            "type": "boolean"
          },
          "rowMode": {
            "type": "string",
            "enum": [
              "root",
              "submission"
            ]
          }
        },
        "required": [
          "id",
          "label",
          "requiredScopes",
          "requiresFormId",
          "rowMode"
        ]
      },
      "ExplorerReportError": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              false
            ]
          },
          "error": {
            "type": "string"
          }
        },
        "required": [
          "success",
          "error"
        ]
      },
      "ExplorerReportDatasetResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ExplorerReportDatasetDetail"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ExplorerReportDatasetDetail": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "id": {
            "type": "string",
            "enum": [
              "contacts",
              "interactions",
              "paiements",
              "abonnements",
              "promesses",
              "forms_submit",
              "cerfas"
            ]
          },
          "label": {
            "type": "string"
          },
          "requiredScopes": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "requiresFormId": {
            "type": "boolean"
          },
          "rowMode": {
            "type": "string",
            "enum": [
              "root",
              "submission"
            ]
          },
          "fields": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/ExplorerReportField"
            }
          },
          "relations": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/ExplorerReportRelation"
            }
          },
          "limits": {
            "type": "object",
            "additionalProperties": false,
            "properties": {
              "columns": {
                "type": "integer",
                "enum": [
                  40
                ]
              },
              "filters": {
                "type": "integer",
                "enum": [
                  20
                ]
              },
              "sorters": {
                "type": "integer",
                "enum": [
                  4
                ]
              },
              "values": {
                "type": "integer",
                "enum": [
                  20
                ]
              },
              "valueLength": {
                "type": "integer",
                "enum": [
                  500
                ]
              },
              "pageSize": {
                "type": "integer",
                "enum": [
                  200
                ]
              },
              "page": {
                "type": "integer",
                "enum": [
                  500
                ]
              },
              "groups": {
                "type": "integer",
                "enum": [
                  30
                ]
              }
            },
            "required": [
              "columns",
              "filters",
              "sorters",
              "values",
              "valueLength",
              "pageSize",
              "page",
              "groups"
            ]
          },
          "aggregateOperations": {
            "type": "array",
            "items": {
              "type": "string",
              "enum": [
                "count",
                "sum",
                "avg",
                "min",
                "max"
              ]
            }
          }
        },
        "required": [
          "id",
          "label",
          "requiredScopes",
          "requiresFormId",
          "rowMode",
          "fields",
          "relations",
          "limits",
          "aggregateOperations"
        ]
      },
      "ExplorerReportField": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "field": {
            "type": "string",
            "minLength": 1,
            "maxLength": 180,
            "description": "Exact logical field identifier advertised by this dataset's authorised catalogue; never a database path or expression."
          },
          "type": {
            "type": "string",
            "enum": [
              "TEXT",
              "NUMBER",
              "MONEY",
              "DATE",
              "DATETIME",
              "BOOL",
              "ENUM",
              "REF"
            ]
          },
          "label": {
            "type": "string"
          },
          "filterable": {
            "type": "boolean"
          },
          "sortable": {
            "type": "boolean"
          },
          "groupable": {
            "type": "boolean"
          },
          "numericAggregate": {
            "type": "boolean"
          },
          "operators": {
            "type": "array",
            "items": {
              "type": "string"
            }
          },
          "unit": {
            "type": "string",
            "nullable": true,
            "enum": [
              "NUMBER",
              "MINOR_CURRENCY_UNIT",
              "MAJOR_CURRENCY_UNIT",
              null
            ]
          }
        },
        "required": [
          "field",
          "type",
          "label",
          "filterable",
          "sortable",
          "groupable",
          "numericAggregate",
          "operators",
          "unit"
        ]
      },
      "ExplorerReportRelation": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "id": {
            "type": "string"
          },
          "dataset": {
            "type": "string"
          },
          "cardinality": {
            "type": "string",
            "enum": [
              "one",
              "many"
            ]
          },
          "requiredScopes": {
            "type": "array",
            "items": {
              "type": "string"
            }
          }
        },
        "required": [
          "id",
          "dataset",
          "cardinality",
          "requiredScopes"
        ]
      },
      "UnisoftRequest_729f4d152ef616c77bcd": {
        "type": "object",
        "properties": {
          "dataset": {
            "type": "string",
            "enum": [
              "contacts",
              "interactions",
              "paiements",
              "abonnements",
              "promesses",
              "forms_submit",
              "cerfas"
            ]
          },
          "formId": {
            "type": "string",
            "format": "uuid",
            "description": "Required only for forms_submit, whose supported row mode is submission. Other datasets reject formId."
          },
          "filters": {
            "type": "array",
            "maxItems": 20,
            "items": {
              "type": "object",
              "properties": {
                "field": {
                  "type": "string",
                  "minLength": 1,
                  "maxLength": 180,
                  "description": "Exact logical field identifier advertised by this dataset's authorised catalogue; never a database path or expression."
                },
                "op": {
                  "type": "string",
                  "enum": [
                    "contains",
                    "equals",
                    "startsWith",
                    "endsWith",
                    "in",
                    "notIn",
                    "eq",
                    "neq",
                    "gt",
                    "gte",
                    "lt",
                    "lte",
                    "between",
                    "before",
                    "after",
                    "isTrue",
                    "isFalse",
                    "isEmpty",
                    "isNotEmpty"
                  ]
                },
                "values": {
                  "type": "array",
                  "maxItems": 20,
                  "items": {
                    "oneOf": [
                      {
                        "type": "string",
                        "maxLength": 500
                      },
                      {
                        "type": "number"
                      }
                    ]
                  }
                }
              },
              "required": [
                "field",
                "op",
                "values"
              ],
              "additionalProperties": false
            }
          },
          "fields": {
            "type": "array",
            "minItems": 1,
            "maxItems": 40,
            "uniqueItems": true,
            "items": {
              "type": "string",
              "minLength": 1,
              "maxLength": 180,
              "description": "Exact logical field identifier advertised by this dataset's authorised catalogue; never a database path or expression."
            }
          },
          "sort": {
            "type": "array",
            "maxItems": 4,
            "items": {
              "type": "object",
              "properties": {
                "field": {
                  "type": "string",
                  "minLength": 1,
                  "maxLength": 180,
                  "description": "Exact logical field identifier advertised by this dataset's authorised catalogue; never a database path or expression."
                },
                "order": {
                  "type": "string",
                  "enum": [
                    "asc",
                    "desc"
                  ]
                }
              },
              "required": [
                "field",
                "order"
              ],
              "additionalProperties": false
            }
          },
          "page": {
            "type": "integer",
            "minimum": 1,
            "maximum": 500,
            "default": 1
          },
          "pageSize": {
            "type": "integer",
            "minimum": 1,
            "maximum": 200,
            "default": 50
          }
        },
        "required": [
          "dataset",
          "fields"
        ],
        "additionalProperties": false
      },
      "ExplorerReportRunResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ExplorerReportRunResult"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ExplorerReportRunResult": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "dataset": {
            "type": "string"
          },
          "columns": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/ExplorerReportField"
            }
          },
          "rows": {
            "type": "array",
            "maxItems": 200,
            "items": {
              "$ref": "#/components/schemas/ExplorerReportRow"
            }
          },
          "total": {
            "type": "integer",
            "minimum": 0,
            "maximum": 9007199254740991
          },
          "page": {
            "type": "integer"
          },
          "pageSize": {
            "type": "integer"
          },
          "hasMore": {
            "type": "boolean"
          },
          "readAt": {
            "type": "string",
            "format": "date-time"
          },
          "sourceComputedAt": {
            "type": "string",
            "format": "date-time",
            "nullable": true
          },
          "freshness": {
            "type": "string",
            "enum": [
              "LIVE_QUERY"
            ]
          },
          "consistentSnapshot": {
            "type": "boolean",
            "enum": [
              false
            ]
          }
        },
        "required": [
          "dataset",
          "columns",
          "rows",
          "total",
          "page",
          "pageSize",
          "hasMore",
          "readAt",
          "sourceComputedAt",
          "freshness",
          "consistentSnapshot"
        ]
      },
      "ExplorerReportRow": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "values": {
            "type": "object",
            "additionalProperties": {
              "oneOf": [
                {
                  "type": "string",
                  "maxLength": 2000,
                  "nullable": true
                },
                {
                  "type": "number"
                },
                {
                  "type": "boolean"
                }
              ]
            },
            "description": "Only the requested logical field identifiers. Values preserve owner raw units. Unsupported or malformed stored values are null; no raw document or nested snapshot is returned."
          },
          "currencies": {
            "type": "object",
            "additionalProperties": {
              "type": "string",
              "nullable": true,
              "pattern": "^[a-z]{3}$"
            },
            "description": "Currency for each selected MONEY field, or null when unavailable. No organisation currency is fabricated."
          }
        },
        "required": [
          "values",
          "currencies"
        ]
      },
      "UnisoftRequest_411efe4dbeaae4a40e62": {
        "type": "object",
        "properties": {
          "dataset": {
            "type": "string",
            "enum": [
              "contacts",
              "interactions",
              "paiements",
              "abonnements",
              "promesses",
              "forms_submit",
              "cerfas"
            ]
          },
          "formId": {
            "type": "string",
            "format": "uuid",
            "description": "Required only for forms_submit, whose supported row mode is submission. Other datasets reject formId."
          },
          "filters": {
            "type": "array",
            "maxItems": 20,
            "items": {
              "type": "object",
              "properties": {
                "field": {
                  "type": "string",
                  "minLength": 1,
                  "maxLength": 180,
                  "description": "Exact logical field identifier advertised by this dataset's authorised catalogue; never a database path or expression."
                },
                "op": {
                  "type": "string",
                  "enum": [
                    "contains",
                    "equals",
                    "startsWith",
                    "endsWith",
                    "in",
                    "notIn",
                    "eq",
                    "neq",
                    "gt",
                    "gte",
                    "lt",
                    "lte",
                    "between",
                    "before",
                    "after",
                    "isTrue",
                    "isFalse",
                    "isEmpty",
                    "isNotEmpty"
                  ]
                },
                "values": {
                  "type": "array",
                  "maxItems": 20,
                  "items": {
                    "oneOf": [
                      {
                        "type": "string",
                        "maxLength": 500
                      },
                      {
                        "type": "number"
                      }
                    ]
                  }
                }
              },
              "required": [
                "field",
                "op",
                "values"
              ],
              "additionalProperties": false
            }
          },
          "operation": {
            "type": "string",
            "enum": [
              "count",
              "sum",
              "avg",
              "min",
              "max"
            ]
          },
          "field": {
            "type": "string",
            "minLength": 1,
            "maxLength": 180,
            "description": "Required for sum/avg/min/max, forbidden for count. Only a root or computed NUMBER field with numericAggregate:true is accepted; MONEY and relation metrics are unsupported."
          },
          "groupBy": {
            "type": "string",
            "minLength": 1,
            "maxLength": 180,
            "description": "Optional single groupable field. Omit for one overall value. No multi-axis, date-bucket, expression or money aggregation is accepted."
          },
          "limit": {
            "type": "integer",
            "minimum": 1,
            "maximum": 30,
            "default": 12
          }
        },
        "required": [
          "dataset",
          "operation"
        ],
        "additionalProperties": false
      },
      "ExplorerReportAggregateResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ExplorerReportAggregateResult"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ExplorerReportAggregateResult": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "dataset": {
            "type": "string"
          },
          "operation": {
            "type": "string",
            "enum": [
              "count",
              "sum",
              "avg",
              "min",
              "max"
            ]
          },
          "field": {
            "type": "string",
            "nullable": true
          },
          "groupBy": {
            "type": "string",
            "nullable": true
          },
          "items": {
            "type": "array",
            "maxItems": 30,
            "items": {
              "type": "object",
              "additionalProperties": false,
              "properties": {
                "group": {
                  "oneOf": [
                    {
                      "type": "string",
                      "maxLength": 2000,
                      "nullable": true
                    },
                    {
                      "type": "number"
                    },
                    {
                      "type": "boolean"
                    }
                  ]
                },
                "count": {
                  "type": "integer",
                  "minimum": 0,
                  "maximum": 9007199254740991,
                  "nullable": true
                },
                "value": {
                  "type": "number",
                  "nullable": true
                }
              },
              "required": [
                "group",
                "count",
                "value"
              ]
            }
          },
          "value": {
            "type": "number",
            "nullable": true
          },
          "count": {
            "type": "integer",
            "minimum": 0,
            "maximum": 9007199254740991
          },
          "valueCount": {
            "type": "integer",
            "minimum": 0,
            "maximum": 9007199254740991,
            "nullable": true
          },
          "truncated": {
            "type": "boolean"
          },
          "readAt": {
            "type": "string",
            "format": "date-time"
          },
          "sourceComputedAt": {
            "type": "string",
            "format": "date-time",
            "nullable": true
          },
          "freshness": {
            "type": "string",
            "enum": [
              "LIVE_QUERY"
            ]
          },
          "consistentSnapshot": {
            "type": "boolean",
            "enum": [
              false
            ]
          }
        },
        "required": [
          "dataset",
          "operation",
          "field",
          "groupBy",
          "items",
          "value",
          "count",
          "valueCount",
          "truncated",
          "readAt",
          "sourceComputedAt",
          "freshness",
          "consistentSnapshot"
        ]
      }
    },
    "securitySchemes": {
      "bearerAuth": {
        "type": "http",
        "scheme": "bearer",
        "bearerFormat": "API Key",
        "description": "Format: `ke_live_xxx`"
      },
      "apiKeyHeader": {
        "type": "apiKey",
        "in": "header",
        "name": "X-API-Key"
      }
    }
  }
}
```
