Create an indexer for Azure Search service index from blob storage (Json Array data) with Native blob soft delete

Question

Hi There,

We are building a public facing website using Azure Search Service to look up for data.

Our data is in CRM and we use power automate to copy day into azure storage table. And a scheduled indexer to feed data into the Search Index. However, it doesn't support document deletion.

As per the documentation there are two ways to deal with document deletion.

1. Native blob soft delete (preview), applies to Blob Storage only
2. Soft delete using custom metadata

We cannot go with the second approach because our Power Automate workflow runs every 24hrs, deletes all the entries from azure storage table inserts data again.

We are trying the first approach. However, when creating an indexer it throws error saying "This indexer uses 'NativeBlobSoftDeleteDetectionPolicy' which is not compatible with one-to-many parsing mode. Use a different type of deletion detection policy"
Data stored in blob is of Json Array format. Ex: [{"id": ""something", "name": "name1"}]

How do we fix this?

Regards,

Prasanth.

Answer 1

Hi there A_PONNAP

Thanks for using QandA platform

Try adjusting your indexing setup. 'NativeBlobSoftDeleteDetectionPolicy' is incompatible with one-to-many parsing mode, this is used when processing multiple documents within a single blob, like your JSON . either store each document as an individual blob or switch to Batch parsing mode in your indexer, allowing multiple documents within a blob to be processed.

If this helps kindly accept the answer thanks much.