Connect to ServiceNow via OAuth for copying table data in Microsoft Fabric

[Fr_msazr]

Hi Fabric Community,

I’m working on a scenario where I need to ingest data from several tables in ServiceNow into Microsoft Fabric (Lakehouse / pipelines).

However, the native ServiceNow connector in Microsoft Fabric / Data Factory seems to support only Basic Authentication at present. 

In my environment, using Basic Auth is not acceptable (security policies, credential management, rotation, etc.). We need to authenticate via OAuth 2.0 to ServiceNow to pull data.

So my questions / requests:

1. Does Microsoft Fabric (Data pipeline) support a ServiceNow connector with OAuth 2.0 authentication (rather than Basic)?

2. If the native connector does not currently support OAuth for ServiceNow, what is the recommended / best practice workaround?

3. Are there existing user cases, sample solutions, or community posts that implement OAuth with ServiceNow + Fabric that I could refer to?

I’d greatly appreciate any guidance, sample configurations, or pointers to Microsoft / community resources on this. Thanks in advance!

Best Regards!

[v-karpurapud]

Hi @Fr_msazr 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[Fr_msazr]

Hi @v-karpurapud ,

Thank you for the follow-up. I’ve reviewed the information and I’ll mark this as Solved. Unfortunately, I haven’t had the chance to implement and test it, as we decided to go with a different approach — exporting data from ServiceNow to an intermediate storage instead.

Thanks again for your support.

Best regards!

[v-karpurapud]

Hi @Fr_msazr 

Thank You for the Update.

[Fr_msazr]

Hi @suparnababu8 ,

Thank you very much for your response!

As you suggested, I will try the OAuth authentication via the HTTP connector  and see if that works in my scenario.

One additional question: if the HTTP connector (using OAuth) works, will I be able to download / fetch full table data (i.e. ServiceNow tables) using a CopyData activity? In other words, is it possible to ingest the table's content via HTTP + OAuth ?

If your suggestion works, I’ll be very happy to mark your post as the solution.

Thank you again for your help and guidance, I really appreciate it.

Kind regards!

[v-karpurapud · Accepted solution]

Hi @Fr_msazr 

Thank you for reaching out to the Microsoft Fabric Community Forum.
 

Yes  it is possible to pull full table data from ServiceNow into Microsoft Fabric using the HTTP connector with OAuth 2.0. While the native ServiceNow connector currently supports only Basic Authentication, the HTTP connector is a secure and flexible alternative. By calling the ServiceNow REST Table API and passing an OAuth bearer token in the request header, you can authenticate safely and retrieve table data in JSON format.

You can use this HTTP connection as the source in a Copy Data activity to load the results directly into your Lakehouse or Delta table. To get all records, just enable pagination with the parameters sysparm_limit and sysparm_offset, which let you fetch the data in batches. It’s also a good idea to handle rate limits and add retry logic in your pipeline for reliability.

With this setup, you will have a secure and automated way to ingest complete ServiceNow tables into Fabric without using Basic Auth.


For more information refer to the official document below:
Copy data from ServiceNow V2 - Azure Data Factory & Azure Synapse | Microsoft Learn

 

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.
 

[Fr_msazr]

Hi @v-karpurapud,

Thank you very much for the detailed explanation — this is really helpful!

Just to clarify, is there also a way to pull data from ServiceNow over HTTPS (for example, using the REST API directly with an HTTPS endpoint), or is the HTTP connector the only option currently supported in Fabric for this type of integration?

Thanks again for your support and guidance.

Best regards!

[v-karpurapud]

Hi @Fr_msazr 

Yes  you can securely pull data from ServiceNow over HTTPS. When you configure the HTTP connector in Microsoft Fabric and specify a ServiceNow REST API endpoint beginning with https://, all data communication automatically occurs over an encrypted HTTPS connection. This ensures that your data transfer fully complies with enterprise security standards.

At present, the HTTP connector is the only supported method in Fabric for connecting to ServiceNow using OAuth 2.0 or other token-based authentication methods. Through this connector, you can directly call ServiceNow’s REST API and include the required Authorization: Bearer <access_token> header to authenticate securely. Once connected, you can use the Copy Data activity to retrieve and load JSON data into your Lakehouse, Warehouse, or Delta table.

Regards,

Microsoft Fabric Community Support Team.

[suparnababu8]

Hello @Fr_msazr 

1. As of now Microsoft Fabric service now conenctor will support only Basic Authentication. Requesting you submit your requirement here Fabric Ideas - Microsoft Fabric Community If your requirement get enoough votes, Microsft brings this feature in future.
2. As a alternate, you may use REST API using HTTP conenctor in data factory with OAuth. or you may use Synapse notebooks to authenticate service now via OAuth.

Please go through below threads, it might helps you

HTTP connector overview - Microsoft Fabric | Microsoft Learn

Set up the ServiceNow service for Microsoft 365 Copilot connector ingestion | Microsoft Learn

Please let me know if it helps you/

Thank you!!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!