what are the best way to import when lakhs of records are involved ??

[Manikantahere]

when it comes large data system performance should be considered right so how to manage large amount of data to import?

[Anand Kumar P]

Hi @Manikantahere ,

Create an event in ServiceNow (e.g., data.pull.initiate). Trigger this event in a script using gs.eventQueue, which will activate the data-pull process. Define a Script Action for the event to run when triggered. In the Script Action, use RESTMessageV2 to call the external API and pull data. Parse and insert the data into ServiceNow, handling large responses in batches if needed. Go through below link for more info 

https://www.servicenow.com/community/now-platform-articles/how-to-import-4-million-records-in-3-hour...

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

[Manikantahere]

how to do batching in rest call?

what if excel having one lakhs records need to import them in batch wise?  

pls let me know if possible.