Unable to create an Indexer to Index SharePoint data in Search Service

Derek D 10

Per this guide, - https://learn.microsoft.com/en-us/azure/search/search-howto-index-sharepoint-online

the process to setup a SharePoint Indexer in Cognitive Search/Search Service is to send a POST request to create it. It then waits for up to 10 minutes for you to authenticate. Next step is to get the Status with a GET request. This should return a microsoft.com/devicelogin link and Code. You enter the code in, it authenticates everything and creates the Indexer.

This part of the process does not work for me. I enter the code, but my POST request never stops spinning and therefore the Indexer is not created. If I re-run it, it generates a new Code, but that doesn't work either.

Basically, my POST request never gets authenticated with this Device Code.

brtrach-MSFT 16,121 Reputation points Microsoft Employee

2023-12-07T20:01:10.48+00:00

@Derek D Please let us know if the below answer was helpful by accepting it as the answer. If you have further questions or concerns, reply to this message and we will assist you further.
Stefano Accardo 0 Reputation points

2024-01-18T16:40:17.0633333+00:00

Is this fixed? As of today, I still experience this error.

Vishal Thakur 5

POST:

POST: https://{{AZURE_SEARCH_SERVICE_NAME}}.search.windows.net/indexers?api-version=2023-10-01-Preview

BODY

{
    "name" : "sharepoint-indexer",
    "dataSourceName" : "sharepoint-datasource",
    "targetIndexName" : "sharepoint-index",
    "parameters": {
    "batchSize": null,
    "maxFailedItems": null,
    "maxFailedItemsPerBatch": null,
    "base64EncodeKeys": null,
    "configuration": {
        "indexedFileNameExtensions" : ".pdf, .docx",
        "excludedFileNameExtensions" : ".png, .jpg",
        "dataToExtract": "contentAndMetadata"
      }
    },
    "schedule" : { },
    "fieldMappings" : [
        { 
          "sourceFieldName" : "metadata_spo_site_library_item_id", 
          "targetFieldName" : "id", 
          "mappingFunction" : { 
            "name" : "base64Encode" 
          } 
         }
    ]
}

ERROR:

{
    "error": {
        "code": "",
        "message": "Error with data source: Unexpected keyword 'n' in query property.  Please adjust your data source definition in order to proceed."
    }
}

1 answer

brtrach-MSFT 16,121 Reputation points Microsoft Employee

2023-11-09T22:54:37.31+00:00

@Derek D Based on the document you provided, it looks like you are following the correct steps to create an Indexer. However, it seems like you are having trouble authenticating your POST request with the device code.

Have you tried checking the status of the indexer after entering the code? The document mentions that you should check the indexer status after entering the code. If the last indexer run has an error telling you to go to https://microsoft.com/devicelogin, go to that page and provide the new code.

If you are still having trouble, could you please provide me with more information about the error message you are receiving? This will help me better understand the issue and provide you with a more accurate solution.
Please sign in to rate this answer.
Derek D 10 Reputation points

2023-12-08T17:20:51.3733333+00:00

I have tried this many times. It hangs at the Status window for 10 minutes. Anytime a new /devicelogin code is generated, I see it, try it, it does not work. I have re-created this scenario many times.

brtrach-MSFT 16,121 Reputation points Microsoft Employee

2023-12-09T00:45:03.84+00:00

I think the next step is to have you reach out to us. Can you please send an email to azcommunity@microsoft.com with the subject as ATTN: Bryan and in the body of the email please include your Azure subscription ID.

We look forward to hearing from you.

K.Seastream 30 Reputation points

2023-12-14T08:58:45.7933333+00:00

I´m having the same problem. Followed the guide and when I try to create the indexer (using Postman) and run the GET command, I get the code and enter it in https://microsoft.com/devicelogin but no indexer is created. Sometimes Postman gets a response saying ”Error with data source: AADSTS70020: The provided value for the input parameter 'device_code' is not valid. This device code has expired.” but I have entered the code within 10 min. I also tried creating an indexer using the webinterface in Azure, but it never gets saved, it tries to save but seems to timeout or something.

Robert 0 Reputation points

2024-08-22T00:00:58.52+00:00

Check your data source, I had the exact same problem. Make sure the data source is created correctly (Website is correct, App Id is correct, TenantId is correct , etc).

Veena Srikanth Urs 0 Reputation points

2024-09-18T14:41:00.23+00:00

even after successful authentication, indexer not created
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Unable to create an Indexer to Index SharePoint data in Search Service

1 answer

Your answer