-
Ask Anything! No question is too basic.
We want you to succeed using Xano or any other No Code tool to launch your big idea to the world. Visit the "🤷 Help! I'm a Noob" to learn the basics and grow with the community.
-
Uploading files to an S3 object locked bucket
Hi there, I am attempting to upload files to an object locked bucket in Amazon S3. For those unfamiliar, object lock in S3 is primarily for compliance and limits any user from deleting or removing files after upload. I am getting the upload to work to a normal bucket via the native Xano functions, but for object locked…
-
Empty object in API response
My data here is pretty straight forward at the moment. For some reason the phone_number object returns null despite both records having data in the object fields (formatted and unformatted). See below where the second row has the phone_number object data. Response is empty. What could possibly be causing this to occur?
-
List as input won't work
I want an input to be a list, but I get this message - what does it mean and how do I solve it?
-
how to filter results by a boolean field in a record.
I have about 8000 records and among other fields or keys they each have a boolean field that says "isEnabled" with a true or false. I am trying to simply query all records and then return the records where the "isEnabled" is "false". Thanks in adavnce!
-
Round result created_at and adding custom string
Hi, I've managed to convert the basic timestamp to minutes ago if it's under 60 minutes, hours ago if it's under 24hours and days ago if it's over 24h ago. I now have two problems left: 1. Where do I add the "round" filter at the end so that there are no decimals? 2. How can I add the string "minutes ago/hours ago or days"…
-
How to creat a point from existing lat long data
I have a table of "hydrants" within my xano database with about 8000 records and among the other hydrant properties there's a lat field and a long field for each hydrant. I have created a field called "hydrant locations". What I am trying to do is to build a function stack that pulls in the already existing "hydrant" lat…
-
On "Edit Record" only fill field if it is currently empty but don't override...
In my Function Stack I want to Edit a Record but only fill the fields which are empty. I noticed there are filters for isEmpty which gives me true or false but I cant use this to set it if true. 🙄 How can I achieve this? Is it possible to use "Add Record", "Edit Record", etc in a Lambda Function?
-
Format timestamp for database
Hi I tried following this tutorial: as I want to format all created_at fields in the database. When I've created the function stack for a whole database I get "Invalid timestamp format". This is what my api/function stack looks like What am I doing wrong? Thanks! Filip
-
Getting only the INTof a record id from a get all records query
I am unable to get a only the INT from a simple get all records query. I am getting the company id from the logged in user and store it in buyer_id. Using the buyer_id, I filter my second query certificates using only the company_id INT. How can I get only the number the INT and not the object with the number? The closest…
-
Connection Lost... Reconnecting
Why is this happening on my instance CONSTANTLY. Every time I try to save a function, or add a new function, I get this popup, erasing the single action I just made. Its very frustrating. My API function stack is extremely large and long, but I don't understand why this is happening if my CPU is using <1% when editing.
-
User table password best practices on new/update
Should filters for length/upper/lower/digits be setup on the password field in the user table? And/or should I use filters on the inputs of the new user and change password API's? If I set the requirements on the field in the user table, can I just enforce the requirements on my front-end? TIA
-
API Input mapping
Im throwing query params on an api call (get request) to xano, for pagination. I have 'page' as a query param, ive tried to get it to populate in xano as a string, integer, and even json, i can never get it to populate..
-
Any solution for the Google OAuth 400 and 403 errors?
Hello! I'm having some issues with the Google OAuth extension in Xano, I believe I did the whole setup the right way twice, but when I hit the /oauth/google/continue after the /oauth/google/init, I'm getting this 403 response on my application (Webflow + Wized): { "code": "ERROR_CODE_ACCESS_DENIED", "message":…
-
Updating table reference list array
I have two tables, one called Profiles and one called Regions. The Profiles table has a table reference (list) to the Regions table. On the front end, users complete a form to update their profile with the regions they are in. In my API, I have an input that contains the values for the new regions they select on the form.…
-
How to avoid error "Unable to locate var" when the variable is not created?
Hi, My function stack, in a loop, sometimes create a variable object called "final_variant_records_with_errors". Sometimes it doesn't (this is intended). I need to reference "final_variant_records_with_errors" later in the loop, only if has been created. The problem is, if it was not created, Xano would return error…
-
Is it important to add a version number to the API endpoint name?
Hi all, I am looking at best practices for API naming and many forums indicate to place a version number with the name. eg: /v1/subscribers/details Is this important / worthy to implement as it adds more characters to each API name? Or OK to leave out for most applications?
-
Sync between Dev Test and Live
If I have 3 workspaces Dev, Test, and Live. What is the best way to sync all the changes done in Dev and move to Live?
-
Filter Database Query by 'Does not include those"
Hello dear No-Coders, I'm trying to query all records from a database where every item has a certain task ID, by providing all task IDs that I don't want to have outputted. So if I have a database with the tasks; 1A, 2B, 3C, 4D… and I provide the filter on 3C and 1A… - I would only get an array of 2B, 4D… back. But the IDs…
-
Enum values not saving
My enum fields work at first, and then they don't, and I can't figure out what this issue is. I have three enum fields in my table. They are all set as lists and I've added text values. When I add data to my table, the enum fields sometimes work and sometimes don't. Very frustrating. The times when they don't work, the…
-
Help! I've hit a brick wall with a bulk update function
Hi. I am completely new to xano and I'm struggling to understand it. I was using adalo for an MVP build but hit a wall because the database functionality in adalo didn't support bulk updates. So I'm hoping I can achieve what I want to do in Xano. My app is essentially a to-do list that will break down a big goal (or…
-
I need help with the function stack
hello i am creating an ecommerce b2b portal. Only i have problems with the product attributes. I have much problems to transform my data in the function stack, I have different productitems where the product attributes are stored only of I wan to extract the data i get it in a format that is difficult for the front end to…
-
extract value from array
External API response is a single array with decimal value in it. last: [31.8] How do I extract the value to be able to use it for math operations after? The value is dynamic and pulling from external API.
-
Setting up a default, if not ..
I have a live city app that's currently being used by users in City A. As the app expands, I need to add a new city, City B, to it. For new users, I've set up a mechanism using device IDs to automatically provide information related to City B upon selection. However, I'm facing a challenge in setting up a default city. I…
-
Operator for filtering "any from array" in "array"?
Hello Xano team! I query all records from "products" DB and I need to filter them by input var array products.tags - array of tags input - array of tags I need: any of tag from input is in product.tags array[Screenshot 2022-10-13 at 13.49.18.png]which operator to use if both sides are arrays?
-
External API Request - Adding arbitrary string data before the JSON.
Hi, I am using the External API Request function and it works fine when loading JSON parameters. However I am hoping to see if I can add some arbitary string data BEFORE the JSON paramters are sent. The remote location can happily receive a string before the JSON data. For example, I am trying to add the word WARN as a…
-
Resetting variables
Given multiple returns all with the same name, is the last one invocation the latest value? Intuitively that would make sense but I want to be certain, please see screenshot.. who ever wins the if/else condition is the user that is returned right?
-
Magic link: encoding versus UUID?
I see that most of the marketplace functions that generate a magic link will create a password / random string and then use a function to encode the string before returning it as the token. Is there any benefit to this approach versus just generating a UUID to serve as the token? The encoding seems unnecessary.
-
Why does my webhook gets a 500 as soon as I publish the endpoint? (Build plan)
Hello, I'm sending a post webhook via Postman. When I go to the request history of my endpoint I get a "200 OK" result. Then I publish the endpoint. I post the exact same call from Postman, and I get a "500 internal server error" - although I do receive the data from Postman. I'm surely missing something obvious, but I not…
-
Is it possible to get the most recent record for each group?
Hi everyone! I have a table candidate link to tables order and worker. Each line in this table candidate have different status like: I want to make a query all request filtered by "where order_id = input.order_id" to fetch only the candidates of a specific order. But I want to only have one record per worker_id so I can…
-
How to push/remove a value in the list while editing the record in 1 step?
Hi I am new to Xano. So this might be a stupid question. But I didn't manage to find a good answer online. I have a table "files" with column "variants" that is a list of integers. I want to remove/push the value in this list. Right now, I need to do 2 steps Get a record to basically get the current list ("variants_id")…