Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

importBulkData : DeleteOnLoadFailure= Y

in ERP Integrations 4 comments

Summary:

Issue with DeleteOnLoadFailure= Y when calling importBulkData REST API

Content (required):

Hi Guys

I have just noticed today when calling importBulkData  that the "Load Interface File for Import" job has these rows in the log:

************************************************************************************

InterfaceTableNames= GL_INTERFACE

DeleteOnLoadFailure= Y

------------------------------ 

Adding Statement : DELETE FROM GL_INTERFACE WHERE LOAD_REQUEST_ID=XYZ

************************************************************************************

But, in my API call I have set the JobOptions as follows with PurgeOption=N, so why are the entries being deleted from the GL_INTERFACE table? I need them to remain in there!

How can I ensure this happens?

"JobOptions":"ValidationOption=Y,InterfaceDetails=15,EnableEvent=Y,ImportOption=Y,PurgeOption=N,ExtractFileType=ALL",

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!