In this Azure tutorial, we will discuss how to fix the error Failed To Validate The Notification URL SharePoint Webhook Azure Function Endpoint, which I got while trying to subscribe to Azure Function to the SharePoint List with Webhook for the Azure Function Endpoint URL.
Table of Contents
Recently, I was working for a requirement where I had to update the Sentiment score in the SharePoint List using the Azure Text Analytics API. As part of the requirement, I have created the below stuffs.
- An Azure Text Analytics service in the Azure Portal.
- Created an Azure Function App (.NET Core) in the Azure Portal.
- I have also Created an HTTP triggered Azure Function using Visual Studio 2019 and deployed to Azure to the created Azure Function App.
- Created a SharePoint custom list in my SharePoint online Site with the required columns.
Now My Azure Function should respond to the SharePoint Webhook. So I was using the PowerShell SharePoint PnP cmdlets to interact with the Azure Function EndPoint URL.
Below was the PowerShell SharePoint PnP cmdlets that I was using here
PS C:\WINDOWS\system32> Connect-PnPOnline -Url https://tsinfo.sharepoint.com/sites/Raju/
Add-PnPWebhookSubscription -List SentimentList -NotificationUrl https://sentimentfunctionapp.azurewebsites.netYou can able to see below after executing the above cmdlets, we got the below error
The complete error message was as below
Add-PnPWebhookSubscription : {“odata.error”:{“code”:”-1,
System.InvalidOperationException”,”message”:{“lang”:”en-US”,”value”:”Failed to
validate the notification URL ‘https://sentimentfunctionapp.azurewebsites.net’.”}}}
At line:2 char:1
- Add-PnPWebhookSubscription -List SentimentList -NotificationUrl https …
~~~~~~~~~~~~~~~~~- CategoryInfo : WriteError: (:) [Add-PnPWebhookSubscription], Exception
- FullyQualifiedErrorId : EXCEPTION,SharePointPnP.PowerShell.Commands.Webhooks.Ad
dWebhookSubscription
To fix this issue, What I have done is wrongly, I was using the Azure Function App Endpoint URL, so only I was getting the error and SharePoint List Webhook fails to validate when using the Azure Function endpoint.
Now we need to follow the below steps to fix this issue.
Login to the Azure Portal (https://portal.azure.com/)
Navigate to the Azure Function App and then click on the Functions from the left navigation. Now you can able to see the list of Azure Functions inside your Azure Function App. Click on the one that you want to interact with SharePoint.
On the Azure Function page, click on the Code + Test link from the left navigation and then click on the Get Function URL button to copy the Azure Function URL. Click on the copy button as highlighted below to copy the Azure Function URL.
The Azure Function URL will look like below
https://sentimentfunctionapp.azurewebsites.net/api/FunctionSentiment?code=X7jt8XeMGK0fRCG2uJeC2nj0ewr8qqA52P4rkg7WTdglgf3RmqlIYQ==
Now the complete PowerShell SharePoint PnP cmdlets is as below
PS C:\WINDOWS\system32> Connect-PnPOnline -Url https://tsinfo.sharepoint.com/sites/Raju/
Add-PnPWebhookSubscription -List SentimentList -NotificationUrl https://sentimentfunctionapp.azurewebsites.net/api/FunctionSentiment?code=X7jt8XeMGK0fRCG2uJeC2nj0ewr8qqA52P4rkg7WTdglgf3RmqlIYQ==You can able to see below, we got the expected Output with out any issue this time
This is how you can fix the error Failed To Validate The Notification URL SharePoint Webhook Azure Function Endpoint.
You may also like following the below articles
- CS1061 C# ‘HttpRequest’ does not contain a definition for ‘Content’ and no accessible extension method ‘Content’ accepting a first argument of type ‘HttpRequest’ could be found
- Error While Redeploying The Azure Function System.Exception: Publishing failed
- The specified module ‘ADSync’ was not loaded because no valid module file was found in any module directory error
- The term ‘Login-AzureRmAccount’ is not recognized as the name of a cmdlet error
- No match was found for the specified search criteria and module name ‘MSOnline’
Wrapping Up
Well, In this article, We have discussed how to fix the error Failed To Validate The Notification URL SharePoint Webhook Azure Function Endpoint or Failed to validate notification URL. Hope this will help you to fix your issue as well !!!