Rest connector multiple API call pagination issue

[Yashh]

Hi ,

I am trying to import entitlements from the target source using a rest connector. There are 3 types of entitlements that we need to accommodate in a single entitlement type in Saviynt. In the ImportAccountEntJSON, I am making 3 calls to import the 3 types using different filters in each url of each call. However, I am getting the following error while running the import -
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-2-rvxzz-DEBUG-pullObjectsByRest - responseStatusCode ::null
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-2-rvxzz-DEBUG-Got showLogs = true
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-2-rvxzz-DEBUG-Got null response statusCode with erroMsg - [error:Error Illegal character in query at index 54: https://abcd.com/api/v2/assets?filter="asset_type_id:17000297326"&per_page=100&page=2]
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-2-rvxzz-ERROR-Exception in getting response in pullObjectsByRest :
2024-06-18T23:12:21+05:30-ecm-worker--null-rvxzz--java.lang.Exception: NullResponseFromTarget at com.saviynt.provisoning.rest.RestUtilService.checkForErrorMsg(RestUtilService.groovy:1463) at com.saviynt.provisoning.rest.RestProvisioningService.pullObjectsByRest(RestProvisioningService.groovy:4551) at com.saviynt.provisoning.rest.RestProvisioningService.processEntitlementByPagination(RestProvisioningService.groovy:952) at com.saviynt.provisoning.rest.RestProvisioningService.processEntitlementByEntFilterAndNoFilter(RestProvisioningService.groovy:851) at com.saviynt.provisoning.rest.RestProvisioningService.processEntitlementsFinal(RestProvisioningService.groovy:695) at com.saviynt.provisoning.rest.RestProvisioningService.processAccessFullBySequentialAndIterative(RestProvisioningService.groovy:653) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterativeWithoutEntFilter(RestProvisioningService.groovy:530) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterative(RestProvisioningService.groovy:284) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFull(RestProvisioningService.groovy:170) at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:144) at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:233) at SapImportJob.execute(SapImportJob.groovy:109) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-2-rvxzz-DEBUG-Got showLogs = true
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-2-rvxzz-DEBUG-Got showLogs = true
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-2-rvxzz-DEBUG-Error while getting Access Import response for entType- Device, url- https://abcd.com/api/v2/assets?filter="asset_type_id:17000297326"&per_page=100&page=2 is: null
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-2-rvxzz-DEBUG-Getting response statusCode null, so failing Access Import Job
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-2-rvxzz-DEBUG-Inside importAccessFull:persistEntObjects, pptTypeSep : ~#~
2024-06-18T23:12:20+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-2-rvxzz-DEBUG-callStageNumber : 1

Following is the ImportAccountEntJSON that I am using - 
{
"accountParams": {
"connection": "PROD_SNAP_CON_HMP",
"processingType": "SequentialAndIterative"
},
"entitlementParams": {
"connection": "PROD_SNAP_CON_HMP",
"processingType": "SequentialAndIterative",
"entTypes": {
"Device": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://abcd.com/api/v2/assets?filter=%22asset_type_id:17000297326%22&per_page=100",
"httpContentType": "application/json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "*/*"
}
},
"listField": "assets",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"customproperty2": "asset_type_id~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.size()>0?headers.Link.replace('<', '').replace('>; rel=\"next\"','').trim():null}"
}
}
},
"call2": {
"callOrder": 1,
"stageNumber": 1,
"http": {
"url": "https://abcd.com/api/v2/assets?filter=%22asset_type_id:17000297309%22&per_page=100",
"httpContentType": "application/json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "*/*"
}
},
"listField": "assets",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"customproperty2": "asset_type_id~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.size()>0?headers.Link.replace('<', '').replace('>; rel=\"next\"','').trim():null}"
}
}
},
"call3": {
"callOrder": 2,
"stageNumber": 2,
"http": {
"url": "https://abcd.com/api/v2/assets?filter=%22asset_type_id:17000297325%22&per_page=100",
"httpContentType": "application/json",
"httpMethod": "GET",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "*/*"
}
},
"listField": "assets",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"customproperty2": "asset_type_id~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${headers?.Link?.size()>0?headers.Link.replace('<', '').replace('>; rel=\"next\"','').trim():null}"
}
}
}
}
}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}

