-
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 to convert this into a file
Hello I’m using the clip drop api from stable diffusion and I’m getting an image returned in this format. I’ve been told this is Jfif format but any idea on how to convert this into a file resource and ultimately an image url.
-
How to filter or query records where a table reference no longer exists
I am just trying to clean up our data as we're about to go live to 100 external beta testers. I was just wondering if there is quick way to filter or query records where a table refrence no longer exists? I have tried != = 0 = null and have not had any success in the spreadsheet view of the table
-
Convert array to json
Hi, I have an array and I would like to transform that into a typical json payload. Any suggestions? It comes from an api call, csv_encode step.
-
Import txt file
Hey guys, I am trying to create an api to import txt to xano and I am facing a issue because xano is removing the extra blank spaces and I need all the spaces to be able to convert this information after. How can I do it ? because each customer of mine have different formats and they cannot changed it. Ex of line in txt:…
-
Geocoding an address... how to save the latitude and longitude points?
I'm using Geocode.io for an external API to take a user's input (address) and convert it into geocoded latitude and longitude points, but I am having trouble saving the coordinates in the database as a geo_point. Can anyone help me understand how I can accomplish this? I have successfully converted the address into…
-
How to i replace non-breaking spaces with normal spaces
I am receiving data which has, I believe, non breaking spaces. This is then causing a problem with my next API call. How do I change the non breaking spaces to normal spaces on Xano? Is there a certain Regex replace I need to use? Any help would be much appreciated! Thanks.
-
??♂️ Object Array being Deleted instead of Added to
I have a table for users and a column (object data type) for profiles. The profile schema is very simple: profile_id, profile_firstname, and profile_lastname. I have an endpoint that takes a new profile firstname and lastname. It finds the last profile on the user and pops off the profile_id, adds one to "autoincrement".…
-
How to nullfill variable (equivalent of SQL coalesce)
I keep running into the use case of wanting to create a variable that is the first non-empty value of a series of other variables. For example for some final variable X: I want X to be the first non-empty value of variables A, B, and C So if A = 2, B = null, C = 1 then I want X = 2 If A = null, B = null, C = 1 then I want…
-
How to return a value only if it is set?
The value `ongoingTimeCategorizationUpdated` is only present when a couple of conditions are true. This leads to an issue when it's not set. Is there a way to handle that use case gracefully? I'd like to avoid an extra action, if possible.
-
How to nest a list of items within a list of items?
I want to have a user select a car manufacturer from a list of available options so that, when they choose their car manufacturer, it then brings up the available models for them to choose from. I do not want users to store their vehicles as text fields, as this would make it harder to verify whether their insurance is…
-
Is there a function in xano to shorten a url without using external services/APIs
I am wondering if there is a way to make a link shorter without the need for using external service/API integration. Is this doable in xano? Regards Nour
-
How to update the value of object
Hello, ran into a strange issue while using an external API, { "id": 1, "lat": 55.082226, "lng": 22.76919399999946, "rank": 2 }, { "id": 2, "lat": 55.082226, "lng": 22.76919399999946, "rank": false } This is the response that I get, and in my database, I have 'rank' field as an integer. Is there a way to replace those…
-
Filter after aggregate function
I have a list of stock transactions that I want to run an api call to aggregate them and only return the currently active holdings. In other words if the sum of all the transactions for a certain company returns a quantity of 0, I would like to filter it out. I can understand how to filter the inputs but not the outputs as…
-
Bulk delete via Direct Database Query
I am wondering if I can take advantage of Direct Database Query to remove multiple (thousands) of records. My query: DELETE FROM abc WHERE id IN (?); This works if I specify the id values by hand, but when using an argument there I run into an SQL error. Even when I transform an array of ids to a text like "1, 2, 3", the…
-
Import CSV issue
Hello, I have created an endpoint to upload a CSV to create records in my XANO database. The whole action is working fine. The loop retrieves the object but when I do the GET to add the data to my database, this adds an empty line. However, in my history when I run a test I see this. Do you know where I made a mistake?…
-
New column in output for each record
I have an Employee table which stores the Name and Salary. I want to run a query to Calculate the average salary of the entire table. Check each Employee's salary. Label it as High or Low if it is higher/lower than the average. Get an output for each Employee's Name, Salary and Status [high or low]. The first step is…
-
Sum a duration field in the correct format
I have a database where I am keeping track of incoming calls. I have a field where I keep track of the duration of the call in this format minutes:seconds. Currently I have this formatted in a text field. I need to sum up these duration values and return them in this format hours:minutes:seconds. Does anyone know how I can…
-
Tip: sorting is disabled by default in queries
Hey gang, I watched this video on accessing arrays within arrays by using an index. Unfortunately, queries performed around my implementation of this pattern were not sorted by default, resulting in unpredictable behavior when "set"-ing and "get"-in by index. This (see the video) was a powerful feature, b/c of how often…
-
Sort and filter by count
I have an Property table n-1 Floor table. And Floor n-1 with building table. Now im having a case that need to query building with sort and filter by Property record count. And Filter and Sort by Owner[] which is an field of Property. Can xano do this natively. Thanks alot.
-
ENUM values as a return variable
How do I include ENUM values in a return variable as part of a GET API. The enum values will be used in a drop-down. The GET data will be subject for change and a following UPDATE api.
-
Xml to Json
Hey! The external API returns the response to the request in xml format. Is it possible in Xano to convert xml to Json or parse xml? The xml_decoder filter could not solve the problem. Returned xml example: <?xml version="1.0"?> <ReservationAbodeTable xmlns="urn:schemas-som-ru:tws-reservationAbodeTable"…
-
Create zip file from database images
Hi there, I have tables containing images or pdf files. Now I need to create a zip file from a set of these images so the user can download all in one file with one click. I did not see a function for that in Xano so far, does someone know a trick or hidden feature for that (lambda?)
-
Using Xano Pattern filter (Regex) doesn't give expected results
I've added a column with a Pattern filter, as such: The pattern is: `/\b(1[0-2]|0?[1-9]):[0-5][0-9] [AP][M]\b` Il also tried `\b(1[0-2]|0?[1-9]):[0-5][0-9] [AP][M]\b` But it doesn't work, I can write any kind of text in the column, it doesn't get rejected. Although, I've tested that regex at and it provides expected…
-
Returning the "x" last records from the table, but in ascending order
Hello. How do I make a query on a table, returning the "x" last records from the table, but in ascending id order? Thank very much for help.
-
Concat substitutes ¶ with a paragraph sign
hey guys, I try to build a URL string with parameters using concat. If I add ¶m2= to the string "¶" is substituted with a paragraph sign, see second screenshot. What can I do to make sure its not substituted? Thanks so much Timo
-
When should you create a new API instead of modifying an existing API?
Hey ya'll, An area I'm struggling with is how to determine making the call to either create a new API or modify an existing API. While it is relatively simple to create new APIs, the list of APIs just continues to grow. I'll paint a scenario for example sake. I've decided to have two user types - it will use the same user…
-
How can I build an activity tracker with Xano?
Hey! I would like to create an activity tracker for my dashboard. To be flexible with more upcoming modules, I had the idea to create three different databases. One for modules, one for submodules and one for activity_tracking of users. I would like to left join the submodules with my filtered activity_tacking table for…
-
Configuring Plaid Transactions in my DB
We are sourcing Plaid transactions which contain the following logic for negative/positive markers on the 'amount' field (from Plaid docs): The settled value of the transaction, denominated in the transactions's currency, as stated in iso_currency_code or unofficial_currency_code. Positive values when money moves out of…
-
Update Datatype & ignore empty fields not working for Booleans and ENUM fields
So I try to do a simple edit action to one of my data fields and ignore the fields that are not send in the call. I do this by using the Set_ifnotempty/null filter. This works for strings and dates, but not for booleans or ENUMS. Although the fact I use set_ifnotnull, my boolean fields always get reset to false if I don't…