Sav4Sav import not importing users information which assigned manually

[VijayMaram]

Hi Team,

We are adding users to savroles (ROLE_ADMIN & ROLE_MANAGER) manually and then we ran account import job using Sav4Sav. But we observe only ROLE_ADMIN is getting mapped to account and not the other savrole.

When we add savroles to users using ARS process and we ran import. Then we see association.

Is there any configuration i am missing here.

[NM]

Hi @VijayMaram , can you share your accountimportjson

[VijayMaram]

Hi @NM 

Thanks for your quick response. 

Below is the JSON we are using.

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
1
],
"deleteLinks": false,
"accountThresholdValue": 100,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://*********-dev.saviyntcloud.com/ECM/api/v5/user?q=accountExpired:0&fields=username,email,displayname,statuskey&sort=username&order=desc",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "username~#~char",
"name": "username~#~char",
"displayName": "displayname~#~char",
"customproperty2": "email~#~char",
"customproperty11": "statuskey~#~char",
"status": "active~#~char"
},
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 500,
"totalCountPath": 999999999
}
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"SAVRoles": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://*********-dev.saviyntcloud.com/ECMv6/api/userms/savroles",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET",
"successResponses": {
"statusCode": [
200,
201
]
}
},
"listField": "savroles",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "ROLENAME~#~char",
"entitlement_value": "ROLENAME~#~char"
}
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"SAVRoles": {
"call": {
"call1": {
"connection": "userAuth",
"acctKeyField": "accountID",
"processingType": "httpEntToAcct",
"listField": "users",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpMethod": "GET",
"url": "https://*********-dev.saviyntcloud.com/ECMv6/api/userms/savroles/${id}/users?limit=1000&offset=0",
"httpContentType": "application/json"
},
"entKeyField": "entitlementID",
"acctIdPath": "username",
"pagination": {
"offset": {
"offsetParam": "startIndex",
"batchParam": "limit",
"batchSize": 1000,
"totalCountPath": "completeResponseMap.totalResults"
}
}
}
}
}
}
}
}

[NM]

Hi @VijayMaram , do you see the the user coming in via postman??

[VijayMaram]

Hi @NM 

Yes, as i mentioned above if i add user to savrole manually then i don't see data.
But when i add SAVROLE to users using ARS then we were able to see the data.

[rushikeshvartak]

Does running api from postman shows data?

[VijayMaram]

Hi @rushikeshvartak  and @NM 

Yes, we are using SOAPUI and we were able to see the data. But we observe only 500 records are coming and it looks like pagination issue.

Can you please review below JSON, any changes can help here? 

I have tried multiple combination here. but every time i am getting only 500 records.
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 500,
"totalCountPath": "completeResponseMap.total"
}
}

---------------------------------------------

{
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"statusColumn": "customproperty11",
"activeStatus": [
1
],
"deleteLinks": false,
"accountThresholdValue": 100,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": true,
"deleteAccEntForActiveAccounts": true
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://*********n-dev.saviyntcloud.com/ECM/api/v5/user?q=accountExpired:0&fields=username,email,displayname,statuskey&sort=username&order=desc",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "results",
"keyField": "accountID",
"colsToPropsMap": {
"accountID": "username~#~char",
"name": "username~#~char",
"displayName": "displayname~#~char",
"customproperty2": "email~#~char",
"customproperty11": "statuskey~#~char",
"status": "active~#~char"
},
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 500,
"totalCountPath": 999999999
}
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"SAVRoles": {
"entTypeOrder": 0,
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "https://*********n-dev.saviyntcloud.com/ECMv6/api/userms/savroles",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET",
"successResponses": {
"statusCode": [
200,
201
]
}
},
"listField": "savroles",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlementID": "ROLENAME~#~char",
"entitlement_value": "ROLENAME~#~char"
}
}
}
}
}
},
"acctEntParams": {
"entTypes": {
"SAVRoles": {
"processingType": "httpEntToAcct",
"call": {
"call1": {
"connection": "userAuth",
"acctKeyField": "accountID",
"processingType": "httpEntToAcct",
"listField": "users",
"http": {
"httpHeaders": {
"Authorization": "${access_token}"
},
"httpMethod": "GET",
"url": "https://*********n-dev.saviyntcloud.com/ECMv6/api/userms/savroles/${id}/users?limit=1000",
"httpContentType": "application/json"
},
"entKeyField": "entitlementID",
"acctIdPath": "username",
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 500,
"totalCountPath": "completeResponseMap.total"
}
}
}
}
}
}
}
}

[rushikeshvartak · Accepted solution]

Try below

"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 500,
"totalCountPath": 99999
}
}