-
Passing array output from a query into an addon input
Has anyone discovered a way to pass a list of values directly from the output of a query into an addon? I have an addon which does some aggregate calculations, based on an array of values (which it looks up) for the input. The problem is though - I can't find any way to pass ANY list value as an output into the addon (it…
-
Parsing Object with Quotes into Array
My frontend is providing me with this: { "2": { "domEvent": {} "value": [ 3, 4, 5 ] } "3": { "domEvent": {} "value": [ 7, 10, 11 ] } } I'm trying to get the values as a list. What sequence of filters would I need to use to transform this into an integer list / array of [3, 4, 5, 7, 10, 11]? These are coming from a sidebar…
-
How can I link a single uploaded image to multiple records
The scenario is as follows: I have a field in a table for status Status can only have 2 values, active and inactive I have uploaded 2 icons to public files, one for active and the other for inactive How can I store the 'inactive' image against each record that is inactive? Alternatively, when creating an endpoint returning…
-
Query condition based on relational data
In the Xano-WeWeb tutorial there is an example for conditional query: Only show records when user_id = user.ID I also have a Company database, related to multiple users (team members) who should have access to each others records. For instance condition for Products database should be: Show products to users "Where Company…
-
I want to take date as input and query all records that are created on that same date
The created at field is timestamp in xano . not allowing to compare only date
-
query all records missing some filters and compare ops
[FireShot Capture 090 - Xano - api2.zwsociety.com.png]Missing filter to convert db fields to array (e.g. a description text fields with free text), Missing intersection operator to allow db field to be compared to an array of keywords. Missing regex filters, missing array count filter. Generally availability of filters is…
-
Overwriting my array objects instead of appending it
Hey guys, I have a setup to add an object to an existing array of objects, which are reviews in my case. My problem is that instead of appending it it's overwriting the values already existing in this field, here's a loom with all the details: Thanks for your time
-
How to filter / summarise a response based on a criteria nested two levels deep?
I have a response from an get all records query called certificates, enriched by some addons (farm, credits). I want to filter my response where credits.status == ex_post. How can I achieve this? Using the result I want to summ different data from that list like total_tonnesco2e with credit status ex_post I tried dot…
-
Build a custom sitemap with Xano?
My Bubble website uses Xano to populate all of it's product pages. So for example the URLs look like the following: domain.com/product/565 domain.com/product/985 domain.com/product/1183 domain.com/product/89 When the page is loaded on Bubble, it knows to make an API call to Xano looking for the ID in the URL (So…
-
Unable to update a timestamp field in Add records in bulk
I'm trying to add records into a table in bulk after preprocessing and building objects received in another query. So, I set "updated_at" with "now" as a timestamp in a new variable, which I later will be merging with another object to include in my bulk task. However, the timestamp is not updating in the destination…
-
Error "Text filter requires a scalar value" when looping through array
I want to loop through an array of teams: ["Sales", "Management"] For each item in the array, I want to create a new team in my Team table. However I can't seem to get to the team name when creating the teams. When I refer only to the item in the array, I get an error "Text filter requires a scalar value". I've already…
-
How i make a conditional case-insensitive such that it works in all capitlization variations?
So i have a conditional Where, String A == String B. What is the simplest way to make sure it returns true if the strings match in all characters regarding if their capitalization match? So if i am comparing Myemail@gmail.com to myemail@gmail.com it will return true?
-
Non Break Space (NBSP)
I have a problem importing data from a file where sometimes have a non break space (NBSP or U+00A0 or   or chacode = 160 or \00A0 or ) In the workflow, if i don't use anything related to lambda no problem happens, but the result of the API in postman are with the space. Data in file: SEVE CD LS 20 Data out for…
-
HTMX + Xano + ..Webflow? 😍
With all the HTMX craze, I thought to create a Webflow cloneable, and who knows maybe a Webflow App, but I noticed that HTMX needs to get HTML back in order to swap content inside the document. So my question(s) is..: - Can we manipulate data in Xano to return with the format we want it (from JSON to HTML) without using…
-
How to manipulate/transform an .slk file in xano ?
Hi, I would like to import data (open data from a French public site which does not have an API but allows the download of a .slk file) I do not know how to transform the .slk file into json . I tried with a lambda (and the help of Chatgpt) but without success. Would you know how to do it? Thank you in advance for your…
-
Querying and transforming object (using Google Places API)
Hi, I am using the Google Places API and would like to extract some information and write it to a table. I would like to save the address in a table of "service providers". The concept of what is a city differs hugely when looking at a global level. So I would like to store the administrative_area_levels, als Google calls…
-
Generate a random 8-character string for each record
In a product I'm building I'm in a spot where I think I'll need a way to allow users to invite other users to share data. My thought is if John wants to let Sarah access his records, John will add both Sarah's email address and Sarah's 8-digit code in a form to add her. Meaning, Sarah doesn't need to receive an email to…
-
looking for trigger & automation guide
is there any guide about < trigger & automation >? just like Airtable, i would like to make automated tasks when a record row is generated -> create new row in another table ex. when a new record is generated in a table, then create another record in a different table based on the values. what kinda guide do i have to look…
-
Support for UUID?
Hi Why Xano does not have the UUID type that comes with PostgreSQL? Is this something that you will offer in the coming future? If not, why not? Thanks Joe
-
remove three rows BEFORE running CSV Stream
I am working on a CSV import API - but the specific CSV I am importing has 3 rows of notes I need to remove above the header (4 rows to remove total including header row). I did the old way (pre csv stream example video from Xano) and just repeated the way header was removed three additional times to get all 4 rows out…
-
Best practice for keeping a while loop in check
What is the best practice for keeping a while loop in check while building and testing? Currently I create a variable that increments on each run and make it part of the condition for whether the loop continues. So like 'iteration < 100'. Is this the right way? Is there a simpler way to manage this?
-
Addon default if record doesn't exist
This is probably more of a feature request, but is there an easy way to define a default if an addon to a query function doesn't contain a record? Currently, the way that several addon types work (aggregate, single), if no record(s) were found it simply leaves out the field entirely. This is just annoying when it's a…
-
Addon behavior...
Hey, I have some addons that return arrays of objects... I'm looking for a way to prevent these addons from returning [null] instead of [] aka [0] when no data is found... Reason i'm asking is because (thanks to Eli and Jared) we found out that an array with "null" inside, breaks/prevents the XanoSDK in Bubble from…
-
Group Items by Entity in Another Table
I currently have and endpoint the pulls together multiple tables into one API response using subpaths. An example of the response is below: { "id":146, "created_at":1696558520736, "property_id":0, "user_id":0, "status":"Created", "payment_status":"Unpaid", "first_name":"Peter", "last_name":"Griffin",…
-
Direct Database Query + Update Variable to add property to object
So I am using a direct database query as a fallback to a Query All Records. Each of these return an array of objects. After either of those steps are hit, I'm adding a new property, distance, to each item in the array. When I do this to the variable from the Query All Records, everything works great and the property is…
-
Help with For Each Loop and Array
Hey all, I have a peculiar problem in which I've tried every manipulation possible to fix. Here's the core problem: I'm running an aggregate result on a table, it also has add-ons. Here is the output. It is an array of objects and works as expected. Then, I want to do a for each loop to multiply…
-
Lambda - Incrementing a variable in a loop
I have an int variable called count_emails. I wanted to use it as a counter by incrementing it in a foreach loop. I thought a simple example like this would be a good way to start with lambdas. I tried both of the following, but the value of count_emails remains 1. - see screenshot 2 return $var.count_emails++; return…
-
Extract lat/lon from geography (point)
Is there a way to extract lat/lon from a geography (point, in this case)? I'm getting a geo point as an input into an endpoint and want to use the lat/lng in a distance calculation, but the distance calculation only accepts decimal values, and thus I must extract lat/lng from the input. In this case using GET data GET lat…
-
When will xano support webp images?
I'm having trouble navigating around uploading webp images as attachments. It saves the attachment type as empty and makes my front end have problems rendering it.
-
Conditional IF - testing a bool - unexpected result
I am iterating through a list of users, so as to send them an email. A user can choose to not receive email. This is set in the table Settings with property 'canemail' which is a bool. False means - 'Don't email me'. In the screenshot below you can see that I test canemail - Stop and Debug shows that, for this record, the…