Remove Document Using Azure Search Index Sink RRS feed

  • Question

  • I don't see 'Delete' as a supported WriteOperation on the Azure Search Index Sink (I only see Upload and Merge).  How would I go about removing documents from an index using data factory?  I was hoping to write a query which would return all items that need to be removed and push that through a data factory pipeline, but this doesn't seem to be supported through WriteOperations.  Is there another way to go about this via Data Factory?

    Thursday, September 28, 2017 3:09 PM

All replies

  • Delete is not a supported write operation for the Azure Search sink.  To remove documents from the index, you can look into using a few of the new features in ADF V2 Public Preview: (1) using lookup activity to get all items that need to be removed (https://docs.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity), and (2) using the Web activity to invoke a REST endpoint and implement a web service that performs the delete operation (see tutorial example here: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-control-flow#create-email-workflow-endpoints)

    Friday, September 29, 2017 2:48 PM