# Get the tables or files of a hyperscale dataset

Endpoint: GET /hyperscale-datasets/{hyperscaleDatasetId}/tables-or-files
Version: 3.15.0
Security: ApiKeyAuth

## Security:

  - `ApiKeyAuth` (unknown)
    apiKey in header Authorization

## Path parameters:

  - `hyperscaleDatasetId` (string, required)
    The ID of the Hyperscale Dataset.

## Query parameters:

  - `limit` (integer)
    Maximum number of objects to return per query. The value must be between 1 and 1000. Default is 100.

  - `cursor` (string)
    Cursor to fetch the next or previous page of results. The value of this property must be extracted from the 'prev_cursor' or 'next_cursor' property of a PaginatedResponseMetadata which is contained in the response of list and search API endpoints.

  - `sort` (string)
    The field to sort results by. A property name with a prepended '-' signifies descending order.

## Response 200:

  - `200` (unknown)
    OK

## Response 200 fields (application/json):

  - `items` (array)

  - `items.id` (string)
    The ID of the Hyperscale Dataset table or file.

  - `items.schema_name` (string)
    Name of the table schema (Oracle/MSSql only).

  - `items.table_name` (string)
    Name of the table (Oracle/MSSql only).

  - `items.collection_name` (string)
    Name of the collection (MongoDB only).

  - `items.database_name` (string)
    Name of the database (MongoDB only).

  - `items.filter_key` (string)
    The unique database column field to filter the source data.

  - `items.column_array_rows` (integer)
    The number of column array rows to be used by the sqlldr oracle utility which determines the number of rows loaded before the stream buffer is built.

  - `items.unload_split` (integer)
    The number of unloaded files to be generated from the source database.

  - `items.stream_size` (integer)
    Long The stream size to be used by the sqlldr oracle utility which specifies the size (in bytes) of the data stream sent from the client to the server.

  - `items.end_of_record` (string)
    The end of line character. Support values are \n, \r  and \r\n (Delimited files only).

  - `items.delimiter` (string)
    The single character length delimiter used in source files (Delimited files only).

  - `items.enclosure` (string)
    The single character length quote character used in the source files (Delimited files only).

  - `items.enclosure_escape_character` (string)
    The escape character used to escape quote characters (Delimited files only).

  - `items.escape_enclosure_escape_character` (boolean)
    Whether to escape the enclosure escape character (Delimited files only).

  - `items.has_headers` (boolean)
    Whether source files have header column names or not (Delimited files only). If set to true, format files with the same column names are created and the same can be used for the masking inventory. If set to false, the column names of pattern f0, f1, f2, and so on are used to create the format files for delimited file masking.

  - `items.unique_source_files_identifier` (string)
    This is the source key that maps the load-service and masking-service data sets with the unload-service data set (Delimited files only). Please ensure that this value is different for each HyperscaleDatasetTableOrFile.

  - `items.source_files` (array)
    List of all source files that need to be masked (Delimited files only). All files should have the same delimiter character and other helper characters. All files should have the same number of columns and same column names if it has a header line.

  - `items.perform_join` (boolean)
    Whether the split files must be joined (Delimited files only).

  - `items.masking_inventory` (array)
    DataSet information for masking inventory.

  - `items.masking_inventory.field_name` (string)
    Name of the field.

  - `items.masking_inventory.domain_name` (string)
    The name of the domain assigned to this field.

  - `items.masking_inventory.algorithm_name` (string)
    The name of the algorithm assigned to this field.

  - `items.masking_inventory.date_format` (string)
    The format of the date assigned to this field.

  - `items.masking_inventory.algorithm_field_name` (string)
    The name of the algorithm field that is associated with this algorithm.

  - `items.masking_inventory.algorithm_group_no` (integer)
    The group number of the algorithm to identify a set of columns associated with one instance of algorithm.

  - `response_metadata` (object)

  - `response_metadata.prev_cursor` (string)
    Pointer to the previous page of results. Use this value as a cursor query parameter in a subsequent request, along with limit, to navigate through the collection by virtual page.

  - `response_metadata.next_cursor` (string)
    Pointer to the next page of results. Use this value as a cursor query parameter in a subsequent request, along with limit, to navigate through the collection by virtual page.

  - `response_metadata.total` (integer)
    The total number of results. This value may not be provided.

