-
Why can't I see the new table reference when doing an addon
I have a problem. I have a user table that references a clients table using the clients_id. I have an auth/me endpoint that calls the user details and an addon of the client. Now I have a new countries table and I created a new field, countries_id, on the clients table that references the countries table. On the auth/me…
-
Any update on auto-update of APIs when a table name changes?
I thought I read somewhere that Xano was considering adding functionality to have APIs automatically updated if a user changes a table name. Is that correct? I'm not a programmer, but it seems plausible since Xano's editor already has a reference in each function of the function stack to the underlying tables. If this is…
-
format_timestamp: I can't format to readable view
I want to format dates (created_at) to readable view. 1. I use Loop 2. I use format_timestamp But the result contains dates in timestamp fromat not readable Result in Debugger: What do I do wrong?
-
Upload to Nextcloud via Webdav OCS API - MKCOL ist not allowed
I want to upload files to a Nextcloud Instance. Before I can Upload I need to create the folders if they dont exist. Typically on a WebDAV u use MKCOL but using this method I get this error: code: ERROR_CODE_INPUT_ERROR,message: Input "MKCOL" is not one of the allowable values.,param: method So looks like the method is not…
-
Generating JWT Token for use with Ghost
Greetings! I've read the Xano JWS Encode documentation and watched some tutorials on YouTube. However, I'm still struggling to execute successfully in practice. I'm trying to generate a JWT token for use with Ghost's API as shown in their documentation: . Any tips on how to pull this off in Xano? Thanks!
-
new authentication option
i need continue with microsoft extension in xano
-
How to POST list of resources (more then 1)?
I have POST endpoint for resource "Thought" Query Parameters: Body { "description": "string", "percent_believe": integer } It is easy. But my interface has option of adding some resources "Thoughts" when user clicks button "Save". If user doesn't click button "Save" then thoughts haven't to be saved. { [ {"description":…
-
How do I send a list of booleans using the API
Hey everyone, I'm using the API to post to a table (currently using postman). This table has a field that is a list of booleans. It works if I just send "true" or "false", but when I try to send an array of them, I get the following error. Here's the table schema incase I have something setup incorrectly there: I'm new to…
-
POST list of resources
Hi, everyone. My app has to have option to add some resources when user clicks a button. How to do it in Xano {[{description: string, percent: integer}]}
-
Get the first duplicate item from array and delete it
Hi, I am struggling with the following request - I have an array of users which contains duplicates (which is desirable). When I call a specific API endpoint, I need to remove one of the duplicates (if duplicates exist, if not then delete the unique record) but keep the others. Example: - Existing array [1, 2, 2, 3, 2, 3]…
-
API call failing due to missing variables
Hello, I have a function that does the following actions from a high level: Queries records from two tables drills down into a specific field that links both tables [Table 1 ID (not xano) is primary and Table 2 has table 1's id (as secondary releationship) Where the value in that field appears in both tables, add the xano…
-
How to Retrieve Specific Users via PATCH
I am trying to connect to the endpoint in a table I have called "users". When I set it up within my frontend, Draftbit, I am given an error saying that the endpoint is not found. I originally thought I needed to put the users_id when testing the endpoint. An example I put in was a user_id of 38, which is an existing…
-
Replace database query parameters with array
I am trying to make an sql query as shown in the screenshot but I am having issues replacing the parameters as some of them are arrays, how can I prevent the error on the right and have the array render properly in the query without the square brackets
-
Post request from ESP8266 to Xano database
I'm trying to post data into a database table from my IOT device but I keep getting a 308 redirect response. Does anyone have experience with this? Some of my code: WiFiClient client; HTTPClient http; String serverPath = serverName + "/checklist_devices/"; http.begin(client, serverPath.c_str()); int httpResponseCode =…
-
Connect ETIMEDOUT error ?
Hi everybody, I have a recurring problem and I do not understand where it comes from... After 1200/1300 different API calls, I often get an error "connect ETIMEDOUT"... Each endpoint uses an authentication and I am in place "Scale x1". What could be the cause of this?
-
Do not show Null values
When a new record is added and there is no value passed, it automatically puts a null value in the field. But I just want it to stay blank. Is it possible to just save blank values? Any help is appreciated. Kind regards
-
Problema com Data e Hora com integração Bubble e Xano
Olá pessoal, precisava de ajuda com datetime, estou trabalhando em um projeto Bubble e Xano e quando a informação sai do Bubble, está salvando no Xano com 3 horas a menos. Eu entendo que é por conta do timezone, porém não consegui corrigir o problema do meu lado. https://www.loom.com/share/cb0fc850379a425c95dc6a4afcb433cd…
-
Trying to POST form-data in API request
Hi, I'm trying to POST form-data to another API (using a webhook/Xano Endpoint URL) but I can't seem to send data in curl as '—form' data. Here's the external API request: Here's the request logged (output): It seems the headers are not set, while I did use the 'Import CURL' function to map all the fields correctly. When I…
-
How can I use a variable to locate an Object property for Update?
I have an external API response which returns a list of codes. { "id": "401547429626", "sequenceNumber": "62600", "type": { "id": "5", "text": "xxx", "abbreviation": "xxx" }, { "id": "401547429648", "sequenceNumber": "64800", "type": { "id": "24", "text": "Pass Reception", "abbreviation": "REC" } I have an object which…
-
How can i skip the Auth0 Universal login page, and go straight to the SSO Connect
How can i skip the Auth0 Universal login page, and go straight to the SSO Connect? I am using Wized, Xano, Auth0 and Vipps Logg Inn.
-
Many to many relations
Greetings to all. My objective is to obtain an ultimate outcome similar to that. I have created these tables with this relations 1- student: class_id 2- class: [teacher], [subject] 3- exam: class_id 4- subject. From student API/ Get I gather information about students, teachers, exams, and subjects. I have two issues: 1- I…
-
Webhook 204 No content response
I'm trying to connect a webhook to Xano, but I'm encountering the following error message: "Please ensure that your webhook URL exists and handles POST requests. The required status code is 204 No Content." I have configured this correctly; the webhook URL does exist, and it indeed supports POST requests. However, I'm…
-
How to save a changing response structure from external API in database?
Hello! I am trying to save a list of transactions from my bank account in my DB. For example: here you can see that there is one incoming (account top up) and one outgoing transaction (paying a utility bill). One of them has a creditor name (utility provider) and another one has a debtor name (my own account from which I…
-
Whatsapp API
I am trying to set up the Meta/Whatsapp API webhook and am completely lost. Apparently, The Messenger Platform tries to "verify the webhook by sending a GET (instead of Post) request to the callback URL with certain parameters. Then the callback URL responds with the value of the hub.challenge parameter. The URL should…
-
How can I use environment variables in lambda functions?
How can I use environment variables in lambda functions? In my Workspace Settings I created a env called "apiKey".How can I use it in the code of my Lambda Function? If I try to log it or use it its always undefined. In the docs it says u can use it everywhere. I also tried $var.apikey and $apiKey. 😒plz help…
-
Log out API
How to create log out api any idea?? What exactly I will do for log out API If once token is created by login API then how to delete that token or destroy that token using log out API
-
How does the metadata API request history search work?
I'm looking to filter requests for the previous hour via this endpoint.https://api.cdco.io/apidoc:meta/#/request%20history/get_workspace__workspace_id__request_history Does anyone have examples of how to format the search query?
-
Count table records by column values
Hi there! I need help with creating an API endpoint. I have a report table where I reference other tables. In particular, I have Rating_1 column, which shows Rating values (integers, 1 to 5) selected by users. I'm trying to create an API endpoint that will return a count of report records for each rating value, even if…
-
Whatsapp Api
Hi all. I am trying to set up the webhook whatsapp Api. Whatsapp Api sends me this GET request, and I need to send back in the response the hub.challenge value, but when I try to do so it generates an error. I think the function stack thinks I want a value like this. Because the name has a dot in it. { hub: { challenge:…
-
Sort elements in random order
Hey everyone, is there a way in xano to sort elements in a random order, but to make that order consistent with pagination? Something like using a ORDER BY RAND(SEED) in sql. Similar to this stackoverflow quesiton: https://stackoverflow.com/questions/10729633/php-mysql-pagination-with-random-ordering Thanks a lot!!