SOAP Account and entitlement import

[AtrayeeDutta07]

Hi Team,

Facing issue in Account and ent import using SOAP connector.

Import Account response from POSTMAN:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<response>

    <Auth status = "0"></Auth >

    <Read status = "0">

        <User>

            <name>XYZ</name>

            <role_id>1</role_id>

            <id>1</id>

        </User>

        <User>

            <name>ABCD</name>

            <role_id>2</role_id>

            <id>3</id>

        </User>

    </Read >

</response>

Import Roles/Entitlements Response from postman:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<response>

    <Auth status = "0"></Auth >

    <Read status = "0">

        <Role>

            <name>Administrator</name>

            <id>1</id>

        </Role>

        <Role>

            <name>Timesheet User</name>

            <id>36</id>

        </Role>

       </Read>

</response>

Account response have role id tagged to it, and in Role call have role name , id.

Accounimport JSON:

{

"CONNECTION1" : "login",

"RECONCILATIONFIELD1" : "ACCOUNTID",

"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\"><Read type=\"User\" method=\"all\" limit=\"1000\"><_Return><name/><id/><nickname/><external_id/><role_id/></_Return></Read></request>",

"REQUESTPARAMS1" : {

        "Content-Type": "application/xml"

},

"RESPONSEDATAPATH1" : "response.Read.User",

"RESPONSETOTALRESULTS1" : "PAGINATE",

"ACCOUNTMAPPING1" : "NAME:nickname,ACCOUNTID:external_id",

"REQUESTTYPE2" : "ENTITLEMENTS",

"CONNECTION2" : "login",

"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\"><Read type=\"Role\" method=\"all\" limit=\"1000\"><_Return><name/><id/></_Return></Read></request>",

"REQUESTPARAMS2" : {

        "Content-Type": "application/xml"

},

"RESPONSEDATAPATH2" : "response.Read.Role",

"ENTITLEMENTMAPPING2" : {

"Role.entitlement_value" : "Role.name",

}

}

job is running but not bringing account/entdata.

Can anyone please help on this?

Any working JSON, that brings account, entitlement and acc-ent mapping as well?

Regards,

Atrayee

[stalluri]

@AtrayeeDutta07 

Can you try Json

{
    "CONNECTION1": "login",
    "RECONCILATIONFIELD1": "ACCOUNTID",
    "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\"><Read type=\"User\" method=\"all\" limit=\"1000\"><_Return><name/><id/><nickname/><external_id/><role_id/></_Return></Read></request>",
    "REQUESTPARAMS1": {
        "Content-Type": "text/xml;charset=UTF-8"
    },
    "RESPONSEDATAPATH1": "response.Read.User",
    "RESPONSETOTALRESULTS1": "PAGINATE",
    "ACCOUNTMAPPING1": "NAME:name,ACCOUNTID:id",
    "REQUESTTYPE2": "ENTITLEMENTS",
    "CONNECTION2": "login",
    "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\"><Read type=\"Role\" method=\"all\" limit=\"1000\"><_Return><name/><id/></_Return></Read></request>",
    "REQUESTPARAMS2": {
        "Content-Type": "text/xml;charset=UTF-8"
    },
    "RESPONSEDATAPATH2": "response.Read.Role",
    "ENTITLEMENTMAPPING2": {
        "Role.entitlement_value": "Role.name"
    }
}

[AtrayeeDutta07]

Hi Sam,

The above JSON not bringing data, job running successfully. Not getting much over logs.

Regards,

Atrayee

[stalluri]

@AtrayeeDutta07 

{
  "ACCOUNTS_IMPORT_JSON": {
    "CONNECTION1": "login",
    "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\"><Read type=\"User\" method=\"all\" limit=\"1000\"><_Return><name/><role_id/><id/></_Return></Read></request>",
    "REQUESTPARAMS1": {
      "Content-Type": "application/xml"
    },
    "RESPONSEDATAPATH1": "response.Read.User",
    "ACCOUNTMAPPING1": "ACCOUNTID:id,NAME:name,ROLE_ID:role_id",
    "REQUESTTYPE2": "ENTITLEMENTS",
    "CONNECTION2": "login",
    "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\"><Read type=\"Role\" method=\"all\" limit=\"1000\"><_Return><name/><id/></_Return></Read></request>",
    "REQUESTPARAMS2": {
      "Content-Type": "application/xml"
    },
    "RESPONSEDATAPATH2": "response.Read.Role",
    "ENTITLEMENTMAPPING2": {
      "Role.entitlement_value": "name"
    }
  }
}

[AtrayeeDutta07]

Hi @stalluri 

The above config is not working for ent and account import. Do you have a sample JSON, that imported account and ent both from separate calls?

Regards,

Atrayee