-
Filter by index
Hello to all, I am still new to Xano and I am looking for a way to sort by a field in a table for which I have used the GROUP feature. To situate, I have a table with different products. One of the fields in this table is category which refers to another table. On this other table, each category has an index. I would like…
-
Check users authentication
Is there an action i can perform that check the users authentication token to see if its valid?
-
Searching text fields in a referenced table
Hi All, I'm struggling to apply search to a table referenced in the main table. For example: The "primary table" contains name and body of the post. The referenced table contains "comments" on that post. The search query works perfectly on the primary table but when I try a join or add-on it fails - either outputting no…
-
Looping through an array that contains collections
Hello ya all! Hope you are doing really good :) I've been going insane over something so little that I've decided to simply come forward and ask the question. I have this case where I POST data to Xano, here I need to iterate an array that contains details about additional beneficiaries of a contract. For each of the…
-
Export table rows to CSV
I have a need to be able to select rows from a table (using Xano's table grid) and export the selected rows to a CSV file. I would have thought it was one of the bulk actions when selecting rows, but it seems I can only delete them, which is not *quite* what I'm after. 🙂 TIA!
-
Distance between geom points: query database
Suppose I want to query a database table that has an field called geom_point1. I have two inputs: geom_point2 and distance. I want to query all rows whose distance(geom_point1, geom_point2) <= distance. CanI do that in Xano? thanks P.S: Below is just an example but I do not think it is correct. [image.png]
-
Can Xano team access our databases
Can Xano team access our databases and access our users' information? Or is Xano fully encrypted, and no one can access information other than me? Thank you!
-
Daily import of 30k+ rows
Hi, New to Xano, happy with basics and concepts but before getting to invested with Xano on this project, wanted some insights from experienced Xano users, please. Scenario A daily import of 30k rows from a MSSQL database, this data needs to be processed and manipulated, so possible looping and comparing against existing…
-
Is it possible to create a Chat App in Xano where I don't see the user's messages?
Hello, I'm looking to include chat functionality into my app. One thing I'm curious about is that for privacy reasons, I would prefer to not be able to see the contents of my app users' chat messages when I use the Database tables, similar to how the login/signup password field currently works in Xano databases. It's…
-
Is there any way to customize my data table relationships?
I don't want to be forced to use the ID to reference the datatable. I would like the data to be returned to match a unique field that I set. I'm wondering if there is a way to do this?
-
Unknown error
Has anyone seen this type of error - I'm just doing a simple get on all records in the table. Thanks Gavin
-
Qn on 'File Resource' and 'Create Image From File'
So my front end passes an image url back to xano and Ive tried just using 'Create Image From File' straight without using 'Create File Resource' and it seems to work and store the image metadata. I've seen a couple tutorials from Xano and they always 'Create File Resource' before using 'Create Image From File'. So am I…
-
How to check how much data storage usage?
Is there a way I can see how much database storage I am using and have left?
-
Authenticating users
Is there an action that i can create via xano to throw into the front end to check if the user's authtoken is valid? This way i can send user's to the log in page if it isn't.
-
Separating customer data into different databases but serving the same business logic.
How would we go about developing a backend for a project management SaaS/ERP product in Xano (let's take Asana as an example) that has to serve many different customers and their employees, where everyone is using the same version of the product (business logic, schema, APIs) but where the customer data is separated into…
-
Stop Xano from updating fields I don't want it to
Hi there I am creating an application in bubble and I am using Xano as the backend. I am a noob at all of this and so any help would be awesome. Is there any way to make it so Xano only updates fields that change and stop it from blanking out images or other fields I have stored in my tables? Any help greatly appreciated.
-
How do I capture the header info in a webhook response?
How do I get the information in a header from a webhook response? In the snapshot below, I'm looking to get the information marked in red but the "Get All Input" feature in Xano for webhooks only gets the "Raw Content" body part of the webhook response. Any assistance will be appreciated. [image_chfxhy.png]
-
Database link vs. table reference
Suppose I have a user table with two fields: id and name. In an API I want to have as an input the name of the user with id=1. Should I select Table reference or Database link in the list below? If I should select the former, how to refer to the name of the record?[image.png]The documentation (Field Types) does not have…
-
"For each" loop for API results
Suppose an API (get_player_api.results as player) returns me the following list: [ { playerId: 1, name: Cristiano, lastName: Ronaldo, age: 37 }, { playerId: 2, name: Lionel, lastName: Messi, age: 35 } ] This is the function stack:[image.png] Now, for each playerId of the list above, I want to get the record in the…
-
Create array of arrays or something similar (review solution)
Suppose I make a call to an API and it returns me a list where each element of the list (player_api) is of the form: { playerId: 1, name: Cristiano, lastName: Ronaldo, age: 37 } Also, suppose I run a for each loop that gets the id of each player_api and returns me the record with that id in the database (player_database).…
-
'Get Record' with two field look ups.
I want to use the 'Get Record' database request. I would like to get a user based on two fields. However, the 'Get Record' request accepts only one field. Does this mean I have to use the 'Query all records' request? If yes, I have two questions: 1. How can I get only the first record of that request? 2. Is 'Query all…
-
Bug?
Finally got a job and can get back to my project in xano :) , anyway, when I hit googles api for geocoding from xano, I get API key errors (its a fresh key, even a new google project just to make sure).. weirdly, every-time I hit the URL (provided in Xano debug tab for the request) in the browser outside of Xano, works…
-
How to continue a function stack when a value is empty?
[How to continue a function stack when a value is empty.mp4] Hi guys I get this error when I send a query that is empty or "0". I'd like to know how my function stack can continue when a variable is empty. [CleanShot 2022-08-17 at 12.27.54.png] [CleanShot 2022-08-17 at 12.27.33.png]
-
SSO via SAML through XANO?
Is it possible to use SSO with XANO using SAML? For example: Frontend: User chooses SSO and gets redirected to Identity Provider for login Identity Provider: User logs in and identyprovider sends a saml response with signature/certificate for validation to XANO using a predefined callback url Xano: validates response,…
-
Xano's equivalent of bubble's Option Sets
In Bubble, there is this concept of option sets. Option Sets allow you to store a preset list of things (e.g. months of the year, days of the week, etc.). Option Sets are not stored in the database so they are faster/easier to use. From my understanding of Xano, option sets would be something like an environment variable,…
-
Need to compare two values from different variables and return a boolean if found
Hi guys, I need to compare more than one value in different variables and return true if any of the values exist in both variables. The screenshot below shows what I'm trying to achieve. [Image]I tried this filter, but get false[Image], even when I know it's true. So, what would be the best function to use? Thanks!
-
Is there a tutorial on how to use XANO + zapier
I understand that xano does not have native integration with zapier at the moment and the only way is to use zapier's webhook with Xano's function stack. Does anyone ever tried this ? or maybe a video tutorial link ? Thanks!
-
Unable to create new endpoints
I have these endpoints for a table, automaticly created with CRUD option. [Image] I'm then unable to create any request starting with the cashing base. [Image] That is also the case for all other tables. Thanks in advance.
-
Do plan changes affect IDs?
When upgrading from say Growth to Scale will my instance or API ids change? I saw it looks like you can change the API id. I suppose with a custom domain the instance becomes less of an issue as well. Anyways, just trying to do a little planning. Thanks!
-
Password validation is NOT working
Hey - curious as to how I can get validation to work. I'm passing in my plain text input and comparing to that in the database via the security function, but it does not work and it continually says that it's false. Any way to remedy this?