status attribute not available in Target application

[Prashant16]

Hi  All,

We have requirment that there is no status attribute available for Google Analytics on the application side. As a result, during reconciliation through the importAccountJson, all accounts are being marked with the status "Suspended from import."

To address this issue, could you please suggest a solution for importing users such that:

1. Active Users are imported successfully.
2. Inactive Users are handled appropriately if not found in the target system.

[NM]

Hi @Prashant16 , on the application end do we have inactive accounts?

Or Does it not return in api response?

[rushikeshvartak]

Please share postman screenshot and curl command [Refer https://codingnconcepts.com/postman/how-to-generate-curl-command-from-postman/ ]



⚠️‼️‼️Do not upload any attachments that contain sensitive information, such as IP Addresses, URLs, Company/Employee Names, Email Addresses, etc.‼️‼️⚠️

[Prashant16]

{
"name": "accounts/787987/accessBindings/AYVX2ezGfnBP9E-tIviLPm7Uv1js6rzJfCDyXg=",
"user": "Deleted user",
"roles": [
"predefinedRoles/editor"
]
},

[rushikeshvartak]

So user column decide user is active or bot not? If yes what are possible values

[Prashant16]

For Active accounts, it will be a mail for deleted account it will be "Deleted user"

[rushikeshvartak]

use status threshold configuration 
{
"statusAndThresholdConfig": {
"deleteLinks": true,
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"statusColumn": "customproperty1",
"inactiveStatus": [
"Deleted User"
]
}
}

[Prashant16]

i tried with below json by adding the threshold configuration as you suggested but still same all account status is "suspended from import".Please find below the JSON .


"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"deleteLinks": false,
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"statusColumn": "customproperty1",
"InactiveStatus": [
"Deleted User"
]
}
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "accountID",
"colsToPropsMap": {
"name": "userRef.email~#~char",
"accountID": "userRef.id~#~char",
"status": "Active~#~char"
}
}
}, 

[NM]

@Prashant16 try this

"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"statusAndThresholdConfig": {
"deleteLinks": false,
"accountThresholdValue": 100,
"correlateInactiveAccounts": true,
"inactivateAccountsNotInFile": false,
"statusColumn": "customproperty1",
"InactiveStatus": [
"Deleted User"
]
}
},
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "",
"httpHeaders": {
"Authorization": "${access_token}",
"Accept": "application/json"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "items",
"keyField": "accountID",
"colsToPropsMap": {
"name": "userRef.email~#~char",
"accountID": "userRef.id~#~char",
"customproperty1": "user~#~char"
}
}
},

[Prashant16]

HI @NM ,

I tried with above json but no luck 

[rushikeshvartak]

i is lower case inactiveStatus

[Prashant16]

Hi @rushikeshvartak  and @NM ,

I tried with above jsosn and Ihave successfully reconciled user accounts with an active status in the target application using the provided JSON configurations. However, I am encountering an issue where, during user provisioning through Saviynt, the status is initially set to "manually provisioned." After running the reconciliation job, the status changes to "SUSPENDED FROM IMPORT SERVICE."Can you please help me here 

[rushikeshvartak]

• Please share data analyzer screenshot for both accounts and csv extract
• share create account jSON from saviynt
• Share create account postman call screenshot with response

[NM]

Hi @Prashant16 that means it is creating new accounts check your account id is it matching?