Uploading Entitlements using Schema-Based Upload via API

[Sahana_BB]

Hi Team,

We are trying to Import Entitlements through API and have an issue with running "File based Entitlement Import (SchemaEntitlementJob)" Job through API

I have this SAV file(ENTITLEMENT_VALUES.SAV)

FILE_NAME_STARTS_WITH=Entitlement_Values
SKIP_NO_OF_LINES=1
FILE_IMPORT_DELIMETER=,
#EMAILTEMPLATE="Email Template Name"
CREATE_SECURITYSYSTEM_IF_NOT_EXIST=NOACTION
CREATE_ENDPOINT_IF_NOT_EXIST_IN_SECURITYSYSTEM=NOACTION
CREATE_ENTITLEMENTTYPE_IF_NOT_EXIST_IN_ENDPOINT=CREATE
ENTITLEMENT_VALUES_NOT_IN_FILE_ACTION=NOACTION
#ENTITLEMENT_VALUES_NOT_IN_FILE_ACTION=INACTIVE
securitysystems,endpoints,entitlementtype,entitlement_value,description,customproperty1,customproperty2,customproperty3,owner,rank,status

Similarly, the data file is as follows (Entitlement_Values.csv):

The SAV and data files are loaded to the corresponding directories on the UI /Datafiles and /SAV through API-Postman

When the schema based Entitlement import job is run  through API with the below configuration:

The result through API says 200 Ok with the message: Starting job

But the job history shows the below error:

Even though the job ended with error, the data file (.csv) is still in the Datafiles folder instead of being moved to the /Fail folder.

But if the same Job is run through UI > Job Control Panel, the datafile(.csv) is moved to Success folder and everything works as expected. 

Is something wrong with the API body?

Thanks, Sahana

[rushikeshvartak]

Can you share screenshot of files uploaded in Datafiles & sav location

trying changing

FILE_NAME_STARTS_WITH=Entitlement_Values.sav

[Sahana_BB]

Hi Rushikesh,

Thanks for replying:)

Changed the sav file name to Entitlement_Values.sav and tested it, same issue Job fails when its run through API and csv file stays in /Datafiles itself instead of moving to /success

Can you please verify and help in figuring out this issue?

[rushikeshvartak]

Please share logs after running job. Or try running job from saviynt first then go with API

[Sahana_BB]

Hi Rushikesh,

Thanks for replying!

If Job is run from saviynt it works perfectly, the issue is if the same job is run from API it fails. For our use case we want the job to run successfully from API.

Attaching the logs after running Job through API..