-
Message of the Day Logic/Architecture (New item from list each day)?
Message of the Day Logic (New item from list each day)? I'm new to Xano but I've been building things for years. So, I'm familiar with data architecture but still feel like a noob in a lot of ways. Here's what I'd like to try to get to know Xano: Display a new message each day on a front end, but have Xano handle all the…
-
sign in with microsoft
i am currently tasked to move the entire backend of the mobile app of my company im working for. currently it requires sign in through Microsoft account and I'm looking for a way to replicate that, is that something i can do that with auth0?
-
Atomic blocks
Hey! When I have a sequence of queries for an endpoint(5 queries for example), when the third query fails and then the request fails, I would want the first and the second queries to be rollbacked to their initial values like for atomic blocks with sql. Is that available? If it is, how can I setup it up. If it is not, can…
-
(Untitled)
Hey everyone, hope you're doing well. I'm having an issue. [Image] I'm comparing my user name and the input name both filtered with a split(' ').join('') to remove all whitespaces. When I'm doing that directly with the values, the condition doesn't pass. But when I store them in variables, I have the result. My…
-
table/record security.
I'm looking to make an app in Appgyver. People are going to have to log into it, which I get how to do. The app is really a repository for PDFs, which I figured I'd use Xano to store. I want to make it so certain users see only certain groups of PDFs, figure make each group a different table possibly. How would I do the…
-
Bubble: Do I need to change the names of Local Storage plugin on every page?
Hello, I'm new to Xano and after watching Michael's videos on authentication, I have a question about using Local Storage plugin in Bubble. To help me know which plugin I'm pushing the authToken to, I rename them based on the page the plugin is on. So for example, instead of using the default name of Local Storage A…
-
edge caching of images and videos
do you provide equivlanet cloudfront or cloudflare?
-
Bubble.io: How to access Local Storage plugin from Reusable Header to Log Out a user?
I use Xano as my backend and Bubble as my frontend. Based on Michael's videos, I also use the LocalStorage Bubble plugin. I'm stuck on logging out and have a question: I've created a reusable Header in Bubble to hold all my navigation controls so that I only need to make changes to the header in one place and have it…
-
Sharing the workload with a friend
I have a complex back-end scheduler to write which will involve multi-level conditional queries, extensive business logic and much more than just simple crud operations, and I am finding it difficult. I have a friend who is retired (like me!) who has many years of database and programming experience and has offered to help…
-
Problem setting up auth0
Having trouble following video about how to install auth0. I have successfully set up an auth0 account but when I try to install to xano from marketplace, the video doesn't say what do put into the "Merge into an authenticated database" box. And the drop down arrow doesn't have any options. Can't seem to move forward from…
-
(Untitled)
Hi, before I start a project, I want to find out if the following is possible - I am well versed with APIs and the like but just want to make sure all of this is possible even if it needs to use a few apps/software to achieve it. Looking forward to your suggestions. Part 1. Registration form that sends a request to the…
-
Adding table reference through API Post
Hi, I am trying to add the order ID to a payment entry, two separate tables with a table reference in the payment table referencing the order table via the ID. I have queried the order table and found the correct order, as per screenshot.[Screenshot 2022-04-22 at 16.43.08.png]I have then created a new variable with the…
-
Table reference and EDIT endpoints
Hi everybody, I am actually building a webapp similar to TripAdvisor but for local food stores. I'll simplify my problem the most. I have a user table, with a table reference (called shop_owners) to my shop table. And I want these shops owners (and only them) to be able to edit their own shop's information. I know how to…
-
Help filtering array list based on another array
I need some help on how to implement a certain requirement. Is this the right forum to ask? If yes, I have two tables Say A and B. Table A has Product_Name (String) + other fields + BOM_Products (Object List) with below fields BOM_Product_Id (Integer), BOM_Product_Name(String), Table B, has User_Pref_Theme + other fields +…
-
Is there anyway i can use a different ID as a table relationship value.
I'm pretty new to all this. So orders come in from our CMS every order has a customer. I want to use the customer id that we already get from our CMS as the id instead of the standard customer id that the customer table has be default. Is this possible? Thanks
-
[Solved] How to eliminate duplicates?
I will try to make it as simple as possible 🙂 There is a table where I have some emails. email1@test.com email2@test.com email3@test.com email4@test.com email5@test.com When I submit a JSON: { "contacts": [ { "email": "email1@test.com" }, { "email": "email2@test.com" }, { "email": "email3@test.com" } ] } I want to get back…
-
Possible to set field requirements at database level?
Is it possible to set field requirements inside of the database, instead of in an API? A way more advanced version of unique index's. For instance, if we only allow employees to work on projects that their supervisor is the manager of... if I want to ensure that whenever a new employee is added to a project in the…
-
Access value of a webhook that has been POST to xano API.
It all sounds unbelievebly simple doesn't it. I've watch a few tutorials and gone through the docs. But in my webhook i don't get any variable i just get a big json object. For example in the tutorials you guys make it super simple and your webhook has data { email: "value" etc.etc. } My webhook i just get a JSON object…
-
Restricting GET requests only from whitelisted domains
Hello there, I’m using Webflow as my front end. There are instances where I need to retrieve information stored in my Xano database via a GET request (using vanilla javascript) and then display them on the front end. Now my question is - is it possible for Xano to only respond to requests made from my site? This is because…
-
Store Token in localStorage, sessionStorage or cookie
Hello, Im building a verry simple webapplications with 2 secure pages (profile page with user data). once a user login he will be redirected to his profile page where he can update his profile. what is the best way to handle this. store token in localstorage, session storage or in a cookie? Hope someone can help me. thank…
-
Pagination setup
I try to set up pagination for stored data in order to use it with my app. However, I followed the documentation but I think I am missing something. When I test this in Run & Debug Mode works well. https://xxx.xano.io/api:xxx/hubs?page=3 [xpg1.png][xpg2.png][xpg3.png][xpg4.png][xpg5.png] When I run this in…
-
Check if geo_point input exists
Hi all, is there a way to check an input of type "geo_point" if it exists? Checking for null does not work, it immediately shows the following message if parameter does not exist:[image.png]But when I insert a parameter and leave it empty then it brings me a null[image.png]
-
Table Delete/Renam
How can i delete a database table that I no longer need or rename a table that could have a more descriptive name
-
How to authenticate API for Retool frontend
I have GET and POST API requests going to Retool through an open API which allows users in Retool to see all Xano table records and edit specific ones based on their ID. I'd like to secure the connection but I'm having issues. I tried the out the box Xano functionality for API authentication but this doesn't work as…
-
Most recommend frontend platform?
I have an HTML/CSS template for my web-app. And I'm building the backend using Xano What tool should I use for the API JS connection
-
Is using the precondition function for an API key like functionality secure?
Using the user auth for securing the API endpoints is a pain for the project I'm working on because tokens expire and I'm not sure how to keep renewing them in Retool. (I don't really need users for this project) So I thought I could use the precondition function that evaluates if "key" querystring equals my API key I…
-
Record limit?
After all my filtering is done, is there a record limit to the amount of records I can send back?
-
Importing ERD to Xano
Hi all, does any of you know if it would be possible to import the ERD file from LucidChart to Xano? The ERD would be exported as a PostgreSQL file.
-
Question about Lambdas
Hello! I've been following the Lambda announcement, and it seems like a very cool new feature. However, I feel I'm not *quite* wrapping my mind around the exact use-cases for when to use them. For example, in the docs it's made very clear that lambdas can access and do all the same things as you can within the function…
-
Does Xano replace the need for server side frameworks & coding languages?
I understand that Xano is great for building a database, but is Xano's server side functionality advanced enough to replace the need to learn server side programming languages & frameworks? I'm asking because I'm currently learning to code & with me being in a rush, I'm wondering if using Xano will allow me to skip…