-
Passing a list of objects to an API from Appgyver
I'm trying to figure out how to pass a list of objects from Appgyver to Xano to add to a table. The list contains 2 fields: 1. crewID (int) 2. Time (string) The list could contain up to 8 rows. I'm trying to configure the Xano API to add all the data in the list to the table in a single API call. I'm not sure if this is…
-
Creating a variable out of 2x inputs
Hi, sorry for what is probably a super simple question. I want to take 2x inputs (first name & last name) and set a variable using both with a space. I just can't see an easy way of setting a path which references both inputs. Thanks in advance![Screenshot 2022-04-23 at 17.49.54.png]
-
Extract JSON
I'm trying to extract data. But I need all the information. Not only the numbers (78,25) but also 'D24'. This informatie is different in every response. Is there a possibility to extract this data? [CleanShot 2022-04-16 at 17.32.02@2x.png]
-
is there a way to get the date part only of a timestamp
is there a way to get the date only part of the timestamp? or i should just make another field type for date?
-
Download an Image & Store it in a Xano Database
Hello! I'm currently following along with this video, Download an Image & Store it in a Xano Database, to try to access an image at a url endpoint and download it to my database. The problem I'm running into is that when I try to Create Image Metadata (seen at this moment in the video) it consistently gives me this…
-
Limit volume of database rows
Hey all, does anyone know if there’s a way to set a rule of maximum number of database rows? I’m creating a voucher code system and want to stipulate that no more than 50 rows (vouchers) can be redeemed, each with unique identifiers. Thanks in advance 😊
-
Extract information from geo_point
It seems that the geo_point is obtained thru the Google map API so how can we extract iinfos like city, location name etc.. ? Thank you 🙂
-
Get records with the most recent date for each group
Hello everyone, I want to know how to get the records with the most recent date for each group. Similar to this example: a | 3/20/2022 |76 a | 2/22/2022 |80 a | 2/12/2022 |50 a | 3/16/2022 |40 b | 3/17/2022 |44 b | 3/18/2022 |44 c | 2/12/2022 |50 Desired result: a | 3/20/2022 |76 b | 3/18/2022 |44 c | 2/12/2022 |50 Thanks
-
Determine the current iteration within a loop
Is it possible to determine the current iteration a loop is in? For example, I have 3 records that I am using a loop on, and I want to build logic into the loop to only run a specific action if the current loop iteration is the first. I was thinking about building a counter within the loop, but thought there might be a…
-
SQL Server to Xano import
We have an existing SQL server database having 100+ tables and some of them have a lot of data in it. To take each table, import them to xano and change data type for each field is waste of time and sometime resulting in loss of data when we are changing data types. Is there any better way in xano by which we can take our…
-
Averages with null values
Using Function Stack, and querying all records, I get the list of all my data. Now i'm trying to get averages over multiple fields. Ex: Car_usage: 1 to 5 Car_motor_usage: 1 to 5 ... So each record row is for 1 car but with multiple ratings. The problem is that if someone doesn't know for example the "car_motor_usage": the…
-
Extracting data to a datawarehouse
Hi All, I was wondering if anyone was able to extract data on a periodic basis to a cloud data warehouse like Snowflake?
-
Transform Xano generated timestamp to date format for Bubble
I want to show the date of the last record from my Xano database in Bubble and I'm presuming that I can get this from the timestamp data. When I make a get request to the timestamp parameter it displays as a number like this: "1649858712526". I can't find a way to convert this output into a date format within Bubble so I'm…
-
Importing external API data to Xano database without creating duplicate records
I’m trying to import an external API to my Xano database and update the database when records are updated in the external API. I tried using the forEach tutorial ( https://youtu.be/rdnuW2Vg8aA), however, when I repeat the Get request to the external API in order to get the most up to date fields, it duplicates the entire…
-
Query multiple tables, combined pagination
Hi all, I have three tables, each with different columns and datasets. I would like to be able to: a) Return all records within each table, combined into a single array of records with pagination. This is so I can page through ALL records regardless of their type b) Pass a query to each table, and then have a combined…
-
Problem with value type of lng/lat coordinates
Hello Community, I need your help (again 🙃). I use the geo location point in my database. And in API I get the following output: { "map_point": { "type": "point", "data": { "lng": 11.24084525997, "lat": 49.484516944722 } } } I want to use the values of lng and lat in my function. In my function I expect these values to be…
-
Objects and Arrays with Sendgrid
Hi all, I'm trying to implement the Sendgrid API, but am currently stuck with some customisations. [image.png]In Xano, I have "personalizations" for my Sendgrid function set to intake the following data: "personalizations": [ { "to": Array of objects with "name" and "email", dynamic_template_data": Object of key/value…
-
Human readable time format
I'm trying to use the default 'created_at' timestamp to show the date a post was made in a GET request. I have created a For Each Loop function and updated the variable to a human readable time format but it returns the epoch format. Is there a different trick to this or this is not possible in the default timestamp?
-
Object Notation
I'm trying to get the value for a property of an item in a Webflow CMS Collection. This is the JSON [CleanShot 2021-06-27 at 01.09.41@2x.png] Ho would I access created-on? I first did a foreach on myvar.response.result.items as item then I tried to access it via: 1) item.created-on 2) item["created-on"] and I still…
-
No GEO Filters in Variables?
Hello everyone, I have a question, why is in Variables (Data Manipulation > Create Variable) does not exist GEO filters?
-
Help with transforming the end date of a month
If I'm working with the last days of the month, say January 31, for example, and want to now get the next last day of the month, my approach has been to use the transform_timestamp filter, and use +1 month. The problem is that this returns March 3rd, not February 28 as I would have expected (and need). How would I solve…
-
COUNT IF
Hi guys, Any recommendation on approaching the equivalent to the excel formula: COUNTIF(range_of_numbers,">5")/COUNT(range_of_numbers) Goal: count the % of numbers about the value 5 Here's my current approach Using library addon the math lib are limited to count. • So I'd need to do an add-on search WHERE…
-
Grouping and Aggregating Records
Is there a way to create this query using Xano? I don't see a way to use "HAVING" SELECT user_id, COUNT(*) FROM comments WHERE photo_id <= 50 GROUP BY user_id HAVING COUNT(*) > 20;
-
Nested, very nested database edit
Hi Xano Team I am struggling to edit/update a database record based on the below database structure. [db1.PNG][db2.PNG] [db3.PNG]I would like to edit/update the qty field in the available_slots list as shown in the above screen. Can you please assist in advising which filters/structure I should use to edit a…
-
Update existing array items from another array
I'm trying to update an existing array's items with results from a separate array, matching based on a value match between the two arrays. The first screenshot (premergedJSON) is the data structure prior to the merge, and the second screenshot (PostMergedJSON) is what I'd like the data to be structured as after the merge.…
-
Conditional query with a list inside the table.
I have a table with price_lists, and a list of user_ids on each row in that table to check what price_lists the user have access to. { "pricelist_name": "test 1" "users":[2,3,4] }, { "pricelist_name": "test 2" "users":[2,4] }, { "pricelist_name": "test 3" "users":[4] }How would i return only the pricelists that a user have…
-
Merge 3 list of objects
I have 3 arrays with a common id that I want to merge in the most efficient manner. I am not able to use an addon or join as the biggest of these 3 arrays is cached and comes as a variable and not directly from the database - I guess we can't join/merge at this stage. Array 1 has 300+ items, and the others have 10+ items…
-
If value is .. then .. else ..
Hi, I recently started to explore Xano. But I have the following question. We use a lot of variables. What I would like to do is a variable give a certain value depending on the value of another variable. Even in some cases and want to use more the one if, else, then. I found de conditional filter, but this is just half…
-
Filter to get an object based on key/value match in same array item
I want to use a filter to get the "parties" object where `region_abbreviation` matches an input. How would I do this in Xano? I think it's a combo of Get() + Map() or Keys() but can't figure it out. [ { "region_label": "United States", "region_abbreviation": "us", "parties": [ { "party_code": "A", "party_label":…
-
Insert dashes in text
Hey, I have a text string as follows: 12345678. I want to insert a dash between every 2 letters. E.g. 12345678 becomes 12-34-56-78 How can i use the text filters to this? Thanks!