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.
Then you can add additional logic in your script to construct additional column to your feed file. I feel this way it is simple, no need to complicate much.
For some connectors like WebServices, we have below config, I wish the same for delimited file but unfortunately it is not available.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.