External API to trigger Qlik Replicate task

[chandraprakash_j_volvo]

Hello

Source : MS SQL Server (MS Replicate)

Target: Azure SQL Server

In source there are tables needs to gets truncated on daily basis. As replication is enabled on the source side truncate is getting blocked. So we disable the replication and do the truncate. Challenging part is truncate happens on different time for every table. So after truncate happens we will be notified. After that Full load hae to be done from the qlik replicate.

So my question here is:

1. After notification, can we use the external api to trigger the task in qlik replicate?

2. If above approach is possible,can we do Full load for particular table alone after each notification by using qlik? or external API?

[OritA]

Hi, 

QEM includes APIs that allow you to perform different actions in Replicate.
FYI - here is a link to the QEM documenation that lists the available options:
https://help.qlik.com/en-US/enterprise-manager/May2024/Content/EnterpriseManager/EnterpriseManager_A...

As of QEM 2024.5 it is also possible to use QEM API for reloading one specific table within a task (reloadTable API)  for further details please refer to the QEM user guide under: 
https://help.qlik.com/en-US/enterprise-manager/May2024/Content/EnterpriseManager/EnterpriseManager_A...

Regards,

Orit