Servicenow Integartion.

[Black Coder]

I have a requirement in ServiceNow to export incident data as CSV files and upload them to an Amazon S3 bucket. Specifically, we need to export 900,000 incidents by breaking them into smaller chunk files.

Additionally, we need to perform incremental exports to capture and send updated incident details every 15 minutes.

Could you please provide guidance on how to achieve the incremental export as CSV files and automate the process to send updated incidents to the S3 bucket every 15 minutes?

[Community Alums]

Hi @Black Coder ,

The general approach would involve 3 steps-

Step 1: Script Include for batched export
Step 2: Script Include for uploading CSV data to AWS S3
Step 3: Scheduled Script to export the data at the regular interval of 15 mins.

For one time upload you can do the same thing by limiting the records and have a field to check if the record was uploaded or not(once record is eligible for batched export mark it true)

Also you can have a approach of creating events and using a script action to upload the data(You need to use the above script includes)

If my response has resolved your query, please consider giving it a thumbs up ‌‌ and marking it as the correct answer‌‌!

Thanks & Regards,

Sanjay Kumar