This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
We are using ServiceNow connector as (linked object) as source and pulling the data into our database. If we have limited data, we are able to retrieve and copy. But if we have larger data more than 300 rows, we are seeing error code 2200 and 401 error.
The 401 received is:
{
"errorCode": "2200",
"message": "Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ServiceNow] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 401,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ServiceNow] (60) API Connection Failed (Unauthorized Access). Check credentials. HTTP Response code: 401,Source=ServiceNowODBCPlugin_sb64.dll,'",
"failureType": "UserError",
"target": "3-LOAD-LANDING",
"details": []
}
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Hello @Ravindra Sunkaranam ,
Welcome to the MS Q&A platform.
As per the 401 error, the servicenow is rejecting the API call due to unauthorized access. Can you please confirm if you are using the endpoint with "http://" so the format is http://<instance>.service-now.com and the authentication are Basic, OAuth2?
document: https://learn.microsoft.com/en-us/azure/data-factory/connector-servicenow?tabs=data-factory
I was using https://<instance name>.service-now.com and basic authentication. Actually, I am a ServiceNow developer, and one of our customers is using Azure Data Factory. For their environment, they are seeing a 401 error. and within my environment, I am able to pull the data without any errors.
Hello @Ravindra Sunkaranam ,
Thank you for the reply and for providing more details.
As I mentioned, the ServiceNow is rejecting the API call due to unauthorized access(could be an issue with the credentials)
Can you please check the credentials that are being used to access the ServiceNow API? Also, please test using Postman to see if the issue is with the connection.
I hope this helps.
What should I test with Postman? When we copy data, how do we know that the rest of the API call is made to ServiceNow?
If it is the problem with credentials, we shouldn't get even top 10 or top 100 results. And with the same credentials, we are able to fetch data from ServiceNow.
Hello @Ravindra Sunkaranam ,
Thanks for the reply. The issue you are facing is strange. As you can copy when the data set is small.
Since you see the issue when copying more than 300 rows, there could be an issue with the network preventing the connector from reaching the ServiceNow API. Please run the Wireshark tool and see if you see anything.
If the network trace didn't help, I suggest filing a support request, and a support engineer can take a deeper look to troubleshoot the issue further. If you don't have a support plan, I can enable one-time free support for you to work closely on this matter.
I am looking forward to hearing from you.