PARTNERS - Please join us for our upcoming webinar:
Leveraging Intelligent Recommendations for Operational Transformation.
AMS Partners Click HERE | EMEA/APJ Click HERE

Not getting full accounts from target application

MayurDighe
New Contributor
New Contributor

I am unable to import full accounts from the target application.  while 1st attempt succeeded in importing a few accounts(suspended and active), for full import; added pagination body in the same import account JSON, after adding the pagination body in JSON  accounts not imported and import job status showing SUCESSFULL. The postman is working fine for the same. 

Connection JSON 

{
"authentications": {
"acctAuth": {
"authType": "API Key",
"url": "
https://##############.###########.com/auth/token"
,
"httpMethod": "POST",
"httpParams": {
"api_key": "####################",
"api_secret": "##################"
},
"httpHeaders": {
"contentType": "application/json",
"Accept": "application/json"
},
"httpContentType": "application/json",
"expiryError": "ExpiredAuthenticationToken",
"authError": [
"InvalidAuthenticationToken"
],
"retryFailureStatusCode": [
401
],
"timeOutError": "Read timed out",
"errorPath": "error.code",
"maxRefreshTryCount": 5,
"tokenResponsePath": "access_token",
"tokenType": "Bearer",
"accessToken": "Bearer abcd"
}
}
}

 

 

Import Account JSON;

{
"accountParams":{
"connection":"acctAuth",
"processingType":"SequentialAndIterative",
"call":{
"call1":{
"callOrder":0,
"stageNumber":0,
"http":{
"url":"https://##########################/api/v2/users?limit=100",
"httpHeaders":{
"Authorization":"${access_token}",
"Content-Type":"application/json",
"Accept":"application/json"
},
"httpContentType":"application/json",
"httpMethod":"GET"
},
"listField":"data",
"keyField":"accountID",
"colsToPropsMap":{
"accountID":"id~#~char",
"name":"attributes.username~#~char",
"status":"attributes.active~#~char",
"customproperty4":"attributes.active~#~char"
},
"pagination":{
"offset":{
"offsetParam":"offset",
"batchParam":"limit",
"batchSize":100,
"totalCountPath":"5000"
}
}
}
}
}
}

STATUS_THRESHOLD_CONFIG

 

{
"statusColumn":"customproperty4",
"activeStatus":[
"active"
],
"deleteLinks":false,
"accountThresholdValue":2000,
"correlateInactiveAccounts":true,
"inactivateAccountsNotInFile":false,
"deleteAccEntForActiveAccounts":true
}

 

Import JOB result

 

MayurDighe_0-1714659565804.png

 

 

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Could you kindly provide a detailed snapshot of the information extracted from the logs, encompassing errors and other pertinent functionality details encountered during the execution of this process? Your assistance in furnishing this information would greatly aid in the analysis and resolution of any issues .


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.