Abort the scheduled data import through Pre-script script.

[ankit19]

I need to abort the scheduled data import from Excel, based on checking headers of imported Excel sheet.

From Below script I'm able to get the headers name in system logs but cannot find a funtion which I can call inside the if(header1 != 'Allocation Logic') to abort the import submission.

[Sandeep Rajput]

@ankit19 Did you try the following?

current.setAbortAction(true);

[ankit19]

@Sandeep Rajput Thanks for your response.

I have tried below code, but didnt worked.

if(header1 == 'Allocation Logic'){
gs.info("headers from sheet header2" + header1);
current.setAbortAction(true);
}

Able to get the info msg in logs.

Thanks

[thomaskennedy]

cancel = true;

See https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/referen...

[ankit19]

@thomaskennedy  Thanks for your response.

I have tried below code, but didnt worked.

if(header1 == 'Allocation Logic'){
gs.info("headers from sheet header2" + header1);
cancel = true;
}

Able to get the info msg in logs.

Thanks