Hello
While trying to connect Adalo with an Oracle database through External Collections; I keep running into authentication failures & formatting issues. 
Even after exposing a RESTful API from Oracle; Adalo either fails to fetch the data or throws vague errors during query setup.
I have double-checked headers & endpoint structures but the data isn’t populating inside my app. 
Has anyone successfully connected Adalo to an Oracle backend? If so; how did you configure your endpoints & handle things like pagination / filtering in a way that worked with Adalo’s expected format? 
I am especially curious if any extra middleware / JSON reshaping was needed to make things work smoothly. Checked External Collections with APIs | Adalo Resources guide related to this for reference.
In the process of debugging; I revisited what is pl sql, since understanding Oracle’s procedural logic has helped me interpret the behavior of the responses and optimize how queries are executed behind the scenes.
Thank you !!