-
Calculate dynamically
A project requires a static database (updates by sales per user), and a dynamic database (calculated every hour, or by a web request). Dynamic database updates user bonuses from static db sales. Here is the catch. There are conditions for bonuses. Each user connects to another user, as a line. user1 >user2...> userx Each…
-
Symptoms Ratings. I want an eye to see if this will work for what I want.
[Screen Shot 2022-02-21 at 11.50.47 AM.png][Screen Shot 2022-02-21 at 11.51.01 AM.png][Screen Shot 2022-02-20 at 12.46.09 PM.png]
-
Help need on a Xano project
Hi there, I'm working on a No Code project and I need to move the DB from Airtable to Xano. The scope is to store information related to some Campaigns, Email Sequences, Messages, Contacts, Activities (email sent/received), and some other stuff related to drip email campaigns. So I'm looking for someone with experience in…
-
How to add an id (increments each time a new entry is posted) inside an object
Hi!, i have a noob question, how do can i insert an id (similar to the one that all database tables have) inside of an object? is there a way to make this organically instead of using post requests?
-
Input Default Value
I'm trying to set an input timestamp as a default value of now, but for some reason the default value option is not showing up? is this a bug or am I doing something wrong?[Screenshot 2022-02-16 111638.png]
-
Help with PATCH operation
Can anyone help me set up a patch operation properly. In that, I set it up and it "edits" a "resets" untouched data fields (inputs) to 0, instead of holding on to their values. Ideally I want to leave the untouched inputs holding their previous values unless and until they are written over. Lemme know if this is what PATCH…
-
changing time format sent to the frontend
My time is a unix timestamp in milliseconds, Have tried to change it to display the date but I had no luck, I get errors or it messes up the entire endpoint, can someone please help 😄
-
Filtering data
Hello, I have a table with 2 text fields and 1 image field. What i want is to filter the data according to users age or some other criteria. For example i want the user to choose his age from a dropdown menu and see results according to his choice. I use appgyver as frontend. As you can tell i am pretty new to this and any…
-
Importing List of Integers or Text entries from .csv
Hi This is my first post and I am new to Xano, but not to dBases. I have decided to split my Bubble app up and offload the dBase into Xano for performance reasons. I have exported lots of tables from Bubble into .csv format and they all contain many fields that are either a "list of" integers or a "list of" texts. When I…
-
How to trim "Surname" text (remove all characters except the 1st one) and display "S." only
I need to return trimmed surname in endpoint. Ive tried to search documentation but I haven't found exact solution for my case. Thank you
-
How to Reference JSON Value Where Path includes spaces
I am working with some legacy data that include spaces in object names which comes through as the below... "fields":{ "Bakery Name":"Tasty Bread", "Job Reference":"4556", "Bakery Type":"Bread" } How can I reference values say "Bakery Name" using dot notation? I have tried • fields.Bakery Name • fields."Bakery Name" •…
-
Conditional filter when updating an image
I want to allow my users to update their image profile. I'm using first_notempty filter and it works great. The only problem is when I want to update only certain fields without updating the profile image, then I'm running into an error: "Exception: missing file resource" so I guess first_notempty filter is not the right…
-
Trouble with an Array of dates
hello I have the following returned array: [ 05/03/2009, 03/02/2022, 30/09/2020, 25/10/2021, 11/01/2022, 02/02/2022, 01/02/2021, 01/02/2022, 25/10/2021 ] I am trying to extract the oldest date from the array. I have not been successful using the sort function. Not sure there is a native date sorting function? I have tried…
-
Uploading PDF with API
Trying to figure out how to upload a pdf with the API from a URL. For example how would I setup Xano so that this URL can be uploaded? "https://www.w3.org/WAI/ER/tests/xhtml/testfiles/resources/pdf/dummy.pdf"
-
How does Xano protect data that is entered through a Webflow site?
-
Authentication token expired
Hello, I have a user table that I set up for quite some time, and created login, signup APIs. They worked perfectly. I am resuming work after few days and try the same APIs, and I get "token expired" pop up. I tried with signup API to add new user and new token, it is throwing the same pop-up. Could you help! [image.png]
-
Error when json external filtering
i have a table where column geo_id contains list of ids (reference to other table of geo)[Screenshot 2022-01-27 at 18.14.37.png]I try to filter query by geo_id=11 as geo_id is list so I use operand "in"[Screenshot 2022-01-27 at 18.07.44.png]when I try to run i get this error:[Screenshot 2022-01-27 at 18.07.51.png]Can…
-
How does API Access setting work inside the database table?
I notice that there are public, private and internal setting for API access on each row in a database table. Even if authentication is turned on for api access should also the database rows be changed to private?
-
Transforming data \n to JSON API
Hi there, I want to use an external API. The type I need to send is: "Content-Type: application/json" I need to send a key from google (here as "googlePrivateKey")-[image.png]Sadly that key has a lots of \n in it and is and this causes my API to not work. As the \n is causing the api to fail it is escaped like this: \n.…
-
Create a POST request from a Webflow form to xano
Hello, How can I create a POST request using a Webflow form or code that's in an Embed on Webflow? Eventually, the POST request should append the logged-in user's ID to the data that has been posted. Thanks!
-
User-user connection table
Hello, I have a user table and I added an object with relationship to the same user table. The object only adds user_id and doesnt add other fields like email, avatar etc into the list and when I GET, it is the same. What I want is, once I add a user, I want the object to contain all of the added user details At the moment…
-
Setting up sendgrid magic link - URL question
Hi All, I'm setting up sendgrid to use their magic-link functionality. I'm working through this video: https://community.xano.com/c/announcements/magic-link-with-sendgrid-is-here I've got to the point where I need to add the "magic_link_redirect_uri". [magiclinksetupURL.png] I am using draftbit as my front end - do I…
-
Get an array element at a specific index using a variable
I have an array... myArray = ["a","b","c"]. I then have a variable... myValue = 2 How can I create a new variable which is the element at the position of myValue? So myNewVariable = "c". I have tried creating a new variable, setting the value to that of the array, then using get with a path of myValue, but I am unable to…
-
IP Address of my Xano Instance
Hi All, We need to call APIs at our Client's end and they need to add our IP Address to their Whitelist. Where can I find the IP Address of my Xano Instance? Is it a Static IP Address? TIA Kumar
-
Object and Table reference returns empty
I'm not sure if I'm doing something wrong or it's a bug but this gives me a headache. All tables have example data in them. Any advice? [Screen Shot 2022-01-08 at 1.36.59 PM.png][Screen Shot 2022-01-08 at 1.36.38 PM.png][Screen Shot 2022-01-08 at 1.02.41 PM.png]
-
What's the right way to reach a certain path across array records?
Hello! I am trying to run a condition that would check all array records "event_type" value to see if it equals a string. My Array is { "resource_user_events": [ { "id": 4, "created_at": 1641609301338, "user_id": 1, "event_type": "Like", "related_resource": "Activity", "related_resource_id": 2 }, { "id": 2, "created_at":…
-
How to compare 2 database ID's and update
Hi Guys, I have the following scenario. Database1: database gets products based on external api Database2: core database with our products. What I want to do is to update the core database 2 with information from database 1, IF the id from database 2 is present in database 1. Currently I have the following expression that…
-
Few first timer questions
Hi....its my first day with Xano. I must say my first impression has been great. A few questions if you can pls advice on: 1) I have imported a table from CSV, how can I auto generate CRUD ops for my table / fields. 2) Can I connect to a database in AWS RDS or take the API functionality being developed in Xano into AWS…
-
How to "skip" an entry if a variable is missing
Hi Guys, I'm calling an API, and loop through it to get all items in a database. This works fine, however if one variable is missing in one of the items i'm looping through, the loop breaks. How can I make sure the loop continues, if one item has a missing value? Thanks!
-
Image size in response
I want to have response image array with "?tpl=med" included in URL Im using Draftbit as FE & I havent found how to change it on FE so would be nice to have it from Xano side. [Screenshot 2022-01-04 at 09.14.59.png] Can you please suggest how to add this to endpoint. Thank you.