Infor Account and Entitlement Import

[GPS]

Hello Team,

I am unable to import the accounts or entitlements into Saviynt.  I am using the below JSON.


ImportAccountJson:

Spoiler

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
"false"
],
"deleteLinks": true,
"accountThresholdValue": 10,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://mingle-ionapi.inforcloudsuite.com/TRN/FSM/fsm/soap/classes/Actor/lists/_generic?_lplFilter=A...",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "_fields",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "Actor~#~char",
"name": "Actor~#~char",
"displayName": "MingleId~#~char",
"customproperty2": "PersonName.FamilyName~#~char",
"customproperty3": "PersonName.GivenName~#~char",
"customproperty4": "MingleId~#~char",
"status": "active~#~char",
"customproperty11": "suspended~#~char"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Group": {
"entTypeOrder": 0,
"entTypeLabels": {
"customproperty1": "Description"
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://mingle-ionapi.inforcloudsuite.com/TRN/FSM/fsm/soap/classes/PLTFSMRoles/lists/_generic?_field...",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "_fields",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Role~#~char",
"entitlement_value": "Role~#~char",
"customproperty1": "Description~#~char"
},
"disableDeletedEntitlements": true
}
}
}
}
},
"acctEntParams": {
"connection": "userAuth",
"entTypes": {
"Group": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://mingle-ionapi.inforcloudsuite.com/TRN/FSM/fsm/soap/classes/ActorRole/lists/_generic?_fields=...",
"httpMethod": "GET"
},
"listField": "_fields",
"entIdPath": "ActorRole.Role",
"entKeyField": "entitlementID",
"acctIdPath": "Actor",
"acctKeyField": "accountID"
}
}
}
}
}
}

Postman Response:
Account call:

{

"_count": 10000,

"_links": [

{

"rel": "self",

"href": "../lists/_generic?_lplFilter=Actor.IsActorDisabled%3Dfalse&_fields=Actor%2CMingleId%2CPersonName.GivenName%2CPersonName.FamilyName&_limit=10000"

},

{

"rel": "next",

"href": ""

},

{

"rel": "prev",

"href": ""

}

]

},

{

"_fields": {

"MingleId": "johnathan.bomar@gmail.com",

"PersonName.FamilyName": "Johnathan",

"Actor": "#N/A",

"PersonName.GivenName": "Bomar"

}

},

{

"_fields": {

"MingleId": "Role@gmail.net",

"PersonName.FamilyName": "Reed",

"Actor": "000111",

"PersonName.GivenName": "TESTRoleDefault"

}

},

{

"_fields": {

"MingleId": "",

"PersonName.FamilyName": "Russell",

"Actor": "00papaw00@gmail.com",

"PersonName.GivenName": "Scott"

}

},

Entitlement call:

[

{

"_count": 2,

"_links": [

{

"rel": "self",

"href": "../lists/_generic?_fields=Role%2CDescription"

},

{

"rel": "next",

"href": ""

},

{

"rel": "prev",

"href": ""

}

]

},

{

"_fields": {

"Role": "ApplicationAdministrator_ST",

"Description": "Administrator of FSM"

}

},

{

"_fields": {

"Role": "IEFINBaseSystemAndDataAccess_ST",

"Description": "Base Role all users need"

}

}

]


Account to Entitlement Mapping:

[

{

"_count": 807831,

"_links": [

{

"rel": "self",

"href": "../lists/_generic?_fields=Actor%2CActorRole.Role%2CPLTFSMActorRole%2CActor.PersonName.GivenName%2CActor.PersonName.FamilyName%2CActor.MingleId&_lplFilter=Actor.IsActorDisabled%3Dfalse&_limit=10000"

},

{

"rel": "next",

"href": "../lists/_generic?_lplFilter=Actor.IsActorDisabled%3Dfalse&_limit=10000&ActorRole=Controller_ST&Actor=153542&_rkn=%20&_fields=Actor%2CActorRole.Role%2CPLTFSMActorRole%2CActor.PersonName.GivenName%2CActor.PersonName.FamilyName%2CActor.MingleId&_paging=NEXT&_position=true"

},

{

"rel": "prev",

"href": "../lists/_generic?_lplFilter=Actor.IsActorDisabled%3Dfalse&_limit=10000&ActorRole=ClickBoarding_PFJ&Actor=%23N%2FA&_rkn=%20&_fields=Actor%2CActorRole.Role%2CPLTFSMActorRole%2CActor.PersonName.GivenName%2CActor.PersonName.FamilyName%2CActor.MingleId&_paging=PREVIOUS&_position=true"

}

]

},

{

"_fields": {

"Actor.MingleId": "johnathan.bomar@gmail.com",

"Actor.PersonName.FamilyName": "Johnathan",

"PLTFSMActorRole": "false",

"Actor": "#N/A",

"ActorRole.Role": "ApplicationAdministrator_ST",

"Actor.PersonName.GivenName": "Bomar"

}

},

{

"_fields": {

"Actor.MingleId": "johnathan.bomar@gmail.com",

"Actor.PersonName.FamilyName": "Johnathan",

"PLTFSMActorRole": "false",

"Actor": "#N/A",

"ActorRole.Role": "IEFINBaseSystemAndDataAccess_ST",

"Actor.PersonName.GivenName": "Bomar"

}

},

[rushikeshvartak]

Whats the issue ?

[NM]

@GPS try this for account param first

"listField": "",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "_fields.mingleID~#~char",
"Name": "_fields.mingleID~#~char