Database

User Signup Additional Fields
Hey everyone, I'm trying to add additional fields to my registration form during sign up and it's unclear as to how I should go about it. I'm using WeWeb as a front-end and looking for guidance for the proper workflow. Thank you in advance for any help provided!
Is it a bad practice to have a large list of json objects in a database table column?
Hi, My app does some inventory updates where some products are retrieved as json objects from an external api. I have a database table called "inventory update" which contains a column called "products_json" which is the list of all the products involved in that specific "inventory update" (so it is a list of json…
Can someone explain me how to use this Get record "lock" feature?
Hi, Can someone please explain how are we supposed to use this "lock" feature? If a function in an endpoint was going to edit a record but it was locked, how can I set a retry system that keeps trying until it finds the record unlocked, then it locks it again while it edits the record and unlocks it when finishes editing…
DB Backup/Restore Strategies
I know that Xano only supports full Instance backups for three days. This is helpful, but the backups revert everything, including function stacks in every branch. Curious to hear what approaches anyone is using to backup just their data and have the ability to restore in case of an issue. Some ideas our team had: Sign up…
Sync Xano Database with Firebase
Im currently doing a POC on various NoCode builders and Databases. I really like Xano (not decided on FFlow or DBit yet, FFlow is edging it) My questions are: (lets presume the cost is not relevant) Can I sync a Xano Table to Firestore, this way I get the Xano for my Items, Reference and Documents tables? (will be around 1…
How to save a changing response structure from external API in database?
Hello! I am trying to save a list of transactions from my bank account in my DB. For example: here you can see that there is one incoming (account top up) and one outgoing transaction (paying a utility bill). One of them has a creditor name (utility provider) and another one has a debtor name (my own account from which I…
Simultaneous multiple authentication sources for API
When requiring authentication for API endpoints, I saw you could set up and select any table, however, you can only choose one option. I have both a User and a Employee table. Some of my endpoints will be used for both my user and enterprise websites, so I want a way to have multiple simultaneous authentication sources.…
Google auth problems (also using WeWeb)
Hi, I am using the Google OAuth plugin to sign in/up with Xano, using WeWeb as my frontend. The process is partially successful, but I am still experiencing some bugs. The process successfully creates a new user in my User database, with google oauth info. However, it is failing in the /oauth/google/continue endpoint. Here…
Need Help with Xano Integration in Bubble - Query Parameter Issue
Hi everyone, I hope you're doing well. I'm currently facing an issue with integrating Xano into Bubble and could use some assistance. I've set up a process to retrieve user names using Xano's "Names" API endpoint, and I've added a query parameter called "search_query" to facilitate custom record queries. The strange thing…
How do I get the content of a .txt file stored in my database?
For example, I have a .txt file saved in my database and would like to get its content. How do I get it? I only see the following: {path, name, type, size, mime, meta, url}, no body for the .txt file.
In the database it is a list of JSON but in the function stack it says it requieres a JSON (no list)
Hi, I created a field in my database called "variant_errors" which is a list of json objects. However, when I try to push a json object to it, I see the "input requieres JSON. Currently set to any[]" message. See below: What am I doing wrong here? Thanks!
Add Records in 'random" database
Hello :) Today on Xano we only have the choice to "Add a Record" on a fix database in a API. By "fix" I mean that it is not possible to say: If the data is "abc", check the associated member and add the record in it's database. To do that we have to put an "Add Records" for each database targeted which is not practical at…
When should you create a new API instead of modifying an existing API?
Hey ya'll, An area I'm struggling with is how to determine making the call to either create a new API or modify an existing API. While it is relatively simple to create new APIs, the list of APIs just continues to grow. I'll paint a scenario for example sake. I've decided to have two user types - it will use the same user…
1-1 UNIQUE Field
I have a question regarding the UNIQUE field. Currently, I am using the free version of Xano, so I want to confirm if this feature is available in my plan. In my database, I have two tables - Order and Customer. Each customer is associated with only one order. The Order table contains a reference field (customer_id)…
What's the correct way to to include an Args in Direct Database Query?
Look at the example below, the idea is to find lease_id IN a lease_ids array, in the first case below I tried to format the lease_ids array into (39,38,137,84,144,185,187,189,191,66,146), which is the correct way to query in posgresql, result in an error: But when I directly type them in, no error occur: How can I include…
Database Suggestions
Hello, I have a project that currently just has a Webflow frontend, all of our data is in Airtable, and we are using Zapier automations to allow users to update this data from the frontend. However, we are working on creating a real backend using Xano and Wized, and I am trying to figure out the best solution for what to…
How do I create a QR code in a database?
I want to create a QR code for those who have bought tickets to events.
Can't add Timestamp greater than today
Hi guys, I can't add a timestamp record greater than today to a column, it keeps converting it to today's timestamp or less. What can I do?
Handling Non-Printable Characters and Blacklisting in Database Field Validation
Hi Xano community, I have two questions around data field validation. Recently, we undertook a penetration test which suggested we enforce stricter field validation, mostly to prevent cross-site scripting attacks. While Xano's "filter" feature has been helpful (see the bottom of this page on Xano's documentation), we have…
Possible bug with custom query AND condition
Hi, I posted a question in the "working with APIs" section, which nobody seems to have responded to for several days, about a potential bug with the "AND" condition being treated as an "OR". I have so far found this behaviour appears consistently in all tables with boolean conditions, at the very least. The only workaround…
Filtering using a custom query, unexpected handling of AND condition
Perhaps my logic is failing me here, but I'm struggling with what I would deem, a very basic function - that is to filter on two boolean fields, whilst allowing NULL. In essence, I have two fields: isActive, isTrial. For my GET API, these fields are both parameters that allow null. My goal is quite simple - allowing a NULL…
Querying a Database for Matching Element in Array
I have a large database. One of my fields is an array of text. I could easily juggle it around to be an array of objects or an array of some other type if it helps. I am wondering how to query the database to return only records that contain a defined search element. For example if a record had array: [text, dog, cat,…
database query with filter on field in an object
Hi ! Let's imagine a user database. This database has a list field of objects called "states". Each object has a state (int) and date (timestamp) field. This represents the user's status history. Is it possible to make a query that will directly filter users with a specific status on the most recent date? At the moment,…
Add the ability to access and use database meta data in the function stack.
Please, please add the ability to access and use database (tables, relationship, content, columns) meta data in the function stack instead of calling them from the api. We should be able to use them like every custom or inbuilt function. It would be great!👌. I imagine how quickly it can help my app to be able to easily…
How to store booking times effectively?
I am creating somewhat of a calendly alternative and I need people to be able to select the times that they are available for bookings. However, I am confused, about what type of field type I should use for something like this because the booking availability will have the person's normal weekly hours but then on a…
How to conditionally add a new record, when a null is present in the ID?
Hi All, fairly new here migrating to Xano, moving away from bubble.io thanks to their completely misguided pricing model changes. Having a few challenges trying to migrate some core parts of the DB into Xano. I come from a DBA background, so I'm quite comfortable with the underlying structure. My specific use case is that…
How to update all Records in a database without Query All
I have a large database(1.5 Million Records), and am wanting to go through and update a field for each of them. What would be the best way to do this given that Query All seems to be returning a memory issue. Thanks for any help! Edit: At the moment my plan is to update them in chunks, just curious if there is a better way?
Automating workflow on record creation or update
Hi, I just started using Xano and I'd like to learn if it's possible for me to trigger a workflow on the creation or update of a record in the database? One of my uses cases requires the data in a field to be used in an (external) API call to receive a response that can be saved in another field. For example: let's say I…
What is the ideal table structure, where courses have slide-based lessons with unique content types?
Hello everyone 👋, I'm new to Xano and working on a project which is about learning management system. I'm using Webflow + Wized + Xano. So here I have 2 tables "Courses" and "Lessons". Courses table will have list of course name and some more information about that course. Lessons table will have content for each course.…

Database

Discussion List