ServiceNow API connection to Azure Synapse Analytics

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2023 08:21 AM - edited 02-08-2023 08:44 AM
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.