Import accounts, entitlements and act-ent mapping using Upload New File API

[Adithya]

Hi Saviynt Team,

Hope you’re doing well!

We do have a requirement where application team will be using Saviynt APIs to push file into Saviynt DataFiles folder to perform import (accounts, ent and act-ent mapping) a daily basis and for provisioning and deprovisioning we will be using snow ticket. It is a disconnected application.

When I was going through other forum questions. I found something but need some clarity on this.

Q1> As a first step to import the data using Upload New File API, should we set below in externalConfig.properties in Saviynt Server?

1. job.ecm.imp.file.path=/saviynt_shared/saviynt/Import/Datafiles/
2. job.ecm.savfile.path=/saviynt_shared//saviynt/Import/SAV/
3. job.ecm.imp.file.importprocess.path=/saviynt_shared/saviynt/Import/Process/

Q2> After that should we use corresponding paths in place of path in the API URL for Postman testing?

Q3> As we will be using 1. File based Accounts Import (SchemaAccountJob) 2. File based Entitlement Import (SchemaEntitlementJob) to process .csv file. Do we need to create a new connection for import add it security system?

Appreciate your response at the earliest. Thanks.

[sk]

@Adithya : 

Q.1 : Not required

Q.2: Path in url is api/v5 for SSM version 5.2 and above which is mentioned on Introduction page of API documentation

Q.3: If you are using Application Onboarding Feature then it will automatically create the connection based on sav file configuration

[rushikeshvartak · Accepted solution]

• Q1> As a first step to import the data using Upload New File API, should we set below in externalConfig.properties in Saviynt Server? - Its not required to set path those are set by default

• Q2> After that should we use corresponding paths in place of path in the API URL for Postman testing?

  Below will be API Request

• 
•  As we will be using 1. File based Accounts Import (SchemaAccountJob) 2. File based Entitlement Import (SchemaEntitlementJob) to process .csv file. Do we need to create a new connection for import add it security system? ---> You can use existing connection and update naming convention and existing job can be used. from v23.10 you can create separate job & select which sav file to process https://saviynt.litmos.com/course/12006728/module/17882174?LPId=195907 
•  

[Adithya]

Hi @rushikeshvartak @sk 

Thank you so much for your response.

It would be great if you can share sample .sav file and .csv file to achieve this. It seems the files attached in the documentation is not clear. Please help us.

[rushikeshvartak]

SAV File Name CSV File Name  

Accounts.sav

Account.csv

https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter04-Onboarding-and-Managing-A...

[Adithya]

Hi Saviynt Team,

Is there a way to specify folder path here instead if adding file directly? I have tried below in Postman butting getting error.

Appreciate your response at the earliest. Thanks.

[rushikeshvartak]

In front of key select drop down as "File"

[Manu269]

@Adithya can you check this Uploading Accounts and Associated Entitlements Using Schema Upload (saviyntcloud.com)