Click HERE to see how Saviynt Intelligence is transforming the industry.
|
Click HERE to see how Saviynt Intelligence is transforming the industry.
|
10/21/2023
01:13 AM
- last edited on
10/22/2023
08:04 AM
by
Sunil
I am getting below error in acctent import but same json is working in lower environment
i am using below json
{ "accountParams": { "unsuccessResponses": { "message": "", "response": "", "statusCode": [ null, 400, 401, 403, 404, 405, 409, 429, 500, 503 ] }, "includeExistingInActiveAccounts": true, "doNotChangeIfFailed": true, "connection": "userAuth", "processingType": "SequentialAndIterative", "call": { "call1": { "callOrder": 0, "stageNumber": 0, "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://removed.com/v1/users?pageSize=10000&filter=isActive%20eq%20true ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "keyField": "name", "colsToPropsMap": { "status": "isActive~#~char", "name": "loginId~#~char", "accountID": "id~#~char", "displayName": "fullName~#~char", "customproperty1": "email~#~char", "customproperty2": "isActive~#~bool", "customproperty3": "defaultRoleId~#~char", "customproperty4": "id~#~char", "customproperty5": "annualHours~#~char", "customproperty6": "jobTitle~#~char", "customproperty7": "phoneNumber~#~char", "customproperty8": "referenceField1~#~char", "customproperty9": "referenceField2~#~char", "customproperty10": "referenceField3~#~char", "customproperty11": "supervisor~#~char", "customproperty12": "timeZoneId~#~char", "customproperty13": "allowUserMentions~#~bool" } } } }, "entitlementParams": { "connection": "userAuth", "doNotChangeIfFailed": true, "processingType": "SequentialAndIterative", "entTypes": { "Roles and Products": { "entTypeOrder": 0, "call": { "call1": { "callOrder": 0, "stageNumber": 0, "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://removed.com/v1/roles ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "keyField": "entitlementID", "colsToPropsMap": { "entitlementID": "id~#~char", "entitlement_value": "name~#~char" } } } }, "Teams": { "entTypeOrder": 1, "call": { "call1": { "callOrder": 0, "stageNumber": 0, "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://removed.com/v1/teams ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "keyField": "entitlementID", "colsToPropsMap": { "entitlementID": "id~#~char", "entitlement_value": "name~#~char", "customproperty1": "uniqueCode~#~char" } } } }, "Entities": { "entTypeOrder": 2, "call": { "call1": { "callOrder": 0, "stageNumber": 0, "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://remved.com/v1/mdm/entities ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "keyField": "entitlementID", "colsToPropsMap": { "entitlementID": "id~#~char", "entitlement_value": "name~#~char", "customproperty1": "uniqueCode~#~char" } } } } } }, "acctEntParams": { "connection": "userAuth", "entTypes": { "Teams": { "call": { "call1": { "callOrder": 0, "stageNumber": 0, "processingType": "httpAcctToEnt", "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://removed.com/v1/users/${id}/teams ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "entKeyField": "entitlementID", "entIdPath": "id", "acctKeyField": "accountID" } } }, "Entities": { "call": { "call1": { "callOrder": 0, "stageNumber": 0, "processingType": "httpAcctToEnt", "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://removed.com/v1/users/${id}/entities ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "entKeyField": "entitlement_value", "entIdPath": "name", "acctKeyField": "accountID" } } }, "Roles and Products": { "call": { "call1": { "callOrder": 0, "stageNumber": 0, "processingType": "httpAcctToEnt", "http": { "httpHeaders": { "Authorization": "${access_token}" }, "url": "https://removed.com/v1/users/${id}/roles-products ", "httpContentType": "application/json", "httpMethod": "GET" }, "listField": "items", "entKeyField": "entitlement_value", "entIdPath": "role.name+' '+product.name", "acctKeyField": "accountID" } } } } } }
[This message has been edited by moderator to merge reply comment]
10/22/2023 05:54 PM
It seems this is blackline application, you can't concat 2 values in EntID
{
"accountParams": {
"unsuccessResponses": {
"message": "",
"response": "",
"statusCode": [
null,
400,
401,
403,
404,
405,
409,
429,
500,
503
]
},
"includeExistingInActiveAccounts": true,
"doNotChangeIfFailed": true,
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://removed.com/v1/users?pageSize=10000&filter=isActive%20eq%20true ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "name",
"colsToPropsMap": {
"status": "isActive~#~char",
"name": "loginId~#~char",
"accountID": "id~#~char",
"displayName": "fullName~#~char",
"customproperty1": "email~#~char",
"customproperty2": "isActive~#~bool",
"customproperty3": "defaultRoleId~#~char",
"customproperty4": "id~#~char",
"customproperty5": "annualHours~#~char",
"customproperty6": "jobTitle~#~char",
"customproperty7": "phoneNumber~#~char",
"customproperty8": "referenceField1~#~char",
"customproperty9": "referenceField2~#~char",
"customproperty10": "referenceField3~#~char",
"customproperty11": "supervisor~#~char",
"customproperty12": "timeZoneId~#~char",
"customproperty13": "allowUserMentions~#~bool"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"doNotChangeIfFailed": true,
"processingType": "SequentialAndIterative",
"entTypes": {
"Roles and Products": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://removed.com/v1/roles ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char"
}
}
}
},
"Teams": {
"entTypeOrder": 1,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://removed.com/v1/teams ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"customproperty1": "uniqueCode~#~char"
}
}
}
},
"Entities": {
"entTypeOrder": 2,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://remved.com/v1/mdm/entities ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "id~#~char",
"entitlement_value": "name~#~char",
"customproperty1": "uniqueCode~#~char"
}
}
}
}
}
},
"acctEntParams": {
"connection": "userAuth",
"entTypes": {
"Teams": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://removed.com/v1/users/${id}/teams ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"entKeyField": "entitlementID",
"entIdPath": "id",
"acctKeyField": "accountID"
}
}
},
"Entities": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://removed.com/v1/users/${id}/entities ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"entKeyField": "entitlement_value",
"entIdPath": "name",
"acctKeyField": "accountID"
}
}
},
"Roles and Products": {
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"processingType": "httpAcctToEnt",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"url": "https://removed.com/v1/users/${id}/roles-products ",
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"entKeyField": "entitlement_value",
"entIdPath": "role.name+' '+product.name",
"acctKeyField": "accountID"
}
}
}
}
}
}
Refer blackline Integration Guide -https://forums.saviynt.com/t5/community-sourced-integrations/blackline-integration-guide/ta-p/32755
10/22/2023 11:43 PM
Hi Rishi
I tried below json as well but still i am getting this error-
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestUtilService - pullObjectsByRest - responseStatusCode ::200\n","stream":"stdout","time":"2023-10-22T11:03:33.562239626Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - Entered getResponseHeaders method\n","stream":"stdout","time":"2023-10-22T11:03:33.562511839Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - responseError : null\n","stream":"stdout","time":"2023-10-22T11:03:33.562515322Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - isAuthError: false\n","stream":"stdout","time":"2023-10-22T11:03:33.56253951Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - pullObjectsByRest - responseMap.size : 4\n","stream":"stdout","time":"2023-10-22T11:03:33.562553121Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - pullObjectsByRest - objectList.size : 7\n","stream":"stdout","time":"2023-10-22T11:03:33.562556085Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,562 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - Exception in processAccountEntitlementsCallByHttpAcctToEnt - try2 :\n","stream":"stdout","time":"2023-10-22T11:03:33.571671804Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"groovy.lang.MissingMethodException: No signature of method: com.saviynt.provisoning.rest.RestProvisioningService.processObjectListForAccEntCallByHttpAcctToEnt() is applicable for argument types: (java.util.LinkedHashMap, java.util.HashMap, null, null, java.util.LinkedHashMap) values: [[pagination:null, showJobHistory:null, http:[...], ...], ...]\n","stream":"stdout","time":"2023-10-22T11:03:33.571689019Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementsCallByHttpAcctToEnt(RestProvisioningService.groovy:7532)\n","stream":"stdout","time":"2023-10-22T11:03:33.571692284Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementsByCallTypes(RestProvisioningService.groovy:7881)\n","stream":"stdout","time":"2023-10-22T11:03:33.571695044Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementParams(RestProvisioningService.groovy:6398)\n","stream":"stdout","time":"2023-10-22T11:03:33.571697245Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterative(RestProvisioningService.groovy:300)\n","stream":"stdout","time":"2023-10-22T11:03:33.57169936Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFull(RestProvisioningService.groovy:168)\n","stream":"stdout","time":"2023-10-22T11:03:33.571701583Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:142)\n","stream":"stdout","time":"2023-10-22T11:03:33.571703751Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:229)\n","stream":"stdout","time":"2023-10-22T11:03:33.571705727Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:210)\n","stream":"stdout","time":"2023-10-22T11:03:33.57170806Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at org.quartz.core.JobRunShell.run(JobRunShell.java:199)\n","stream":"stdout","time":"2023-10-22T11:03:33.571718272Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"\u0009at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)\n","stream":"stdout","time":"2023-10-22T11:03:33.571720371Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,588 [quartzScheduler_Worker-2] DEBUG services.HttpClientUtilityService - called api...\n","stream":"stdout","time":"2023-10-22T11:03:33.588303139Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,588 [quartzScheduler_Worker-2] DEBUG services.HttpClientUtilityService - timeout validated for api...\n","stream":"stdout","time":"2023-10-22T11:03:33.588319697Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,588 [quartzScheduler_Worker-2] DEBUG services.HttpClientUtilityService - got response for api...\n","stream":"stdout","time":"2023-10-22T11:03:33.588322528Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,588 [quartzScheduler_Worker-2] DEBUG services.HttpClientUtilityService - calling executeRequestWithTimeoutConfig for api...\n","stream":"stdout","time":"2023-10-22T11:03:33.588599045Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,588 [quartzScheduler_Worker-2] DEBUG services.HttpClientUtilityService - calling api...\n","stream":"stdout","time":"2023-10-22T11:03:33.588609841Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,588 [quartzScheduler_Worker-2] DEBUG services.AdImportService - rangeFilter member;range=18000-19499\n","stream":"stdout","time":"2023-10-22T11:03:33.588635079Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - Inside pullObjectsByRest\n","stream":"stdout","time":"2023-10-22T11:03:33.592856356Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG rest.RestProvisioningService - \n","stream":"stdout","time":"2023-10-22T11:03:33.592867659Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - calling executeRequestWithTimeoutConfig for api...\n","stream":"stdout","time":"2023-10-22T11:03:33.592879968Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - calling api...\n","stream":"stdout","time":"2023-10-22T11:03:33.592884968Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - before calling executeRequestWithHeaders for api...\n","stream":"stdout","time":"2023-10-22T11:03:33.592918052Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - isFipsEnabled = false\n","stream":"stdout","time":"2023-10-22T11:03:33.592923619Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - getHttpClient - sslParams : null\n","stream":"stdout","time":"2023-10-22T11:03:33.592955392Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - getHttpClient - proxyParams : null\n","stream":"stdout","time":"2023-10-22T11:03:33.592959693Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,592 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - getHttpClient - sslSocketFactory : null\n","stream":"stdout","time":"2023-10-22T11:03:33.592961832Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,612 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - setting connection timeout to 10 seconds and request timeout to 60 seconds\n","stream":"stdout","time":"2023-10-22T11:03:33.612176582Z"}"
"ecm-worker","2023-10-22T11:03:34.219+00:00","{"log":"2023-10-22 11:03:33,612 [quartzScheduler_Worker-10] DEBUG services.HttpClientUtilityService - getHttpClient -
