-
API became incredibely slow
Hello, For no particular reason, all my API calls became slow as hell. Sometimes seeing an x10 in execution timing. All worked fine this morning, now my product is simply unusable… Has this ever happen to anyone else ? If that's the case, what were the cause ? I'm on the scale x1 plan. Please help ! 😫
-
Experience with OpenAI's Chat API?
With ChatGPT now being available via an API, I'm looking into adding it to my site and want to run everything through Xano both for the easy record keeping as well as the advanced API functionality. Everything is pretty straightforward but the one unique thing about the Chat API is that in order for their system to have…
-
Calculating total hours worked - Should I use Custom Functions?
Hi! I want my API to return the number of "hours worked", based on some business predicates, using the data being stored in related records. I'm sure it can be done with Xano, but I'm unsure about what component/feature to use. Should I use a Custom Function? Or should I use something different? In Airtable, I'd typically…
-
Timer external api request
Hello everyone. I have a situation where I have to send a request to an API, this API returns me a key and with this key I have to make another request to another endpoint, but, with an interval of approx 7 seconds. How can I configure that after the first request wait X sec and then make the second request?
-
Add Object Record
Hi, I want to add a new record using API. I have an object field called "Layanan" and inside it has an enum list with 3 values which are "BI-RTGS", "BI-Fast", and "Lalu lintas Giro". I tried to do it, but it returns the following error message. How should I do it?
-
Access to Post Body Properties - Webflow API - Remove Collection Items in Bulk
Hi there, I was wondering if anyone else is having issues with the (Delete /) Remove Collection Items API endpoint of Webflow? () It seems to me that Webflow just doesn't want to delete post data via a header, but specifically delete it via a body. My only way out at the moment is to skip the bulk delete endpoint and loop…
-
When/how should we use "API Access on field types"? (public/private/internal)
I'm struggling a bit with this "API Access on field types" option. The doc explains what it does but not how to use it. The behavior of those 3 choices is counterintuitive. I'd have expected the "private" to allow the field as an input but not sending back the field value as output. Instead, it blocks it from input and…
-
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?…
-
Returning an addon, for an addon
Is this possible, or what's an appropriate workaround here?
-
Performance issue between debug and real mode
Hello, I need some help on a subject that I can't understand with Xano. I have created a POST endpoint, which I want to use many times via my Bubble application. During my tests (in debug mode) I usually reach a loading time of 2/3 seconds. My action via bubble is to make a POST request from this endpoint ten or twenty…
-
Schedule workflows
Hi all I am an experienced Bubble user, considering using Xano as the backend for a new app. I am still learning, and here is something I don't know how to do. I'd like to proceed pre-scheduled workflows, with multiple action happening at different date & time, with conditions to proceed. Real life example (not my use…
-
Import large csv file into XANO with the help of the api
Hello all, what is the best way to upload a big csv file from the client side through XANO api? I have no issue with 5MB files but once I try to upload a 50MB file it gives me the following error: An unknown error has occurred. This may be a random occurrence or a memory issues. Is there some kind of similar solution to…
-
What's wrong here?
As you can see, the precondition asks if the new password is similar to the old password. In the run and debug it's different but, it's still being found as the same thing. There are no other preconditions that relate to both the new password and the old password. I'm not sure what's wrong.
-
set_ifnotnull not letting us set empty value
We understand that set_ifnotempty skips all values empty/null. What about we want to reset a value for a record e.g PATCH /users/:id { name: "", } Should let us set name to "" but it is not (set_ifnotnull skips it)
-
500 Internal Server Error: Cannot extract elements from a scalar
I am getting a 500 Error, with the below message (screenshot) in the request history output. The context is that this is part of a ~20 filter + fuzzy search and sort page on a Bubble front end, sorting across a database of recipes in a Xano back end. The API connection in Bubble is a 'POST' and a 'Data' type. The fuzzy…
-
how to edit an existing record targeting it by two or more parameters (fields) evaluating to true?
I want to update a field for a record based on if two column values are true for that record. E.g - Update/Edit "Complete_Status" to a "1" IF "Customer_ID" == "12345" AND && "Subscriber_Status" == "Subscribed" How would I got about doing this? I see that the Edit a record endpoint has the limit stating "If you choose a…
-
Having difficulty saving array of integers as table reference list
Hey folks! Thanks in advance for reading. I'm sending an array of integers from custom frontend (React Native) to Xano backend, and saving as a table reference list. One POST has many TECHNOLOGIES. It all works correctly in debugger: But it does not work correctly in practice: Xano appears to be expecting a single integer.…
-
How to return a single record with 2 or more parameters (inputs) having to be true? (GET)
I see in the endpoint query maker tool the note "If you choose a field_value that maps to multiple records, then the first one found will be used." This would not work for my use case. I have a table with multiple recrods containing the same field value. However I would like to know how to search by multiple field values…
-
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…
-
What type of security can I use on my Endpoints?
Hello everyone, maybe this is a very extensive question and it can have several points of view, but I would like to limit the question to: How can I have a security "filter", so that somehow the origin of the request can be recognized and depending on this it can take X or Y variables. This in order that if a user would…
-
Boolean being read as a text
Hey folks! I'm having a simple types issue in the Function stack. I've got a boolean type “isAcceptingSubmissions” that shows up as a text type in the API. Boolean in Database: In Debugger: But it is a “text” type when querying the database: Is this a bug? Thanks so much for your help!
-
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…
-
More optimized way to get huge json into database
Hey guys, I am having a hard time getting a big number of rows into the database. Currently, I get zipped file from ftp, unzip it, split it into about 250 json files less than 1mb (otherwise, i get 413 error) and send it to xano api to insert the rows into my table, there are a total of 750000 rows in total. The problem…
-
Transforming a list into a list of objects
Hi Xano community, Im trying to trasnform 2 lists into a list of objects where each item in the list becomes a new object I added the above and get the results as So instead of teh above I want to get { Placement: 1 Budget: 10000 Placement: 2 Budget: 10000 Placement: 3 Budget: 10000 } Any guidace is much appreacite it !
-
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…
-
How to add dynamic input at the end of the api request url?
Hi! I have the following sample inputs: data[Name]=John data[LastName]=Cruz data[InvoiceDate]=01/01/2023 and I would like to add them in the end of this sample URL: https://www.pdfotter.com/api/v1/pdf_templates/tem_12345/fill? the URL will look like this:…
-
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…
-
Checkout session metadata in Xano inputs absent from Stripe response
Hi, Xano does get the metadata object of checkout session from my fronted: Yet in Stripe logs the POST /v1/checkout/session does not return the metadata. Seems like Xano does not send that object, since I don't see it in the request body returned by the Stripe log: { "success_url": "https://bonte.com/532933/Page17",…