Thanks, and thanks to everyone else.
I'll add a few things that could help if you're thinking of using this data for secure use-cases:
- Using
current_user.sidrather thanidwould seem to add a decent bit of additional security. Whereasidis an int that obviously can be easily guessed by an attacker,sidis a unique string. - In Settings -> Beta make sure to check "Prevent query variable spoofing" I think this feature was added in response to my question Is the current_user global secure? (Note to Retool -- this should be out of Beta, it's an important piece of security)
Along with IP whitelisting and of course users' needing to log in to Retool, hopefully this all creates some basic decent auth.