Related to large numbers of record in JSON file

Aman66
Tera Contributor

‎01-10-2023 08:04 AM - edited ‎01-10-2023 08:06 AM

Hi All ,

@Ankur Bawiskar @Saurav11 @Mark Roethof @Chuck Tomasi @ Amit Gujarathi @RaghavSh @SanjivMeher

 

My requirement  is to i have a Large number of data records( around 20-30k) in JSON file. there is any possibility to POST the data from Postman to ServiceNow without using any middleware . using some scripted rest API or anything else .

when i am using without middleware i have get only 3k records 

 

Please help me if you have any solution .

0 Helpfuls
  • 429 Views
1 REPLY 1

Tony Chatfield1
Kilo Patron

‎01-10-2023 12:52 PM

Hi, processing of large numbers of records in 1 payload has the potential to cause performance issues and I would not recommend it.
There is a max payload size that cannot be exceeded, and this may be the reason why you cannot post more than 3k files at once.
Controlling maximum request size (servicenow.com)

Scripted REST API is used to process payloads to the target 'endpoint' table, this allows preprocessing of data but may increase the instance response time for the payload, and it would not alter any issues you encounter with payload size.
If the max payload size is being exceeded, I would look at pagination\breakdown to smaller payloads at source.

0 Helpfuls