# Atoti Hub: Atoti Engine Atoti REST API 6.1.24 ## 6.1.24 ### AI Optimizer - [Delete aggregate provider history for all cubes](https://docs.activeviam.com/engine/rest/6.1.24/ai-optimizer/delete-aggregate-provider-history-for-all-cubes.md): Delete the query history on which the aggregate provider recommendations are based for each cube. - [Delete aggregate provider history](https://docs.activeviam.com/engine/rest/6.1.24/ai-optimizer/delete-aggregate-provider-history.md): Delete the query history on which the aggregate provider recommendations are based for the given cube. - [Get aggregate provider recommendations for all cubes](https://docs.activeviam.com/engine/rest/6.1.24/ai-optimizer/get-aggregate-provider-recommendations-for-all-cubes.md): Computes the partial aggregate providers needed to efficiently cover the query history. Partial aggregate providers are recommended for every data cube. This operation is intended to be called in a test environment, in order not to impact the production environment. - [Get aggregate provider recommendations for a pivot](https://docs.activeviam.com/engine/rest/6.1.24/ai-optimizer/get-aggregate-provider-recommendations-for-a-pivot.md): Computes recommendations for a specific pivot. - [Get query history statistics](https://docs.activeviam.com/engine/rest/6.1.24/ai-optimizer/get-query-history-statistics.md): Returns statistics about the query history used for aggregate provider recommendations. ### auto-explain-controller - [Autoexplain](https://docs.activeviam.com/engine/rest/6.1.24/auto-explain-controller/autoexplain.md) ### Bulk REST API - [A specialized version of the DELETE method that deletes atomically all the given entries.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-delete-method-that-deletes-atomically-all-the-given-entries.md): If a path matches a directory, the directory all its sub-entries will also be deleted. If the last element of a path is a wildcard (*), all the entries within the parent directory will be deleted, leaving an empty directory. - [A specialized version of the GET method that retrieves the structure and the content of several entries. ](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-get-method-that-retrieves-the-structure-and-the-content-of-several-entries.md): Allows atomic retrieval of the structure and, if needed, the content of the subtrees with roots and heights specified by path and recursion parameters of the entries, respectively. For each path the corresponding subtree height must be specified; if the height is less or equal to zero only the root… - [A specialized version of the POST method that tries to move atomically all the given entries.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-post-method-that-tries-to-move-atomically-all-the-given-entries.md): For each underlying move, if the target path refers to an existing directory, the entry is moved with its current name to the existing directory. Otherwise, the entry is renamed and moved to the target path. If intermediate directories are missing in the target paths, they will be created using the… - [A specialized version of the PUT method that tries to create or update multiple files atomically.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-put-method-that-tries-to-create-or-update-multiple-files-atomically.md): This method does not allow to create directories. The contents of all provided entries must be non null. Either all the entries or none of them are updated. The "throwNotFound" mode for this operation doesn't exist, because "Not Found" error is never encountered. - [A specialized version of the DELETE method that deletes atomically all the given entries.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-delete-method-that-deletes-atomically-all-the-given-entries-1.md): If a path matches a directory, the directory all its sub-entries will also be deleted. If the last element of a path is a wildcard (*), all the entries within the parent directory will be deleted, leaving an empty directory. - [A specialized version of the GET method that retrieves the structure and the content of several entries. ](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-get-method-that-retrieves-the-structure-and-the-content-of-several-entries-1.md): Allows atomic retrieval of the structure and, if needed, the content of the subtrees with roots and heights specified by path and recursion parameters of the entries, respectively. For each path the corresponding subtree height must be specified; if the height is less or equal to zero only the root… - [A specialized version of the POST method that tries to move atomically all the given entries.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-post-method-that-tries-to-move-atomically-all-the-given-entries-1.md): For each underlying move, if the target path refers to an existing directory, the entry is moved with its current name to the existing directory. Otherwise, the entry is renamed and moved to the target path. If intermediate directories are missing in the target paths, they will be created using the… - [A specialized version of the PUT method that tries to create or update multiple files atomically.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/a-specialized-version-of-the-put-method-that-tries-to-create-or-update-multiple-files-atomically-1.md): This method does not allow to create directories. The contents of all provided entries must be non null. Either all the entries or none of them are updated. The "throwNotFound" mode for this operation doesn't exist, because "Not Found" error is never encountered. - [Change permissions for multiple entries atomically.](https://docs.activeviam.com/engine/rest/6.1.24/bulk-rest-api/change-permissions-for-multiple-entries-atomically.md): Allows atomic update of owners and readers for multiple entries. Either all entries are updated or none. If 'throwNotFound' is false, missing entries are ignored. The 'mode' parameter controls how permissions are updated: REPLACE (default) replaces existing permissions, UPSERT adds to existing permi… ### Content Server REST API - [Deletes an entry from the content server.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/deletes-an-entry-from-the-content-server.md): If the path is a directory all its sub-entries will also be deleted. If the last element of the path is a wildcard (*), all the entries within the parent directory will be deleted, leaving an empty directory. - [Retrieves the entry found at the given path.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/retrieves-the-entry-found-at-the-given-path.md): If the entry is a directory, lists all its accessible children recursively by default. - [Performs an operation on the content service.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/performs-an-operation-on-the-content-service.md): The default operation creates a new entry under the current path with an auto-generated name. - [Creates an entry at the given path or updates an existing one.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/creates-an-entry-at-the-given-path-or-updates-an-existing-one.md): If the permissions parameter is set, only the permissions of the entry are updated. - [Deletes an entry from the content server.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/deletes-an-entry-from-the-content-server-1.md): If the path is a directory all its sub-entries will also be deleted. If the last element of the path is a wildcard (*), all the entries within the parent directory will be deleted, leaving an empty directory. - [Retrieves the entry found at the given path.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/retrieves-the-entry-found-at-the-given-path-1.md): If the entry is a directory, lists all its accessible children recursively by default. - [Performs an operation on the content service.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/performs-an-operation-on-the-content-service-1.md): The default operation creates a new entry under the current path with an auto-generated name. - [Creates an entry at the given path or updates an existing one.](https://docs.activeviam.com/engine/rest/6.1.24/content-server-rest-api/creates-an-entry-at-the-given-path-or-updates-an-existing-one-1.md): If the permissions parameter is set, only the permissions of the entry are updated. ### Database REST API - [Create a new branch.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/create-a-new-branch.md): Create a new branch by doing an empty commit on a new branch without any data change. The new branch is a fork identical to the parent branch. The permissions can also be set on creation. - [Delete a branch.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/delete-a-branch.md): Delete a branch. Requires to be owner of the branch. - [Fast-forward a branch to another one.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/fast-forward-a-branch-to-another-one.md): Fast-forward a branch to another one. The fast-forwarded branch is moved to the target head. It can only be done if the target has been forked from the branch and no new commit happened on the branch since. This requires owner permissions on the branch that is fast-forwarded and read permissions on… - [Update the permissions of a branch.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/update-the-permissions-of-a-branch.md): Update the security of a branch. Permissions can be a user name, a role or the constant string __ALL_USERS__ for all users. Requires to be owner of the branch. - [Update the database.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/update-the-database.md): Update a database by removing, adding or updating facts in the specified branch. - [Execute a query on the database via GET method.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/execute-a-query-on-the-database-via-get-method.md): Execute a query on the database, on a given table, via GET method. The query can be paginated using the parameters page and pageSize. - [Execute a query on the database.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/execute-a-query-on-the-database.md): Execute a query on the database, on a given table, via POST method. The query can be paginated using the parameters page and pageSize. - [Get the full description of the database.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-full-description-of-the-database.md): Get the full description of the database : tables, joins and branches. - [Get the description of all the branches.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-description-of-all-the-branches.md): Get the description of all the branches. Only shows branches where the current user has read permissions. - [Get the description of a branch.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-description-of-a-branch.md): Get the description of a specific branch. - [Get the description of all joins.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-description-of-all-joins.md): Get the description of all the visible joins in the database. - [Get the joins of a table.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-joins-of-a-table.md): Get the joins of the provided owner table name. - [Get the separator.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-separator.md): Get the separator used to concatenate the elements of a field path into a String. - [Get the table names.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-table-names.md): Get the table names that exist in the database. - [Get the description of all the tables.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-description-of-all-the-tables.md): Get the description of all the tables in the database visible to the current user. - [Get the description of the table.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/get-the-description-of-the-table.md): Get the description of the given table name. - [Retrieve size of a table.](https://docs.activeviam.com/engine/rest/6.1.24/database-rest-api/retrieve-size-of-a-table.md): Retrieve size of the selected table. ### JWT API - [Get JWT token](https://docs.activeviam.com/engine/rest/6.1.24/jwt-api/get-jwt-token.md): Retrieves a JSON Web Token (JWT) for the currently authenticated user. ### Configuration REST API - [Gets all defined editable calculated members defined in a given ActivePivot.](https://docs.activeviam.com/engine/rest/6.1.24/configuration-rest-api/gets-all-defined-editable-calculated-members-defined-in-a-given-activepivot.md): Some additional calculated members may be defined in the ActivePivot instance. However, if they cannot be edited through this API, they won't be listed by this call. - [Executes an MDX definition statement.](https://docs.activeviam.com/engine/rest/6.1.24/configuration-rest-api/executes-an-mdx-definition-statement.md): The statement itself defines on which ActivePivot instance it applies. There are various types of statements that are supported by the API. The full list and examples are provided by