get_table_list

Retrieves the list of tables of a specific Replicate task that matches the specified state(s), table schema(s), and table name(s). This is useful for automation processes, for example, as it allows you to retrieve tables in a certain state (e.g. suspended) and then perform an operation on them (e.g. ReloadTable).

Required User Role: See Required Enterprise Manager permissions.

Syntax

def get_table_list(

self,

server,

task,

schema = None,

table = None,

includequeued = False,

includeloading = False,

includecompleted = False,

includechangeprocessing = False,

includeerror = False):

""" response payload: AemGetTableListResp

Parameters

Parameters
Value	Type	Description
server	string	The Replicate Server name as defined on Qlik Enterprise Manager. Example: myrepsrv1
schema	string	The default is all source schemas. Specifying a specific schema name will retrieve all tables from the specified schema. Specifying a pattern will retrieve all tables from schemas that match the pattern. For example, specifying ad* will retrieve tables from the adventure and adventuretwo schemas.
table	string	The default is all source tables. Specifying a specific table name will retrieve the specified table. Specifying a pattern will retrieve all tables that match the pattern. For example, specifying em* will retrieve the employees and employed tables.
includequeued	boolean	Whether to retrieve tables in a queued state.
includeloading	boolean	Whether to retrieve tables in a loading state.
includecompleted	boolean	Whether to retrieve tables in a completed state.
includechangeprocessing	boolean	Whether to retrieve tables in a Change Processing state (that is, tables that are having changes applied to them).
includeerror	boolean	Whether to retrieve tables in an error state.

Return values

AemGetTableListResp

Return values
Value	Type	Description
TableList	List	List of tables that matches the specified input parameters.
schema	string	The name of the schema.
table	string	The name of the table.
state	enum	The current state of the table.

Errors

All of the general errors as well as the errors listed in the table below.

Error responses
Error	Message	Description
AEM_TABLE_LIST_INNER_ERR	Failed to retrieve table list for replication task "{task}" on server "{server}". Error: "{message}"	Returned when the table list cannot be retrieved.
AEM_TASK_NOT_FOUND	Replicate task {task} on server {server} could not be found.	The task name is unknown to Enterprise Manager.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here