-
Column based on concatenate values from other columns
Hi there, Im new to Xano, this may be an obvious question but I’m looking to have a column that’s is a concatenate formula from other values columns within the same record. Any guidance is highly appreciated. Sebas.
-
Table Column - Settings - Filter length not working correctly ?
We want to set the maximum number of characters of an input field to 500 characters. We set the value of 500 in the Settings - Filter parameter - see screenshot below. When we tested it, we got an error message - second screenshot. However, if we set the value to 100 or 50 characters, it works. Is it the case that the max…
-
Memberstack- Xano webhook integration not working
Hello xano team, I have duplicated the webflow- xano-memberstack template and following the video tutorial. However, When a member is created in member stack it is not transferring data to xano through webhook. I have followed the same steps as the video tutorial
-
Magic link for email validation
Hi, I'm interested to use the Magic link snippet from Sendgrid as email validation rather than user authentication. Therefore the only thing I need is to know if someone clicked on the link sent and then update a variable accordingly in my Xano DB. Does anyone know if and how I could do this?
-
User Authentication with Atlassian
Hi! I'm a long time Bubble.io user but for my latest project I want to use Xano + Weweb. My app requires authentication with Atlassian so I can call Jira APIs on behalf of the user. I was wondering if there are any Xano snippets for Atlassian or guides on how to add a custom Social Sign In. Thanks in advance!
-
Generate CSV file for download
We have an option in the endpoint to download the result as a CSV file. How do I convert the JSON output into a CSV file for download?
-
How to group entries based on relational data
Hi all, full disclosure, I'm a noob when it comes to working with APIs and databases ... trying to learn as I go 😬 Stack: Xano, Bubble.io With that out of the way, here is the challenge that I'm facing right now. What I'm trying to accomplish: Create a digest page (each day, for every user) that will contain a list of…
-
Object in database
So I have created an object with different reviews in a database with some information. There is a table reffrence in the object which points to different reviews. There are multible reviews for every day in the database and the different reviews is owned by different users. How do I make it so when the user opens one of…
-
Debug and Live different Outputs on GET-Request
Hey there! I created an GET-Request for a table called "outfits" to output me different outputs filtered by parameters of the GET-request. Now when I Run it in debug mode, everything works fine and I get the correct outfits filtered by category. Here are the parameters for my Debug-Run: But as soon as I Call the…
-
Request timeout
Hi, Is there a way to send a 200 response before the end of the function? I am working with a webhook that allows only 2000ms before it is considered as timed out. Many thanks
-
Manipulate to save records from API call not working
Hi guys I need a little help here. I followed this official video which is exactly what i want to do. https://www.youtube.com/watch?v=rdnuW2Vg8aA Up until saving the response as a variable, everything seems good. The variable holds an array with all product info. When the records are saved the values are null. My first…
-
How to link Miro Board to Xano object
I'm trying to create a Wiki by connecting a Xano object to a Miro board through its API, and then automating the process for subsequent links. How can I do this, please?
-
Manipulate results to group by value
Hello fellow Xano enthousiasts, I am stuck with manipulating results from a database to make it easily usable for my frontend. The current result I am getting is attached as an image below. What I would like is to group all the results by category as a separate array. So basically an array for 'Time' would contain all the…
-
Memory issue/ random occurrence error when retrieving data from ext API
I am trying to pull data from one of my APIs and then insert it into a table. This pulls 200 records per API call and it may have 20000 records. But I keep getting this error:
-
My API seems to run multiple times, is this a front-end or backend issue?
Hello, I've noticed that every once in a while, some of my API's are run multiple times. For example, in the screenshot below, someone was trying to verify the OTP for login and instead of the API running once, it ran like 12 separate times back to back (just showing some of them in screenshot). My question is, is this a…
-
Is there a way to add a table as an input?
I find myself updating a certain set of fields/columns in different tables repeatedly. These columns appear as the same names same types across these different tables. I would like to be able to write one function that accepts the “table name” and then simply update these columns/fields in the provided table instead of…
-
Issue with update request : Table reference field
Hello to all ! I'm a little bit stuck with endpoints that I use to update records, I use the function first_notempty on my fields (not to overwrite the values of my table if the fields are null or empty during the update) it works well on my fields of type text but I have a problem on my fields of type table reference : it…
-
Tracking streaks
Hi community! I'm working on a journaling app and want to add in a function that counts streaks, eg. for how many days are there entries from a specific user. How can I set up an API with some functions that counts entries in a database but only if they are dated concurrently in the past from yesterday. Thanks!
-
How do I do this?
So I have two reviews that belong to two different users. I also have a list table where the reviews are located. Still, all of the users can access all of the reviews. How do I make it so only the owning user can see their review?
-
Restrict API enpoints to run from specific domain/ip only
Hello, Is it possible to only allow the use of an endpoint from a specific domain or ip-adres. maybe with the help of functions? thank you
-
Set externally uploaded file field through API
Hello! How can I set externally uploaded file field through API? This is what I managed to get, but the main problem is that "url" is prefixed with XANO domain { "path": "https://cdn-api-dev.jetadmin.app/media/static_files/projects/test_1251/slideout_TBlx6gL.svg", "name": "slideout_TBlx6gL.svg", "type": "image", "size": 0,…
-
PUT request : Signature Does Not Match
Hi all ! I'm having an issue when creating a post request and i don't understand how to solve it.... I send a POST request to an api that return a presigned url that i use a PUT request to upload images to these presigned, but every time I try the service can't get my images because the content of the urls is empty. When I…
-
how can i post api ?
so I am using Pega and I want to Export data from Xano to Pega with a post method. and Pega is telling me that I have to post the data to their link. and HTTP authentication header how can I do that ?
-
Conditional not doing it's job, based on add-on data
Hey I have a conditional not doing it's job, based on add-on data from a query. See the vid below and let me know if I'm doing something wrong. Thanks! Here is a video I made showing what's going on: https://www.loom.com/share/9f86975c43fe4602b83905f372c4c6d4
-
Send additional params via header for all endpoint in a group is creating CORS issue
I use draftbit for the front-end. I decided to add a couple of additional header variables to send to the server which I access the environment variable. When i return the results my webapp client throws a CORS flag for sending these additonal header in the request. What do I need to do on the server side to fix it or if…
-
Retrieving a non-labelled list as input
(I'm embarrassed to ask because I feel like I'm missing something obvious, but here we go.) I'm trying to catch a webhook (from Shopify). The data sent looks like: [{"email": "foo@domain.com"}] Whether or not I use a JSON or an Object type in the Inputs section, I always end up in the Run & Debug console with something…
-
Divide by zero error
Hey Xano'iens, I have a tricky tricky. My api is erroring when it has to divide by zero. Is there a way around this? My equation will need to divide by zero if the "get all records" count is zero. In my example below, var: signups = zero. Aka: There are no signups for their affiliate link yet.
-
Xano JS SDK - Can't instantiate XanoClient with XanoSessionStorage
Hello guys, I'm trying to set the Xano SDK up to use session storage but I keep getting this error: ReferenceError: Can't find variable: XanoSessionStorage Here's my setup <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/@xano/js-sdk@latest/dist/xano.min.js"></script> <script> const xano = new XanoClient({…
-
How to send message via Whatsapp API on XANO ?
I will show my project to all members , you can send whatsapp message for Free for use this snippets You just fill msdn and your message , don't forget to fill MAUKIRIM_TOKEN variable on your env setting. Token ready to use on snippet descriptions. Need improvement ? you can create issue on this repository , our team will…
-
Group results within an API
Hi everyone! I'm building a journaling app and have a page that allows users to view all their entries. They are currently presented as different items: ie. every entry is separate, even if written on the same day: How can I structure my API so that they are grouped by date: ie. every entry done on the 02.Jan.2022 is one…