What's the record limit for the Import Set API's insertMultiple method?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2023 06:47 AM
Hi,
Question is in the title, basically. I need to import a large number of records and process them via import sets, transform maps, and so on.
I'm using the insertMultiple endpoint to achieve this, but I was wondering about the recommended number of records per operation. The docs (insertMultiple) suggest using 200 records per operation, and gradually increasing while watching instance performance.
If anyone has experience with importing a large number of records via insertMultiple, I'd be glad to hear if the 200 record number is a realistic maximum, or what number you're using.
Thanks in advance,
Max
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-11-2023 07:19 AM
Hi @Max Nowak ,
As per the docs its 200, as you said.
So the recommended approach should be doing it in chunks.
You can refer to this solution: https://www.servicenow.com/community/developer-forum/inserting-multiple-rows-with-a-single-import-se...