-
Background activity monitor
I have some APIs that run for an extended duration, like 5-10 mins. Is there a way to see which APIs are currently running?
-
Enum mismatch issue
I'm adding a bunch of records into a DB table using a loop. One of the fields is an enum type and occasionally the value being passed in does not match the enum. e.g. enum = Apple, Pear. however the value = Watermelon. Adding a null value into the enum field when this happens is an acceptable outcome. Any suggestions?
-
How do I add a integer variable to a text variable.
Hi, I am returning a text variable but also want to append a value of a another integer variable to the text variable. Eg "The value of mindset course is: $300". The 300 is a integer variable that I want to add to the text variable. I'm sure its simple but cant find the answer.
-
Adding API Endpoints when Creating Tables in MetaData API using POST
I am trying to see if I can automatically assign an API Group to a table when I am creating it via the MetaAPI. In short, creating the tables in the Xano GUI allows for specific API Group Endpoints to be added at the time of creation and otherwise requires going through the API Endpoint GUI to assign each one to each…
-
How to delete Table in Database?
I'm ashemed to admit but I can't delete a table. I follow the instuction https://docs.xano.com/database/database/table-view#deleting-a-table but I can't find 3 dots in top right menu
-
Add a participant
Hi, I need to set up a sort of counter where every time a user presses a button to say they want to attend an event, the 'number of participants' column in my xano table increases by one. How might I do that? Thanks, G
-
Issues with delete API end point - Error when record not found
Hello All I have an API end point that takes in an ID, and then deletes records using direct query from two relational tables (i.e. table1_table2, with table1_id and table2_id as fields, and table1_table3, with table1_id and table3_id as fields), and then finally from the primary table (table 1 from the above examples). It…
-
Temporarily disable API endpoints
Hi everyone! Fairly simple question, but is there a way to disable API so they can't be used without deleting them? I know I can delete and re-create them if needed, but being able to lock/unlock endpoints would be helpful and I haven't found a way to do this using the support docs or community resources. Thanks in advance…
-
return the longest text value in an array
Curious if there is a fairly simple way to identify & extract the longest text value (most characters) from an array of text items.
-
How to sign a request with AWS Signature? (Lambda function?)
Hi there! I wanted to check if anyone has experience with AWS Signature using Xano? I know there is the manual way to sign requests but was just curious if you could modify the AWS SDK for javascript to use in the Xano Lambda function? Here's the guide for the signing request: And here's the Javascript code: Appreciate any…
-
How can i search with priority on column between tables?
I have table A and table B. A and B can be joined together. I am implementing an api, which return joins of A and B. The API requires search on A.name and B.name. However i want to list the search on A.name on the top? How can i do that?
-
Date and time
Hi, Is there a way to record time in Xano? I have a date/time picker in my Draftbit frontend, but when I send to Xano it only records the date. It must be possible as timestamps are down to the second. See the screenshots below:
-
function works directly - but when called from another function it throws an error
Okay - I am beating my head against the wall with this one. I have a function that with two inputs that runs correctly. But when I run that function from within another function - with the exact same two input values - it throws an error. I made a loom video - appreciate anyone guidance.
-
I need help with making an API request in Xano
I'm trying to get the data from a file that is currently saved in my Xano database by making an API request. First, I make a query of the database with the files, next I get the file's url. I use the file's url in the API request using the GET method and settings the content-type's charset as "windows-1252" since the file…
-
Has anyone created a snippet for formatting a timestamp into 2mins ago, 2hours ago 2days ago etc?
I see from the Xano docs there is "Relative Time Formats" but I can't seem to get them to work, especially the 'ago' one. Any help would be greatly appreciated!
-
Custom Query - Relation Table in list
I want to apply a filter to the table, and the field I will filter is a list in table relation, meaning, I want to fetch the items that contain the IDs 1,2,3 from the list, but in all the ways I've attempted, the custom query isn't working. Does anyone know how to do it?
-
Control error
Im receiving this error and i cant seem to fix it? any ideas? Im using bubble to send to Xano endpoint. (raw message: {"message":"Error parsing JSON: Control character error, possibly incorrectly encoded"}) any ideas?
-
Direct database query - Array as an statement arg
I´m having trouble to set an integer array as an statement arg to a direct database query Array: SQL: Args: Error: The same SQL query without the args works:
-
Sign up users "internally"
Hello everyone, I am making an app for a client. I want to be able to create a Superadmin to signup Administrators of the organization. This administrators created by the Superadmin will be able to signup members of the team. But the idea is that Signup page is not a public page, so nobody outside of this organization can…
-
How to create a simple data validation list
Hi there, I am new to Xano and WeWeb and do not have technical experience, so apologies if this qualifies as a dummies question. I have a xano table with a list of names. I want the user to be able to choose one of those names by viewing and selecting the list from a drop down box - similar to data validation list in…
-
Webflow/Xano google Oauth troubleshooting
Hey I'm new to Xano and i'm trying to set up a test site to figure out how to introduce users into a webflow site. I followed the instructions from the "Enable your Webflow users to log in with Google using Xano" video. I've gone over everything a million times and I can't figure out why im getting this error message.…
-
My google oAuth plugin doenst seem to work
The code the "/oauth/google/init" provide gives an acces error when using it in "/oauth/google/continue" or "/oauth/google/signup". Im using Wized.
-
What is the formula to convert timestamp to days ago?
I have the creation date in timestamp and I would like to change it to something like "created 2 days ago" how should I do it?
-
Subscription questions
Hi all, I'm nearing the stage where I'll want to upgrade to a Launch plan with Xano. I just have a few questions about the specs: What does the 3GB SSD storage cover? (i.e. what is stored in it, as file/image storage is separate?) What constitutes a "task" in the price plans, e.g. "sub-minute task schedules? What counts…
-
Scaling Database to 130MM Records + Querying
Hello - I am considering using Xano to host a database of 130MM polygons. I'd like to query the database using "Query All Records" with a Custom Query where a specific point (lat, lng) is within one of the polygons (return the polygon the point resides in). My question - do you foresee issues working with a database of…
-
How to let people register with an invitation code
Hi, I am building this webapp (webflow - wized - xano) where people can create an account but they do need to have an invitation code. So we have a registration form with name, company name, email, invitation code, and password. The invitation code needs to match with the email. I am not sure what would be the best way to…
-
How do i handle object with no keys or empty value OR missing object in a API request?
Hi there! I'm pulling data from the tasty API and is facing a challenge. I've build a function stack to pull nutrition values from the get recipes/get-more-info endpoint. But it seems that the function stack will stop running when it runs into a recipe that has either the 'nutrition' object with no keys or is missing…
-
Google OAuth - Precondition Failed?
It seems when trying the Google OAuth, I get stuck on the Continue API GET request. My Init works fine, but when running Continue with my code & redirect_URI I just get "{ code: ERROR_CODE_ACCESS_DENIED, message: Precondition failed. } Any ideas? I haven't edited the API GET request at all.[chrome_TY1PQEtIqQ.png]
-
Not able to use /n (new line) character. Please HELP!
I am trying to create a dynamic public key which will be used to verify signature.I have written lambda function for that. My code: const EncodedKey = "-----BEGIN PUBLIC KEY-----" + "\r\n" +$var.publicKey + "\r\n" +"-----END PUBLIC KEY-----"; The error: error:0909006C:PEM routines:get_name:no start line Please kindly help…
-
Library functions inside lambda
Is there any current way we can call a function from the library inside a lambda? This would be a game changer🚀!!