-
Diff filter doesn't work on object arrays?
[Screen Recording 2022-09-21 at 14.07.26.mov]I have two JSON arrays, and I'm trying to use the diff function to identify unique objects in the array. This works fine on a simple array of numbers, but on an array of objects, it says "an unknown error has occurred" Please see the video attached. First I show you that both…
-
Exporting a txt file?
I have an requirement that I must export data as a .txt file. Is it possible to do this in Xano? If it's not possible to do it natively in Xano, is there a workaround to export it? Thanks
-
Creating a recursive loop using for each.
Hi. I am working on a set of data that requires a loop to periodically update the variable being looped over and include the new items to be looped over. It is limited by a larger variable whose size will always be larger. The structure of the larger variable is similar to the below where the smaller variable will be…
-
Deleting Multiple Records based on a condition
I am new to Xano. Is there a way to delete multiple records based on a condition? For example, I have in my database set of dates in UnixTimeFormat and I wanted to delete all records lesser than the current Unix Time. I was thinking also of creating stack of functions like : 1. Query All records that satisfy the condition…
-
Adding an element to an array: Push and Append replacing the array, rather than adding on to it
Hi! I've created a Function with a For Loop, where at the end of the loop, a new variable is created, and I want to add this variable to an array. I've tried both Push and Append. However, with each one, the entire array is replaced with the new variable as an element, rather than the new variable added on to the end of…
-
Skip first three rows of CSV on import?
I have a CSV that users will be uploading from a specific source that adds notes in the first three rows of the CSV. So, the in source CSV - the headers are in ROW 4. If the first three rows can be deleted (or ignored) - then the file will upload perfectly to the existing table I have created. Is there a way that I can…
-
Query all records, where foreign reference does NOT exist
Hi, I'm trying to do a query in table A, where table B does not have a record with a column pointing to table A. I'm looking around the inner join queries but don't see an obvious way to do it. Ideas?
-
Create Image from buffer?
Hey! I'm doing an external API call to get the image. Then I would like to create an image based on the result of the request. When I'm passing a random URL of the image to "Create Image Metadata" like this: Everything works fine, but I can't pass the directly URL to "Create Image Metadata" because the request that I'm…
-
Formatting UNIX timestamp in query Addon
HI all, I need some help to solve an issue. I have a query all records where I run a for each loop to format a timestamp in human readable format. However, the query has an Addon that brings individual time stamps called as trackers. I need also to format the timestamp from the Addon and haven't found a solution so far.…
-
Group by child tables
I have two tables, profile and company, and I do a left join in a Query All step has some profiles may not have a company. The company table has attributes like company_size. I want to provide a result that aggregates the # of profiles by the company attributes like: { company_size: { "1-10": 33, "11-50": 63 } } They "key"…
-
round to the nearest integer
Hey there, does it exist a "MROUND" filter in Xano to get the nearest integer of a number? 62.48 ⇒ 62 62.52 ⇒ 63 Thank you
-
Array Filter not working - what am I doing wrong?
Hey Xano Community, I'm a bit frustrated already because I'm stuck on a problem for so long that seems so easy to solve. The setup: I have an array of objects. I loop through this array and use "Find all Elements" to find certain items. I push those items into a second array outside of the loop. Now, with each iteration, I…
-
Confguring SendGrid Unsubscribe Module
Hi all I'm trying to configure the Sendgrid Unsubscribe module in my Sendgrid Dynamic Templates. This documentation says that I need to pass in the group_id tag withing an asm tag, like so: I configured this in Xano thus: But it wasn't passed to Sendgrid as expected: Anyone know how to configure this please? Thanks.
-
Using JSON Schema in Xano
Hi, I want to define a JSON Schema in Xano in order to use the new function calling of OpenAI/GPT. Couldn't get it to work as the normal Object tries to treat the schema as an object and gives an error. Does somebody has a hint how to save the JSOn Schema in a variable?
-
Math in multiple fields on the same record
Hi guys, I have a data base structure where there is 8 fields as doubles and one text field. When I query the records, I would like to calculate an average of the 8 fields. I tried to create a new variable starting with 0 and set up a function stack to add numbers. When I put the value to be added like db.field I got an…
-
Create URL-friendly slugs?
I'm in the middle of creating a function stack that grabs a number of items and mashes them all together to make a URL slug for my site. Here is a sample: That works great for that particular item, but when looking through my product table I'm seeing a lot of MDN (model numbers) that use characters like spaces & periods.…
-
Aggregate data after query with multiple groupings
Hi there, I'm stuck for quite a while on this problem and hope you can kick me in the right direction. I'm building a billing system for an audiobook distributor. They publish audiobooks for their publishers on two platforms (Bookwire=bw and Audible=ad). They get the sales data every quarter and must calculate the total…
-
Inexplicable updating of record when function disabled
Hi there I have a step disabled in my function stack and yet somehow that step is still being performed. If I enable the step, then the step is performed twice! Is this a bug or am I doing something wrong? Please tell me I'm not going crazy….! Details in loom, thanks!
-
Counting words inside a List of Text in multiple objects
Hi all, I have a record with fields as List of texts. I'm trying without success to build a function stack to count how many times an specific word appears. In the exemple below, you can see 3 records and 2 list of texts. If I want to count how many times the word "Proud" appears, how should the function stack be?
-
How to split numbers in a text column
Hi everyone, I'm trying to separate number data in a text column formatted as 8.75 5 to display 8.75 and 5 as separate pieces of data. I'd love any feedback on the simplest way to do this.
-
If we have condition for `FI , Else If, else ` it would be much easier building function in xano.
So I am building a login function stack, what I want to do is to make it in one call. like below; I found if we had an "IF, if else, else "statement it would be much easier to work in Xano, Currently, I have to do it with " IF, Else " which is becoming lengthy and tedious. Check if the user state is REGISTER, check the…
-
Best way in Xano to concatenate a full address from parts that needs to be stored in table
I need to concatenate a full address from it's individual geocoded parts where some of the parts of the address may be null. The result needs to be stored in the table. I know what I need to do, just not sure of the best way in Xano. This is part of an API call. Parts include: StreetNumber StreetDirPrefix StreetName…
-
Add trailing zero to decimal
How can I add a trailing zero to a decimal so that is always returned as two decimal places? E.g. decimal in DB of 452.5 should be returned as 452.50. I tried the 'round' filter but it doesn't work. Thanks.
-
How can I construct following query in xano ui ?
Here is my database structure I want to execute following query for Identification and Access Management : SELECT user_id,MAX(create_emp),MAX(read_emp),MAX(update_emp),MAX(delete_emp) FROM member JOIN permission_group ON member.group_id = permission_group.id GROUP BY user_id HAVING user_id = 2; Can someone help me how can…
-
Generating data as a fixed-length record
Is it possible to generate data as a fixed-length record? I want to be able to export a list of Users and all of their information. Each user would be on a separate line. i.e. Name (20 char)| DOB (10 char - dd/mm/yyyy)| Location (20 char) | Company (20 char)
-
Uploading Image URL to S3 via API without storing binary data to Xano File Storage?? - HELP PLEASE
Right now I'm trying to save an image file to S3 via it's public web URL using Xano. S3 only allows me to upload a binary image file, which is fine. But in order to do so, I have to download the image from the URL, save it to Xano file storage, then upload the binary Xano file to S3 via API, then delete the binary file in…
-
Transforming String in List of records
HI all, I have tried different transformation filters like SPLIT but haven't manage to get the result that I need. My Post API call bring a List string from Flutterflow and save as 1 record. The field in Xano is a List of Text. The string brings two texts but is register in one record. How to transform the list to have…
-
How can I make a count/aggregate on object's array
Hi there, I need help setting up a query that includes a count of an object column within a database table. The set-up: I have a database called "notifications" Each notification has a column called "reactions" This column is an array of an object. Each reaction being for example an object containing userID, date, … so in…
-
How can one change a key text in an object?
I have a list of objects I have returned from candidate_application table, which mainly contains the candidate's ID, the job ID (related to the jobs table). My aim is to use add_on to bring the title from the job table. I did that and got the below (image) but I would like to change the key title to something like…
-
Filtering external API request results
@Yuriy Below you can find a video explaining how to use the filter Filter to filter the results you are getting from the external API request. Let me know if this points you in the right direction!