# Get all table metadata

Endpoint: GET /table-metadata
Version: 5.1.41
Security: api_key

## Query parameters:

  - `ruleset_id` (integer)
    The ID of the ruleset to get all table metadata from

  - `page_number` (integer)
    The page number for which to get table metadata. This will default to the first page if excluded

  - `page_size` (integer)
    The maximum number of objects to return. This will default to the DefaultApiPageSize setting if not provided

  - `is_masked` (boolean)
    Get only masked table metadata when this is true, only unmasked column metadata when this is false and leaving this blank will get all tables

## Response 200 fields (application/json):

  - `_pageInfo` (object)

  - `_pageInfo.numberOnPage` (integer)
    The number of items on this page. This should always match the page size unless it is the last page.

  - `_pageInfo.total` (integer)
    The total number of items

  - `responseList` (array)
    Example: [{"tableName":"profile","rulesetId":1}]

  - `responseList.tableMetadataId` (integer)
    The ID of the table metadata. This field is set by the Masking Engine.

  - `responseList.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"

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

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

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

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

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

  - `responseList.isMasked` (boolean)
    This field is true if one or more data columns associated with this table have a masking assignment, and false otherwise. Results may be filtered by this field using the search API.

  - `responseList.rowCount` (integer)
    The last known row count of the table. This value is updated during rule set refresh and when a masking job is executed.

  - `responseList.lastRefreshTime` (string)
    The last time the table and column metadata for this rule set were refreshed.

  - `responseList.lastRowCountTime` (string)
    The last time table row counts for this rule set were fully refreshed.


## Response 400 fields

## Response 403 fields

## Response 404 fields