Import Account with entitlements

[srinath]

Hi Team/ @rushikeshvartak / @Sivagami / @Manu269 

We have seperate API to pull users membership for Grafana API but when we are trying to use "httpEntToAcct" processing type to pull user membership we are unable to pull the user membership to reconcile. Here is the response of the grafana

uri/api/teams/8/members

Could you please help on the requirement. @rushikeshvartak

[sahil]

Can you confirm which field will hold the Entitlement value based on the screenshot. Also, in case a user has multiple entitlements assigned, how would they be visible in response.

[srinath]

Hi @sahil ,

URL/api/teams/16/members -- here 16 is is the entitlement ID. and also in response you will see teamId. for each entitlement we have to pull users memebership.

[rushikeshvartak]

"acctEntMappingInfoColumnFromEnt": "STORE#ACC#ENT#MAPPINGINFO~#~char"

This should be customproperty31

[srinath]

Hi @rushikeshvartak ,

I am able to see the response but i see the value is empty. from logs i am seeing acckey is null.

2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - ACCKEY:null;ENTVALKEY:95344

and this is total response from the logs. Any help

2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Calling Webservice Url - https://dev-grafana.lotuss.com/api/teams/8/members with httpParams - null
2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG services.HttpClientUtilityService - isFipsEnabled = false
2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG services.HttpClientUtilityService - getHttpClient - sslParams : null
2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG services.HttpClientUtilityService - getHttpClient - proxyParams : null
2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG services.HttpClientUtilityService - getHttpClient - sslSocketFactory : null
2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG services.HttpClientUtilityService - setting connection timeout to 10 seconds and request timeout to 60 seconds
2023-06-05 13:46:33,330 [quartzScheduler_Worker-8] DEBUG services.HttpClientUtilityService - getHttpClient - HttpClientBuilder.create().build() called.
2023-06-05 13:46:33,443 [https-jsse-nio-443-exec-97] DEBUG domain.FlatViewJobcontrolController - Inside fireJobAction params = [triggername:Grafana_Account_Import, triggergroup:GRAILS_JOBS, jobname:SapImportJob, jobgroup:DATA, actn:6, job_name:, job_group:, controller:flatViewJobcontrol, action:fireJobAction]
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestUtilService - Got showLogs = true
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Got Webservice API Response: [headers:[Date: Mon, 05 Jun 2023 13:46:33 GMT, Content-Type: application/json, Transfer-Encoding: chunked, Connection: keep-alive, cache-control: no-store, x-content-type-options: nosniff, x-frame-options: deny, x-xss-protection: 1; mode=block, x-envoy-upstream-service-time: 97, CF-Cache-Status: DYNAMIC, Server: cloudflare, CF-RAY: 7d28dcc66d283e1d-SIN], responseText:[{"orgId":1,"teamId":8,"userId":1,"auth_module":"","email":"admin@localhost","name":"","login":"admin","avatarUrl":"/avatar/46d229b033af06a191ff2267bca9ae56","labels":[],"permission":4},{"orgId":1,"teamId":8,"userId":27,"auth_module":"","email":"Test.Srinath@devglobal.lotuss.org","name":"Test Srinath","login":"Test.Srinath@devglobal.lotuss.org","avatarUrl":"/avatar/377f7a37c472012bf8e5112f4cdbb70f","labels":[],"permission":0},{"orgId":1,"teamId":8,"userId":33,"auth_module":"","email":"srinath@securiag.co.uk","name":"Anacle TestOne","login":"TH14000457","avatarUrl":"/avatar/5b1aacbbb8fdc6c1a60ce7d30050f739","labels":[],"permission":0},{"orgId":1,"teamId":8,"userId":14,"auth_module":"oauth_generic_oauth","email":"srinath.b@devglobal.lotuss.org","name":"Srinath B","login":"TH20000081","avatarUrl":"/avatar/9b23f20e65cea5f5ffd7d5070e2b8cff","labels":[],"permission":0}], cookies:[], statusCode:200]
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestUtilService - pullObjectsByRest - responseStatusCode ::200
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Entered getResponseHeaders method
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - responseError : null
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - isAuthError: false
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 1
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : 4
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - ACCKEY:null;ENTVALKEY:95344
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - ACCKEY:null;ENTVALKEY:95344
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - ACCKEY:null;ENTVALKEY:95344
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - inside processAccountEntitlements
2023-06-05 13:46:33,503 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - ACCKEY:null;ENTVALKEY:95344
2023-06-05 13:46:33,614 [quartzScheduler_Worker-8] DEBUG rest.RestProvisioningService - Inside pullObjectsByRest

[sahil]

In your JSON you have defined acctIdPath as user_id where as based on your postman screenshot, the value should be userId. Can you update the same in your JSON and then try,

[srinath · Accepted solution]

Hi Sahil,

I am using right values but i found the issue and figure out and fixed on own.

However thanks for your imputs.

[sahil]

Can you confirm what was the fix.