-
Is this community platform custom build by Xano?
Was wondering what platform they used to run this community app. Couldn't find any ties to a specific software. Is it custom built?
-
Is Xano only for SPAs?
Hello! From my understanding, with the way Xano is setup (a backend that exposes data to the frontend with APIs and JSON), this seems purpose-built for SPA (Single Page Application) apps. I was wondering if there are any use cases (or possibilities) of using Xano for an app that uses Server Side Rendering (SSR)? Would…
-
What is the difference between two field type date and timestamp?
I am using date as field type for campaign start date and for campaign end date. I am selecting a date but it is showing invalid date. Ma I know the reason why it is not working and the solution to fix it[image.png]
-
Bad file bandwidth
Maybe I'm miss understanding this but the file bandwidth looks to be way too low for all plans. And to add 100GB of file bandwidth is expensive too. My site will have a homepage of about 4MB and at least 25k users a month so 25000*4=100000/1000=100GB and then they will load the page multiple times. I also have pages that…
-
Test vs Production - dynamic URL's
Hi Xano Team I am aware of the Data Source configuration to switch between test and production by adding a header X-Data-Source: test for API calls. On my front end I am also running two separate environments and therefore require to send dynamic links (one for test and one for prod) for features like magiclink depending…
-
How to add an "If Error" to API
Is there a way to add a line in the API that returns null if a certain function line returns an error?
-
Blocking Brut Force Attacks
Is it possible in Xano to block thousands of requests from an IP address that tries to crack a password? I mean just block an IP or serve it slower and slower ...
-
Global Enums
I am trying to add a column called "account_locked" to the users table. There are different reasons why an account is locked and there is also a flag if it is possible for the user to get unlocked ever again. There are the Enums which could be used to store the different values e.g. "too many login tries", "account is…
-
Accessing Subpath
I'm running a for loop against a list of queried items. Within the for loop for each item, I want to lookup the specific item's 'unique_id' . I'm having trouble accessing the subpath to input as the search query. I've tried item.unique_id and item.response.unique_id - all return not found in the debug mode. I can see how…
-
When should I put things in an object vs a separate table
Hi there, First off, loving Xano. I was banging my head against the wall as I was unable to make a "db1 of db2" add on work and realized I hadn't created an object before adding a table reference. Followed the instructions here https://docs.xano.com/database/database-relationships for a many to many relationship. I had a…
-
Pagination between Xano and Parabola
I have a Xano table with 70k records that I need to pull into a Google sheet via Parabola. I've setup pagination on Xano to pull the records with Parabola via an API request, however when I setup Parabola with the following settings I only seem to get the first page of data for each page I fetch. Where am I going wrong?…
-
Rename pagination fields
Is there an easy way to rename pagination fields? Specifically, I'd like to add underscores and make all lowercase For example: curPageto cur_page
-
Allow an authenticated user to download their own records
I am building a journaling app and want to allow users to download all entry records associated with their Auth Token. I have an API setup so that a user can GET all records associated with their Auth Token, is there a way to offer this download functionality from XANO? Or do I need to say load up all the entries in a…
-
Video Series Database Structure
Hey guys, Hope everyone is doing well. I am trying to create a database for videos in a series. I want it to have a title, poster photo, description, length, video preview, year, category, and then the seasons with at least 30 videos in each season. I've managed to do everything except the seasons, I'm kinda stuck in the…
-
Query logic fails
I am trying to grab all records where Users.Following has text in it, meaning it is not empty and it is not null. I have this query for the Users records: [image.png] Whether I use AND or OR, i still get back users with empty or null values. Any idea why? Also i can't find don't for what Ignore empty values means in this…
-
precondition help
Hi there, I am trying to implement the precondition for params pass in get api. So scenario is i have 2 params email and phone, i just want to trigger the precondition when both params are null or empty, i tried but could'nt succeed, plz guide me to do this. Thanks in advance.
-
How to build a secure application
Hi there👋, I'm kind of new to Xano and now have a basic understanding of the DB, API and authentication etc. I'm trying to understand how to create a secure application so the user can only CRUD "To-dos" related to themselves. My thinking (please correct me) • I assume on the GET auth/me I would add an add-on to…
-
Can i get the xano user auth token after it's created?
If i create a user auth token in one call, can i retrieve it from the user table in another call later? Is there a specific function to retrieve it? or can i only get it/use it right after creating it?
-
[resolved] Upgrading my instance is not terminating
I just moved up one paid tier and my instance has been "provisioning"/"upgrading" for over an hour. I just wanted to make sure it will eventually be fine.
-
System Variables
Can you store a list of values in one system variable. As an example, I need to store a list of roles that has access to an end point and want to manage this centrally through system variables. What I am looking for is something like this. var (allowedroles) = admin,sales,finance When an end point is executed is to step…
-
Tasks sometimes don't run or take very long and fail silently
I have 5 background tasks. They search for games in my "games" table that are about to start, end, or transition to the next phase of the game, and run some logic accordingly. A few issues I've noticed: 1. I have all my tasks set to run every minute. Sometimes I notice in the history of the task that the tasks just skips…
-
Tasks
When you schedule a background task to run ever minute and the actual task takes for example 3 minutes to run, will the task start again on the minute or is the system intelligent enough to know that there is a task running at the moment which is not completed?
-
Database design challenge
I find the hardest to do is decide on how to structure the database. For example, I'm never quite sure when tables should have columns on both tables pointing to each other, or only one pointing to the other. A User has a Post and it links to the Post table record, but should a Post have a Created_by column, pointing to…
-
How to push the new version of APIs to shared snippet users?
Hi Xano team, I was wondering if it is possible to push my update on APIs to my shared snippet users without affecting the databases. My scenarios are as below: 1. Build API components and share or sell them with other users 2. Managing upgrade of single-tenant applications across the workspaces. In both cases, users…
-
Migrating schemas and tables
I may need to migrate tables and data from one account to another. Exporting an instance creates a .TAR file and then there is another format I saw somewhere. I did NOT see a means to import the instance into a new account. Any help on this appreciated.
-
Instance Vs Workspace
I'm trying to understand the division better and what to use for what. Two workspaces within the same instance would share a URL? or would the URL be different even then? What is the use case for creating separate instances and when separate workspaces within an instance?
-
Image upload quality
I am uploading images via API but some of them appear to be very pixellated once uploaded. Has anyone else had this experience and any potential solutions? https://xqeg-0iug-vw5m.e2.xano.io/vault/fBnbpOFo/98Sl_5qe/7NQPRg../file-adbd21.png?tpl=original
-
how to know if a variable is an array or object
external API returns array for multiple items or object (without [ ] ) for single item depending on the number of items in the result (it is a bit weird but I have to integrate with this). Now when I pass to FE, it wants array otherwise does not work. I need to find a way to push result to array if only 1 item return or…
-
Authentication with external API partners - passing data between two APIs (initial call and call bac
Hello Guys, I am trying to integrate with a partner that requires 1.0 OAuth which seems to a bit too complex for me. The flow is more or less as follow: create client specific signature (API 1), authenticate (API 1), receive link for the specific user where they log in through partner web view to authorize my platform,…
-
date format
Hi Xano Team I have a date value 20211205(YYYYmmdd) which is a text value which I need to convert to a date format. I used the format_timestamp but the function does not know that the text value is in format (YYYYmmdd) and therefore returns a completely wrong date (1970-01-01T07:36:51+02:00) The only way I can get this…