-
Upload Images to Storage from ext. URL
Hi there, I am using Xano Storage to upload base64 encoded image data, which works well. Now I am struggling with a similar task: In my CRUD API I receive an image URL which is located on an external server (via external API). I need to upload (copy) that image from the external url to my own Xano space. Actually I couldnt…
-
How to create a waiting thread fo Webhook?
Hi, I just have a problem, i receive 3-4 Webhook at the same time, The first will create a record, but the other will update records, i can't hav multiple record for the same Booking_id. How can i do to fix it ? Thanks [Capture d’écran 2021-11-13 à 10.53.18.png][Capture d’écran 2021-11-13 à 10.53.45.png]
-
Count Records where Field is Empty
A rather basic question here. I'm able to query records from a related table, such as Users who've created a record in a separate table. Some records will be "deleted" where I'll be adding a timestamp to those records as shown in the image. I'd like to ignore these records where there is a timestamp present. Assuming this…
-
Download CSV from url
Hi Xano team I need some help please. Will it be possible that if I have a url (//s3.amazonaws.com/appforest_uf/f1636896782906x607231206679579800/Telkom.csv) to be able to call this directly from Xano and persist the data. The persisting part I am comfortable with but the download I am not sure off as I don't have insights…
-
Use Xano to Update Webflow on Daily basis
So here's my question: I've got a lot of daily updated data that gets added to XANO. I want to push this to webflow. How would you approach this? Specifically... • How would you tackle the get X items at 9am for today? • How would you check the existence of data in webflow first? Thanks, Toby
-
Array of Images
I for the life of me can't get this to work.. I can't see what I'm doing wrong. I seem to be following all the steps but when the record is added, the image list is empty. When I try this without an array (and without a loop), it works with a single image. API[Screen1.PNG] Create Variable [Create Variable.PNG] For Each…
-
(Untitled)
why am i getting this error in bravo ? [Screenshot 2021-11-06 at 10.42.07 AM.png]I have put in all the inputs, even auth token value.
-
[ resolved] Changing a response to an array or an object instead of a string
I have a POST API setup that posts three inputs and encrypts each one. The API runs fine in XANO but is running into an issue with my front-end. The front-end team have identified that the issue is that the API returns the crypto_1 variable as a string, and that this needs to be changed to an array or an object. I feel…
-
Edit Records API issue
So, this morning I changed one of my fields from "text" to "date", and the POST request associated with it is still working fine. I wanted to copy this endpoint and use it as a PATCH request so users could edit the existing details if they got anything wrong; but I'm getting this error: { code: ERROR_CODE_INPUT_ERROR,…
-
API issues
Get endpoints to retrieve data are super slow today and crashing my browser. Is there anything happening?
-
Unable to get dot notation perfectly.
I am new to XANO, and trying to create my first API. [image.png]This is my table called Margins & I have created a variable called Margins_1 When I try to call Margins_1.Margin its giving me an error. [image.png]Infact that is the case for all the variables there. I need to know where I am going wrong.
-
API error on POST
Hi all! I have a POST endpoint setup that post some input fields to a database, and encrypts them as it does so. It works when I test it in Xano, however when I add the endpoint in my Draftbit front-end it gives the error: "ERROR":{ "message": "src property must be a valid json object"Can anyone point me in the direction I…
-
PUT Update
Okay so fairly simple. I am using PUT to update records. I want to update only one or two fields of a table. But most of the table is tables references to other tables "integers". I can pass "" for a text record and not update its contents. But I cant for anything else. All records get set to 0. How do I ignore all the…
-
How to order a list
Hi everyone, I want to fetch/get a list of objects from my database and have them sort in the front end by date so that the newest are on the top of the list. I feel like this should be super obvious but I'm confused as to which function to use in the API call to make it sort like this. Any advice or a link to a guide…
-
POST API
I'm struggling with a POST API between Bravo and Xano. Currently I'm trying to set up the API in Xano, but I'm getting an "Invalid timestamp format" error in the run and debug portion: code: ERROR_CODE_INPUT_ERROR, message: Invalid timestamp format., param: created_at Not sure what I may be doing wrong. Does anyone have…
-
magic link + ... ?
Hey all, I'm looking to avoid a whole separate system for protecting whole pages (a la Memberstack). I get I can protect/authenticate the database with the magic link/basic auth. But can anyone point me in the direction of a snippet or tutorial that would allow me to block entire pages just using Xano's built-in…
-
Working With Xano and Bravo API issue
I've got a list endpoint working in Xano and in Bravo: but I'm having trouble with a details endpoint. I can get them both working - but only with different endpoint urls! Which is confusing. Xano wants to give me an endpoint url of /{id} which returns a 'not a valid integer' error, but the api will return exactly what I…
-
Facebook Webhook Character Problem
Hi, I'm a newbie on Xano. I'm setting up a webhook for Facebook API. I can get and process the data. The Facebook API requires me to send a challenge code back to Facebook if the connection is successful. I return the code in my API's response part as "self". However, facebook gives an error and says "Expected…
-
Selection of key-value pair value from Response Header
Hi, I am trying to select a specific key-value pair present under the response header by using subpath as mentioned in the video part 3 of Idea to App. But it is observed that, it doesn't drill down inside the Header's key-value pair, instead it drill downs till headers option only. Attaching the image for reference…
-
google-oauth demo returns "Input does not meet minimum length requirement of 12 characters"
Hi, I'm playing around with the google-oauth demo code. I believe I followed all the steps correctly, but when I press on the "signup with google button" I get the google popup and select my account, and then get a red message Input does not meet minimum length requirement of 12 characters after the popup disappears. Any…
-
Response caching reset via API
Hello Guys, I hope you are all well. I am experimenting with caching to improve perf of my app and one of the use case I have is caching the response on the user level (auth-level) but I want to be able to scrap it anytime certain API gets hit. Basically my users create a training plan which lasts a couple of months hence…
-
General Security provided by Xano
Hi Xano Team I am very interested to know what security and protection do you provide by default to protect instances/api's against bots, DDOS etc. Do you actually front the instances with a level of firewall protection or not?
-
API question
I have a table called Settings. There is one record per user. I want to get the record by user_id. When I attempted to create the API endpoint of settings/{user_id} I got an error message "This name is already being used by another query". I can't see another API url like that. Any suggestions? [image.png] [image.png]
-
How to sign external API requests HMAC_SHA-256?
Hello I have been stuck with one issue for some time and hope someone can help. I am trying to set up integration from Xano to my accounting system. The API manual of accounting system instructs that URL parameters (including timestamp and public key) and request body should by used in signature calculation. The signature…
-
.Net Identity platform authentication
Hi guys We have an enquiry regarding using a .Net Core front-end with Xano as a back-end. The client is using .Net's Identity service and wants to keep it. Question 1: In theory, can we use .Net's authentication system to access Xano records from a table that requires authentication? I've seen mention on the forum of…
-
Using a variable to input send to email into Sendgrid dynamic send
I am trying to use the sendgrid dynamic send function to send an email confirmation to a specific end user when they update a record. I have set a get record function to return the only email of the user from the user database. I then set the to email in the sendgrid function to use the outcome of the get record. When I do…
-
html response
Hi Xano team Can you please advice on how I can extract specific data out of an html response like below with Xano. I am connecting to an external api that only supports form data. [html.PNG]
-
Change the queried table (help)
Hi Is there any way to change the queried table in "Query All Records"? [CleanShot 2021-09-10 at 21.01.29@2x.png] We are now painstakingly duplicating every table and every api for staging purposes, but now we hit a roadblock, as it will be a lot of work and prone to error if we change it manually by replacing the line…
-
Favorite or Unfavorite Board
I'm trying to query all my boards and separate the one's that our favorited by the user versus unfavorited using a heart icon. I'm not quite sure how to set this up in the function stack for my db query. I think I need a conditional statement that when the condition is true it will use a heart_fill icon and when its false…
-
Random sort Add-on decorators
I'm trying to random sort a couple table reference fields in my queried table. I believe I have the add-ons setup correctly with random sort, but when I query the main table (with the add-on decorators) it returns the json in order. This makes sense for the "boards" themselves, but I would expect the "Tops" and "Bottoms"…