-
"NOT" conditional rule for filters is missing
I'm trying to write a "Query All Records" with the following rules, and I'm struggling. def validate_time_categorization_within_punch_set(time_categorization, time_punch_set): # Check Start Time if time_categorization["startsAt"] < time_punch_set["clockIn"]: return False # Check End Time if time_categorization["endsAt"] >…
-
Data getting deleted when updating record despite using first_notempty
Hello guys, I have a funnel divided into two parts: Get a quote Subscribe When the user obtain the quote, I execute a POST request to my user table in order to create the record and put all the infos. Then, if the user wants to go further and subscribe, he pursues in the funnel and add information (email, phone, name,…
-
Filter records with date in current quarter
I'm trying to filter for records with a date in the current quarter (e.g. Q1 2023 is Jan 1 - Mar 31 2023). This post shows how to filter for records with a date between two dates. Will I have to calculate the start and end dates of the current quarter? If so, any suggestions on how best to do that please? I basically would…
-
Access value at path that may not exist
Hi everyone I have a Query All Records function that is grouping records by a value (user.role) and then counting the number of records in each group. The output is shown below. I want to access the number of records for a particular role in a subsequent function. There is a chance that the role that I want to access the…
-
Add Records in 'random" database
Hello :) Today on Xano we only have the choice to "Add a Record" on a fix database in a API. By "fix" I mean that it is not possible to say: If the data is "abc", check the associated member and add the record in it's database. To do that we have to put an "Add Records" for each database targeted which is not practical at…
-
How to make api calls with .p12 certificate?
I need to access a payments api that provides a .p12 certificate and requires it to be sent in calls.
-
Help with HMAC security filter
I'm using Xano to accept two webhook calls that require the request body to be encoded using HMAC with a secure key and SHA256 digest mode, then match that to a signature in the header to verify the request. My set up in both endpoints is this (different key, otherwise identical): This works fine for one of the webhooks,…
-
Why is Xano allowing REQUIRED column to be empty?
The more I use Xano, the more I get surprised about how it DOES NOT help me ensuring our data integrity. Not only does the so-called "Required" and "Filters" options do NOT apply when manipulating data outside of the API Endpoint, now I discover that it can even ignore the "Required" option for relationships, leading me to…
-
keep tracking of EDIT method
Hello, before publishing my application, I am looking for a method to track data changes (CRUD EDIT). For example, a user changed their name or phone number in a table but I want to keep track of what they changed. Which method is correct and economical?
-
Getting the full URL called of an API endpoint
I'm using Hubspot and I need to implement a verification of the authenticity of a call from Hubspot to a Xano API endpoint. For this verification, I need the exact same URL called by Hubspot, as is (with query parameters if there's any) to include it in the string that will be hashed and compared. However, I noticed that…
-
Add up fields from large table
Hello Xano experts, I've got a table with many records and each record contains many integer fields. I need to sum up the same fields for all records. So the output has one record of sums for all fields: field_1_sum, field_2_sum, ... field_500_sum. Adding up through the loop doesn't look feasible. Is there a more elegant…
-
Where to Use xml_decode?
I've got an API that returns the results in one big chunk of XML data:[image.png] Based on other things I've seen here, it seems that parsing this out into data I can work with is possible via the xml_decode filter, but I'm not sure where to apply it? I tried applying the filter on the text headers of the API call but…
-
Can Xano save API response from audio buffer as an audio document like MP3 or other audio executable
Hello everyone, I'm currently working with the Xano platform and I have a specific use case where I need to save an API response, which is in the form of an audio buffer, as an audio document such as MP3 or any other executable audio format. I'm wondering if Xano has the capability to handle this type of conversion and…
-
Return of enum values
How do I return enum values in a variable as part of a GET api? The enum values will be used in a drop down as part of updating data from the GET api. Or do I get the enum values in another way for my front end?
-
LOOM VIDEO: HELP! 3rd party API Loop Write to Database
Hi, I have a simple API request that uses a FOR LOOP to iterate through an array of inputs coming from another table named MATRIX 1) MATRIX table is what I am using as the basis for INPUTS into an API request at Apify.com a web scraping API. 2) COUNTS table where I want to write the results of the API query I am having…
-
Does anyone know how to get around the 100 record API limit with Airtable?
I have connected Airtable to Xano via the external API but Airtable has a 100 record limit per API call. Does anyone know how to get around this so i can import all my records into Xano?
-
Is it possible to change data source in swagger?
Hi, my question is that if it's possible to change data-source for auto-generated swagger page. Currently, you can't change headers, therefore swagger always use live data.
-
How to sort add-on response
Hi all, I have to tables. The entries of the child table are referenced to entries of the parent table. Now I would like to sort the entries of the child table. I included an add-on, please see screenshot of the response of my api call (screenshot 1). I would like to sort "bildung_sludes_id[] by the value of…
-
Xano and SendGrid: How to send a simple dynamic template
I'm struggling to find out how to send a simple "non-dynamic" dynamic template. Basic sends work so Xano is hooked up to sendgrid, but I can't figure out the required syntax to pull a specific dynamic template. I have dynamic templates already setup in SendGrid. From the documentation, it seems like this is all I need to…
-
Possible to run the draft version of an API endpoint
Is it yet possible to run the draft version of an API endpoint from a 3rd party? I have a live form in WeWeb and would like to make some changes to the endpoint it's posting to but I can't publish it for testing as it will impact the live flow as well. Is there any way to tell the endpoint to run the draft version of…
-
Allow my users to display their Instagram Posts, Username and Followers on their profile
Hey everyone. I have spent the last two weeks looking for some sort of information or tutorial on how to do this. I simply want my (ALREADY LOGGED IN and AUTHENTICATED) users to be able to display their Instagram posts, username and amount of followers using the Instagram basic api on their profile walls on my app I have…
-
Is Xano filtering OpenAI's response?
I've got Xano successfully connected to OpenAI and the responses that I am generating almost always have multiple paragraphs. Here is a screenshot of a sample response inside of their "Playground" tool: When I click "View Code" at the top, here is the JSON response code they show for this particular response: { "model":…
-
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…
-
Upload PDF from Xano to external
Hi, I've been working on posting a file for a while now. What's the goal? We retrieve a PDF file from an external system. This file then needs to be posted to another system. Retrieving the PDF is not a problem, and saving the file in Xano works fine as well. However, the challenge comes when we need to send it to another…
-
How to utilize $search in Direct database query?
In Xano's table we can define $search fields and its ranking, how can we use it in the new Direct database query?
-
Can fuzzy search work across multiple tables?
Is it possible to setup a fuzzy search that can search multiple tables? I've currently got an API endpoint setup that performs a "Query All Records" on my /producdb table and joins in another table with product specs. The fuzzy search implimented currently works, but only on the productdb table. If a user tries to search…
-
Left Join an Aggregated Query
I am executing a "Query All Records" based on a userID. I am then aggregating those records with Count Distinct, and a Sum aggregation. I want to subsequently (within the same function, or separate) left join another table where the PointFloor variable < = TotalPoints AND PointCeling > TotalPoints. Is there any way to do…
-
Bug Database Cannot Find Workspace
Hi, I have been trying to work all day, but keep getting errors that one of my workspace is not found, I have filed a support ticket
-
Referencing Row Number in Variable
I have a queried table with 1 row. I want to reference the first row in the table in a formula. How do I do this? For example: TableName.ColumnName Row 1. I tried TableName.ColumnName[0] but it didn't work Also returning the query as a "single" is not an option since its an aggregation.
-
How to prevent password sharing (or only permit 1 session)
I aim to prevent a scenario where a team of individuals shares a single subscription instead of purchasing individual profiles for each member. User A logs in with profile A User B logs in with profile A Is there a way to log user A out when B starts a new session with that profile for example? I want to ensure that they…