You need to place a “Translator” within your app’s code.
Where to place it: Exactly when your app is receiving data from the AppSheet API.
The Translator’s job: It will quickly convert the data.
If it receives Y, it will tell the app, “This is actually true.”
If it receives N, it will tell the app, “This is actually false.”
By doing this, the data will arrive in your expected true/false format before it is processed inside your app, and you won’t face any compatibility issues.