I’m actually developping a little OData API which will serve as source for our Appsheet apps,
and now I have to implement the authentication part.
When on Appsheet, select data source, OData, you can fill the OData API url and then a logon/password.
If I click “connect” only a GET https://odataurl/$metadata is sent by Appsheet.
I d’like to protect this by redirecting to an authentication URL which will wait for a POST user/password.
But how can I inform Appsheet on which url/ body content to use to get an authentication to my API ?
Is it usable as it ?
If not, I’ve read that Appsheet uses OAuth2, I can implement an OAuth2 authentication.
But in this case, which user token will be used to get a connection to my API, the Appsheet app creator token or the App user one ?
How are intended to be used the user/password fields in the OData connection screen ?