Can anyone tell me how this can be fixed?

[rushikeshvartak]

{
  "accountParams": {
    "connection": "PROD_SNAP_CON_HMP",
    "processingType": "SequentialAndIterative"
  },
  "entitlementParams": {
    "connection": "PROD_SNAP_CON_HMP",
    "processingType": "SequentialAndIterative",
    "entTypes": {
      "Device": {
        "entTypeOrder": 0,
        "call": {
          "call1": {
            "callOrder": 0,
            "stageNumber": 0,
            "http": {
              "url": "https://abcd.com/api/v2/assets?filter=%22asset_type_id:17000297326%22&per_page=100",
              "httpContentType": "application/json",
              "httpMethod": "GET",
              "httpHeaders": {
                "Authorization": "${access_token}",
                "Accept": "*/*"
              }
            },
            "listField": "assets",
            "keyField": "entitlementID",
            "colsToPropsMap": {
              "entitlementID": "id~#~char",
              "entitlement_value": "name~#~char",
              "customproperty2": "asset_type_id~#~char"
            },
            "pagination": {
              "nextUrl": {
                "nextUrlPath": "${headers?.Link?.size()>0?headers.Link.replace('<', '').replace('>; rel=\"next\"','').trim():null}"
              }
            }
          },
          "call2": {
            "callOrder": 1,
            "stageNumber": 1,
            "http": {
              "url": "https://abcd.com/api/v2/assets?filter=%22asset_type_id:17000297309%22&per_page=100",
              "httpContentType": "application/json",
              "httpMethod": "GET",
              "httpHeaders": {
                "Authorization": "${access_token}",
                "Accept": "*/*"
              }
            },
            "listField": "assets",
            "keyField": "entitlementID",
            "colsToPropsMap": {
              "entitlementID": "id~#~char",
              "entitlement_value": "name~#~char",
              "customproperty2": "asset_type_id~#~char"
            },
            "pagination": {
              "nextUrl": {
                "nextUrlPath": "${headers?.Link?.size()>0?headers.Link.replace('<', '').replace('>; rel=\"next\"','').trim():null}"
              }
            }
          },
          "call3": {
            "callOrder": 2,
            "stageNumber": 2,
            "http": {
              "url": "https://abcd.com/api/v2/assets?filter=%22asset_type_id:17000297325%22&per_page=100",
              "httpContentType": "application/json",
              "httpMethod": "GET",
              "httpHeaders": {
                "Authorization": "${access_token}",
                "Accept": "*/*"
              }
            },
            "listField": "assets",
            "keyField": "entitlementID",
            "colsToPropsMap": {
              "entitlementID": "id~#~char",
              "entitlement_value": "name~#~char",
              "customproperty2": "asset_type_id~#~char"
            },
            "pagination": {
              "nextUrl": {
                "nextUrlPath": "${headers?.Link?.size()>0?headers.Link.replace('<', '').replace('>; rel=\"next\"','').trim():null}"
              }
            }
          }
        }
      }
    }
  },
  "acctEntParams": {
    "processingType": "acctToEntMapping"
  }
}

[Yashh]

Hey Rushikesh,

