-
Magic link Xano / Bubble
Hi, I've followed the great tutorial here https://www.youtube.com/watch?v=eWIpAPrNeuc&list=PLOch5nUqQ_Y6eyPlp15BGBlQRJjFWnmtT&index=4 But contrary to what is shown in the video, when trying to initialize the API call for /auth/magic-login, I get the following error message: You have set the data type of this call to…
-
Creating a dynamic array to populate multi select field
I have a search form that has a multi-select field for location, in this case US states. Users can select one or more. What I was considering was querying my listing table to create an array list of the states currently represented by active listings. Example is I have 10 listings in California, 5 in Florida, 2 in Texas.…
-
How to access the data of Add on
Hi Guys, Im trying to access the data from an addon but havent been able to figure it out I tried using dot notaiton but keep getting an error
-
Optional Input param not set to default, how to deal with that?
Hi, Am I wrong in assuming that setting an input parameter of an api (includeCustomer) to not required and setting the default value (in this case to false) should still create an input parameter includeCustomer = false? If so, then that functionality seems to be broken. If my assumption is wrong, what is a nice way to…
-
Why do Addons return as individual arrays? Where as query all records returns a normal array?
players_in is an addon where are all_players is a query all records. You can see by the additional [] in players_in that it is storing all the records from the addon in their own array. Why is this and how do I fix it? I need players_in to output the same as all_players
-
How do I add a path variable in my external api request?
Hi! I'd like to know how to set a path variable for my url in my external api request. For example I have this URL: https://www.pdfotter.com/api/v1/pdf_templates/:templateId/fill? and for the templateId it has a value of tem_1234567 for example. I can't set it as a param since it will turn the response url into:…
-
How to whitelist API requests from only specific Webflow website?
Hi, I'm trying to figure it out the solution how to secure my embeded POST functions on Webflow website. Right now, any user is able to see the full endpoint url and therefore can use it on their own. Is there a way to whitelist requests only from authorized webflow domain or perhaps there's a chance to secure/hide embeded…
-
Why does my external API request not return any results?
Hi, I am using an external api request to get data from a bubble app. For table less than 50,000 records everything is working fine, however above that limit the result seems to be empty. For example, below is a screenshot of what I get with a list of 53,428 records. I placed my cursor at 51,000, it's counting 90 and the…
-
INPUT ERROR INVALID TIMESTAMP
When someone fills out the input boxes on a patient registration it is supposed to transfer to Xano. I am trying to set up a custom action with Xano API (create and POST) that will add the form input onto my Xano table. I keep getting “INVALID TIMESTAMP FORMAT” See pics below. Please help!
-
Noob question: Filter in Xano
Hi guys, I have a table events that has a column called id_neighbourhood. And I have the table neighbourhood with the name of it. I'm calling an API with an array with the neighbourhoods to use in the filter. That means I can get all the events in one or more neighbourhoods. But when I do this search: get this error: Plase…
-
Headless CMS Suggestions for Xano?
My current stack is using Bubble as the frontend and Xano as my backend. I'm wanting to add blog content to my site and have looked into platforms like Webflow but: A. I don't want my blog (or app) to have to live on a subdomain (blog.domain.com) B. I don't want the Bubble site and the blog to have two separate…
-
How to check if file from sftp server already exists in database
Hi! I'm trying to make a task in which I call an sftp server and check for new files in a path. I'm sending an external api request to list all the files in that path and getting their filename by creating a variable. How do I then use that variable (the filename) to check whether that file already exists in my database?
-
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…
-
Help to resolve a JS error when connecting to an external API.
Hi Xano community, I was hoping i could get some expert advice regarding an issue I'm having with a custom weather api in webflow. I was using Prakash's https://www.youtube.com/watch?v=HMsrFzoZYr0 tutorial on how to link up a API endpoint to Webflow. However when publishing the website the data will not show due to this JS…
-
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,…
-
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 ?
-
Best data practice
Hi everyone, I have the below mater table example. Attribute set A table AND Attribute set B table are the expected results. Is the best practice to import the master table (actual data has more than 600 columns and over 70k rows) into Xano via CSV and use the API filters to get the expected result? Or should I processed…
-
data split between three tables, how to join all of them
Hey, I am trying to build a project regarding tracking of expenses, thus far I've done it using google sheets but I'm trying now using Xano and Retool. my three tables are: Categories: id name Locations: id name category_id Transactions: id amount date location_id my main flow will look this: open the app -> input amount…
-
API connection with Aircall
Hello, I would like to establish a connection between Xano and aircall but it does not work. I can get information but I can't send any. I always get the same error message. I think that the format is not adapted and I think that it is probably the phone number which must be in E.164 format. I used the sprinft command but…
-
On "Launch" Plan and Don't have Branches - can this be right?
I have an API endpoint in production, and my workspace is on the Launch plan. Without branches, I'm trying to figure out how to test some improvements to the endpoint - it seems like any changes I make are immediately pushed to live - can that be right? If not, how can I test tweaks to my API without turning off the…
-
ERROR on XANO's side when creating a Stripe Session: "Please use a numerically indexed array"
I'm building an ecommerce platform for a client using Xano (for the very first time) and Stripe. I'm using the Stripe's official plugin available in the Xano's marketplace. I'm setting up the checkout request at this moment and I'm so close to a working solution. But I'm running in a wall here: when running the create…
-
Geting X number of latest records from a table
As the title mention, how can I do it from an API?
-
How to see response without "debug" button
i know we can use debug button to test external api response, but when i go to request history i cannot see my external api request. How do i do this ? the reason is because i will be doing a lot of steps on functions stack and often i will need to go back to multiple previous api response. With the current situation, i…
-
Code generation from string disallowed in this context
Hey guys, I'm trying to dynamically build a JSON object from a Javascript-end definition. My input is plain-text, like: "obj[people][name] = 'Anthony'; obj[people][age] = 19;" And I want to build a JSON object that I can work with in Xano. I am able to do it in Node.js locally, so I tried to use Lambdas and run that…