Hi Team,
For SOAP integration-below is the response XML to import Projectgroup, that is an entitlement type, and <name>Healthcare Professional Services</name> is the entitlement value.
the users assigned to this group in comma separated values, <assigned_users>43,426,5031,416,852,129,413,124,132,793,1436,18698,143,44,196,452,133,27042,24471,8509,146,1725,241,22726,6207,1075,499,435</assigned_users>
<Projectgroup>
<created>
<Date>
<hour>14</hour>
<minute>01</minute>
<timezone/>
<second>02</second>
<month>08</month>
<day>17</day>
<year>2009</year>
</Date>
</created>
<assigned_users>43,426,5031,416,852,129,413,124,132,793,1436,18698,143,44,196,452,133,27042,24471,8509,146,1725,241,22726,6207,1075,499,435</assigned_users>
<notes/>
<active>1</active>
<name>Healthcare Professional Services</name>
<updated>
<Date>
<hour>12</hour>
<minute>25</minute>
<timezone/>
<second>34</second>
<month>09</month>
<day>20</day>
<year>2022</year>
</Date>
</updated>
<id>2</id>
How can we map the accounts ?
Account_importJSON:
{
"REQUESTTYPE2": "ENTITLEMENTS",
"REQUESTXML2": "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><request API_version=\"1.0\" client=\"ULSB2\" client_ver=\"1.1\" namespace=\"default\" key=\"i6SlzfCtaiWgXIRt9xu3\"><Auth><Login><company>ULSB2</company><user>${USERNAME}</user><password>${PASSWORD}</password></Login></Auth><Read type=\"Role\" method=\"all\" limit=\"${OFFSET_NUMBER},${PAGE_SIZE}\"><_Return><name/><id/></_Return></Read></request>",
"SOAPAction2": "https://app.sandbox.openair.com/OAirService#read",
"REQUESTPARAMS2": {
"Content-Type": "text/xml;charset=UTF-8",
"soapAction": "https://app.sandbox.openair.com/OAirService#read",
"Host": "http://ulsb2.app.sandbox.openair.com "
},
"RESPONSEDATAPATH2": "Read.Role",
"RESPONSETOTALRESULTS2": "PAGINATE",
"ENTITLEMENTMAPPING2": {
"Roles": {
"ENTITLEMENT_VALUE": "id",
"DISPLAYNAME": "name",
"CUSTOMPROPERTY3": "name"
}
},
"REQUESTTYPE3": "ENTITLEMENTS",
"REQUESTXML3": "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><request API_version=\"1.0\" client=\"ULSB2\" client_ver=\"1.1\" namespace=\"default\" key=\"i6SlzfCtaiWgXIRt9xu3\"><Auth><Login><company>ULSB2</company><user>${USERNAME}</user><password>${PASSWORD}</password></Login></Auth><Read type=\"Role\" method=\"all\" limit=\"${OFFSET_NUMBER},${PAGE_SIZE}\"><_Return><name/><id/></_Return></Read></request>",
"SOAPAction3": "https://app.sandbox.openair.com/OAirService#read",
"REQUESTPARAMS3": {
"Content-Type": "text/xml;charset=UTF-8",
"soapAction": "https://app.sandbox.openair.com/OAirService#read",
"Host": "http://ulsb2.app.sandbox.openair.com "
},
"RESPONSEDATAPATH3": "Read.Projectgroup",
"RESPONSETOTALRESULTS3": "PAGINATE",
"ENTITLEMENTMAPPING3": {
"Projectgroup": {
"ENTITLEMENT_VALUE": "id",
"DISPLAYNAME": "name",
"CUSTOMPROPERTY3": "name",
"CUSTOMPROPERTY4": "assigned_users"
}
},
"REQUESTTYPE1": "ACCOUNTS",
"REQUESTXML1": "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><request API_version=\"1.0\" client=\"ULSB2\" client_ver=\"1.1\" namespace=\"default\" key=\"i6SlzfCtaiWgXIRt9xu3\"><Auth><Login><company>ULSB2</company><user>${USERNAME}</user><password>${PASSWORD}</password></Login></Auth><Read type=\"User\" method=\"all\" limit=\"${OFFSET_NUMBER},${PAGE_SIZE}\" enable_custom =\"1\"><_Return><name/><id/><role_id/><active/><primary_filter_set/><nickname/><external_id/><filterset_ids/><primary_filter_set/><date_active__c/><date_term__c/></_Return></Read></request>",
"SOAPAction1": "https://app.sandbox.openair.com/OAirService#read",
"REQUESTPARAMS1": {
"Content-Type": "text/xml;charset=UTF-8",
"soapAction": "https://app.sandbox.openair.com/OAirService#read",
"Host": "http://ulsb2.app.sandbox.openair.com "
},
"RECONCILATIONFIELD1": "Name",
"RESPONSEDATAPATH1": "Read.User",
"RESPONSETOTALRESULTS1": "PAGINATE",
"ACCOUNTMAPPING1": "Name:nickname,accountID:id,customproperty1:active,customproperty2:role_id,customproperty3:nickname,customproperty4:id,customproperty5:primary_filter_set,customproperty6:external_id,customproperty7:name,customproperty12:filterset_ids,customproperty13:date_active__c,customproperty14:date_term__c",
"ENTITLEMENTMAPPING1": {
"Roles": "role_id"
}
}
Regards,
Atrayee
