Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/21/2024 12:38 AM - edited 10/21/2024 06:21 AM
Hi Team,
I am trying to import account and entitlements from the saleforce marketing cloud target to saviynt but i am able to import only business units but not roles from the target, here both are considered as entitlements.
Can anyone help us with the json payload for acctEntParams for roles
Thanks in advance
Regards,
Padmavathi
10/21/2024 07:46 AM
Please share the logs & JSON in text format for easier debugging. Additionally, provide the task ID, error details, or specific line numbers where the issues occur to help us review the relevant sections efficiently.
Also share postman screenshot and curl command
⚠️ Important: Do not upload attachments containing sensitive information, such as IP addresses, URLs, company/employee names, or email addresses. For more information, refer to the Saviynt PII Policy.
10/21/2024 08:40 AM
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
10/21/2024 08:52 AM
Also share postman screenshot and curl command