REST API Limitations

[danroga]

Is there a limit on how many records can be uploaded into ServiceNow via the REST API? I'm using a camel microservice to upload records into tables, and I get inconsistent results with serviceNow throwing different errors, like throwing an authentication error on record 2600, but the next time, it takes them all. Possibly a security check only allowing so many updates in so much time?

thanks!

[Brad Tilton]

We did introduce REST API Limiting in London, but I believe you have to turn that on. There is also a limit based on the number of REST calls an instance can process at once. If all of the semaphores are full it could fill up the queue and start dropping calls. 

I think to properly troubleshoot this for you we'd need more details around the errors you're seeing, what kind of data you're importing, and how long it's taking.

[danroga]

Hi Brad, sorry for the delay in response. I have to run some of these jobs which take a while before failure. I don't believe there is any limiting put in place, but if you can tell me where to look, I'll verify that. 

The last test, ran for about 25-30 minutes, sent in 3488 records before it threw the following error

javax.ws.rs.ProcessingException: java.net.ConnectException: ConnectException invoking https://dirsharedservicesdev.service-now.com/api/now/table/u_swc_poe?sysparm_display_value=false&sysparm_exclude_reference_link=false&sysparm_input_display_value=false&sysparm_suppress_auto_sys_field=false: Connection timed out: connect

It will sometimes report an authentication error even though that part is repeated over and over with no issues. Sometimes it won't allow a very large file upload, like 140MB will timeout. We've run tests and seen where its input 26,000 records in about 100 minutes, and didn't fail, but now we are consistently seeing failures. 

-Thanks

-Dan R.