-
How can I link a single uploaded image to multiple records
The scenario is as follows: I have a field in a table for status Status can only have 2 values, active and inactive I have uploaded 2 icons to public files, one for active and the other for inactive How can I store the 'inactive' image against each record that is inactive? Alternatively, when creating an endpoint returning…
-
Error Loading Database
Has anyone received the below error when attempting to open a database? I receive it about 70% of the time a try to open one database in particular. "Http failure response for…
-
How to filter 39,000 records in a searchbox
Hi team, I am a beginner on Xano and Weweb and I would like to filter a table with more than 39 000 records in order to display cities in a searchbox on Weweb. Could you show me how to filter from Xano so that the Weweb editor doesn't crash by creating a Get API collection? Thanks in advance
-
Filter Database Query by 'Does not include those"
Hello dear No-Coders, I'm trying to query all records from a database where every item has a certain task ID, by providing all task IDs that I don't want to have outputted. So if I have a database with the tasks; 1A, 2B, 3C, 4D… and I provide the filter on 3C and 1A… - I would only get an array of 2B, 4D… back. But the IDs…
-
Only one database per workspace?
I'm totally new to Xano and would like to know, are you limited to one database per workspace? When I click on Dashboard and see my default workspace and its database, I don't see a way to create a second database in that workspace. If I'm creating two websites that use authentication, I would naturally want two databases…
-
Is it possible to get the most recent record for each group?
Hi everyone! I have a table candidate link to tables order and worker. Each line in this table candidate have different status like: I want to make a query all request filtered by "where order_id = input.order_id" to fetch only the candidates of a specific order. But I want to only have one record per worker_id so I can…
-
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…
-
How to delete Table in Database?
I'm ashemed to admit but I can't delete a table. I follow the instuction https://docs.xano.com/database/database/table-view#deleting-a-table but I can't find 3 dots in top right menu
-
I need help with making an API request in Xano
I'm trying to get the data from a file that is currently saved in my Xano database by making an API request. First, I make a query of the database with the files, next I get the file's url. I use the file's url in the API request using the GET method and settings the content-type's charset as "windows-1252" since the file…
-
Scaling Database to 130MM Records + Querying
Hello - I am considering using Xano to host a database of 130MM polygons. I'd like to query the database using "Query All Records" with a Custom Query where a specific point (lat, lng) is within one of the polygons (return the polygon the point resides in). My question - do you foresee issues working with a database of…
-
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!
-
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…
-
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…
-
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…
-
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…