Forum Discussion

aby997's avatar
aby997
Copper Contributor
Sep 02, 2021

How to Search Video transcripts using Microsoft Search or any other Search API

We are looking for ways to search video transcripts for the recorded meeting videos stored in MS streams, one drive, videos stored within sharepoint folders etc. Search results should return timeline links to the video where the search keyword is being mentioned. Do we have any options to get this.or any suggestions

 

 

1 Reply

  • trevorharrisABMG's avatar
    trevorharrisABMG
    Copper Contributor
    May 22, 2023

    I know this is an old post but I couldn't find anything more recent. I wanted to say the Microsoft Search API does search Transcripts; however, in the API Response, it doesn't return the video file URL; it returns the 'hidden URL' of the transcript file itself, which is usually something like
    https://contosocompany.sharepoint.com/sites/marketing/Shared Documents/Forms?FormID=xxx

    wondering if anyone else has found a way to manipulate the search API headers or response so that it returns the URL of the video file itself?


    For example, if I POST the following to the Search API:

    {
    "requests": [
        {
            "entityTypes": [
                "driveItem"
            ],
            "query": {
                "queryString": "erla"
            }
        }
    ]
}

     
    I get something like this in the Response  (note the webURL returned):

    {
    "value": [
        {
            "searchTerms": [
                "erla"
            ],
            "hitsContainers": [
                {
                    "hits": [
                        {
                            "hitId": "01SSPF7JBTDLFZZEVMOFCIAZHBVFPCQ3UJ",
                            "rank": 1,
                            "summary": "<ddd/><c0>ERLA</c0> for John and bite, we would go to the <c0>ERLA</c0> borrower info, his buttons going to show <ddd/>",
                            "resource": {
                                "@odata.type": "#microsoft.graph.driveItem",
                                "size": 3850,
                                "fileSystemInfo": {
                                    "createdDateTime": "2023-04-10T13:47:10Z",
                                    "lastModifiedDateTime": "2023-05-19T15:56:49Z"
                                },
                                "listItem": {
                                    "@odata.type": "#microsoft.graph.listItem",
                                    "fields": {},
                                    "id": "9ccb1a33-ac92-4471-8064-e1a95e286e89"
                                },
                                "id": "01SSPF7JBTDLFZZEVMOLCIAZHBVFPCQ3UJ",
                                "createdBy": {
                                    "user": {
                                        "displayName": "Emily Robertson",
                                        "email": "email address removed for privacy reasons"
                                    }
                                },
                                "createdDateTime": "2023-04-10T13:47:10Z",
                                "lastModifiedBy": {
                                    "user": {
                                        "displayName": "SharePoint App"
                                    }
                                },
                                "lastModifiedDateTime": "2023-05-19T15:56:49Z",
                                "name": "Byte Bit - Adding or Removing.mp4",
                                "parentReference": {
                                    "driveId": "b!C0PSVS8R9kah0tiOIPRQ_6Ea4VgHFMZPr2XrzfQ0hpla1dEKVvL4Sow7A3NEXkgr",
                                    "id": "01SSPF7JDKXI2HP25BXJEIZ2HRDCNPIKVZ",
                                    "sharepointIds": {
                                        "listId": "0ad1d56b-f256-4af8-8c3b-0373445a482b",
                                        "listItemId": "174",
                                        "listItemUniqueId": "9ccb1a33-ac92-4471-8064-e1a95e286a89"
                                    },
                                    "siteId": "contoso.sharepoint.com,55d2430b-112f-46f6-a1d2-d88e20f450fe,58e11aa1-1407-4fc6-af65-ebcdf4348690"
                                },
                                "webUrl": "https://contoso.sharepoint.com/sites/BayTraining/Shared Documents/Forms/DispForm.aspx?ID=174"
                            }
                        }
                    ],
                    "total": 1,
                    "moreResultsAvailable": false
                }
            ]
        }
    ],
    "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#Collection(microsoft.graph.searchResponse)"
}

     

Resources