-
Security - input sanitization (validation)
Hi, I'm building a process (API endpoint) which starts with a user input from a Webflow form. I am aware that it is good practive to sanitize such input on backend, but I'm wondering is that an issue with a solution like Xano? I will have some simple validation on the form (for example for basic email format check), but it…
-
Best practice for storing user info
Hello - I am trying to make an application using DraftBit as a frontend that allows a supervisor to have a list of subordinates under them. When they select a name from the list it will pull up a dossier of that person showing a list of all their pertinent information. This information should be editable by the supervisor…
-
Looking for a Xano developer asap
Hello. We are looking for a Xano and Wized back-end wizard to support us (project manager + experienced webflow developer) in building a robust online, video-based education platform. The FE has been fully developed on Webflow. If you are available to start work in the next couple of weeks and work at least 25h a week…
-
How to check if file from sftp server already exists in database
Hi! I'm trying to make a task in which I call an sftp server and check for new files in a path. I'm sending an external api request to list all the files in that path and getting their filename by creating a variable. How do I then use that variable (the filename) to check whether that file already exists in my database?
-
Is there any way to fetch a database's object through mapping?
I’d like to ask for your help. I’m trying to generate a text file using CRON/Task in Xano. Here’s the flow: As an example, I have a database called users and I’ll be looping through each of the user in the users. For each user, they have the following: { username, email, transactions: { amount, vat, refund_amount } } My…
-
LinkedIn style database, how to in Xano
Hello, I would like to create a beck end where user can create an account and populate it's details. For example, let say that she is putting in information about her education. Masters in something from 2016-2019 description of masters Bachelor in something from 2013-2016 description of it Now, do I have to create a…
-
Does anyone here know how to make a header and footer for a .txt file in xano?
I'm planning on creating a file resource (.txt) that has a sample format like this: HEADER 00000001 DETAILS/NAME/MMDDYYYY FOOTER 00000001 The details' data will be taken from a table while the header and footer are separately saved in a DB. Another thing, is it possible to create a file name sequence number that increments…
-
Product Catalog: One big table or many related tables?
My Current Situation I've got an ec-commerce with roughly 13,000 products that largely runs on two tables within my Xano database: Table 1: Products (Name, price, SKU, URL, etc) Table 2: Product Categories (Each product in Table 1 has a relationship with this table as it points to the appropriate category) What I'm now…
-
Complex Financial Functions
Airtable has been very useful to me because of their ability to perform Excel-like functions. For example this monthly payment formula can be done by reference other fields in a record: {Loan Amount}*({Monthly Rate}*POWER(1 + {Monthly Rate}, INT(Amortization)*12)) / (POWER(1+{Monthly Rate},(INT(Amortization)*12))-1) From…
-
Best data practice
Hi everyone, I have the below mater table example. Attribute set A table AND Attribute set B table are the expected results. Is the best practice to import the master table (actual data has more than 600 columns and over 70k rows) into Xano via CSV and use the API filters to get the expected result? Or should I processed…
-
database best practices
Hello, we are reorganizing our databases, since we saw the need to make our processes more optimal, I am not really an expert in databases, I would like to have some opinion on what would be the best practices to avoid long times in the searches from our Front. apart from this, I have some questions: 1. Is there any best…
-
Group results within an API
Hi everyone! I'm building a journaling app and have a page that allows users to view all their entries. They are currently presented as different items: ie. every entry is separate, even if written on the same day: How can I structure my API so that they are grouped by date: ie. every entry done on the 02.Jan.2022 is one…
-
Prevent duplicate records apart from blank/null values
I want to prevent duplicate records in a table but allow for blank/null values of those fields. It seems with a unique index, it includes null values. So where I have email | phone fields in my table, and I want to allow a user add either or, the null values are considered a duplicate.
-
Secret Key Xano
Hello everyone, We plan to use Xano to manage our app data. However, to ensure maximum security for users, we would like to use the security functions as indicated here: https://docs.xano.com/working-with-data/functions/security Is it possible to save secret keys outside of Xano and/or outside of environment variables?…
-
Edit all users of a table with a single DB query [EDIT ALL RECORD]
Hi, I'm setting up a cron-job where every week I would edit the field counter of all users back to zero. I wouldn't like to do this with a FOR cycle because Is probably not ideal and not fair for some users to get the counter to 0 prior to others, I'd like to do this with a simple DB query, is that something possible with…