Thanks for your reply, I tried the code and all 3 calls are working however there seems to be some issue in the pagination. I ran the import job and it is failing with the following error -
2024-06-19T21:23:37+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-rvxzz-DEBUG-Got null response statusCode with erroMsg - [error:Error Illegal character in query at index 54: https://abcd.com/api/v2/assets?filter= "asset_type_id:17000297325"&per_page=100&page=2]
2024-06-19T21:23:37+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-rvxzz-ERROR-Exception in getting response in pullObjectsByRest :
2024-06-19T21:23:37+05:30-ecm-worker--null-rvxzz--java.lang.Exception: NullResponseFromTarget at com.saviynt.provisoning.rest.RestUtilService.checkForErrorMsg(RestUtilService.groovy:1463) at com.saviynt.provisoning.rest.RestProvisioningService.pullObjectsByRest(RestProvisioningService.groovy:4551) at com.saviynt.provisoning.rest.RestProvisioningService.processEntitlementByPagination(RestProvisioningService.groovy:952) at com.saviynt.provisoning.rest.RestProvisioningService.processEntitlementByEntFilterAndNoFilter(RestProvisioningService.groovy:851) at com.saviynt.provisoning.rest.RestProvisioningService.processEntitlementsFinal(RestProvisioningService.groovy:695) at com.saviynt.provisoning.rest.RestProvisioningService.processAccessFullBySequentialAndIterative(RestProvisioningService.groovy:653) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterativeWithoutEntFilter(RestProvisioningService.groovy:530) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterative(RestProvisioningService.groovy:284) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFull(RestProvisioningService.groovy:170) at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:144) at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:233) at SapImportJob.execute(SapImportJob.groovy:109) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
2024-06-19T21:23:37+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-rvxzz-DEBUG-Got showLogs = true
2024-06-19T21:23:37+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-rvxzz-DEBUG-Got showLogs = true
2024-06-19T21:23:37+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-rvxzz-DEBUG-Error while getting Access Import response for entType- Device, url- https://abcd.com/api/v2/assets?filter= "asset_type_id:17000297325"&per_page=100&page=2 is: null
2024-06-19T21:23:37+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-rvxzz-DEBUG-Getting response statusCode null, so failing Access Import Job

I used the same url in postman and I am getting the output as expected. Do you know the cause of this error?

Thanks,
Yash

[This message has been edited by moderator to disable url hyperlink]

[rushikeshvartak]

It seems : in ul causing issue.

[Yashh]

Hey,

It was an issue with the pagination URL, I updated it and the import is working. There is one issue though, I am only able to import 100 pages of records and not the pages after 100. 
Here is the pagination that I am using -
"pagination": {
"page": {
"pageSizeParam": "per_page",
"pageSize": 100,
"pageRecordCount": "100",
"pageNumberParam": "page",
"totalCountPath": "headers.X-Search-Results-Count",
"firstPageNumber": 1
}
}

This is the link that I am getting in the response header of the api call in postman - 
<https://abcd.com/api/v2/assets?include=type_fields&filter="asset_type_id:17000297326"&per_page=100&page=101>; rel="next"

Do you know how I can achieve this?

Thanks,
Yash Gautam

[rushikeshvartak]

Can you share errors coming from saviynt logs

[Yashh]

Hey Rushikesh,

