Salesforce Access Import Failure and New account error

[cdavis2]

When importing Salesforce Access it is failing due to the following error:

Error in getResultId

Cannot get property 'result' on null object

Due to the above error I believe it is also what is causing issues with provisioning new users.

Error in creating user = Erro 

See logs attached

[rushikeshvartak]

• Does connection is working.
• Does it working on postman ?

[cdavis2]

The test connection works fine in fact it pulls in all the accounts no problem but access is where it errors. Its not an error to where nothing gets pulled in the entitlements still come in as well but I cant pinpoint what is causing the error to show up.

[rushikeshvartak]

• Please share connection configs

[cdavis2]

object_to_be_imported : Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense,FeatureLicense,Folder,Document,Attachment,PermissionSetGroup,PackageLicense

createaccoutnjson: {
"Username": "${user.email.toLowerCase()}".qa,
"Alias": "${user.firstname.toString().substring(0,1)}${user.lastname.toString().substring(0,4)}",
"LastName": "${user.lastname}",
"FirstName": "${user.firstname}",
"CompanyName": "${user.orgunitid}",
"Department": "${user.departmentname}",
"Title": "${user.title}",
"Street": "${user.street}",
"City": "${user.city}",
"State": "${user.state}",
"PostalCode": "${user.customproperty19}",
"Country": "${user.country}",
"Email": "${user.email.toLowerCase()}",
"EmailPreferencesAutoBcc": true,
"EmailPreferencesAutoBccStayInTouch": false,
"EmailPreferencesStayInTouchReminder": true,
"FederationIdentifier": "${user.email.toLowerCase()}",
"Phone": "${user.secondaryPhone}",
"MobilePhone": "${user.phonenumber}",
"CommunityNickname": "${user.lastname}",
"IsActive": true,
"TimeZoneSidKey": "America/New_York",
"LocaleSidKey": "en_US",
"ReceivesInfoEmails": true,
"ReceivesAdminInfoEmails": true,
"EmailEncodingKey": "ISO-8859-1",
"LanguageLocaleKey": "en_US",
"EmployeeNumber": "${user.employeeid}",
"ProfileId":"${profileId}",
"UserPermissionsMarketingUser": false,
"UserPermissionsOfflineUser": false,
"UserPermissionsAvantgoUser": false,
"UserPermissionsCallCenterAutoLogin": false,
"UserPermissionsMobileUser": false,
"UserPermissionsSFContentUser": false,
"UserPermissionsInteractionUser": false,
"UserPermissionsSupportUser": false,
"ManagerId": "${managerAccount==null?'':managerAccount.accountID}"
}

fieldmapping: 

{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty3": "CompanyName~#~char",
"customproperty4": "Email~#~char",
"status": "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",
"customproperty9": "ContactId~#~char",
"customproperty10": "AccountId~#~char",
"customproperty13": "FederationIdentifier~#~char",
"customproperty20": "UserPermissionsSupportUser~#~bool",
"customproperty30": "IsActive~#~bool"

},
"profilefield_mapping": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"customproperty4": "UserLicenseId~#~char",
"customproperty1": "UserType~#~char",
"description": "Description~#~char",
"customproperty7": "CreatedDate~#~date",
"customproperty8": "CreatedById~#~char",
"customproperty2": "LastModifiedDate~#~date",
"customproperty9": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date"
}
}
}

statusthresholdconfig:

{
"statusAndThresholdConfig": {
"accountThresholdValue": 50,
"correlateInactiveAccounts": true,
"statusColumn": "customproperty30",
"activeStatus": [
"true"
],
"deleteLinks": true,
"lockedStatusColumn": "customproperty22",
"lockedStatusMapping": {
"Locked": [
"1"
],
"Unlocked": [
"0"
]
}
}
}

[rushikeshvartak]

"Username": "${user.email.toLowerCase()}".qa,

This is wrong 

"Username": "${user.email.toLowerCase().concat('.qa')}"

[cdavis2]

That fixed my provisioning issue but I am still receiving an error when I do a an access import for salesforce. 

[rushikeshvartak]

Try below objects

Profile,Group,PermissionSet,Role,Territory,PermissionSetLicense,FeatureLicense,Folder,CustomAndStandardObject,Document,Attachment,Account,Lead, Opportunity,Contact,Campaign,Case

[cdavis2]

I made the change and still getting the same results

[rushikeshvartak]

Try with less objects and validate