text-analytics-api

Can Microsoft Cognitive Services analyze Microsoft Office documents?


I'd like to do a key phrase analysis of a Microsoft Word document. It looks like the API only takes JSON documents. Is there a route to use real life documents like Microsoft Office documents?


Solution

  • A recent hackathon project, Resolving Managed Metadata Madness in SharePoint, answers this question.

    The developer of that project used a three step process involving custom code. An Azure Function was written to extract the text to pass to the API. The function returns the results of the analysis back to Microsoft Flow.

    1. A Flow attached to Document Library will call the Azure Function that’ll do the heavy lifting
    2. An Azure Function will run, extract text, analyze it using Azure Cognitive Services, and then write the info back to SharePoint Online
    3. Finally, notifies admin of the execution and the creator of the file.