-
Consequences of renaming a column?
Hello! I discovered one of my front end tools doesn't do well with capitalized fields. I have been using camelCase for my column names in Xano, and I realized the easiest fix would be to switch them to all lower case. However, Xano has an ominous warning saying "Renaming your column name will not preserve existing data."…
-
Datasource best practices
Hi all, i have a question about the best practice regarding managing datasources. By default, the datasource is live. If you create a datasource, by default it's named test. BUT, if i'm not mistaken, you can do schema modifications only in the live datasource while any modification impacts all the other datasources, only…
-
Moderating Post Data
I have a posts table for people to create posts. The table has a post title, description, and so forth. What are methods I can use to moderate this table, and ensure that there aren't any negative posts being uploaded?
-
How to use Magic Link for resetting password
I tried setting up and testing my endpoints for resetting a user's password through with Magic Link. I am running into this error though: The 'user' table the function was set at wasn't wasn't the correct table so I switched it to my 'Users' table, keeping everything the same except where the data is being queried: I have…
-
Help with pagination
I tried implementing pagination, but I keep getting this error. This is how I am setting it up for pagination: I believe the problem is with setting up the external part as such: But I am not sure where to put my object to make this work — if this is even the correct way to utilize pagination. Where am I going wrong?
-
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…
-
Generate Unique Identification Numbers
I need to create a field in my database that generates unique identification numbers for each row. The desired format is f-####-####-####, where the "f" remains constant. These numbers should be generated for both existing records in the database and any future records that will be added. Can anyone help? I can easily do…
-
Amazon SES with XANO instead of SendGrid
As many of you know, its a common issue Twilio Sendgrid automatically rejects accounts upon signup without any reasoning. I assume they are getting stricter to reduce pishing and such. This causes a challenge for business owners as myself who are locked out and now need to find a solid alternative solution for…
-
Converting GeoJson Format from SHP to XANO polygon geo field type
Hello! I am trying to convert a GeoJson output I have from a shapefile into the same formatting that exists for XANO polygon geo field types. Is there a way to do so and with what tools? TIA.
-
How to show EST correctly?
I currently have it set up that a post can have the time it was created shown as such: But I am getting this output: The post was created at 6:58 EST, not 5:58 How can I fix this?
-
Testing in Production & Development
When an app I created is uploaded, how will I be able to continuously update and test my backend in development without affecting the app within production?
-
Not able to use Facebook login
Hi, I am trying to integrate Facebook login, followed step by step instruction as provided in the walkthrough video, but I am not able to log in even via DEMO. 1) I have created an app in Meta for Developers and filled out all necessary pre-requesites. No required actions from Meta. 2) I have configured environment…
-
xdo error
Hi, not sure whats wrong with a pretty simple query all records: I am trying to query records based on record.user_id = auth: id AND record.expiration > now I get an error: Unsupported parameter reference - xdo Here is the link: Thanks!
-
Xano database storage (3GB SSD)
I've deleted ~95% of the records I had, but the Database usage is still the same, does something else like requests or task performed so far also affect database storage? I've deleted the records yesterday morning and stats are already updated, but Database usage remain the same.
-
How to Retrieve Dropped Variables in XML Decode
Hello again! I am using this XML: https://www.youtube.com/feeds/videos.xml?channel_id=UCYKyAnIssgNJ3rUFra2fGJQ When navigating to the URL, I can see variables in the object called media:group. When I run an API request and use XML decode on the results in Xano, the media:group object drops off. Any ideas on why that may…
-
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…
-
[URGENT] My App is down, Xano is not responding
I'm getting this error constantly when I try to load my functions API requests are returning "Unknown error." for some endpoints. I'm unable to escalate to anyone in the Xano team and my application has become unusable. @Chris Coleman @Michael Udinski @Sean Montgomery @Prakash Chandran
-
Change PK to UUID
is there any way to change PK to something else? for example to UUID field. I know its possible to work with uuid without that and im already doing that in mine every API endpoint, but calling that incovinient will be extreme understatement. And also that an absolutely unjustified hit on endpoints performance. And using…
-
Enum mismatch issue
How do you deal with a case where the value being passed in does not match the enums? e.g. accepted enums = Apple, Grape. Value = Watermelon. In this case, I want to escape the edit and move onto the next iteration in the loop.
-
Conditionals For Editing Data
Whether I use PUT, PATCH, or POST to edit data, I run into this issue. I followed the following video and used both methods shown: Yet I am presented with this error: This is what I personally did: Method 1.) Method 2.) Where am I going wrong?
-
modificar o key de um json
Pergunta simples.. estou fazendo uma busca no BD que me retorna isso: [ { Nome_assinatura: Empresa J}, { Nome_assinatura: empresa teste}, { Nome_assinatura: Empresa Eduardo}] como substituir o : "Nome_assinatura" por "title" para ficar assim: [ { title: Empresa J}, { title: empresa teste}, { title: Empresa Eduardo}]
-
Documentation best practices
Hi all, We build our products on a WeWeb/Xano stack and use Notion to document our products. At the moment there is no integration between Xano and our documentation. Documentation should be in sync with the actual implementation. Question now is - how to achieve that? But first question would be - what is the go-to…
-
PUT Conditionals
When using PUT, is there a way to specify that if a value is not changed then the original value will be kept. At the moment, when a value is not changed, it is set to null.
-
update multiple records in one database request
Hi all, I have a table A in which i want to update multiple records based on the unique id. When i am using edit record statement it's only updating single row. please let me know how to achieve it. Thanks
-
How does database lock work?
Hello, not sure if this is a new functionality, but at least I just noticed it haha It would really help in my workflow to avoid any issues in parallel requests, just wanted some clarifications how does it actually work, if two requests happen at the same time, the first one locks it, and what happens with the second one,…
-
Post Process body requires JSON decoding?
Working with the Post Process function and was struggling with retrieving data from the 'body' variable. Ultimately it turns out you have to use the json_decode filter before you can get any of the data from the body object. Is this expected? If it is expected, it would be good to add this to the documentation as it wasn't…
-
Formatting timestamps
Where can I going wrong when trying to format 'created_at' into a more readable time? The 'created_at' is not being altered: Instead this appears at the bottom of my query: Where am I going wrong?
-
Finding Specific ID's from a joined table
I created a join to GET club information for my specific use case like such: is there a way to specify that I only want post information from '_clubs' if the 'id' for '_clubs' is a specific one? For example I only want club id #1, thus giving me all the post data for that.
-
Posting Non-Existing Data
How can I set up this such that I only create a new row if it doesn't already exist:
-
Formatting Data Outputs
How would I format my output data such that it looks like this: [{label:'One', value:1}, {label:'Two', value:2}] the string would column's value in a table and the integer would be a row id.