-
Integer Array behaving like Integer in API call
Forum was very helpful yesterday. Giving it another go :) CONTEXT: I'm creating a new Post. One post is related to many technologies via an Integer Array field (i.e. list of integers) that links POSTS and TECHNOLOGIES tables. ISSUE: Xano correctly links TECHNOLOGY when the array has just one integer (ID), but does not…
-
Tired of Bubbles Recursive workflows looking alternatives for External APIS
Hey all! About two years ago now I built my first bubble App. Things have been going somewhat smoothly. The app is similar in a way to Pcpartpicker its large data aggregation site but in a different industry. This being my first true app I've built a lot of things wrong including the database data structure and this has…
-
Search API requires same parameter key with different search terms
Hi, How do I make an external API call using Xano where the parameter key is duplicated but with different values. For example, in Postman this call works: myapi/requests?_limit=200&request_type=maintenance&request_type=non_maintenance request_type is used to specify filters and is repeated as many times as necessary. When…
-
How do I handle empty fields?
I make an external call (bubble) to retrieve records then use that data to write new records in Bubble. Sometimes the fields are empty and that should be okay but I get 500 Internal Server Error when that happens. How do I allow the fields to be empty?
-
Sporadic endpoint errors in the last few days
In the last 3 days I've started to see a variety of errors from Hookdeck - which acts as a webhook proxy - trying to reach some of my Xano endpoints. I've seen a variety of 404, 500, 502 and 503, SELF_SIGNED_CERT, CONNECTION_RESET and CONNECTION_REFUSED errors on 3 different endpoints. e.g… <html> <head><title>503 Service…
-
Help with openai
Hello, Im trying to work with the new chat API from Openai. here is the cURL request example from their documentation: the “messages” param is an array that must be formatted like so… I've set up written the code in my api call and I have confirmed on webhook.site that im sending the messages array in the right format.…
-
Addons - 'Referenced By' column is empty
I wanted to find out where my add-ons were being used, i.e. in which api end-point. However, the Addons - Reference By column is empty for all addons. Is this a bug? Or is there something I needed to have done to have a value in Referenced By. Thanks.
-
Get specifics fields listed in an array from an external API response
Hello, I tried to map some fields with one of my databases who are listed in an array in an API response. The API response return me a list of entity with basics fields but 23 more fields are listeds in an array. I can identity the fields i need with a name or an ID and then return the vaue of the field. (As you can see in…
-
line break whatsapp api cloud
Hello everyone. I am trying to make line breaks when sending a text with whatsapp api. i understand that i should use "\n" but it doesn't work, what should i do?
-
CSV Decode // Column header
Hello, I am using CSV decode to read data from my column headers. On small CSV files, no problem, but on large files (100,000 lines), the API is too long and I can't return the data. Can you help me optimize the functions to only read the first line of my CSV file? Thank you very much,
-
Google OAuth Extension
Hi, I'm working with Google OAuth Extension, I did what is shown in the video in the google cloud console, configure the extension with the id and secret, but when I go to test in the "Explore live demo" section, I get the following error: invalid to resolve dbtable: user I am using the users table instead of user, and the…
-
disabled authentication not run
Hi, I disabled authentification for an endpoint to turn it public again. It runs into swagger, but not into xano using run & debug. I closed chrome and connect me again for a new session but its identical. cookie ? know problem ?
-
External API problems
Just getting started with Xano. I am trying to set up an external API. I have it working in Postman. I am getting a "resource not found" response in Xano. From my debugger: {input: {url: https://api.mlsgrid.com/v2/Property, method: POST, params: {$filter: OriginatingSystemName eq 'carolina' and ModificationTimestamp gt…
-
Newest item doesn't appear
So I have a problem with my list. Everything worked fine until some days ago. When a user logs in they see the items, and pagination works fine, but the problem is that the user doesn't see the latest list item instantly and must scroll up to see it. I followed your pagination video with bravo (which I use) but suddenly…
-
I401 - External API - Twitter API
Hi, I'm make a Get request to Twitter API, using my bearer token as auth. I'm using exactly the same config in Xano and Postman, Postman works fine, Xano always returns a 401… My Twitter Bearer token is set as an Envorinment variable, that is then pushed into Headers array. Any ideas? what am I missing? please help 🙏🏼…
-
Hiding data in PATCH call
When making a Patch call that edits data within an object, in order to ensure the data does not end up "null" or "false" i have to input the existing variable's data within each data set. Is there a way to not have to input the existing variable's data? Even when i hide the data from the API it still sets it as "null" or…
-
How to only get the users stuff from object?
I'm trying to get back only what the user owns in an object. More specifically only the review that the user wrote. The reviews object is inside of my summaries table. The information of every record in the summaries table is the same for everyone except the reviews. So think of it as maybe different dishes on a restaurant…
-
Unable to create a record with a relational object field (many to many)
Hey folks! Trying to do what I think is a super simple thing in Xano, but having some difficulty. Thanks for your help in advance. I have a table POSTS related to another table TECHNOLOGIES via the Object field. I chose object because I don't expect a post to have more than two or three technologies related to it. All I…
-
External API - 401 error - Twitter API - Works on Postman
Hi everybody, I'm trying to do a basic call to Twitter API GET /2/users/by/username/:username I've copied the cURL into my function Added my Twitter Bearer token as an Environment variable The Beare token is pushed into the Headers array. I always get a 401 back. That same request in Postman works fine, using exactly the…
-
Setting up a forgot password API
Hello, I am currently working with Appgver as my Front end service and of course Xano as my backend. I need help on figuring out how to go about creating a ‘reset password’ process. Any ideas, suggestions would be highly appreciated. Thankyou for your time.
-
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…
-
Table join producing duplicates?
Hey there! I'm querying a database of users and a database of pages where each page is assigned to a user via a user id. I want to select users whose pages fit a particular conditional, so I'm using an inner join with the following standard condition: user.id == page.user_id However, the result of this join is that each…
-
Store SVG files from external API
Hi, Is there a way to convert SVG extension into an image? For instance, this is the URL input I am trying to convert: //s3.amazonaws.com/appforest_u/f1642423221020x804309003486281444/test.svg I managed to convert it into a file but xano does not allow to create an image from that file. Thanks
-
Performance issues on random requests
Hi, I am seeing veeery slow (up to 14 seconds, sometimes around 5s) requests on some of my endpoints regularly. But when I use the given parameters to test the query, it is quite ok with ~0.6-1s. endpoin 1: endpoint 2: How can I find out what the problem could be? Is there a way to have a “Explain query” like function like…
-
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
-
External API Request with raw/binary body
Hi again, I am trying to send data to the algolia API. see The API expects the data to be in the body, with —data-binary/raw. How can I send the data like that? It is not working with the params option from the external api request function. I also tried the “import from curl” method but same result, the API is not happy…
-
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!
-
Testing API Calls with Flutterflow
Hi all, I was looking for the option to integrate Xano+ Flutterflow and I'm in a early stage of my app. I had create the whole structure before in Bubble.io but for security and certification issues, I want to shift to Xano. My issue is that the free version don't allow API calls and I would like to test before signing for…