# Update the set of tables and their attributes associated with a database ruleset in bulk

Endpoint: PUT /database-rulesets/{databaseRulesetId}/bulk-table-update
Version: 5.1.43
Security: api_key

## Path parameters:

  - `databaseRulesetId` (integer, required)
    The ID of the database ruleset to update the tables for

## Request fields (application/json):

  - `tableMetadata` (array, required)
    Example: [{"tableName":"profile","rulesetId":2},{"tableName":"address","rulesetId":2},{"tableName":"users","rulesetId":2}]

  - `tableMetadata.tableName` (string, required)
    The name of the table metadata. This name must match the name of a table in the ruleset it is created on. This name must be unique for the given ruleset; in other words, the same table cannot be added to a ruleset more than once.
    Example: "profile"

  - `tableMetadata.rulesetId` (integer, required)
    The ID of the ruleset to create the table metadata on.
    Example: 1

  - `tableMetadata.customSql` (string)
    Custom SQL for the table.

  - `tableMetadata.whereClause` (string)
    SQL where clause for the table.

  - `tableMetadata.havingClause` (string)
    SQL having clause for the table.

  - `tableMetadata.keyColumn` (string)
    Key Column for the table.

## Response 200 fields (application/json):

  - `asyncTaskId` (integer)
    The ID of the AsyncTask. This field will be generated by the Masking Engine.
    Example: 1

  - `operation` (string)
    The type of operation that the AsyncTask is performing.
    Enum: "ADD_MAPPINGS", "ALGORITHM_CREATE", "ALGORITHM_MIGRATE", "ALGORITHM_UPDATE", "DATAFILE_BULK_UPDATE", "ENCRYPTION_KEY_CREATE", "EXPORT", "EXPORT_CLASSIFIER_FILES", "EXPORT_MAPPINGS", "EXPORT_PROFILE_SET", "EXPORT_SL_VALUES", "IMPORT", "RULESET_REFRESH", "TABLE_BULK_UPDATE", "MAINFRAME_DATASET_BULK_UPDATE", "SUPPORT_BUNDLE_GENERATE"

  - `reference` (string)
    The reference for the AsyncTask. An example of a reference is the ruleset ID for a RULESET_REFRESH operation.
    Example: 13

  - `status` (string)
    The status of the AsyncTask in regard to its completion.
    Enum: "CANCELLED", "FAILED", "RUNNING", "SUCCEEDED", "WAITING"

  - `startTime` (string)
    The date and time that this AsyncTask was started.

  - `endTime` (string)
    The date and time that this AsyncTask completed.

  - `cancellable` (boolean)
    True if the AsyncTask can be cancelled, false otherwise.

  - `exceptionDetail` (string)
    The details associated with the Java exception that caused this async task to fail, if applicable.


## Response 400 fields

## Response 403 fields

## Response 404 fields