-
performance insights
I have an endpoint that really has a lot of validations. This is divided into 2 it makes validations of the input data. Approx this validations is taking 3sec (of all the logic of my function stack). If the result of this validation is true. I must send a request to a third party api. when I send this request I get a token…
-
How can i return values from object received from a post ?
Hi there ! i would like to return 2 values of each object i received into a lonly object but i successly fail. I mean i can't configure with the set or get, i've tried many combo as to set my path and indicate the 1st value and it still doest work. How to return the values i put in picture.url and picture.description…
-
Querying a Database for Matching Element in Array
I have a large database. One of my fields is an array of text. I could easily juggle it around to be an array of objects or an array of some other type if it helps. I am wondering how to query the database to return only records that contain a defined search element. For example if a record had array: [text, dog, cat,…
-
Weird database column header display
Hey Peeps. Can anyone tell me why this table is not displaying the ID column header correctly? The ID column display width does not match the ID column header width. If I try to reduce the size of the ID column header, the actual ID column reduces at the same time. Also, the time_as_text column header is showing, but the…
-
"object" text issue
Hi all. I have a weird issue and I'm hoping someone has a workaround. I need the text "object" on an API call. However every time I write "object" Xano auto converts it to {} an actual object. I dont need an actual {} object. I just need the word "object" in plain text. I also tried to concat an empty field, but I got the…
-
File name is too long?
I've attempted to load multiple files with various name sizes but I keep getting this error. Any thoughts on how to resolve or what the core issue is?
-
Sprint F problem. It's confusing % with %s
Hey, my Sprint F function is confusing a % with a %s and telling me I have an invalid parameter count. See this quick video: Thanks for any help!
-
Swagger API's dont correlate to API section
The API's that I had set up under projects within the API tabe are not under the same heading when I enter Swagger. Does this impact the functionality of those API's and how do I correct this so both are identical?
-
How much could it cost me per month?
I'm developing an app with FlutterFlow that is about to be published since we have people waiting for it. At what point should my app be to have to move from Build to Launch and from Launch to Scale x1?(e.g. 10k, 20k, 50k active users. X reads and writes.) Thanks
-
File resource duplicates object
Hey everyone, hope you're doing well. I have an issue apparently caused by a file resource. I have this input that is a list of objects The data I send from the frontend is this I then do a loop on the variations list to perform the desired action, but I'm being confronted with the loop running twice even I just sent one…
-
Authentication during API configuration and Rund and Debug
I've noticed that when setting up API's I dont have a user authentication drop down. Additionally there is no quick authentication tokin that I can use during run and debug. Can somone point me in the right direction to set this up.
-
Simple problem from a novis
I have table 2 which refrences data from table 1 using a "table reference". The issue that I"m currently having is on the front end. When the app pulls the data from table 2 the collumn refrencing table 1 data comes through as a number and not as txt. Any thoughs on how to sove this? I'm sure its easy
-
How can I apply a condition to function in a stack?
I am pulling properties from MLS and adding to a table using Upsert. I have a custom function that pulls comps based on the address. I have that function run as part of a stack that pulls the properties from MLS. I only want the custom function that pulls comps to run when a new record is added to the properties table but…
-
I am passing 148 objects as a JSON input to an endpoint but only 67 are received, why?
Hi, I am passing information of 148 products like this ones (this products are retrieved from Meta's API): This list is passed as JSON variable "client_variants_meta" to another endpoint that uses this as an input. However, if we use the requests history to check the inputs of that other endpoint, it says that there were…
-
How do I input a nested json as a parameter?
I have set up this webhook where a nested value called score[scaled] is sent to me. How should I set up the input such that it can read this number?
-
"Searchindex" and the wildcard operator
Hi guys! The wildcard operator is great when dealing with single words, but when a "sentence" iwth i.e. two words is the input search it falls down. Anyone have any good examples on how to deal with this? I have tried to skip the :* when dealing with more than one word, but it seems difficult to find white spaces in the…
-
Dynamic Image Transformation Quality
Hey, when I transform an image, the new image quality is bad. I made a quick 1-min video showing this: What do you think I can do to help this?
-
Column depending on another
I have a column that depends on another. Depending on the value that is entered, the other column needs to be automatically filled with a predefined value. I've been trying to do an endpoint, but isn't working.
-
Add record errors for user signup
I have a lot of fields in my User table, some of which are referencing other tables. When I try debugging the Signup API I'm getting an error and I think it may be related to the referenced items, but I'm not sure. I'm screwing it up somewhere. I can set some of the fields to id (auth) and that'll remove the warning but…
-
Return an ID each time a value is found in a object array from an array
Hi there, I know it's possible but can't get my mind into it: I am quering a database to have all the result matching a specific request. It comes out as an array (list of results). In this array, there is this "selected_club" section that has a specific array of objects I am interested in, I would like to see if my…
-
Combining JSON data from seperate sources
Hi, I have a table of products and each product gets dynamically priced for the individual user in real time. The price is retrieved from an API call. I'm trying figure out how I can combine the products and the price data into a single JSON response that I can use as an API call. I have attached a screenshot to try and…
-
Format of dot notation for nested array value
What would be the correct dot notation for highlighted nested "key:value" below. The return variable is named "results". I tried "result.links.1.href" but received an error.
-
Filter Query by organisation and subscription
Hi, I am new to Xano and my frontend is Bubble.io. I have a Subscription, Organisation (references Subscription), User (references Subscription and Organisation) and Customer (references Subscription and Organisation) tables. I need to query the Customer table were - 1. The current user's organisation is the customer's…
-
Extracting Users Initials
What's the best way to extract a users initials when they signup? Inputs will have first_name and last_name. Also, is there a way to ensure the first letter of their names is capitalized?
-
edit record remove other object properties that are hide
when i try to edit a record i hide some object properties but the value of this properties is removed and not ignored why? i need to keep the value and update the other object properties
-
How to conditionally add a new record, when a null is present in the ID?
Hi All, fairly new here migrating to Xano, moving away from bubble.io thanks to their completely misguided pricing model changes. Having a few challenges trying to migrate some core parts of the DB into Xano. I come from a DBA background, so I'm quite comfortable with the underlying structure. My specific use case is that…
-
Photo Sharing Template
Hi All, im following this tutorial in youtube "Bravo Studio + Xano: Build a photo sharing app (similar to Instagram)" when i setup Get Photo API at minute 11:23. i'm getting error 401 - Unauthorized with response body: "{\"code\":\"ERROR_CODE_UNAUTHORIZED\",\"message\":\"Unsupported input\"}"actually i follow exactly what…
-
Monthly house rental marketplace application
I am developing a monthly house rental marketplace application. I want user to reserve listing by month instead of days. What should my input, function and database should look like ?
-
Cancel an endpoint workflow with a custom function
Hi, I have endpoint A. I have a custom function A which does some calculations and defines if endpoint A should be stopped prematurely. Can I stop endpoint A by adding a "Return" function (or any other function that allows stopping a running the workflow) into custom function A or I will have to add the "Return" function…
-
How to update all Records in a database without Query All
I have a large database(1.5 Million Records), and am wanting to go through and update a field for each of them. What would be the best way to do this given that Query All seems to be returning a memory issue. Thanks for any help! Edit: At the moment my plan is to update them in chunks, just curious if there is a better way?