topic Re: QEM Python API to get table details in task. in Qlik Replicate

QEM Python API to get table details in task.

vchilakamarthi — Tue, 28 Nov 2023 20:45:39 GMT

Hello,

Exporting the current replicate task from QEM would give me a JSON that has table manipulation settings.

It has the following info.

manipulations": [{

"name": "SOURCE_OWNER.TABLE_NAME",

"table_manipulation": {

"owner": "SOURCE_OWNER",

"name": "SOURCE_TABLE_NAME",

"new_table_name": "TARGET_TABLE_NAME",

"new_owner_name": "TARGET_OWNER",

That gives me access to source/target table details and also the column mapping.

Which API could give me this information ?

I don't see get_task_details or get_tables return this info.

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/api_getTaskDetails.htm

Also which api can give me STORE_CHANGE_SETTINGS of a given task.

Re: QEM Python API to get table details in task.

Heinvandenheuvel — Tue, 28 Nov 2023 21:01:10 GMT

What about the GetTableStatus call. It returns an array with :

{ "table_details":[ { "schema_on_source":"{string}", "table_on_source":"{string}", "schema_on_target":"{string}", "table_on_target":"{string}", :

No columns mapping but the manipulation JSON will only show you those columns which are manipulated.

For full table and column information only REPCTL dumpmetadata can help you.

>> Also which api can give me STORE_CHANGE_SETTINGS of a given task.

You'll have to EXPORT the task look for the store change line to see if it is there. I believe the task_setting parameter is common_settings.save_changes_enabled, Absence = default = off.

But don't take my word for it. Take a test task, export once with and once without store change and DIFF

Hein.

Re: QEM Python API to get table details in task.

vchilakamarthi — Tue, 28 Nov 2023 21:03:43 GMT

Thank you let me test it out and see what I get.

Re: QEM Python API to get table details in task.

vchilakamarthi — Wed, 29 Nov 2023 05:12:27 GMT

Ok, what I need is found in two different places.

1. If store_change_settings on a task is enabled

get_task_details - store_changes_enabled (boolean)

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/api_getTaskDetails.htm

2. Get source and target table names and their owners in a given QLIK replicate task (like you suggested above already) using get_table_statuses

https://help.qlik.com/en-US/enterprise-manager/May2023/Content/EnterpriseManager/EnterpriseManager_APIGuide/PythonAPI/api_gettablestatuses.htm

Thsi is good ...thank you for your time.