Import Set API Timeout – Partial Data Handling in ServiceNow

[HarikrishnaA]

Hi Community,

I attempted to import 50,000 records into ServiceNow using the Import Set API (multi-insert). However, the API call timed out before completing, and I did not receive an import_set ID in the response.

Upon checking the sys_import_set table, I noticed that a corresponding import set record was created, but its state remains "Loading" and does not transition to "Cancelled" or "Ready."

My question is:
If the payload was only partially uploaded due to the timeout, will ServiceNow eventually process the data? Or will the import set remain in the "Loading" state indefinitely?

I’d appreciate any insights into what happens in such scenarios and how best to handle them.

Thank you!

[Maik Skoddow]

Hi @HarikrishnaA 

unfortunately, it's not clear what you mean.

1. Have you performed an outbound request to pull the data from an external data source? In that case the so-called Transaction Quota rules might have stopped importing. See https://www.servicenow.com/docs/csh?topicname=c_TransactionQuotas.html&version=latest for more information.
2. Has any external client tried to send the data to your ServiceNow instance? Also, here the will have an impact. But also check the following KB article: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0996698 

Maik