-
Email Address Case Sensitivity Issue in Xano - Need Help Resolving
Hello, I'm a newcomer to Xano and I'm encountering an issue where Xano is treating example@gmail.com and Example@gmail.com as distinct email addresses. How can I go about resolving this problem?
-
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function?
How can I change the timestamp format in an addon by using filters in a 'Get Records' Function? Below is a recording of my current setup that works in my 'Query All Records' function. However, in my 'Get Records' function, I'm encountering the following error: 'Please use a numerically indexed array.
-
Find All using nested arrays
Hi. I'm working with an interesting problem. I have arrays that are nested and need to search the main arrays based on values in the nested ones. Here's an example from the Xano Documentation [ { "id": 4, "created_at": 1632268901955, "make": "honda", "model": "civic", "year": 2002, "maintenance": [ { "year": 2004,…
-
GET unique url from a database cell - How to?
Hi, I am using Xano as a backend to Draftbit. I have a unique url in a cell on a database. How can I GET that user's unique url clickable in their profile section on Draftbit? … I was told from support at Draftbit, "Yes, based on your structure in Xano, you should be able to retrieve warranty url together with user data.…
-
Failing to configure PUT API
The API should update a variable DAYS which is an array of integers. But when I enter a test value like [2,3,13] - it fails to update with a right array. Instead I'm getting zeros. Yet, a very similar POST API works fine, and accepts an array of integers. What could be a reason?
-
How to check if the value (not the field type) is an integer?
I know about the "is_int" filter, however, the "is_int" filter checks if the field type is an integer, not the actual value. I have my field type set to decimal because it stores both decimals and/or integers. As a result, I have no way of checking if the value itself is an integer or not because the "is_int" function…
-
Get request with Array Query works in debugger but not in live
Hi, Been trying to figure this out for a while now, I have a get request that has an input for an array in the debugger it's passed like this { "color_in": ["Red","Green"]} And when I try to do the same in postman it doesn't work, and I tried all different alternatives but nothing it only works in postman if I try it with…
-
Xano Bubble | Error code 400 - Missing Parameters
Hi! I'm trying a logic where i send a "tag" and receive a "condition", where information from a QR Code is collected and i get the information about the status of something. Worked before, but i messed the system and i can't recall how i made 😅 Now everytime i get the 400 error code from Bubble, but inside Xano work as…
-
Building GraphQL queries programmatically
I'm new to Xano and even newer to GraphQL. There doesn't seem to be any extension for building GraphQL queries programmatically similar to, for example, this npm package. I'd like to know if anyone has experience with custom functions for building the query string. I like to have a set of custom functions for…
-
How do I generate a coupon code for users in Xano?
How do I generate a coupon code for users? Ideally, I want it to be the user's first name in caps followed by a 6-digit string of random letters AND numbers. This is something similar to the 4-digit auth code, but… now we are including letters. Example code would be: JOHNDOE7BK3HE (all is in caps)I know there is a"Generate…
-
Which is faster/better: an api endpoint that pulls from 9 tables or a task that does it every 2 mins
I am creating an app which has a homescreen that needs to pull data from roughly 9 tables. My current plan is to create a homescreen table that is refreshed with a background task every 2 minutes with the latest data from those 9 tables. That way the homescreen frontend api call only needs to pull from one table to load…
-
Authorizing Make.com for http call
Noob here… I'm primarily using Xano and WeWeb together for my app. Works great. The user auth on API calls works great. There are some automations I'd like to do using Make.com, primarily using a webhook on a button to retrieve data from Xano and send to a 3rd-party PDF app. How do I go about authorizing the HTTP call in…
-
Connect tables
Hello, I'm new to Xano and began with creating my back-end which is super exciting but at the same time challenging for me, having no background in coding! My objective is to create a web application where users can set one to many objectives and define a tailored strategy for each of these objectives. In terms of tables,…
-
Conditional filters, first_notempty and zero values
I am using conditional filters to update a record with partial values using an API call (https://www.youtube.com/watch?v=WvOlaXmoq5o) This is working as expected, but I am running into a problem when I attempt to update the record with a zero value. Where I am attempting to write a zero value, the associated field in Xano…
-
Flutterflow showing all data as "null"
Hi, building my first fullterflow app with xano. If I set all the fields in the database as "Nullable" = no, then I am getting all fields on the screen displayed as "null". If I set all the fields as "Nullable" = yes, I am getting an flutter error saying was expecting a string but got a null. Please advise how to sort…
-
Is this possible to build this with Xano? generate Unique URLs
This site polls.io lets you create a poll with a unique URL where users can go in and fill it out. Can we build something like this with Xano where we create something like a poll and in the unique URL users can vote, see stats of the current poll and add new questions in the unique URLs? I don't want users to have to…
-
Creating Unique Slugs Based on User Names from Relations
Hi there, I can't help my novice skill and knowledge. I need help, please. I want to create a slug based on users' full names. I attempted to add the slug field to the 'user' table but discovered that I couldn't have more than one unique index. So, I added the slug field under my 'profile' table, which already has a…
-
Safely copy image metadata from one table to another
Hey! I'm moving my image metadata from table Posts to table Images. How do I safely make this change? I want to 1) loop through all posts 2) for each create a new record in the Images table, where Images.image === Post.image, then 3) refer to that newly created Image record via table reference. I tried using the "Get File…
-
Extract values from objects that meet a specific condition and add those values to a new array
Hi, I have 2 variables. One variable is "products", which is an array of products and the other variable is "product_ids", which an array of product IDs. If I wanted to create a new array "prices" that contains the prices of all the products whose id is in the "product_ids" array, how could I do this? Example: products = […
-
Querying records from last 7 days using 'YYYY-MM-DD' format
Hi there, I'm a bit stuck and would love some help — I'm trying to query only the records from the last 7 days from our Plaid database table. Plaid only provides the date of a transaction, not a timestamp, so we've been saving this data as a date field with 'YYYY-MM-DD'. In theory, the query should be as simple as this,…
-
Reference variable in a variable?
Hi, I'm using a loop to manipulate an object. I need each loop to use a succesive element in my JSON data. For example: Loop 0 —> user.preference.0 Loop 1 —> user.preference.1 Loop 2 —> user.preference.2 Initially I thought I could simply use the loop's "index" variable (which tracks the loop's current iteration number) in…
-
Best practice to build JSON and send to another app?
I'm using WeWeb to collect a bunch of data that creates records across several tables. What is the best practice to create a JSON file that would then get sent to another app? I do want to store the JSON file for archiving. It's being sent to a PDF creator. Is this normally done using the function stack? Just not sure how…
-
How to add SVG icons to Xano?
I need help some here. Sorry if this is a basic question, but I could not find information about this anywhere. I have a categories table where I need to add SVG icons, but when I try to add them to the storage/image field, it does not allow me to select SVG files. Do I need to use a different field type for SVG?
-
How can I add quotation marks to strings in a string array?
Hi, I have this array of strings: [aw654, grw68, 4] This is what I want: ["aw654", "grw68", "4"] How can I do this in Xano? Is there a filter that can add the quotation marks? Thanks!
-
Google OAuth for IOS
Hi all! Bit of dissonance in the Google OAuth 2.0 flow & the marketplace Extension directions for mobile apps. If you're developing for mobile, Google doesn't offer a client secret. Should I leave that field blank in the env variables? And what to put for the redirect URI, which it looks like I pass along in the body of my…
-
Expand API Request History in Dashboard?
Hey! Feel like I'm missing something, but I can't find a way to expand beyond 24hrs when viewing my API request history in Dashboard. Only possible to access through the Metadata API? :/ Thanks!
-
Querying a lits of Favourite Episodes
Hi, I have an app with meditations in it. Users are able to favorite their meditations. I have that functionality working. What I'm having trouble with is creating an endpoint that returns a list of all of the authenticated users favorite meditations. I've tried using joins as well with no luck. Currently, I have a field…
-
Time to next quarter hour
Hi, I have a "now" variable that gives me the current time. I would like this variable to give me the time of the next quarter hour. Examples If it is 03:12, the variable must be 03:15 If it is 07:25 the variable must be 07:30 Do you have any idea how I can proceed? Thanks :-)
-
Boolean being true if record is referenced in another table
If I have, let's say, table 1 and table 2. If a record with the ID of 3 in table 1 is referenced in table 2, then a boolean would be set to true if it's referenced in that specific table. Is this possible? (Or does that make sense cuz that's kinda hard for me to understand and I'm writing it)
-
Select id as text, not auth
Hi, I am trying to set id as text. However, Xano automatically takes it as if it was an "auth" value, which it isn't. What can I do for it to stop taking it as auth? I already tried typing "id" into the text box, did not work. Thanks