-
OpenAI API Overview: ChatGPT, DALL-E, Whisper and more.
Table of Contents How to Leverage OpenAI with Xano What is OpenAI? What does OpenAI do? How can I utilize OpenAI with Xano? API Pricing Authentication / Headers Requesting organization Making requests Models Chat Models Vector Representations and Embeddings What are Embeddings? What are Tokens? Token Limits Audio Models…
-
Query with a special character.
Im were used the import CSV which has some records with name field contain "m²". But then i can not using the get action in API to get the records with input "m²". Wondering what is the issue and if there are some solution. Thanks for all help.
-
How to implement the PATCH Method the right way?
In Xano, the PATCH method overwrites the entire object by default. This is not how I imagine it. Normally PATCH should be used for partial changes and PUT should overwrite the object. So now I am looking for a filter for my fields to overwrite the values only if the keys occur in the request. I have to say that I imagined…
-
wearable APK integration on Xano
Hi all, Does have anyone figure out how to integrate data coming from an wearable ring as APK into Xano? I would like to test different ways to collect data but haven't figure out how to do it.
-
Possibility of creating multiple table and their relationships through a single metadata API request
This is a question about the Xano metadata API and its capabilities. Is it possible to create multiple Xano tables and their various schema's, including relationships between tables within a single create table POST request, or do we need to pass the requests for each table into seperate requests?
-
Issue with POST request using data-raw in the body
Hey guys, i'm facing a problem with an external API request, i have the POST request setup with import CURL, but when i run the request i receive a false status i don't know why, i used data-raw in postman and everything worked great, does Xano support datat-raw? and what could cause the status false? i've checked the URL…
-
Getting Error 500 - Disk Full
An API that worked fine until yesterday now throws a Disk Full error. Exception: SQLSTATE[53100]: Disk full: 7 ERROR: could not write to file “base/pgsql_tmp/pgsql_tmp743884.2”: No space left on device (SQL: select count(distinct “playlist”.*) as aggregate from “mvpw1_3” as “playlist” inner join “mvpw1_6” as “Followers” on…
-
Has anyone used Nylas in their setup?
Im building a somewhat niche CRM system that relies heavily on users managing, logging and screening high volume emails. Slogging through the various mail client setups is disheartening. Im looking to build an MVP on the side, as I service my consulting clients. Just looking for any input. Maybe someone knows of a better…
-
Requesting help with an external API request - "Actor input must have content type "application/json
Hi, I would really appreciate some help resolving my problem here. I am trying to make an external API request to an Apify actor with a POST request method to run actor synchronously and get dataset items. The debugger is saying "Actor input must have content type "application/json".", but I see "content-type:…
-
GET reference table on custom endpoint "/user/{user_id}/[CUSTOM]"
I created another endpoint "/user/{user_id}/groups" and here i want to collect all the group data for the relevant user.. Im not quite sure how to accomplish this though.. Can anyone in the community help out with this?
-
How do I use a Precondition with an Array?
I'm trying to write some permissions into my application, simply put getting a list of users who are allowed to edit a record. I have a basic list of users stored in array who have access, and I want to enforce a precondition that says if the users_id trying to edit the record is in the array, then they can edit. The…
-
Passing a Binary File Body Through Xano External API
Hi All, I am attempting to upload a CSV to external service using an API (storage.googleapis.com). My process involves creating a CSV file from a data source and sending it through the API via a PUT request. I have the first part of the process which creates a CSV file working. I also have the second part of the process…
-
Product recommender system using Xano
I was wondering whether it would be possible to implement collaborative filtering for product recommendations using Xano. Such a system would be very valuable to e-commerce apps, like the one I’m building on Flutterflow. The goal would be have search results populate already sorted depending on the user’s past shopping…
-
Sending log events to a remote Syslog server
Hi, I am looking at a syslog remote server to receive any specific log files I wish to send. I have already viewed NcScale but didn't have a good experience. I have found a another syslog server and asking if there a method to send syslog files to a remote server? I was trying to use the API request element but it seems…
-
Querying based blank and null values and date values
Hi, I have some different columns. Som of the are blank ("") and some of them are null. I would like to make an api call (using http endpoint for each data table), where I e.g. can retrieve all records where x column is null or where y column is blank (""). Also, I can't get querying based on dates both unix epoch format…
-
Handling test and live environments
We are working on a Software as a service platform in which we would want to create apis for other businesses to consume in the banking domain. Now for them to integrate these apis in their applications we want to give them two different environments, test and live. The users can generate their client_key and client_secret…
-
Handling missing variables from a Webhook call
I am integrating Xano with Salesforce. I've gotten it to work fairly well but when data isn't populated in Salesforce the API callout doesn't include a null value for the variable but rather just strips it from the call. An example is Middle Name. When it is populated in Salesforce the JSON looks like this: { "new": [ {…
-
How do I go from Image from Database to Base64 string?
I currently have it so that when I receive an image from it is stored in a database as the image, I want to send this image to Google Vision API. To do that I need to send it as a Base64 string, but I can't figure out how to convert this image to a Base64 so that it can be understood by the Google Vision API. Any help?
-
OutSystems com Xano
Sou OutSystems Team Lead em uma multinacional em Portugal. Estou querendo utilizar API do Office 365 como credencial para fazer log in em uma plataforma criada em OutSystems. Acho que esta API do Office 365, consigo criar tudo em xano e depois consumir em OutSytems. Alguém ja passou por algo assim? I'm an OutSystems Team…
-
Create PDF file from external API in Xano
Hi all, I am working with an external API that responds with pdf data. I am encoding this pdf data using the base64_encode filter. The encoded data saves fine to a database column. However, what I am having trouble with is generating the PDF file in Xano. I have tried to use the create file resource function using a…
-
How do I account for empty/null values when doing a get request?
I'm using Bubble as my front end, but whenever I make a call and there is an empty value or null value, bubble throws an error. I am using the xano plugin along with the api connector, (I've attached screenshots below of how the get request is setup) This is one of the errors I got Has anyone else faced the same issue and…
-
Text Filter require scalar value error
Hi, please see here: I had a fgunction that WAS working, I added a step, now it gives me a scalar value error... I deleted that step, it still give me the error...
-
PATCH Conditional Filters
I want to utilize PATCH to update a user's information, but found that I cannot update information on my frontend without filling out all the criteria listed here: I want it such that a single field can be updated without the need to updated the other fields. For example, only updated a firstname and not lastname,…
-
For each from an array in the previous response
Hi, Just been off of XANO (Was in XANOAX mode 😁) for a couple of months, and oh boy forgot a lot of stuff, feeling rusty. Hope you can help me: I am running an API request and I get an array "results". I now need to run a For each loop to each id inside the results. but when I try to get the path I get the 1 value in the…
-
Querying records (GET) with date interval
I have this code that works - it makes a GET for all records with date_run for 1 specific date. Does anyone of you know how I can do it for multiple dates and e.g. all records AFTER a certain date?
-
Colon in endpoint url
I am trying to set up a webhook but the source (a Payment Gateway - PayU) is not accepting a webhook with ":" in its url. Any suggestions?
-
LISTEN and NOTIFY commands through Xano http endpoint
Hi there, Is it possible to use the LISTEN and NOTIFY commands (that postgres normally support) through the Xano http endpoints?
-
Unsupported Media Type on an external API call
Hi 🖐️, I'm having troubles with an external API call. I'm trying to pass an object to a third party API (Eledo, a pdf generating tool) that expects an object and returns a PDF (doc here). For the loom video of the issue, please check here. I'm getting an unsupported Media Type error in the Xano debugger. I digged…
-
Requesting list of IDs in get endpoint
Hi there, How do I request multiple IDs in a simpel request? I currently am doing it in a loop, but due to speed I would love to learn how to do it in a single request:
-
Updating a record via API
I am having a bit of a noob issue and have not found a post on the topic. Maybe it is too simple, so please bare with me I have a POST method for one of the tables. It is a profile table so it has a few fields there. I want all of them to be optional when updating meaning I can just send 3 o the fields, and only that…
-
Handling test vs live in APIs
Hi, I'm currently building up numerous APIs for a semi-live app, but having a few challenges in trying to determine if I'm working with a test or live source environment (in my case, bubble). I already pass the X-Data-Source header from my bubble test instance, but my APIs also leverage external services for things like…