Working with data in Xano - The Basics

Today we'll cover the core concepts around working with Data in Xano. Specifically:
Functions - Use them to execute actions in the NO CODE API Builder
Variables - Store information to be used in your API
Dot notation - drill into specific properties of a variable
Filters - Transform and manipulate data in variables
Addons (like GraphQL) - Enrich Data with related data
Date & Times - Work with Timestamps, relative time, and timezones.
Documentation being referenced:
docs.xano.com/working-with-da...
Chapters
0:00 - Introduction
0:35 - Functions - Perform an action
1:55 - Variables - Store data
3:55 - Dot Notation - Dive into data
6:00 - Filters - Transform data
7:27 - Functions - Loop through a variable list and filter each item
11:30 - Addons - Enrich data
13:44 - Dates & Times
19:30 - Summary
Vist Xano - The Fastest No Code Backend Dev Platform
go.xano.co/2XCePjG
Twitter
/ nocodebackend
Subscribe to Xano's Channel for Weekly New Content
/ nocodebackend

[@StephDespiteMS]

Documentation - wow, I'm learning so much!! I know how I'm spending my weekend.

[@asdqwezxcasdqwezxc12]

Following along this, I was able to get the Time Now function to work properly, but nearing the end, while formatting the time through the filter function, I'm getting {"code":"ERROR_CODE_INPUT_ERROR","message":"Invalid timestamp format.","param":null} my format is set to "r" and time zone set to "UTC" I had an add-on that added data and I customized the results to show only one column, I thought that might have been the issue, since that add-on didn't have a timestamp on it. But after adding the created_at back on, and removing the add-on all together, I'm still having the issue. Any thoughts on that?

[@danield3358]

happening to me too

[@balloonartisan]

When you are doing all of these different functions/ operations, is it making permanent changes to your database or is it just a temporary change?

[@nocodebackend]

the only time you would be making a change to your database is when using a function that explicitly interacts with your database. These are called "database requests". The function stack can handle on the fly data transformations to be presented in your front-end in any format

[@balloonartisan]

@@nocodebackend how many tears need to be shed on average before a beginner understands all of this stuff?! 😢 haha. Thanks for the videos!

[@easy_english_123]

12:11 - Add on - add more information 14:20 - Format date

[@wheres_bears1378]

Do add ons work for api calls?

[@nocodebackend]

Addons are for querying records from your tables and aren't really applicable to external API calls.