Bulk Deleting Flow Data

Overview

This Example Lab project demonstrates how to bulk delete Flow data stored in the WorkFlow.

Explanation

This project contains a Flow that uses the Get All step in order to obtain a list of Flow data from the WorkFlow. The output data from the Get All step is then passed into a ForEach Step. The ForEach step then iterates through each item in the list and deletes it. Each item is deleted by using the Raw SQL Step. The Raw SQL Step contains the command "delete FROM flow_state_storage_data where flow_tracking_id='Item.primary_flow_tracking_id'" which deletes each item run through the ForEach step.

Project Download