RW90Q: No Query in the API?
Am I correct to understand that the API does not offer any way to query the database? The endpoints list and docs I saw didn't show any way to retrieve a value for a specific record. E.g. "look up the value of 'phone number' for record with userid 'nef349'."
How would I do that with a database you are hosting?
Riya_NoCodeBackend
Sep 25, 2024A: Hi,
It gives you the APIs for all the endpoints. You can test this as well within the API documentation that gets generated for you automatically. You can test adding a record, deleting, updating and fetching. But querying the DB with conditions is not possible. This is more for a querying tool that lets you chat with it.
Our primary goal here is to enable you to get the APIs. Once you have them, you can do any complex queries outside with these API endpoints. For eg, use any automation tool like zapier, activepieces etc. Or simply create your own simple front end and display conditional data there.
What's I'm trying to convey is, you got the critical thing cracked here: the APIs. Sky is the limit what you can do post that.
Thanks
Not a query tool? If it’s a relational database, normalization is standard practice in order to reduce data redundancy and improve data integrity. For example we have three tables with ‘students’, ‘classes’ and ‘teachers’, it’s not possible to join them? No foreign keys etc?
Hi,
At the moment, it's not possible to join the tables, but replied a similar question where we mentioned that we are already on it and soon you can link tables using foreign key constant.
Thanks Riya for your reply.Is the (to be) developed ‘query tool’/‘the ability to linking tables with foreign keys’ part of this Appsumo deal?
Yes. Having foreign key in table is a core feature for any database. Once developed, it will be available as an option by default. Similar to how we currently have the option to make a column unique (which in the backend convert it to Primary key).