How to configure a delete flow in an automation

[Ionut_Dumitrascu]

The simplest way to create a delete flow in an automation is to use a list block together with a delete by id block. This will loop through the list and delete the items one by one. 

However,  depending on the type of paging APIs are using, this flow can actually skip entire pages of data when deleting. To avoid this, you need to first load all the items in memory before actually deleting them.

The simplest way of doing this is to do a 'count' of the list first. To do this, Add an 'Output' block in which you can configure a formula to count the items in the list.

This will load all the data from the list in memory. Now, you need to use a 'Loop' block together with a 'Delete by id' block, in order to delete every item from the list.

Please note the CDP is a feature only available in the Qlik Application Automation OEM environments. The above information however applies to all cloud tools. 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.