Unable to import Accounts via REST

Sitarasmi
New Contributor III
New Contributor III

Hi Team,

We are using v 5.5 SP 3.17 and facing error while importing accounts via REST connection. Below are connection & ImportAccount jsons

Connection JSON

{
"authentications": {
"userAuth": {
"authType": "oauth2",
"url": "xx",
"httpMethod": "POST",
"httpParams": {
"client_id": "xx",
"client_secret": "xx",
"grant_type": "refresh_token",
"refresh_token": "xx"
},
"httpHeaders": {
"Content-Type": "application/x-www-form-urlencoded"
},
"httpContentType": "application/x-www-form-urlencoded",
"authError": [
"Unable to authenticate the client",
"Invalid OAuth token Bearer"
],
"retryFailureStatusCode": [
401,
403
],
"errorPath": "",
"maxRefreshTryCount": 5,
"tokenResponsePath": "access_token",
"refreshType": "RefreshToken",
"tokenType": "Bearer",
"accessToken": "Bearer abcd"
}
}
}

 

ImportAccount

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "account.status",
"activeStatus": [
"true"
],
"deleteLinks": true,
"accountThresholdValue": 5000,
"accountsInImportAction": "Active",
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "xx",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "records",
"keyField": "accountID",
"statusConfig": {
"active": "true",
"inactive": "false"
},
"colsToPropsMap": {
"accountID": "Id~#~char",
"name": "Name~#~char",
"displayName": "Name~#~char",
"customproperty11": "Status__c~#~char",
"customproperty12": "Email__c~#~char",
"customproperty30": "isActive__c~#~bool",
"customproperty31": "Title__c~#~char",
"customproperty32": "Line_Manager__c~#~char",
"customproperty33": "Grade__c~#~char",
"customproperty34": "Department__c~#~char"
},
"pagination": {
"nextUrl": {
"nextUrlPath": "${response?.completeResponseMap?.next_page==null?null:response.completeResponseMap.next_page}"
}
}
}
}
}
}

 

It works fine through POSTMAN. 

Failing in Saviynt - with Error-while-getting-Account-Import-Response-WebService-call-failed-with-responseStatusCode-null error.


Can anyone please check & guide.

 

Thanks,

Sitarasmi

 

2 REPLIES 2

naveenss
All-Star
All-Star

Hi @Sitarasmi 

Can you share the sample postman response? Also please add {"showLogs":true} in the configJSON and execute the account import job and share the logs for the same?

Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

Sitarasmi
New Contributor III
New Contributor III

Hi Naveen,

Thanks, we were providing wrong url , now its resolved.