-
Custom function not adding some info to variable
Hi, This is a custom function where I create a variable (which is a payload) with some product (variant) information: Everything is being included correctly into the payload except for the "variant_summarized_info" (which comes from an external api call), "name_of_retailer" (input text) and "unique_id_of_retailer" (input…
-
From a list of 1000 items, run a loop in batches of 100
Hello, I have a list of 1000 items and I have to run some functions for each one of them (on a loop) and finally upload all of them to an external database through an external api call. The problem is this external database only allows to upload 100 items per api call so I can't wait until the 1000 loops are done and them…
-
Getting Auth0 to work with Webflow!
Hi all! Xano support pointed me at a Youtube video for hooking up oauth2 (Google) and said to follow this to achieve the same for Auth0. No luck getting this to work so far and hoping someone eagle eyed can spot the issue. Also happy to pay to resolve! For Auth0, I added the myaccount URL on Webflow in the callback URL…
-
Firebase ID token verification
Hey everyone, I am currently trying to verify Firebase-generated ID token (my setup is: Firebase for auth, XANO as function & db backend). Thus, I'm in the process of writing a function to verify a Firebase auth token within Xano (to then auth within Xano and make authenticated API calls) - for this, I am following the…
-
Display Images in Repeating Group from URL
Hi there - We will have images that are standard (one of 10 images shown on each user page). Is there a way to add them to xano as a URL or referenced ID so that we do not need to upload the image to the database each time? For instance, display specific icon or emoji related to an option, without having the icon or emoji…
-
Is it possible to copy a function from one endpoint to another?
Hi, I have a "Create variable" function in one of my Xano endpoints and I need to create the exact same function in another of my Xano endpoints. To save time (since it has a lot of filters), I would like just to copy it and paste it there. Is this possible or will I have to build the function from scratch (adding all the…
-
Different outcome for request history and debugging with Get All Input
Hi there, So I'm trying to debug an error with handling payload from Get All Input. I cannot go any further as I'm getting two completely different results (outputs) for the same input values when I use Run & Debug and when I look at the Request history. Request history: Here the output is: {"message":"Unable to locate…
-
Xano x Bubble -- Filter by Today's Date
Help! I have tried to filter values that eual today's date and have tried almost every combination of > today's date rounded down to day +day -1 etc. and cannot figure it out. How would you make this work in bubble?
-
How to edit a name or any other parameter via Bubble & xano API integration?
Hi there - I've tried 10 different ways to do this and cannot figure it out. How can I edit the name based on a USER ID and/or bubble ID that is stored in Xano? This is the error:
-
Loop Error: Attempting to Loop through output of Query All Records
H do I change it to a numerical index if its a list of objects? Whoops! An error occurred. Exception: Please use a numerically indexed array.
-
Dumb Question: How do you only get the first 10 items returned from Query All Records?
Dumb question because I can't figure out the for loop in Xano, but I only want to return the first 10 entries.
-
How to query all records, when some inputs could be empty
I have a search form: I want to search for all hunts meeting the forms criteria, which I'm doing successfully when I require all the fields in the form. See conditionals. My question: How do I query based on this form, if say, 'category' is not filled in? Meaning the user wants to query all hunts in TX, without caring…
-
Evaluating Xano, here's my scenario!
Hey all, heard a lot about Xano from the bubble forums, so I thought I list out what I am trying to do: I have several very different servers that handle some jobs that take quite a while to finish, so I implemented a simple job queue in mysql to tabulate them (I know, not ideal) Each job as a pretty lengthy JSON payload I…
-
How to disallow read/update for column, by user role
What's the recommandation to allow read/updates of specific columns depending on the user role? is it something that must be done on each API endpoint? What are the best practices and tips to make this process simpler?
-
How to handle OpenAI's API rate limits in Xano?
Hi, OpenAI's API has rate limits. In the case of chat completions on the free trial, the api rate limits currently are: 1. Requests per minute: 3 requests per minute. 2. Tokens per minute: 40,000 tokens per minute. You'll get the amount of tokens you consumed in each api response (see image below). My use case is the…
-
I can't get 2 function stack works in a row from a post request in bubble...
I tried multiple scenario to make 2 function stack works in a row but I can't… Here is a scenario: I'm adding a record on Xano with first function stack Then I adding another record (the same) in a second function stack. It works well when I run&debug it When I make a post request on bubble, it only fires the first…
-
Handle an external API call when some optional fields may or may not exist
Hello I can't find the solution to this problem: I have an external api call which returns me a list of objects. For each object there are some optional fields. When the field is empty, it is not shown in the API call response. For example: [ {"required field": "value", "optionalField": "value"}, {"required field":…
-
How do you create a Database field "updatedAt" that auto-updates?
Coming from Airtable where this is trivial, I can't figure out how to build an updatedAt field that auto-updates whenever the record is updated. I guess it works very differently, and it could added into the create/update endpoints of each Table, but even though, how do you get the current timestamp in a Function Stack?…
-
Error transforming an integer to text
Hi, I have a data table called "App settings and variables" which contains the "Max_tokens_per_completion" field, which is an integer. In my functions, as first step I am calling the "App settings and variables" table so that I can use some of its variables in the subsequent functions: First question, is this a good…
-
Finding duplicate records within database
How can i run through a field within a table to find duplicate records? EDIT: Disregard, I found what i was looking for.
-
Generate an array using info collected through looping
Hi, I've collected information of some product variants using "for each loop". Now I want to create a "variants" array that contains all products and the their info. This is the array that I have managed to create: What do I have to do in order to make the response look like this (see below)? variants: [ {"Name": "Black…
-
Creating tagging system in Flutterflow
Hello, I would like to create a tagging system in Flutterflow. For every item in the table there would be string tags to select from the list of custom tags created by the user. The user would be able to create, edit and delete the tags. It would be perfect to filter with any tag also. My idea was to do UI in a form of…
-
API doesn't return anything in response
I have this API endpoit that should return an employee object Here is the code invoking the API, the response JSON is empty, I don't understand how to read the data returned by the API.
-
500 Error on /auth/login - Invalid password syntax.
Hello everyone! I noticed that since yesterday I was able to login but then without any changes that I can recall I started getting this error. I also tried setting a new /auth/login but that didn't help The interesting part is that everything works fine in the same way w/ another account that I own, so I'm rather confused…
-
Return only the first n characters of a text
Hi, I have to trim this description text so that it returns only the first 92 characters. How can I do that? Also, if I needed to return the last 92 characters how could I do that? Thanks!
-
Create a variable with specific values received from an external api call
Hi, I am getting the following response from Meta catalog, describing a list of products. The response per product looks like something like this: { "data": [ { "name": "Shoe", "retailer_id": "123gffj", "availability": "in stock", "description": "Test description.", "color": "Red", "material": "Cotton", "pattern":…
-
Automatically update records depending on a table reference
Hey, hope you are doing well. I'm working on a multiple stores management for products. Each product has a stores attribute which allows to display the stock by store. I have linked the store table (store_id) as you can see. When a new store is added to the store table, I would like it to be automatically added to the…
-
Get product data from Meta Catalog API and upload that data to Typesense
Hi, I have to get data of some products in a Meta catalog via . Can I get the product data from Meta Catalog and upload that data to Typesense without creating any data tables in Xano? I just want to use Xano as bridge, but I want to store everything in Typesense only. If it is possible, how? Thanks!
-
Send text from Bubble to Xano, then include that text into an External API call url path
Hi, I need to send this catalog id from my front end (Bubble) to Xano, and then call including the catalog id (that I received from the front end) into the API url. How can I do that? I've put the catalog_id as input: How can I send that from Bubble to Xano now? Should I add the catalog_id as a header or parameter or what?…
-
Can EVAL's Add filter have IN/CONTAIN option?
I am trying to create a sort of item for every user such that previously ordered items are shown at the top of the list. My previously ordered items are precalculated and saved as an array in another table. So, in my primary function, I am trying to create a boolean variable that tests whether an itemID is present in the…