REST - Accounts Import

[rushikeshvartak]

Hi 

Trying to fetch accounts from application, Below is error from Logs. Any inputs on possible reasons

Account JSON

Error :

Output from Postman

[sahajranajee]

Hi Rushikesh, 

404 would imply that the API endpoint itself is not found. Is the webservice you are trying to access, accessible from your Saviynt environment?

You can try including  a "testConnectionParams" block in your Connection JSON to validate a simple webservice call while Save and Test Connection to ensure that the connectivity works.

Example of the same can be found in our Connector guide:
https://saviynt.freshdesk.com/support/solutions/articles/43000521736-rest-connector-guide

[rushikeshvartak]

what will be keyfield, listfield & colsMapping in below case

[avinashchhetri]

What Sahaj is suggesting is to validate if your endpoint is reachable from Saviynt or not, At this point you need not worry about the specifics of the connector itself.

Regards,

Avinash Chhetri

[rushikeshvartak]

testConnectionParams

Http url giving proper error on UI

Https url. Showing 404 page not found. Trying to understand if server is reachable or not. Maybe SSL issue

[sagars]

@rushikeshvartak 

Your ListObject is wrong above. The Response you shared is in the image format so try something below or use JSON editor tool to understand the trace path. I believe the userid is sitting under "Viewlable" attribute. (This is just an example to give you a understanding). So try out path.

Listfield - objects.T_BASIC_USER.attributes.USER_ID.metamap

Columnstopropmap
"name" : "viewlabel"

Before going there 404 is the error you are getting so try this get user call in postman first to make sure there is no issue with reaching the target URL.

Also which application is this?

Regards,
Sagar Srikantaiah

[rushikeshvartak]

Keycloack Technology - Energy Credit Application.

404 - Error because of SSL , Added SSL into keystore

[rushikeshvartak]

here datavalue contains username

https://codebeautify.org/jsonviewer/y22398596 

[sagars]

@rushikeshvartak ,

Listfield = objects.T_BASIS_USER

colsToPropsMap = attributes.USER_ID.datavalue

Regards,
Sagar Srikantaiah

[rushikeshvartak]

"listField": "objects.T_BASIS_USER",
"keyField": "accountID",
"colsToPropsMap": {
"name": "attributes.USER_ID.datavalue~#~char"

2022-06-16/14:33:51.575 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseStatusCode ::200
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - Entered getResponseHeaders method
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - responseError : null
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - isAuthError: false
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 1
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : 1
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - Inside importAccountsFull:persistAccounts, pptTypeSep : ~#~
2022-06-16/14:33:51.576 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - Exception in persistAccounts try2 :
java.lang.NullPointerException

case 2 :

"listField": "objects.T_BASIS_USER",
"keyField": "accountID",
"colsToPropsMap": {
"name": "attributes.USER_ID[0].datavalue[0]~#~char"

try2 error & objectList.size gives all 139 records

2022-06-16/21:31:50.809 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 1
2022-06-16/21:31:50.809 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : 139
2022-06-16/21:31:50.809 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - Inside importAccountsFull:persistAccounts, pptTypeSep : ~#~
2022-06-16/21:31:50.809 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - Exception in persistAccounts try2 :
java.lang.NullPointerException
2022-06-16/21:31:50.809 [{}] [quartzScheduler_Worker-2] DEBUG rest.RestProvisioningService - Exception in persistAccounts try2 :
java.lang.NullPointerException

[Sharukh_Shaikh · Accepted solution]

Hi Rushikesh,

Please add the AccountID Field in the colsToPropsMap mapping.

Thanks,

Sharukh.