-
Return String Value based on Boolean True or Fale
Watching some tutorials, I was able to successfully return (using an addon) a boolean value, true or false, based on whether the item is saved/liked by the authenticated user or not. But on the front-end no code tool I am using, Bravo Studio, I need to accompany this with a string value; for example: if _likes: false then…
-
'Get All Input' function causes 'Unable to decode input error'
Hi all, I'm having trouble getting the “Get All Input” function to work properly. My setup is as follows: I have a submission form on a Webflow page with POST action set to endpoint in Xano. The first function in this endoint's funtion Stack is “Get All Input” with json encoding. When I send some test data from the form in…
-
Upload and Map XLSX file to database
Hi everyone Wondering if this is possible in Xano? We are wanting to upload a XLSX file and map the data on a particular tab to the database based on a preset mapping list (ie. Field 1: C10, Field 2L H112, Field 3: A3) Is this possible with Xano or do we need to custom code this up? Cheers S
-
Passing DB Schema to Custom Function
Is there an easy way to set the input to a custom function to match a table's schema? I see the database link which gives me alllllllllll the fields as inputs, but if I stick it in an object I don't get any of them. The context of my question: I've got a custom function that calculates a number of fields when a row is…
-
Querying records where string length is less than N
I have a table with US Zip codes where some zips with leading zeros were not imported properly (the data type was originally integer) when importing from Airtable. I would like to prefix these zip codes with a "0". However, upon looking at Querying All Record function, I can't seem to add a Strlen filter in the WHERE…
-
Strategy for Complex data transformation
Hello fellow Xano enthusiasts! I've got an interesting challenge and am open to some ideas on how best to tackle it. I've got an array of invoice data. Each of these invoices have been fully paid. I am trying to work out the number of days between the invoice being issued (being the invoice date) and the invoice being…
-
Machine Learning models in Xano
Hey there! When using a Python-based backend, it was quite easy for me to generate machine learning models or neural networks in the backend, or pass data through an existing model, before pushing it to the front end. "Easy" as in, Python or R both have lots of libraries for ML up for grabs, for example. Are there any ways…
-
How to use variable within Query All Records `includes` custom query
Hi Xano community. We're attempting to use the text value returned from an outside API within our Query All Records request using includes to identify any rows within Xano table contain the variable's stored text value. We're receiving a null response when we use our variable (see below): I believe to make this work we…
-
Relationship within an object to table
I am pulling data from an external API into a table. Within that table I have an object called bookmakers with a key for each bookmaker. Because the API doesn't provide a photo, ive created a second table with the photos. I am trying to join the two based on the name of the bookmaker but cannot figure out how
-
Is Xano down?
Hello, I just started out, it seems i'm stuck with this it just keeps on loading. It won't let me copy URL endpoint and won't let me run and debug. Febuary 1 2023, 2 PM MST
-
Count() in Lambda?
I have an array of objects that have their own little arrays: [ {"numbers":[[1],[1,2],[1,2,3]]}, {"numbers":[[4],[4,5],[4,5,6]]} ] I want to update the objects to include only child arrays with with more than one element so the result would be: [ {"numbers":[[1,2],[1,2,3]]}, {"numbers":[[4,5],[4,5,6]]} ] My research says…
-
Addon Database Query is returning empty results
Hi there, I've set up an addon to query my video table, as you can see in the image below. The query is working, but it is returning the elements that aren't included as [] in the response. How can I fix this? I've tried changing the output from list to single, but it gave me the same result.…
-
How do I dynamically replace something within a path?
I am looking to pass on a dynamic value to path from a previous API result. For example: API 1 gives me some unique id say abc134. I then want to call API 2 but need to pass on this abc134 value in path, not as a query parameter. I need {userId} to be dynamic, here it will be abc134 from API 1 response. I don't see any…
-
Query all records from - filter
Hello, I have a table with a JSON field that on some records is empty. When using the above query method I want to filter out all the records with that JSON field empty. However differently then the filter list that appears usually in this case I can not find the is_empty filter. Comparing the JSON to empty object did not…
-
Create TXT files
I have a specific use case: I wish to convert a string value to a TXT file (.txt). Who can show me the way on how to make that happen?
-
Generate GeoJSON Data
I'm looking to generate GeoJSON Data to be passed to Mapbox as seen here: https://docs.mapbox.com/mapbox-gl-js/assets/earthquakes.geojson Does anyone know how I would go about doing this?
-
Issues in query all records
I have one column as JSON Array it contains multiple row value with 2 columns in it. eg module_name and updated_time I have to query all records and along with that I have to add two where condition one is on module_name which is "equal" condition and another one is on updated_time which is "less then or equal (<=)"…
-
new table column not shown as table input in function stack
When I add a new column into one of my database tables it does not appear as a selectable input in my list of API endpoint inputs or in my custom function inputs.
-
Parsing multipart/form-data from SendGrid inbound mail parse
Hey guys, I'm testing out SendGrid's inbound mail parse with a test title, test body texts, and also 2 attachments. When the email hits SendGrid, they send over a multipart/form-data that is separated by boundaries to an end point that I set up in Xano. How do I parse this request body into a useful object that I can use…
-
Transforming ISO String to Timestamp
Hi, I have a problem and i don't know how to solve it .After an airtable import I have a computed string field containing a string in ISO format ( because it was a computed field in Airtable ): 2023-01-02T16:03:44.818Z (by the way there is a bug in Airtable import when you have a DATE field with the option "include time"…
-
How do I create an object of a database table schema type as in below:
What I am trying to accomplish is to define an object of a table schema type. See below. I have tried all I could and I only get an object of type object not of type employee_job_assignment object. I believe I am missing some details/step, please help.
-
Don't know how to input objects
Hi there, I have the following snipped that I want to pass: [image.png] And the following inputs and variables defined: [image.png] But when I run it, I keep getting an empty object, as if my "organizations_list" wouldn't exist: [image.png] and I just can't explain why.... why is the organizations_list not being…
-
Custom Functions within Custom Functions
I'm running into an issue where I need custom functions to be able to reference other custom functions (this works fine) when called within my API endpoint's function stack. I have not been able to figure this out. Any help would be much appreciated.
-
Complex Financial Functions
Airtable has been very useful to me because of their ability to perform Excel-like functions. For example this monthly payment formula can be done by reference other fields in a record: {Loan Amount}*({Monthly Rate}*POWER(1 + {Monthly Rate}, INT(Amortization)*12)) / (POWER(1+{Monthly Rate},(INT(Amortization)*12))-1) From…
-
How can I preserving image metadata during upload?
Hey all, I'm trying to build out a web and mobile app that needs some of the additional metadata and EXIF data from a photo. After a short test of the image metadata upload in Xano I noticed most of the photo metadata is stripped from the image. Does anyone know of a way to maintain the photos metadata (DateTimeOriginal,…
-
Create image metadata stripping out jpeg EXIF header
We're using the "Create Image Metadata" block, and we're seeing that it is stripping out the jpeg EXIF headers. Specifically, some of our jpegs include a 90 degree rotation flag. This is lost. As a result, the images in Xano are not oriented correctly. In addition, Xano is stripping out the GPS location and other metadata…
-
Aggregate based on paging
Hi there, I have a question, in this video you explain how to use aggregate, how could I use only 2 records for that aggregate function instead of all?
-
Best data practice
Hi everyone, I have the below mater table example. Attribute set A table AND Attribute set B table are the expected results. Is the best practice to import the master table (actual data has more than 600 columns and over 70k rows) into Xano via CSV and use the API filters to get the expected result? Or should I processed…
-
What formats do dates need to be in in order to query a range in the database?
I need to grab all rows in a database for a week range. I have the first date of the week and the last date of the week. I've tried timestamps, YYYY-MM-DD, and MM/DD/YYYY. All of those return an error: message=Invalid syntax for schema type[date] It seems like this would be a simple thing, so maybe I'm doing something…
-
Get acronym using Lambda
I'm trying to get the acronym of the text variable with a Lambda function var str = $this; var matches = str.match(/\b(\w)/g); // ['J','S','O','N'] var acronym = matches.join(''); // JSON return(acronym) The function doesn't work with $this. I've used (return $this;) and I've successfully got a result. This means the…