REST Connector not importing accounts

sris
New Contributor III
New Contributor III

The job finishes succesfully but accounts are not imported. Below is the info from logs

2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.022428972Z stdout F 2023-08-15 15:12:08,022 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Time Taken to populateEntitlementMapByConfig : 0.002"
"2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.022443072Z stdout F 2023-08-15 15:12:08,022 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Inside importAccountsFull:persistEntObjects, pptTypeSep : ~#~"
"2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.022523673Z stdout F 2023-08-15 15:12:08,022 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - INFO: Account Name is null, record not saved."
"2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.025335526Z stdout F 2023-08-15 15:12:08,025 [quartzScheduler_Worker-8] DEBUG services.ImportUtilityService - EntitlementType 'Organization_Roles_group' for Endpoint 'Workday_REST_UAR' found with EntitlementTypekey - 1547"
"2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.027690069Z stdout F 2023-08-15 15:12:08,027 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Time Taken to populateEntitlementMapByConfig : 0.002"
"2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.027700669Z stdout F 2023-08-15 15:12:08,027 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Inside importAccountsFull:persistEntObjects, pptTypeSep : ~#~"
"2023-08-15T15:12:08.760+00:00","ecm-worker","","","","2023-08-15T15:12:08.027793271Z stdout F 2023-08-15 15:12:08,027 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - INFO: Account Name is null, record not saved."

Below is the JSON file format of accounts (ID) and roles

{
"Report_Entry": [
{
"ID": "123456789",
"Org_Roles_group": [
{
"Role": "abcd"
}
],
"Time_of_Most_Recent_Sign_On": "2023-07-18T12:17:40.371-07:00",
"User": "Firstname Lastname"
},
]
}

Below is the Import JSON

{
"accountParams": {
"connection": "acctAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"accountsNotInImportAction": "Suspend",
"accountThresholdValue": 10,
"correlateInactiveAccounts": false
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "url",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
}
},
"listField": "Report_Entry",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "ID~#~char",
"NAME": "User~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"Org_Roles_group": {
"importAsEntitlement": true,
"listPath": "Org_Roles_group",
"idPath": "Role",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "Role~#~char",
"entitlement_value": "Role~#~char"
}
}
}
},
"entitlementParams": {
"processingType": "SequentialAndIterative",
"entTypes": {
"Org_Roles_group": {
"entTypeOrder": 1
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}
 
Entitlement type got created in the endpoint, but no accounts or accesses are coming in. Please advise
3 REPLIES 3

dgandhi
All-Star
All-Star

What is the response of the job in the logs? Is it 200 or something else?

 

Thanks,
Devang Gandhi
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

sris
New Contributor III
New Contributor III

It is 200

responseMap :: [headers:[Transfer-Encoding:chunked, X-Content-Type-Options:nosniff, Connection:keep-alive, Pragma:no-cache, Date:Tue, 15 Aug 2023 18:30:00 GMT, X-Frame-Options:DENY, Referrer-Policy:no-referrer, Strict-Transport-Security:max-age=31536000; includeSubDomains, Cache-Control:no-cache, no-store, max-age=0, must-revalidate, Set-Cookie:INGRESSCOOKIE=1692124201.528.1118.251845|3523113d2bd3072fa485626e272241b1; Path=/; Secure; HttpOnly, Vary:Origin,Access-Control-Request-Method,Access-Control-Request-Headers, Expires:0, X-XSS-Protection:1 ; mode=block, Content-Type:application/json;charset=UTF-8], resultObject:{"jobId":"19536","STATUS":"OK","response":"In-progress","USERMS":"Endpoint sync and Entitlement sync STARTED. Job Id - 19536"}, responseCode:200]"

sris
New Contributor III
New Contributor III

Some additional info

"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.512478095Z stdout F 2023-08-15 18:33:41,512 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - "
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.512605397Z stdout F 2023-08-15 18:33:41,512 [quartzScheduler_Worker-10] DEBUG rest.RestUtilService - pullObjectsByRest - responseStatusCode ::200"
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.715650503Z stdout F 2023-08-15 18:33:41,715 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - Entered getResponseHeaders method"
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.715773605Z stdout F 2023-08-15 18:33:41,715 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - responseError : null"
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.715781806Z stdout F 2023-08-15 18:33:41,715 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - isAuthError: false"
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.715866507Z stdout F 2023-08-15 18:33:41,715 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 1"
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.71601651Z stdout F 2023-08-15 18:33:41,715 [quartzScheduler_Worker-10] DEBUG rest.RestUtilService - Exception in RestUtil.getAt : java.lang.ArrayIndexOutOfBoundsException: 0"
"2023-08-15T18:33:41.756+00:00","ecm-worker","","","","2023-08-15T18:33:41.734322253Z stdout F 2023-08-15 18:33:41,734 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : null"