Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/07/2023 10:35 AM
Hi ,
We have setup a salesforce connector and provided the below filter query. The account recon job is executed successful however when we run access recon issue we are getting below error message.
Error::InvalidBatch : Failed to process query: MALFORMED_QUERY: unexpected token: 'username'
OBJECT_TO_BE_IMPORTED: Account,Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense
ACCOUNT_FILTER_QUERY:(Profile.name IN ('profile1','profile2') and (NOT Username like '%@xyz%'))
ACCOUNT_FIELD_QUERY:Id, Username, LastName, FirstName, Name, CompanyName, Email, IsActive, UserRoleId, ProfileId, UserType, ManagerId, LastLoginDate,LastPasswordChangeDate, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp,AccountId, FederationIdentifier, CallCenterId, UserPermissionsSupportUser, Country, CommunityNickname, TimeZoneSidKey, LocaleSidKey,Emp_UserType__c
FIELD_MAPPING_JSON:
{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty3": "CompanyName~#~char",
"customproperty4": "Email~#~char",
"customproperty10": "IsActive~#~bool",
"customproperty5": "UserRoleId~#~char",
"customproperty6": "ProfileId~#~char",
"accounttype": "UserType~#~char",
"customproperty7": "ManagerId~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"creator": "CreatedById~#~char",
"customproperty8": "LastModifiedDate~#~date",
"updateUser": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date",
"customproperty11": "AccountId~#~char",
"customproperty13": "FederationIdentifier~#~char",
"customproperty20": "UserPermissionsSupportUser~#~bool",
"customproperty23": "Country~#~char",
"customproperty27": "CommunityNickname~#~char",
"customproperty30": "CallCenterId~#~char",
"customproperty31": "TimeZoneSidKey~#~char",
"customproperty32": "LocaleSidKey~#~char",
"customproperty33": "Emp_UserType__c~#~char"
}
}
10/08/2023 11:27 AM - edited 10/08/2023 11:31 AM
1. Are you getting response from postman using this query?
2. Also to isolate the issue pls try the without not keyword.
3. without braces
10/08/2023 06:45 PM
Hi @nimitdave Please find my response inline. The job is failing only when we run access recon Job. The issue only seems to be with not like condition, It is important for us to exclude users which contain "xyz" Do we have any alternate solution for this in salesforce OOTB?
1. Are you getting response from postman using this query? Tried the below in postman but not getting response However we have been able to reconcile the accounts successful in saviynt. The job is failing only when we run access recon Job.
https://xxx.salesforce.com/services/data/v57.0/query?q=Select Id, Username from User where NOT Username like '%@xyz%'
2. Also to isolate the issue pls try the without not keyword. : Without not like keyword condition both Account and Access job execute successful
3. without braces : Tried without braces still the same error
10/08/2023 09:31 PM
@Anu , please create a support ticket and and provide this forum link in that. also Pls attach below:
1. all connector jsons
2. complete logs for account and access import.
3. logs for access import with not and without not keyword.
10/09/2023 05:59 AM
@nimitdave Thanks for your response. We have created the ticket and provided the required details . Awaiting response.
https://saviyntsupport.saviynt.com/support/tickets/2004303 |