-
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…
-
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 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")…
-
For each from an array in the previous response
Hi, Just been off of XANO (Was in XANOAX mode 😁) for a couple of months, and oh boy forgot a lot of stuff, feeling rusty. Hope you can help me: I am running an API request and I get an array "results". I now need to run a For each loop to each id inside the results. but when I try to get the path I get the 1 value in the…
-
First not empty filter with Push Filter for Array
Hello, How can I push to an array (when editing a record) ONLY if the input is not null? This is what I have but its not working. I'm really hoping I can use a filter for this instead of having to use if statement Any help is greatly appreciated!
-
For each loop, to create items in a separate database
Hi! I'm importing information from a JSON object, and I want to be able to take an array of tags, and add them to a separate database. For example, I'm trying to import each individual item from the "types" array into a separate database called tags. I'd like to have them as individual tags that I can later reference and…
-
Exception: Param: transactionAmount - Text filter requires a scalar
Hello! I am trying to run a loop to save multiple records from an external API to my DB. When doing an API call (without loop) it is workign fine and returning all data. (screen 1) Once I add the loop it runs into an "Exception: Param transactionAmount - Text filter requires a scalar." The custom function is the working…
-
How can I add quotation marks to strings in a string array?
Hi, I have this array of strings: [aw654, grw68, 4] This is what I want: ["aw654", "grw68", "4"] How can I do this in Xano? Is there a filter that can add the quotation marks? Thanks!
-
I'm looking to hire Xano expert who can help with Data manipulation using Arrays and Loops.
I'm working on building a database that would serve as a Corpus for my Arabic classes. It would be a relational database for which I create the structure myself in Airtable and then import it into Xano. The main things I need help with is Data manipulation using arrays and loops, since I need to generate new words from…
-
Update specific items in an array
Hey, I have watched a few of the Customer Corner videos now re updating/editing arrays through the API, but I'm struggling to apply them to my situation. I've recorded this loom, but will give a quick overview here too: The frontend user I have a page in my app where users can update the 'Core' for their brand, e.g. the…