Here you go - 
2024-06-21T13:59:09+05:30-ecm-worker-integration.ExternalConnectionCallService-quartzScheduler_Worker-6-wg44j-DEBUG-END INVOKING EXTERNAL CONNECTION
2024-06-21T13:59:09+05:30-ecm-worker-jobs.SapImportJob-quartzScheduler_Worker-6-wg44j-DEBUG-FINISH externalConnectionCallService
2024-06-21T13:59:09+05:30-ecm-worker-jobs.SapImportJob-quartzScheduler_Worker-6-wg44j-DEBUG-Setting the value of import status
2024-06-21T13:59:09+05:30-ecm-worker-jobs.SapImportJob-quartzScheduler_Worker-6-wg44j-DEBUG-Import status :: Success
2024-06-21T13:59:09+05:30-ecm-worker-jobs.SapImportJob-quartzScheduler_Worker-6-wg44j-DEBUG-END SapImportJob
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Deletion of old Account_entitlements1 complete
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-processAccountEntitlementParams complete..
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-calling processEntitlementOwnerParams - memento.entTypesSet : [3068]
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside processEntitlementOwnerParams*****
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entitlement types from ImportAccountEntJSON.entMappingParams: [3068]
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entitlement types from ownerEntTypeSet: []
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-ownerEntTypeSet is EMPTY. Skipping entitlement owner deletion
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-processEntitlementOwnerParams complete..
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-calling importUtilityService.markEntitlementsStatus - statusAndThresholdConfig : [inactivateEntsNotInFeed:false, deleteLinks:true, entThresholdValue:[entType:[Devicename:[ent:100000]]]], endpoints: HMP Test, entTypesMap: [Device:3068], ae1EntTypeSet: [3068]
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-Process markEntitlementsStatus
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-accountEntThresholdValue = 1000
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-deleteAccEntForActiveAccounts = true
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-inactivateEntsNotInFeed = false
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-Start deleteAccountEntitlementLinks
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-Query to get Account-Entitlement mapping not Inserted/Updated in this job: | SELECT AE1.ACCENTKEY AS ACCENTKEY FROM ACCOUNT_ENTITLEMENTS1 AE1, ENTITLEMENT_VALUES EV WHERE | AE1.ENTITLEMENT_VALUEKEY=EV.ENTITLEMENT_VALUEKEY AND| EV.ENTITLEMENTTYPEKEY IN (3068) AND (AE1.JOB_ID<>3194411 OR AE1.JOB_ID IS NULL)|
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-Account-Entitlement mapping to be deleted: 0
2024-06-21T13:59:08+05:30-ecm-worker-services.ImportUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-Cannot delete Account-Entitlement mapping as the entries to be deleted is either 0 or exceeds accountEntThresholdValue
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Enter cleanUpDeletedLinks
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside cleanUpEntitlement2ByEntType
2024-06-21T13:59:08+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entitlements2 deleteQuery = select e2.ENT2KEY from Entitlements2 e2 inner join Entitlement_values ev1 on e2.ENTITLEMENT_VALUE1KEY=ev1.ENTITLEMENT_VALUEKEY inner join Entitlement_values ev2 on e2.ENTITLEMENT_VALUE2KEY=ev2.ENTITLEMENT_VALUEKEY inner join Entitlement_types et1 on ev1.ENTITLEMENTTYPEKEY=et1.ENTITLEMENTTYPEKEY inner join Entitlement_types et2 on ev2.ENTITLEMENTTYPEKEY=et2.ENTITLEMENTTYPEKEY where et1.ENTITLEMENTTYPEKEY in(3068) and et2.ENTITLEMENTTYPEKEY in(3068) and (e2.JOB_ID is not null and e2.JOB_ID <> '3194411')
2024-06-21T13:59:09+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside cleanUpEntitlementMapLink
2024-06-21T13:59:09+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-EntitlementMap deleteQuery = select emap.ENTITLEMENT_VALUE1KEY, emap.ENTITLEMENT_VALUE2KEY from EntitlementMap emap inner join Entitlement_values ev1 on emap.ENTITLEMENT_VALUE1KEY = ev1.ENTITLEMENT_VALUEKEY inner join Entitlement_values ev2 on emap.ENTITLEMENT_VALUE2KEY = ev2.ENTITLEMENT_VALUEKEY inner join Entitlement_types et1 on ev1.ENTITLEMENTTYPEKEY = et1.ENTITLEMENTTYPEKEY inner join Entitlement_types et2 on ev2.ENTITLEMENTTYPEKEY = et2.ENTITLEMENTTYPEKEY where et1.ENTITLEMENTTYPEKEY in(3068) and et2.ENTITLEMENTTYPEKEY in(3068) and emap.JOB_ID is not null and emap.JOB_ID <> '3194411'
2024-06-21T13:59:09+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside cleanUpEntMappingInfoField
2024-06-21T13:59:09+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entitlements Mapping InfoField deleteQuery = update entitlement_values ev inner join entitlement_types et on ev.ENTITLEMENTTYPEKEY = et.ENTITLEMENTTYPEKEY set entitlementMappingJson = null where et.ENDPOINTKEY = 2200
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-called executeGetRequestWithHeaders for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-after calling executeRequestWithHeaders for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-called api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-timeout validated for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-got response for api...
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - responseStatusCode ::200
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entered getResponseHeaders method
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-responseError : null
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-isAuthError: false
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - responseMap.size : 1
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - objectList.size : 100
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside importAccessFull:persistEntObjects, pptTypeSep : ~#~
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-secondaryEntTypeImportConfig: null
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageSizeParam value : per_page
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageSize value : 100
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageNumberParam value : page
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-totalCount: 15337
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageNumber: 101
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside pullObjectsByRest
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-calling executeRequestWithTimeoutConfig for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-calling api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-before calling executeRequestWithHeaders for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-isFipsEnabled = false
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-getHttpClient - proxyParams : null
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-getHttpClient - sslSocketFactory : null
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-setting connection timeout to 10 seconds and request timeout to 60 seconds
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-getHttpClient - HttpClientBuilder.create().build() called.
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-called executeGetRequestWithHeaders for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-after calling executeRequestWithHeaders for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-called api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-timeout validated for api...
2024-06-21T13:59:06+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-got response for api...
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - responseStatusCode ::400
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entered getResponseHeaders method
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-responseError : null
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-isAuthError: false
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - responseMap.size : 2
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - objectList.size : null
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-secondaryEntTypeImportConfig: null
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageSizeParam value : per_page
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageSize value : 100
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageNumberParam value : page
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-totalCount: null
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageNumber: 102
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-paginationParam.doBreak: true
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside importAccessFull:persistEntObjects, pptTypeSep : ~#~
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-calling buildEntitlementMappings..
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside RestProvisioiningService.buildEntitlementMappings
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-called fetchEntitlementTypesFromEntMappingParams..entTypesMap = [Device:3068]
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-calling processAccountEntitlementParams - memento.entTypesSet : [3068]
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside processAccountEntitlementParams*****
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-inside processAccountEntitlementsByAccToEntMappings
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-populate userMap query: select new Map(u.username as username, u.id as id) from Users u where u.statuskey = 1 and u.userSource in ('314')
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-acctEntSql: select new Map(acc.accountID as accountID, acc.id as id, acc.customproperty31 as mappings) from Accounts acc where acc.endpointkey.id = 2200 and ( acc.status = '1' or acc.status = 'Manually Provisioned' ) and acc.customproperty31 is not null and acc.customproperty31 != '{}' and acc.customproperty31 != '[]'
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-delete inactive account linking: true
2024-06-21T13:59:06+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Inside deleteAccountEntitlementsByEntType
2024-06-21T13:59:05+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-called executeGetRequestWithHeaders for api...
2024-06-21T13:59:05+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-after calling executeRequestWithHeaders for api...
2024-06-21T13:59:05+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-called api...
2024-06-21T13:59:05+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-timeout validated for api...
2024-06-21T13:59:05+05:30-ecm-worker-services.HttpClientUtilityService-quartzScheduler_Worker-6-wg44j-DEBUG-got response for api...
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - responseStatusCode ::200
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-Entered getResponseHeaders method
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-responseError : null
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-isAuthError: false
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - responseMap.size : 1
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-pullObjectsByRest - objectList.size : 100
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestProvisioningService-quartzScheduler_Worker-6-wg44j-DEBUG-secondaryEntTypeImportConfig: null
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageSizeParam value : per_page
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageSize value : 100
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageNumberParam value : page
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-totalCount: 15337
2024-06-21T13:59:05+05:30-ecm-worker-rest.RestUtilService-quartzScheduler_Worker-6-wg44j-DEBUG-pageNumber: 100

[rushikeshvartak]

pullObjectsByRest - responseStatusCode ::400

It seems URL is not well formed