Getting Entvalukey:Null error in mapping Account to Entitlement - REST

[Neeharika008]

Hi Experts,

We are getting below error when we are trying to map accounts to entitlement

"2024-06-27T06:25:08.197+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-dw5lh","DEBUG","inside processAccountEntitlements"
"2024-06-27T06:25:08.197+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-dw5lh","DEBUG","ACCKEY:1197918746;ENTVALKEY:null"
"2024-06-27T06:25:08.197+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-dw5lh","DEBUG","inside

ImportAcctEntjson:

{

  "accountParams": {"connection": "userAuth1",

                        "processingType": "SequentialAndIterative",

                        "statusAndThresholdConfig": {},

                        "call": {

"call1": {

                        "callOrder": 0,

                        "stageNumber": 0,

                        "http": {

                        "url": "https://xxx.com/users",

                        "httpHeaders": {

                        "Authorization": "${access_token}",

                        "Accept": "application/json"

                        },

                        "httpContentType": "application/json",

                        "httpMethod": "GET"

                        },

                        "listField": "details",

                        "keyField": "accountID",

                        "colsToPropsMap": {

                        "accountID": "userlogin~#~char",

                        "name": "userlogin~#~char",

"customproperty1": "firstname~#~char",

                    "customproperty2": "lastname~#~char",

                    "customproperty3": "email~#~char"

                        }

                        }

  }

  },

 "entitlementParams": {  "connection": "userAuth1",

        "processingType": "SequentialAndIterative",

        "entTypes": {

"Roles": {

        "entTypeOrder": 0,

        "call": {

          "call1": {

            "callOrder": 0,

            "stageNumber": 0,

            "http": {

              "url": "https://xxx.com/users/roles",

              "httpHeaders": {

                "Accept": "application/json",

"Authorization": "${access_token}"

              },

              "httpContentType": "application/json",

              "httpMethod": "GET"

            },

            "listField": "details",

            "keyField": "entitlementID",

            "colsToPropsMap": {

              "entitlementID": "name~#~char",

              "entitlement_value": "name~#~char"

            }

          }

        }

      }

        }

  },

  "acctEntParams": {

     "entTypes": {

      "Roles": {

        "call": {

          "call1": {

            "connection": "userAuth1",

            "processingType": "http",

            "http": {

              "url": "https://xxx.com/users/roleassignment/user",

              "httpContentType": "application/json",

              "httpMethod": "GET",

              "httpHeaders": {

                "Authorization": "${access_token}"

              }

            },

            "listField": "details",

            "acctKeyField": "accountID",

            "entKeyField": "entitlementID",

            "acctIdPath": "userlogin",

            "entIdPath": "roles.rolename"

          }

        }

      }

    }

}

}

Postman response for roleassignemnet:

{
"details": [
{
"userlogin": "a.avi.k.kumar@test.com",
"firstname": "test",
"lastname": "Admin",
"email": "a.avi.k.kumar@test.com",
"roles": [
{
"rolename": "test"
},
{
"rolename": "User"
}

]
}
]
}

Only account import is successful, please suggest some solutions to import entitlement & to map them with imported accounts.

[rushikeshvartak]

Use Below json

{
  "accountParams": {"connection": "userAuth1",
                        "processingType": "SequentialAndIterative",
                        "statusAndThresholdConfig": {},
                        "call": {
"call1": {
                        "callOrder": 0,
                        "stageNumber": 0,
                        "http": {
                        "url": "https://xxx.com/users",
                        "httpHeaders": {
                        "Authorization": "${access_token}",
                        "Accept": "application/json"
                        },
                        "httpContentType": "application/json",
                        "httpMethod": "GET"
                        },
                        "listField": "details",
                        "keyField": "accountID",
                        "colsToPropsMap": {
                        "accountID": "userlogin~#~char",
                        "name": "userlogin~#~char",
"customproperty1": "firstname~#~char",
                    "customproperty2": "lastname~#~char",
                    "customproperty3": "email~#~char"
                        }
                        }
  }
  },
 "entitlementParams": {  "connection": "userAuth1",
        "processingType": "SequentialAndIterative",
        "entTypes": {
          
"Roles": {
        "entTypeOrder": 0,
        "call": {
          "call1": {
            "callOrder": 0,
            "stageNumber": 0,
            "http": {
              "url": "https://xxx.com/users/roles",
              "httpHeaders": {
                "Accept": "application/json",
"Authorization": "${access_token}"
              },
              "httpContentType": "application/json",
              "httpMethod": "GET"
            },
            "listField": "details",
            "keyField": "entitlementID",
            "colsToPropsMap": {
              "entitlementID": "name~#~char",
              "entitlement_value": "name~#~char"
            }
          }
        }
      }
        }
  },
  "acctEntParams": {
     "entTypes": {
      "Roles": {
        "call": {
          "call1": {
            "connection": "userAuth1",
            "processingType": "http",
            "http": {
              "url": "https://xxx.com/users/roleassignment/user",
              "httpContentType": "application/json",
              "httpMethod": "GET",
              "httpHeaders": {
                "Authorization": "${access_token}"
              }
            },
            "listField": "",
            "acctKeyField": "accountID",
            "entKeyField": "entitlementID",
            "acctIdPath": "details.userlogin",
            "entIdPath": "details.roles.rolename"
          }
        }
      }
    }
}
}
 

[Neeharika008]

Hi @rushikeshvartak ,

It is not even mapping with account key using above JSON. Please find the logs below:

bjectList.size : 1"
"2024-06-28T08:32:08.350+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-qnp7w","DEBUG","inside processAccountEntitlements"
"2024-06-28T08:32:08.350+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-qnp7w","DEBUG","ACCKEY:null;ENTVALKEY:null"
"2024-06-28T08:32:08.353+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-qnp7w","DEBUG","delete inactive account linking: false"
"2024-06-28T08:32:08.354+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-qnp7w","DEBUG","Inside deleteAccountEntitlementsByEntType "
"2024-06-28T08:32:08.365+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-qnp7w","DEBUG","Deletion of old Account_entitlements1 complete"
"2024-06-28T08:32:08.366+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-6-qnp7w","DEBUG","processAccountEntitlementParams complete.."

[rushikeshvartak]

In old logic try

roles.rolename[0]