ServiceNow API connection to Azure Synapse Analytics

Del4
Tera Contributor

Hi all,

 

Im looking for some advice please. We are trying to connect our ServiceNow instance with Azure Synapse Analytics. We have created a user within the SN instance and added the following roles:

 

  • personalize_dictionary
  • itil
  • rest_api_explorer
    _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
  • web_service_admin

 

However, with these 3 roles we're getting the following error: HTTP Response code 403. If we add web_service_admin - we then get a HTTP Response code of 400. (As soon as we add the admin role to this user, the connection works fine)

 

Can anyone shade any light as to what role we are missing so we can remove the admin role as it doesnt state the roles required within this article: Copy data from ServiceNow - Azure Data Factory & Azure Synapse | Microsoft Learn

 

Many thanks

Del.

0 REPLIES 0