-
Turning created_at Into Real Times
My goal is to create a posting mechanism where the post will show how long ago it was posted. For example, "2 hours ago" or "3 weeks" ago. How would I go about this?
-
Filtering Data by Time Created
I am trying to send data to my frontend based on the time that it was created. The use case for this is a user's post would be displayed based on how recent it was posted. Think of how any forum or social media account displays posts based on how recent it was created. I know there is a way to do this, but I am unsure how…
-
How do I guarantee consistent endpoint performance with list filters?
My app's endpoint performance is great across the board when there is less traffic. "Endpoint A" will take less than 1 second to run consistently. However, when traffic increases for a 6 hour period, "Endpoint A" begins to take 40+ seconds to run. The 2 biggest culprits contain list filtering on a table Query. Example:…
-
Joining Data Correctly?
I am trying to join data in Xano in order to get data from multiple tables. Currently this is what I am doing: When I test the endpoint, I am unable to get anything in my '_userclubrole' table. It looks like this: How can I fix this?
-
Is it possible to set a default image?
If I have a 'file upload' field in my table, is it possible to set a default image for it? For example, if a user hasn't uploaded an avatar or a logo. I can manage it from the front end if necessary - I just thought this might be a more streamlined solution.
-
How far back can I fetch request data with the meta api?
I'm trying to fetch request history from last week with the meta API but I can only pull data from the past couple days. Is this a limitation or how far back should I be able to retrieve request history?
-
Deleting files
Is there a way to delete files that have been uploaded to storage? When uploading a new image to a record it's replacing the metadata but don't know what happens to the previous file. Don't want to fill up the storage with old files. I will probably create a table purely for saving the file metadata and then saving the…
-
Try Catch on External API Call
I am using Try/Catch on an external API call (actually an internal call) with the Catch block calling another external API call (internal call) if the first one fails. I've tried erroring out with a precondition, as well as throwing an error with a return value. In the former case, I just see the error from the Try block…
-
Does the new "Lock" query output feature (for database transactions) affect addons too?
I noticed that we have new features being silently released every week, I'm loving it. I have a question about the "Lock" field in the output tab of data queries. I know this feature is available for addons and that we can activate it directly from the addon editor, but locking the main query does affect nested addons even…
-
Direct Database Query - tableName as variable
Hi, new to Xano but not to building apps. We're porting an existing app to xano so i started with datamigration. Every table (about 70 of them) has a updatedAt field. We use this field to determine what the last point was that the table content was synchronised. Initially i've build a function that has an enum named table…
-
Possible to modify function variables inside of lambda function?
Is it possible to modify a function-stack variable from inside of a lambda function? i've tried everything I can think of. I want to do something like this: Create Variable: as foo Lambda function { $var.foo = "testing"; } Response: return var:foo[Screen Shot 2022-04-21 at 12.52.19 AM.png] the value persists inside of…
-
Use a web link to return the page's main image and metadata like title and description
You know how in facebook or on your phone when texting when you put a link in it transforms it to a photo and title? I'd like to do the same thing on the Xano backend and then put it in the database to then display to the frontend. Anyone done this? Is there an API or javascript to do this? Thank you!
-
CSV file import problems - "scalar value" ?
HI all. Hope someone can help me. I am trying to create a function which allows a user to import csv files on a daily basis. The files will need to be appended to the end of an existing table. When i try to test the function - i get a "text filter requires a scalar value" really need some expert advice please.
-
Deny crawling of API via robots.txt
Hi there, my API endpoints got crawled by public crawlers which resulted also in high cpu usage. Is it possible to prevent that e.g. via a robots.txt file hosted on the root of our hosts?
-
Parse XML from External API
Anyway to easily parse XML coming from an External API. I can't access the elements in it easily, so I want to convert it into an array that I can then return to Bubble. So far - I've had limited success with regex expressions; and am thinking of just looping thru the string with substring & indexes.
-
Hiatus Plan
Hey Guys! I was just presented with an offer on renewing my subscription on a "hiatus plan". I cant find any documentation on this plan but I assumed its the same plan access for a month until it tries to go back to the normal?= Either way, looks like it locks you out of your own account. Can someone refund me for this…
-
How to filter records by current month, week, today?
I am trying to create a filter that shows the data from the current month, current week and today. I previously had this filtered by the last 30 days, last 7d days using a timestamp_subtract_days filter with the number of days as input. However I am stuck on figuring out how I can filter by the current month, week. Does…
-
Using cache changes the game
I recently migrated to the Prototype plan because of the following features: - Dedicated server - Redis cache - Custom domain I would like to share here that caching makes a lot of difference, mainly depending on your function/endpoint. In simple query the cache can decrease the response time up to 2 seconds. But there was…
-
File Storage in Xano
Hi All! Im new here and I'm trying to figure out some features and solutions offered by xano. We've build app with the help of FlutterFlow, our current backend is Firebase but this is not the best solution for our app. It's OK for start and test but to scale the app we need better solution. We've looked in Supabase, but…
-
VERY VERY IMPORTANT !!!
I identified a situation that is very "interesting" and relevant(!) to be pointed and discussed: Email authentication is case sensitive and from a security perspective it is obviously very good, the users table the field email is unique and case sensitive too and again from a security standpoint it's obviously very good.…
-
Branch merging "publish" button won't enable?
I try to merge my branches. First it shows that some api group has Drafts. So I uncheck whole api group and try to merge only groups without drafts. Banner on top saying to publish unpublished endpoints remains after fixing issue. Publish button remains disabled. I have no way to enable it. Is it bug or feature?
-
How to make api calls with .p12 certificate?
I need to access a payments api that provides a .p12 certificate and requires it to be sent in calls.
-
Is there a way to use test data in API calls?
Currently, the Xano instance has 2 branches, one live and one inactive. I've been building and debugging a series of API endpoints in the inactive branch using test data. The next step would be to start initializing API calls from the front end of the app to make sure that data is being retrieved and displayed correctly.…
-
Xano's Compatibility for PCM-to-WAV Conversion and Direct Integration with Azure Cognitive Services
Hey everyone, I'm diving straight into it with a technical question about Xano. Can Xano handle PCM responses and convert them directly into WAV format? And here's the kicker: I want to seamlessly integrate it with the Azure Cognitive Services API. If you've got insights or experience with this kind of setup, please share.…
-
API Request History >24 hours?
Hi Xano team, I've looked around the community and pricing pages, and I can't quite find the answer to my question. Is it possible to upgrade the API request history functionality to store requests beyond 24 hours? With a current client, this feature is really helpful for debugging errors, but we have to catch it early. If…
-
Can I set Xano as an OAuth Provider for authentication
Hey everyone, I want to set an SSO Authentication between Circle.so and Xano. But instead of using a third party provider, like Auth0, I'm wondering if it's possible to do so directly using Xano. Is Xano able to provide Client ID, Secret Key, Scope, Authorization URL, etc. If so do you have any resources to do such a…
-
What are best practices regarding testing of our endpoints and functions? (automated testing, etc.)
We are building more and more logic and endpoints in our Xano Backend, and we have no testing whatsoever. How do you recommend the testing approach? With traditional development, we use different kinds of tests (unit test, functional, E2E, etc.), how can this be applied to Xano? I'm thinking using dedicated Custom…
-
Catch an exception
I've converted an API end point with a precondition set to enforce that data is returned. Now that this is a function, is it possible that the calling function can catch exception from the precondition in the function and do something with it? sequence: 1. main function calls the function 2. function fails based on the…
-
Exporting source code?
I'm wrapping up a development project on Xano for a client. They've invested heavily (they've paid me more than $50K at this point) so they're asking questions about backups. I know how to do backups within the system, but in the terrible hypothetical event that the whole team should be on a celebratory cruise that's…
-
No Membership bug?
Hey everyone! I am receiving a message when I try to login to my Xano workspace "no membership." and was wondering if anyone has a solution for it. Thanks!