-
Integrating Mobile App with Xano and Daxko Operations API
Hello everyone, I'm seeking some assistance with integrating my mobile app with Xano and the Daxko Operations API, which currently houses my member/user information. Here's what I need help with: Connecting User Information: I want to link the user information collected in Xano when a user registers for the app with the…
-
1-1 UNIQUE Field
I have a question regarding the UNIQUE field. Currently, I am using the free version of Xano, so I want to confirm if this feature is available in my plan. In my database, I have two tables - Order and Customer. Each customer is associated with only one order. The Order table contains a reference field (customer_id)…
-
Create image from file - error "Flattering required"
What does this error mean? I try to create image from URL image ( JPG )
-
Stripe sessions webhook
I have followed all steps in the following tutorial but I am unable to record the sessions. Can someone please help me trouble shoot?
-
Get a specific header data from an API response
Hi, I am doing an api call to Shopify REST API. This is returning all the headers: I need specifically the "link" header, cause that's the link used for paging. I've tried this (didn't work): Any ideas on how to get this url? Thanks!
-
export curl
how can i export my curl in external api requests? I'd like to edit in a text editor and then reimport
-
Upload image error: the parameter content is not a valid file
Hi, I'm using Xano and Bubble and trying to upload an image to a user's profile. I've followed this tutorial: https://www.youtube.com/watch?v=eYn6XbhIpuI and the endpoint works in Run & Debug mode, and successfully initialized in Bubble. However, when I upload an image on the front end I get the following error: Any…
-
Don't display Xano errors in API responses
Hi, Is it possible to not show function stack errors from Xano in the response to the frontend, and instead just show a generic "An internal server error occurred" message? We grab the "message" field in the response body to show error messages in our UI, but it's unprofessional to display code/DB/internal errors to the…
-
Stripe mode type is not changing
Hello, I have been changing the stripe mode from payment to subscription, but each time I update it, it does not change. It reverts back to subscription. Does anyone know why?
-
How to switch stripe checkout [Post] Sessions to Subscription Mode?
Hello all! Trying to setup the Stripe Checkout and i'm hitting a wall on what to do, since what I did seems to make sense to me but obviously that's not the case. I also tried adding more to the [line_items] object but was told through the response that the values I inputted was not supported for Checkout and was used for…
-
What's the correct way to to include an Args in Direct Database Query?
Look at the example below, the idea is to find lease_id IN a lease_ids array, in the first case below I tried to format the lease_ids array into (39,38,137,84,144,185,187,189,191,66,146), which is the correct way to query in posgresql, result in an error: But when I directly type them in, no error occur: How can I include…
-
Is it not possible to update an Object schema column once data have been added?
This object is currently set to null. Initialize or disable nullability. Is this expected behaviour? When my table is empty, I can see the schema and edit it. But, as soon as data is added, I get this message, the schema is hidden away, and cannot be edited.
-
How to add a variable to a header in an external API request function
I'm trying to add variables in headers for an external request. The header of these API requests are written like this Authorization: Bearer (API Key or token). However, in this case, the API key is a variable but when I try put in the variable from the list of variables it clears out the other parts of the text i.e…
-
Dynamic object reference?
hi all, super simple question that I’ve tried to answer on my own, but struggled. I’ve got an input field (string) called selectProperty. Property could have a value of “name”, “description” or “url”. I’d like to loop through a ‘get all records’ query, and retrieve item.selectProperty but unsure how I’d convert it to a…
-
Fuzzy search in array of object.
Hello Com, I having an user table here with "Emails" field which is an array of object containing key "value" for storing the "email". But i cannot create index search for that field. Question: Is there any other way to implement the Fuzzy search for that? Thank you all.
-
Upload image array?
Hello, I am trying to write an API call that allows attaching mutiple images in an array. Following tutorials but getting a weird reply and the test/debug only allows one image ulpoad? an anyone help? Whoops! An error occurred. Exception: Jose\Component\Encryption\Serializer\CompactSerializer::unserialize(): Argument #1…
-
How do I manipulate a set of data with the same iD
Hi , I have a set of data with two elements named element_id and element_1 (10 value possible for element_1). each item has header 1 , header 2 , and header 3 that will be used for a calculation check. I want to group in my data items with the same element_id and then find every possible combination of 3 items with…
-
Help with planning
Hi, I am starting a personal project to build a web app for a company I work for. I am a Webflow user and I would like to build it using Wized and Xano, of course. But I am a total newbie on Wized and Xano and I would like to know if someone could give me some guidance to plan the backend. I have attached a view of what I…
-
Best practice for returning partial responses?
Hi there everyone! First time posting here and I'm still in the early stages of my learning journey with everything backend… I really like human friendly RESTful API design and want to figure out how best to create an endpoint whose response changes depending on a querystring / or param value? I've got a URI named…
-
How do I add function result to response variable as key-value pair?
I have figured out the function stack to loop through a list of records and perform simple addition of fields within each record. The last step in the loop is "Array: Add To End" which adds the variable that is the sum of field values to the end of the loop item. When looking at the output, it's just the value, eg. 5. How…
-
Database Suggestions
Hello, I have a project that currently just has a Webflow frontend, all of our data is in Airtable, and we are using Zapier automations to allow users to update this data from the frontend. However, we are working on creating a real backend using Xano and Wized, and I am trying to figure out the best solution for what to…
-
Adding specific data to record only once when 1st object in list is created ?
[ {"type": "preface", "body": "some paragraph"}, {"type": "chapter_1", "body": "some paragraph2"}, {"type": "chapter_2", "body": "some paragraph3"}, {"type": "chapter_3", "body": "some paragraph3"} ] My function stack adds one record (1 object at a time), then queries all records. But I need to add the preface content only…
-
How to avoid error "Unable to locate var"
Hi, I have two objects: variant_in_client_catalog and variant_to_update.0 Sometimes they have the .size path sometimes they don't. I am building an IF action which evaluates if the .size value of both objects are equal. The problem is: whenever any of both objects don't have the .size path, the "Unable to locate var" error…
-
How do I fix "Malformed UTF-8 characters, possibly incorrectly encoded"
Hi. I'm trying to parse a text file. I'll be getting some data from the file and adding them to a record however I'm receiving this error: Malformed UTF-8 characters, possibly incorrectly encoded. I have hunch that it's because of these characters: á,ü,ó, etc. I tried using the strip accent filter however I still keep…
-
Image URL - Filename input not working
Hello Everyone ! For SEO purposes I need to change the filename while uploading. I used the "Filename" input in the "Create Image From file" function. I thought it was it, but now my endpoint return an error : "wrong file extension". Can someone help me to understand this filename input ? The documentation is not talking…
-
Multiple possible inputs for API endpoint
This is definitely basic… I have a table that has several fields that are table references. In my app there are times when I'll want to query that table with one or more of those table reference fields as a filter. Is it best practice to setup a single endpoint that has all possible input parameters, and setup the query…
-
Import SQL data into Xano with cURL and PHP CRON
Good morning, I have a "Launch" plan I have a MySQL database at a NUXIT host I'm coding PHP pages that show me the JSON of each table (40 tables) I would like to create 40 PHP CRON which would allow me to update my XANO database every day (or every hour). I need this because we have created a Web application for our…
-
extract UNIX time from field in array and use that to determine time
Hi. I'm experiencing an interesting challenge. I have an API calling data that has one of the fields returning a string that has a combination of 5 random letters and 16 digits representing a UNIX time. Some of the entries are repeated but the UNIX time itself is unique even where there is a repeated entry. However the…
-
How do I create a QR code in a database?
I want to create a QR code for those who have bought tickets to events.
-
Problem using fuzzy search on HTML content in my database
Hi everyone, Hope you're all well! So first of all thanks to the Xano team for everything as this is an incredible product that I would recommend a hundred times. I currently have one small issue that I can't seem to get around: I try to do a fuzzy search on a field that contains HTML content. It works really well…