Hi @rushikeshvartak
Thanks for the response!
we are trying to import user as account into saviynt along with user business units and roles, we need sample json payload for entitlement type Role under "acctEntParams" to import user along with role, here is the account_entitlement_import json we are using to map user accounts and entitlements
{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"http": {
"url": "https://<****>.soap.marketingcloudapis.com/Service.asmx",
"httpParams": "<?xml version=\"1.0\" encoding=\"UTF-8\"?><s:Envelope xmlns:s=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:a=\"http://schemas.xmlsoap.org/ws/2004/08/addressing\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><s:Header><a:Action s:mustUnderstand=\"1\">RetrieveRequest</a:Action><a:To s:mustUnderstand=\"1\">https://<****>.soap.marketingcloudapis.com/Service.asmx</a:To><fueloauth xmlns=\"http://exacttarget.com\">${access_token}</fueloauth></s:Header><s:Body xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><RetrieveRequestMsg xmlns=\"http://exacttarget.com/wsdl/partnerAPI\"><RetrieveRequest><ObjectType>AccountUser</ObjectType><QueryAllAccounts>true</QueryAllAccounts><Properties>Name</Properties><Properties>AccountUserID</Properties><Properties>CustomerKey</Properties><Properties>Email</Properties><Properties>ActiveFlag</Properties><Properties>CreatedDate</Properties><Properties>isAPIUser</Properties><Properties>UserID</Properties><Properties>LastSuccessfulLogin</Properties><Properties>NotificationEmailAddress</Properties><Filter xsi:type=\"ns1:SimpleFilterPart\" xmlns:ns1=\"http://exacttarget.com/wsdl/partnerAPI\"><Property>Email</Property><SimpleOperator>like</SimpleOperator><Value>sigatest.user%</Value></Filter></RetrieveRequest></RetrieveRequestMsg></s:Body></s:Envelope>",
"httpHeaders": {
"Content-Type": "text/xml"
},
"httpContentType": "text/xml",
"httpMethod": "POST"
},
"listField": "soap:Envelope.soap:Body.RetrieveResponseMsg.Results",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"name": "UserID~#~char",
"accountID": "AccountUserID~#~char",
"customproperty1": "Email~#~char",
"customproperty2": "NotificationEmailAddress~#~char",
"customproperty3": "LastSuccessfulLogin~#~char",
"customproperty4": "isAPIUser~#~char",
"customproperty5": "ActiveFlag~#~char",
"customproperty6": "CustomerKey~#~char",
"customproperty7": "CreatedDate~#~char",
"status": "ActiveFlag~#~char",
"displayName": "Name~#~char"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Role": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://<****>.soap.marketingcloudapis.com/Service.asmx",
"httpParams": "<?xml version=\"1.0\" encoding=\"UTF-8\"?><s:Envelope xmlns:s=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:a=\"http://schemas.xmlsoap.org/ws/2004/08/addressing\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><s:Header><a:Action s:mustUnderstand=\"1\">Retrieve</a:Action><a:To s:mustUnderstand=\"1\">https://<****>.soap.marketingcloudapis.com/Service.asmx</a:To><fueloauth xmlns=\"http://exacttarget.com\">${access_token}</fueloauth></s:Header><s:Body xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><RetrieveRequestMsg xmlns=\"http://exacttarget.com/wsdl/partnerAPI\"><RetrieveRequest><ObjectType>Role</ObjectType><Properties>Name</Properties><Properties>Description</Properties><Properties>ObjectID</Properties><Properties>CustomerKey</Properties><Properties>IsPrivate</Properties><Properties>IsSystemDefined</Properties><Filter xsi:type=\"ns1:SimpleFilterPart\" xmlns:ns1=\"http://exacttarget.com/wsdl/partnerAPI\"><Property>Name</Property><SimpleOperator>like</SimpleOperator><Value>ERM Marketing%</Value></Filter></RetrieveRequest></RetrieveRequestMsg></s:Body></s:Envelope>",
"httpHeaders": {
"Content-Type": "text/xml"
},
"httpContentType": "text/xml",
"httpMethod": "POST"
},
"listField": "soap:Envelope.soap:Body.RetrieveResponseMsg.Results",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "ObjectID~#~char",
"entitlement_value": "ObjectID~#~char",
"displayname": "Name~#~char",
"description": "Description~#~char",
"customproperty1": "CustomerKey~#~char",
"customproperty2": "IsPrivate~#~char",
"customproperty3": "IsSystemDefined~#~char",
"entitlement_glossary": "Description~#~char"
},
"disableDeletedEntitlements": true
}
}
},
"Business Unit": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"http": {
"url": "https://<****>.soap.marketingcloudapis.com/Service.asmx",
"httpParams": "<?xml version=\"1.0\" encoding=\"UTF-8\"?><s:Envelope xmlns:s=\"http://www.w3.org/2003/05/soap-envelope\" xmlns:a=\"http://schemas.xmlsoap.org/ws/2004/08/addressing\" xmlns:u=\"http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd\"><s:Header><a:Action s:mustUnderstand=\"1\">Retrieve</a:Action><a:To s:mustUnderstand=\"1\">https://<****>.soap.marketingcloudapis.com/Service.asmx</a:To><fueloauth xmlns=\"http://exacttarget.com\">${access_token}</fueloauth></s:Header><s:Body xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"><RetrieveRequestMsg xmlns=\"http://exacttarget.com/wsdl/partnerAPI\"><RetrieveRequest><ObjectType>BusinessUnit</ObjectType><Properties>ID</Properties><Properties>Name</Properties><Properties>Description</Properties><QueryAllAccounts>true</QueryAllAccounts></RetrieveRequest></RetrieveRequestMsg></s:Body></s:Envelope>",
"httpHeaders": {
"Content-Type": "text/xml"
},
"httpContentType": "text/xml",
"httpMethod": "POST"
},
"listField": "soap:Envelope.soap:Body.RetrieveResponseMsg.Results",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "ID~#~char",
"entitlement_value": "ID~#~char",
"customproperty1": "Name~#~char",
"displayname": "Name~#~char",
"description": "Description~#~char",
"customproperty2": "CustomerKey~#~char",
"entitlement_glossary": "Description~#~char"
},
"disableDeletedEntitlements": true
}
}
}
}
},
"acctEntParams": {
"connection": "entAuth",
"entTypes": {
"Business Unit": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"url": "https://<****>.rest.marketingcloudapis.com/platform/v1/accounts/${id}/users?%24pagesize=175&%24page=1",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"entKeyField": "entitlementID",
"acctIdPath": "id",
"acctKeyField": "accountID",
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
}
}
}
}
}
Tried by placing this json inside acctEntParams after business unit json, but after import job, unable to see any roles, only business units are added from target
"Role": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpEntToAcct",
"http": {
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"url": "https://<****>.rest.marketingcloudapis.com/platform/v1/accounts/${id}/users?%24pagesize=175&%24page=1",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"entKeyField": "entitlementID",
"acctIdPath": "id",
"acctKeyField": "accountID",
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
}
}
}
}
Thanks in advance!
Regrads,
Padamavathi
