Qlik Enterprise Manager API .

[VINAY98]

Hi Team,

I want to extract the details of count, number of records being updated, deleted & inserted  during CDC task of a particular table through Qlik enterprise Manager API.

Can anyone help me on the above.

Thanks & Regards,

Vinay

[Steve_Nguyen]

the API does not connect those information.

for the API , from user guider only have :

• Viewing a list of tasks for a server
• Viewing details for a particular task
• Stopping a task
• Running a task
• Exporting all definitions from the requested server repository on the selected server
• Importing the JSON definitions provided in the request body into the requested server repository on the selected server
• Reloading a table
• Exporting a task
• Importing a task
• Testing an endpoint's connectivity and configuration

https://help.qlik.com/en-US/enterprise-manager/November2022/Content/EnterpriseManager/EnterpriseMana...

====

what you looking could be from the Analytic 

see https://help.qlik.com/en-US/enterprise-manager/November2022/Content/EnterpriseManager/Main/Analytics...

[Heinvandenheuvel]

The Enterprise Manager API function  GetTableStatuses delivers the data you seem to request.

"table_cdc_info":{
   "insert_count":"{int64}",
   "update_count":"{int64}",
   "delete_count":"{int64}",
   "ddl_count":"{int64}",
   "last_update_time":"{string}",

One typically calls this in a timed loop - once an hour, once a day or similar. Please do note that this information is dynamic and will disappear when the task is stopped and resumed. One might want to ensure a final data collection run just before the task is stopped but you can never get it 'exact'.

If you need this data for auditing purposes you may want to add CHANGE TABLES to you task. You can interrogate and summarize those tables on a regular basis and purge once done.

Another alternative for BATCH_APPLY tasks is to run the tasks with LOGGING for TARGET_APPLY set to DEBUG and go spelunking in the reptask logs.

Enjoy,

Hein.

[VINAY98]

Hi Steve_Nguyen,

Thanks for the solution. But I want to do it in Qlik Enterprise Manager python API.

I had worked on it and got the solution.

Thanks & Regards,

Vinay Kumar Bareth