azure cognitive search - dynamically adding blobs for azure search rest api

78 Views Asked by At

I have multiple containers with blobs(.xlsx format) in it, how can I use one azure search service so that on each rest api call I can get sum of count of a column from each blob or all blobs ...

1

There are 1 best solutions below

0
Gia Mondragon - MSFT On BEST ANSWER

There is not an out-of-the-box way to do this.

A few suggestions:

  1. If you are reading blobs using the Azure blob SDK (not using built-in indexers), you would have to extract the Excel data and compute the count (examples of how to get the Excel data with .NET are here)

  2. If you are using pull blob indexers you can either:

Here is a repo of Power Skills (custom skills applied to different use cases) in case you need examples of how to use them and the skillset official documentation