Flat file account status logic location?

[pattabhi (Pattabhi Nandarapu)]

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"
  }
]