Simplifying Database Structure and Creating APIs for Xano and Weweb
In this meeting, the participant is seeking guidance on setting up a custom Xano API to add records to their databases. They have two databases: one for users and one for cornerstones. The cornerstones database has an array field called "working ons" that is supposed to contain all the working on tasks associated with each cornerstone.
The consultant suggests modifying the data structure to have the working on tasks point to the cornerstones instead of having the cornerstones hold a list of working on tasks. This would simplify the database structure and make it easier to work with in the future.
They discuss how to create two separate API endpoints for creating cornerstones and working on tasks. They also talk about authentication and making sure users can only create cornerstones for themselves.
Next, they discuss how to retrieve all the working on tasks associated with a specific cornerstone. The consultant guides the participant on creating a custom query using Xano's database requests and setting up the necessary conditions based on the cornerstone and user IDs.
Overall, the meeting provides helpful insights on database structure, API creation, and data retrieval using Xano.