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

# Private report views

OpenAPI 3.0.3 · API 2.0.0

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

## Operations

## POST /reports/views

Save an API-key-private report definition

`create_report_view`

Public request/definition objects are limited to 64 KiB. Requires statistics:read, an exact organisation and stable API-key identity. Views are private to that same API key and organisation; no staff sharing, public link or administrator inheritance exists. Campaign-restricted keys, including empty or malformed restrictions, are refused. A view saves a definition, never results or source authority. Definitions and execution revalidate the current Explorer dataset, logical fields, relations, operators and required source scopes; a saved reference does not preserve revoked rights. Dataset grants: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms:read AND forms_submit:read, cerfas=receipts:read; used relations require their own grants. forms_submit requires a current non-deleted form UUID in the same organisation. No Mongo expression, pipeline, database path, custom field or private configuration is accepted. Use list_explorer_report_datasets and get_explorer_report_dataset to build the report. Monetary raw units and unknown currencies remain those of the Explorer projection: payments/subscriptions minor, pledges major; no conversion or financial formula is added. COMPLETED does not prove bank settlement. No provider, business mutation or historical statistics-cache operation occurs. Explicitly stores a private view; additionally requires reports:write. Supply idempotencyKey (8–100 ASCII letters/digits/underscore/hyphen), name (trimmed 1–120 characters), kind=rows|aggregate and the matching public Explorer report request. The definition is validated without running the report. Same key and original creation inputs return the current view without undoing later edits; different inputs return 409 REPORT_VIEW_IDEMPOTENCY_CONFLICT. A deleted key cannot recreate the view. Storage requires a positive durable acknowledgement; 503 REPORT_VIEW_WRITE_UNCONFIRMED means inspect this same idempotent creation before another attempt. No results are calculated.

### Authentication

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

### Required permissions

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

### Request body

```json
{
  "required": true,
  "content": {
    "application/json": {
      "schema": {
        "type": "object",
        "properties": {
          "idempotencyKey": {
            "type": "string",
            "pattern": "^[A-Za-z0-9_-]{8,100}$"
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120
          },
          "kind": {
            "type": "string",
            "enum": [
              "rows",
              "aggregate"
            ]
          },
          "report": {
            "oneOf": [
              {
                "$ref": "#/components/schemas/UnisoftRequest_729f4d152ef616c77bcd"
              },
              {
                "$ref": "#/components/schemas/UnisoftRequest_411efe4dbeaae4a40e62"
              }
            ]
          }
        },
        "required": [
          "idempotencyKey",
          "name",
          "kind",
          "report"
        ],
        "additionalProperties": false
      }
    }
  }
}
```

### Responses

#### HTTP 201

