Advice Needed: Efficiently Importing Bulk OT Assets into ServiceNow CMDB

[furui]

Hi everyone,

If this question has been addressed before, please feel free to redirect me to the relevant post.

I am working on a ServiceNow integration for our product, which generates a substantial list of OT assets. My goal is to import these assets into ServiceNow's CMDB, either through a manual trigger or on a scheduled basis.

However, I’m finding the array of available ServiceNow APIs and integration methods a bit overwhelming. My main requirement is to ensure the client does not need to take additional actions within ServiceNow or create custom apps for their App Store.

Here are the options I’ve explored so far:

1. Instance API

   • Seems to fit the use case but appears inefficient for bulk imports, as it only supports one record per request.
   • I’d likely use Basic Auth or another supported method, depending on whether the export is recurring.
   • Is there a way to enable multi-insert functionality with this API that I might have overlooked?

2. Import Sets (Multiple Insert)

   • This allows bulk data to be added to a staging table, but it requires the client to take additional steps, which I want to avoid.

3. Integration Hub

   • Requires an additional subscription, which adds complexity and cost for the client.
   • Seems overkill for this use case.

4. ServiceNow DataStream/ServiceGraph

   • Requires building and publishing an app on the ServiceNow App Store, which isn’t ideal for this scenario.
   • Better suited for larger payloads (>10 MB), whereas our payloads are below this limit and could work with normal REST APIs.

My Question:
Is there a ServiceNow API or method I might have missed that supports sending multiple records to the CMDB in a single operation?

If not, I’m considering sending numerous single POST requests and then updating them as necessary. While this approach works, it feels inefficient, and I suspect there must be a better solution. Alternatively, I could explore using SOAP APIs since they seem to support bulk inserts.

Any guidance or recommendations would be greatly appreciated!

[CJB]

Did you ever get this figured out?

[CJB]

I thought it was strange as well!