Where do you put this logic? Does it go in a rule or the account schema?
Refer to this topic for context: Account Status
The recent topic around account status, the account attribute name should be IIQDisabled type could be either String or boolean & accepted values true or false.
Note: In case your source contains 1 or 0 values then you need to use below logic to supply true or false to IIQDisabled:
The following SQL query can be used to set up the state for the account as explained in the document.
select ... case when Active=1 then 'false' else 'true' end as IIQDisabled from ...
The complete scenario tested & showcased below for your reference:
my account schema of Delimited Source
my source file
UI:
account details page:
Additional testing done through REST API call:
JSON:
{
"attributes": {
"IIQDisabled": "false",
"acctid": "123",
"acctname": "reddy"
}
}
account details page:
Similarly, the patch also working fine:
[
{
"op": "replace",
"path": "/attributes/IIQDisabled",
"value": "true"
}
]
Just create one more column in your CSV feed as IIQDisabled and pass true/false based on status or some relevant attribute.
Other way is you can make use of Build Map Rule, since it is cloud Rule, I won’t go for this.
Are you manually uploading the file BTW or using some script in automation mode ?
We are using a script to upload them.
As Krishna mentioned, define new account schema attribute IIQDisabled type: String or boolean.
Make sure the source file also has the IIQDisabled column with true or false values.