```json
{
  "description": "Private view response.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown input.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Authentication required.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Scope or principal refused.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "View, dataset, field or form unavailable to this principal.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 409

```json
{
  "description": "Revision or idempotency conflict.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 410

```json
{
  "description": "View was deleted.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "Invalid stored definition or owner rejection.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "Storage/owner unavailable or write unconfirmed.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-mcp-output-schema": true,
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [
    "reports:write"
  ],
  "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": "write",
    "readOnly": false,
    "destructive": false,
    "idempotent": true,
    "warn": false
  }
}
```

## GET /reports/views

List private report view metadata

`list_report_views`

Public request/definition objects are limited to 64 KiB. Requires statistics:read, an exact organisation and stable API-key identity. Views are private to that same API key and organisation; no staff sharing, public link or administrator inheritance exists. Campaign-restricted keys, including empty or malformed restrictions, are refused. A view saves a definition, never results or source authority. Definitions and execution revalidate the current Explorer dataset, logical fields, relations, operators and required source scopes; a saved reference does not preserve revoked rights. Dataset grants: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms:read AND forms_submit:read, cerfas=receipts:read; used relations require their own grants. forms_submit requires a current non-deleted form UUID in the same organisation. No Mongo expression, pipeline, database path, custom field or private configuration is accepted. Use list_explorer_report_datasets and get_explorer_report_dataset to build the report. Monetary raw units and unknown currencies remain those of the Explorer projection: payments/subscriptions minor, pledges major; no conversion or financial formula is added. COMPLETED does not prove bank settlement. No provider, business mutation or historical statistics-cache operation occurs. Passive GET of your private view metadata only; no source query, report calculation, storage write or definition disclosure. Metadata availability does not grant permission to open or execute the view. limit=1..100, default 25; after is nextAfter from this list. Ordering is view UUID ascending and pagination is not a frozen snapshot. Newly created views may appear during paging. No other query keys or non-empty body are accepted.

### Authentication

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

### Required permissions

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

### Parameters

```json
{
  "name": "limit",
  "in": "query",
  "schema": {
    "type": "integer",
    "minimum": 1,
    "maximum": 100
  },
  "description": "Metadata rows, default 25."
}
```

```json
{
  "name": "after",
  "in": "query",
  "schema": {
    "type": "string",
    "format": "uuid"
  },
  "description": "nextAfter from the preceding metadata page."
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Private view response.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewListResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown input.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Authentication required.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Scope or principal refused.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "View, dataset, field or form unavailable to this principal.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 409

```json
{
  "description": "Revision or idempotency conflict.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 410

```json
{
  "description": "View was deleted.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "Invalid stored definition or owner rejection.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "Storage/owner unavailable or write unconfirmed.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-mcp-output-schema": true,
  "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 /reports/views/{viewId}

Read a private report definition with current rights

`get_report_view`

Public request/definition objects are limited to 64 KiB. Requires statistics:read, an exact organisation and stable API-key identity. Views are private to that same API key and organisation; no staff sharing, public link or administrator inheritance exists. Campaign-restricted keys, including empty or malformed restrictions, are refused. A view saves a definition, never results or source authority. Definitions and execution revalidate the current Explorer dataset, logical fields, relations, operators and required source scopes; a saved reference does not preserve revoked rights. Dataset grants: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms:read AND forms_submit:read, cerfas=receipts:read; used relations require their own grants. forms_submit requires a current non-deleted form UUID in the same organisation. No Mongo expression, pipeline, database path, custom field or private configuration is accepted. Use list_explorer_report_datasets and get_explorer_report_dataset to build the report. Monetary raw units and unknown currencies remain those of the Explorer projection: payments/subscriptions minor, pledges major; no conversion or financial formula is added. COMPLETED does not prove bank settlement. No provider, business mutation or historical statistics-cache operation occurs. Passive GET of one definition after current source-right and required-form validation. It does not run the report or modify storage. A missing or foreign key/organisation returns 404 REPORT_VIEW_NOT_FOUND. Revoked dataset/field access or missing form refuses the definition; discover current capabilities instead of bypassing them. Deleted views return 410 REPORT_VIEW_DELETED. No query or non-empty body is accepted.

### Authentication

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

### Required permissions

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

### Parameters

```json
{
  "name": "viewId",
  "in": "path",
  "required": true,
  "schema": {
    "type": "string",
    "format": "uuid"
  },
  "description": "Private view UUID returned by create_report_view or list_report_views."
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Private view response.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown input.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Authentication required.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Scope or principal refused.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "View, dataset, field or form unavailable to this principal.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 409

```json
{
  "description": "Revision or idempotency conflict.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 410

```json
{
  "description": "View was deleted.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "Invalid stored definition or owner rejection.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "Storage/owner unavailable or write unconfirmed.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-mcp-output-schema": true,
  "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
  }
}
```

## PATCH /reports/views/{viewId}

Revise a private report definition

`update_report_view`

Public request/definition objects are limited to 64 KiB. Requires statistics:read, an exact organisation and stable API-key identity. Views are private to that same API key and organisation; no staff sharing, public link or administrator inheritance exists. Campaign-restricted keys, including empty or malformed restrictions, are refused. A view saves a definition, never results or source authority. Definitions and execution revalidate the current Explorer dataset, logical fields, relations, operators and required source scopes; a saved reference does not preserve revoked rights. Dataset grants: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms:read AND forms_submit:read, cerfas=receipts:read; used relations require their own grants. forms_submit requires a current non-deleted form UUID in the same organisation. No Mongo expression, pipeline, database path, custom field or private configuration is accepted. Use list_explorer_report_datasets and get_explorer_report_dataset to build the report. Monetary raw units and unknown currencies remain those of the Explorer projection: payments/subscriptions minor, pledges major; no conversion or financial formula is added. COMPLETED does not prove bank settlement. No provider, business mutation or historical statistics-cache operation occurs. Explicitly changes name and/or report, additionally requiring reports:write and current source rights. Supply the current revision and at least one changed field. kind is immutable. The same public Explorer validator runs without calculating results. Revision comparison and scalar private ownership are checked atomically; stale revision returns 409 REPORT_VIEW_REVISION_CONFLICT. Successful response contains the next revision. An unconfirmed write returns 503 REPORT_VIEW_WRITE_UNCONFIRMED; read the view to resolve its revision before any new command, never blindly repeat an update.

### Authentication

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

### Required permissions

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

### Parameters

```json
{
  "name": "viewId",
  "in": "path",
  "required": true,
  "schema": {
    "type": "string",
    "format": "uuid"
  },
  "description": "Private view UUID returned by create_report_view or list_report_views."
}
```

### Request body

```json
{
  "required": true,
  "content": {
    "application/json": {
      "schema": {
        "type": "object",
        "properties": {
          "revision": {
            "type": "integer",
            "minimum": 1,
            "maximum": 9007199254740990
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120
          },
          "report": {
            "oneOf": [
              {
                "$ref": "#/components/schemas/UnisoftRequest_729f4d152ef616c77bcd"
              },
              {
                "$ref": "#/components/schemas/UnisoftRequest_411efe4dbeaae4a40e62"
              }
            ]
          }
        },
        "required": [
          "revision"
        ],
        "additionalProperties": false
      }
    }
  }
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Private view response.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown input.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Authentication required.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Scope or principal refused.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "View, dataset, field or form unavailable to this principal.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 409

```json
{
  "description": "Revision or idempotency conflict.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 410

```json
{
  "description": "View was deleted.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "Invalid stored definition or owner rejection.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "Storage/owner unavailable or write unconfirmed.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-mcp-output-schema": true,
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [
    "reports:write"
  ],
  "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": "write",
    "readOnly": false,
    "destructive": false,
    "idempotent": false,
    "warn": false
  }
}
```

## DELETE /reports/views/{viewId}

Delete a private report definition

`delete_report_view`

Public request/definition objects are limited to 64 KiB. Requires statistics:read, an exact organisation and stable API-key identity. Views are private to that same API key and organisation; no staff sharing, public link or administrator inheritance exists. Campaign-restricted keys, including empty or malformed restrictions, are refused. A view saves a definition, never results or source authority. Definitions and execution revalidate the current Explorer dataset, logical fields, relations, operators and required source scopes; a saved reference does not preserve revoked rights. Dataset grants: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms:read AND forms_submit:read, cerfas=receipts:read; used relations require their own grants. forms_submit requires a current non-deleted form UUID in the same organisation. No Mongo expression, pipeline, database path, custom field or private configuration is accepted. Use list_explorer_report_datasets and get_explorer_report_dataset to build the report. Monetary raw units and unknown currencies remain those of the Explorer projection: payments/subscriptions minor, pledges major; no conversion or financial formula is added. COMPLETED does not prove bank settlement. No provider, business mutation or historical statistics-cache operation occurs. Explicitly deletes this API-key-private view, additionally requiring reports:write. Supply the current revision. A tombstone retains only ownership/idempotency/revision metadata; saved name and report filters are removed. Existing exports or jobs, if any, are separate private artifacts. Stale revision returns 409. An unconfirmed write returns 503 REPORT_VIEW_WRITE_UNCONFIRMED; inspect current state before a new command. No source query or report calculation is required for deletion.

### Authentication

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

### Required permissions

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

### Parameters

```json
{
  "name": "viewId",
  "in": "path",
  "required": true,
  "schema": {
    "type": "string",
    "format": "uuid"
  },
  "description": "Private view UUID returned by create_report_view or list_report_views."
}
```

### Request body

```json
{
  "required": true,
  "content": {
    "application/json": {
      "schema": {
        "type": "object",
        "properties": {
          "revision": {
            "type": "integer",
            "minimum": 1,
            "maximum": 9007199254740990
          }
        },
        "required": [
          "revision"
        ],
        "additionalProperties": false
      }
    }
  }
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Private view response.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewDeleteResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown input.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Authentication required.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Scope or principal refused.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "View, dataset, field or form unavailable to this principal.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 409

```json
{
  "description": "Revision or idempotency conflict.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 410

```json
{
  "description": "View was deleted.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "Invalid stored definition or owner rejection.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "Storage/owner unavailable or write unconfirmed.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-mcp-output-schema": true,
  "x-unisoft-scope": "statistics:read",
  "x-unisoft-additional-scopes": [
    "reports:write"
  ],
  "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": "write",
    "readOnly": false,
    "destructive": true,
    "idempotent": false,
    "warn": true
  }
}
```

## POST /reports/views/{viewId}/run

Run the current private report definition

`run_report_view`

Public request/definition objects are limited to 64 KiB. Requires statistics:read, an exact organisation and stable API-key identity. Views are private to that same API key and organisation; no staff sharing, public link or administrator inheritance exists. Campaign-restricted keys, including empty or malformed restrictions, are refused. A view saves a definition, never results or source authority. Definitions and execution revalidate the current Explorer dataset, logical fields, relations, operators and required source scopes; a saved reference does not preserve revoked rights. Dataset grants: contacts/interactions=contacts:read, paiements=paiements:read, abonnements=abonnements:read, promesses=promesses:read, forms_submit=forms:read AND forms_submit:read, cerfas=receipts:read; used relations require their own grants. forms_submit requires a current non-deleted form UUID in the same organisation. No Mongo expression, pipeline, database path, custom field or private configuration is accepted. Use list_explorer_report_datasets and get_explorer_report_dataset to build the report. Monetary raw units and unknown currencies remain those of the Explorer projection: payments/subscriptions minor, pledges major; no conversion or financial formula is added. COMPLETED does not prove bank settlement. No provider, business mutation or historical statistics-cache operation occurs. Explicitly runs the current saved definition through the existing public Explorer owner, with current source rights and form admission. reports:write is not required because execution stores nothing. For rows, optional page=1..500 and pageSize=1..200 override this call only; aggregate requires an empty object. The returned viewRevision identifies the definition used. Results are live observations with consistentSnapshot=false, unknown sourceComputedAt and no historical statistics cache. No query keys are accepted.

### Authentication

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

### Required permissions

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

### Parameters

```json
{
  "name": "viewId",
  "in": "path",
  "required": true,
  "schema": {
    "type": "string",
    "format": "uuid"
  },
  "description": "Private view UUID returned by create_report_view or list_report_views."
}
```

### Request body

```json
{
  "required": true,
  "content": {
    "application/json": {
      "schema": {
        "type": "object",
        "properties": {
          "page": {
            "type": "integer",
            "minimum": 1,
            "maximum": 500
          },
          "pageSize": {
            "type": "integer",
            "minimum": 1,
            "maximum": 200
          }
        },
        "additionalProperties": false
      }
    }
  }
}
```

### Responses

#### HTTP 200

```json
{
  "description": "Private view response.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewRunResponse"
      }
    }
  }
}
```

#### HTTP 400

```json
{
  "description": "Invalid or unknown input.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 401

```json
{
  "description": "Authentication required.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 403

```json
{
  "description": "Scope or principal refused.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 404

```json
{
  "description": "View, dataset, field or form unavailable to this principal.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 409

```json
{
  "description": "Revision or idempotency conflict.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 410

```json
{
  "description": "View was deleted.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 422

```json
{
  "description": "Invalid stored definition or owner rejection.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

#### HTTP 503

```json
{
  "description": "Storage/owner unavailable or write unconfirmed.",
  "content": {
    "application/json": {
      "schema": {
        "$ref": "#/components/schemas/ReportViewError"
      }
    }
  }
}
```

### OpenAPI

```json
{
  "x-unisoft-mcp-output-schema": true,
  "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": {
      "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
      },
      "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
      },
      "ReportViewResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ReportViewDefinition"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ReportViewDefinition": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "id": {
            "type": "string",
            "format": "uuid"
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120
          },
          "kind": {
            "type": "string",
            "enum": [
              "rows",
              "aggregate"
            ]
          },
          "revision": {
            "type": "integer",
            "minimum": 1,
            "maximum": 9007199254740990
          },
          "createdAt": {
            "type": "string",
            "format": "date-time"
          },
          "updatedAt": {
            "type": "string",
            "format": "date-time"
          },
          "visibility": {
            "type": "string",
            "enum": [
              "API_KEY_PRIVATE"
            ]
          },
          "report": {
            "oneOf": [
              {
                "$ref": "#/components/schemas/ExplorerReportRunRequest"
              },
              {
                "$ref": "#/components/schemas/ExplorerReportAggregateRequest"
              }
            ]
          }
        },
        "required": [
          "id",
          "name",
          "kind",
          "revision",
          "createdAt",
          "updatedAt",
          "visibility",
          "report"
        ]
      },
      "ExplorerReportRunRequest": {
        "type": "object",
        "additionalProperties": false,
        "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": {
              "$ref": "#/components/schemas/ExplorerReportFilter"
            }
          },
          "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": {
              "$ref": "#/components/schemas/ExplorerReportSort"
            }
          },
          "page": {
            "type": "integer",
            "minimum": 1,
            "maximum": 500,
            "default": 1
          },
          "pageSize": {
            "type": "integer",
            "minimum": 1,
            "maximum": 200,
            "default": 50
          }
        },
        "required": [
          "dataset",
          "fields"
        ]
      },
      "ExplorerReportFilter": {
        "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."
          },
          "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"
        ]
      },
      "ExplorerReportSort": {
        "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."
          },
          "order": {
            "type": "string",
            "enum": [
              "asc",
              "desc"
            ]
          }
        },
        "required": [
          "field",
          "order"
        ]
      },
      "ExplorerReportAggregateRequest": {
        "type": "object",
        "additionalProperties": false,
        "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": {
              "$ref": "#/components/schemas/ExplorerReportFilter"
            }
          },
          "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"
        ]
      },
      "ReportViewError": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              false
            ]
          },
          "error": {
            "type": "string"
          }
        },
        "required": [
          "success",
          "error"
        ]
      },
      "ReportViewListResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ReportViewList"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ReportViewList": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "items": {
            "type": "array",
            "maxItems": 100,
            "items": {
              "$ref": "#/components/schemas/ReportViewMetadata"
            }
          },
          "hasMore": {
            "type": "boolean"
          },
          "nextAfter": {
            "type": "string",
            "nullable": true,
            "format": "uuid"
          },
          "consistentSnapshot": {
            "type": "boolean",
            "enum": [
              false
            ]
          }
        },
        "required": [
          "items",
          "hasMore",
          "nextAfter",
          "consistentSnapshot"
        ]
      },
      "ReportViewMetadata": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "id": {
            "type": "string",
            "format": "uuid"
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 120
          },
          "kind": {
            "type": "string",
            "enum": [
              "rows",
              "aggregate"
            ]
          },
          "revision": {
            "type": "integer",
            "minimum": 1,
            "maximum": 9007199254740990
          },
          "createdAt": {
            "type": "string",
            "format": "date-time"
          },
          "updatedAt": {
            "type": "string",
            "format": "date-time"
          },
          "visibility": {
            "type": "string",
            "enum": [
              "API_KEY_PRIVATE"
            ]
          }
        },
        "required": [
          "id",
          "name",
          "kind",
          "revision",
          "createdAt",
          "updatedAt",
          "visibility"
        ]
      },
      "ReportViewDeleteResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ReportViewDeleted"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ReportViewDeleted": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "id": {
            "type": "string",
            "format": "uuid"
          },
          "revision": {
            "type": "integer",
            "minimum": 1,
            "maximum": 9007199254740990
          },
          "deleted": {
            "type": "boolean",
            "enum": [
              true
            ]
          }
        },
        "required": [
          "id",
          "revision",
          "deleted"
        ]
      },
      "ReportViewRunResponse": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "success": {
            "type": "boolean",
            "enum": [
              true
            ]
          },
          "data": {
            "$ref": "#/components/schemas/ReportViewRunResult"
          }
        },
        "required": [
          "success",
          "data"
        ]
      },
      "ReportViewRunResult": {
        "type": "object",
        "additionalProperties": false,
        "properties": {
          "viewId": {
            "type": "string",
            "format": "uuid"
          },
          "viewRevision": {
            "type": "integer",
            "minimum": 1,
            "maximum": 9007199254740990
          },
          "kind": {
            "type": "string",
            "enum": [
              "rows",
              "aggregate"
            ]
          },
          "result": {
            "oneOf": [
              {
                "$ref": "#/components/schemas/ReportViewExplorerRunResult"
              },
              {
                "$ref": "#/components/schemas/ExplorerReportAggregateResult"
              }
            ]
          }
        },
        "required": [
          "viewId",
          "viewRevision",
          "kind",
          "result"
        ]
      },
      "ReportViewExplorerRunResult": {
        "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/ReportViewExplorerRow"
            }
          },
          "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"
        ]
      },
      "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"
        ]
      },
      "ReportViewExplorerRow": {
        "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.",
            "maxProperties": 40,
            "x-unisoft-map-key-pattern": "^(?:_computed\\.actionsCount|_computed\\.adressesCount|_computed\\.age|_computed\\.civilite|_computed\\.emailsCount|_computed\\.fullName|_computed\\.genre|_computed\\.hasContent|_computed\\.hasType|_computed\\.telsCount|abonnements\\._agg\\.count|abonnements\\._agg\\.firstDate|abonnements\\._agg\\.lastDate|abonnements\\.active|abonnements\\.amount|abonnements\\.assoc|abonnements\\.canceledAt|abonnements\\.datetime|abonnements\\.devise|abonnements\\.id|abonnements\\.max|abonnements\\.method|abonnements\\.name|abonnements\\.nb|abonnements\\.platform|abonnements\\.recurrentType|abonnements\\.retry|abonnements\\.state|abonnements\\.type|cerfa\\._agg\\.count|cerfa\\._agg\\.firstDate|cerfa\\._agg\\.lastDate|cerfa\\.datetime|cerfa\\.id|cerfa\\.num|cerfa\\.year|contact\\._agg\\.count|contact\\._agg\\.firstDate|contact\\._agg\\.lastDate|contact\\.adresse|contact\\.adressesCount|contact\\.age|contact\\.archived|contact\\.civilite|contact\\.datetime|contact\\.ddn|contact\\.deceased|contact\\.deceasedDate|contact\\.editDatetime|contact\\.email|contact\\.emailsCount|contact\\.etat|contact\\.fullName|contact\\.genre|contact\\.giftAid|contact\\.homme|contact\\.id|contact\\.new|contact\\.nom|contact\\.nomHebreu|contact\\.nomJF|contact\\.pays|contact\\.postal|contact\\.prenom|contact\\.prenomHE|contact\\.route|contact\\.tel|contact\\.telsCount|contact\\.tribu|contact\\.ville|forms_submit\\._agg\\.count|forms_submit\\._agg\\.firstDate|forms_submit\\._agg\\.lastDate|forms_submit\\.archived|forms_submit\\.datetime|forms_submit\\.devise|forms_submit\\.editDatetime|forms_submit\\.formId|forms_submit\\.formLabel|forms_submit\\.formType|forms_submit\\.id|forms_submit\\.identityEmail|forms_submit\\.identityNom|forms_submit\\.identityPrenom|forms_submit\\.identityTel|forms_submit\\.paiementMethod|forms_submit\\.state|interactions\\._agg\\.count|interactions\\._agg\\.firstDate|interactions\\._agg\\.lastDate|interactions\\.actionsCount|interactions\\.content|interactions\\.datePrecision|interactions\\.datetime|interactions\\.editDatetime|interactions\\.hasContent|interactions\\.hasType|interactions\\.id|interactions\\.occurredOn|interactions\\.type|paiements\\._agg\\.count|paiements\\._agg\\.firstDate|paiements\\._agg\\.lastDate|paiements\\.amount|paiements\\.assoc|paiements\\.commentaire|paiements\\.datetime|paiements\\.devise|paiements\\.editDatetime|paiements\\.id|paiements\\.infoEmail|paiements\\.infoHomme|paiements\\.infoNom|paiements\\.infoPrenom|paiements\\.infoTel|paiements\\.method|paiements\\.name|paiements\\.platform|paiements\\.source|paiements\\.type|promesses\\._agg\\.count|promesses\\._agg\\.firstDate|promesses\\._agg\\.lastDate|promesses\\.active|promesses\\.assoc|promesses\\.date|promesses\\.datetime|promesses\\.devise|promesses\\.editDatetime|promesses\\.id|promesses\\.montant|promesses\\.name|promesses\\.occasion|promesses\\.state|promesses\\.type|root\\.active|root\\.adresse|root\\.amount|root\\.archived|root\\.assoc|root\\.canceledAt|root\\.commentaire|root\\.content|root\\.date|root\\.datePrecision|root\\.datetime|root\\.ddn|root\\.deceased|root\\.deceasedDate|root\\.devise|root\\.editDatetime|root\\.email|root\\.etat|root\\.formId|root\\.formLabel|root\\.formType|root\\.giftAid|root\\.homme|root\\.id|root\\.identityEmail|root\\.identityNom|root\\.identityPrenom|root\\.identityTel|root\\.infoEmail|root\\.infoHomme|root\\.infoNom|root\\.infoPrenom|root\\.infoTel|root\\.max|root\\.method|root\\.montant|root\\.name|root\\.nb|root\\.new|root\\.nom|root\\.nomHebreu|root\\.nomJF|root\\.num|root\\.occasion|root\\.occurredOn|root\\.paiementMethod|root\\.pays|root\\.platform|root\\.postal|root\\.prenom|root\\.prenomHE|root\\.recurrentType|root\\.retry|root\\.route|root\\.source|root\\.state|root\\.tel|root\\.tribu|root\\.type|root\\.ville|root\\.year)$"
          },
          "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.",
            "maxProperties": 40,
            "x-unisoft-map-key-pattern": "^(?:root\\.(?:amount|montant)|(?:paiements|abonnements)\\.amount|promesses\\.montant)$"
          }
        },
        "required": [
          "values",
          "currencies"
        ]
      },
      "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"
      }
    }
  }
}
```
