Xano Documentation
  • 👋Welcome to Xano!
  • 🌟Frequently Asked Questions
  • 🔐Security & Compliance (Trust Center)
  • 🙏Feature Requests
  • 💔Known Issues
  • Before You Begin
    • Using These Docs
    • Where should I start?
    • Set Up a Free Xano Account
    • Key Concepts
    • The Development Life Cycle
    • Navigating Xano
    • Plans & Pricing
  • The Database
    • Designing your Database
    • Database Basics
      • Using the Xano Database
      • Field Types
      • Relationships
      • Database Views
      • Export and Sharing
      • Data Sources
    • Migrating your Data
      • Airtable to Xano
      • Supabase to Xano
      • CSV Import & Export
    • Database Performance and Maintenance
      • Storage
      • Indexing
      • Maintenance
      • Schema Versioning
  • 🛠️The Function Stack
    • Building with Visual Development
      • APIs
        • Swagger (OpenAPI Documentation)
      • Custom Functions
        • Async Functions
      • Background Tasks
      • Triggers
      • Middleware
      • Configuring Expressions
      • Working with Data
    • Functions
      • AI Tools
      • Database Requests
        • Query All Records
          • External Filtering Examples
        • Get Record
        • Add Record
        • Edit Record
        • Add or Edit Record
        • Patch Record
        • Delete Record
        • Bulk Operations
        • Database Transaction
        • External Database Query
        • Direct Database Query
        • Get Database Schema
      • Data Manipulation
        • Create Variable
        • Update Variable
        • Conditional
        • Switch
        • Loops
        • Math
        • Arrays
        • Objects
        • Text
      • Security
      • APIs & Lambdas
        • Realtime Functions
        • External API Request
        • Lambda Functions
      • Data Caching (Redis)
      • Custom Functions
      • Utility Functions
      • File Storage
      • Cloud Services
    • Filters
      • Manipulation
      • Math
      • Timestamp
      • Text
      • Array
      • Transform
      • Conversion
      • Comparison
      • Security
    • Data Types
      • Text
      • Expression
      • Array
      • Object
      • Integer
      • Decimal
      • Boolean
      • Timestamp
      • Null
    • Environment Variables
    • Additional Features
      • Response Caching
  • Testing and Debugging
    • Testing and Debugging Function Stacks
    • Unit Tests
    • Test Suites
  • CI/CD
  • File Storage
    • File Storage in Xano
    • Private File Storage
  • Realtime
    • Realtime in Xano
    • Channel Permissions
    • Realtime in Webflow
  • Maintenance, Monitoring, and Logging
    • Statement Explorer
    • Request History
    • Instance Dashboard
      • Memory Usage
  • Building Backend Features
    • User Authentication & User Data
      • Separating User Data
      • Restricting Access (RBAC)
      • OAuth (SSO)
    • Webhooks
    • Messaging
    • Emails
    • Custom Report Generation
    • Fuzzy Search
    • Chatbots
  • Xano Features
    • Snippets
    • Instance Settings
      • Release Track Preferences
      • Static IP (Outgoing)
      • Change Server Region
      • Direct Database Connector
      • Backup and Restore
      • Security Policy
    • Advanced Back-end Features
      • Xano Link
      • Developer API (Deprecated)
    • Metadata API
      • Master Metadata API
      • Tables and Schema
      • Content
      • Search
      • File
      • Request History
      • Workspace Import and Export
      • Token Scopes Reference
  • Xano AI
    • Building a Backend Using AI
    • Get Started Assistant
    • AI Database Assistant
    • AI Lambda Assistant
    • AI SQL Assistant
    • API Request Assistant
    • Template Engine
    • Streaming APIs
  • AI Tools
    • MCP Servers
      • Connecting Clients
      • MCP Functions
  • Xano Transform
    • Using Xano Transform
  • Xano Actions
    • What are Actions?
    • Browse Actions
  • Team Collaboration
    • Realtime Collaboration
    • Managing Team Members
    • Branching & Merging
    • Role-based Access Control (RBAC)
  • Agencies
    • Xano for Agencies
    • Agency Features
      • Agency Dashboard
      • Client Invite
      • Transfer Ownership
      • Agency Profile
      • Commission
      • Private Marketplace
  • Enterprise
    • Xano for Enterprise
    • Enterprise Features
      • Microservices
      • Tenant Center
      • Compliance Center
      • Security Policy
      • Instance Activity
      • Deployment
      • RBAC (Role-based Access Control)
      • Xano Link
  • Your Xano Account
    • Account Page
    • Billing
    • Referrals & Commissions
  • Troubleshooting & Support
    • Error Reference
    • Troubleshooting Performance
      • When a single workflow feels slow
      • When everything feels slow
      • RAM Usage
      • Function Stack Performance
    • Getting Help
      • Granting Access
      • Community Code of Conduct
      • Community Content Modification Policy
  • Special Pricing
    • Students & Education
    • Non-Profits
  • Security
    • Best Practices
Powered by GitBook
On this page

Was this helpful?

  1. The Function Stack
  2. Filters

Conversion

Last updated 3 months ago

Was this helpful?

  • - Decodes the value represented as base64 and returns the result.

  • - Decodes the value represented as base64 URL safe text and returns the result.

  • - Encodes the value and returns the result as base64 text.

  • - Encodes the value and returns the result as base64 URL safe text.

  • - Converts a value between two bases.

  • - Converts a binary value into its hex equivalent.

  • - Converts a decimal value into its binary string (i.e. 01010) equivalent.

  • - Converts a binary string (i.e. 01010) into its decimal equivalent.

  • - Creates an object based on a list of keys and a list of values.

  • - Decodes the value represented as CSV and returns the result

  • - Encodes the value and returns the result in CSV-formatted text

  • - Converts a decimal value into its hex equivalent.

  • - Converts a decimal value into its octal equivalent.

  • - Converts a hex value into its binary equivalent.

  • - Converts a hex value into its decimal equivalent.

  • - Decodes the value represented as json and returns the result.

  • - Encodes the value and returns the result as json text.

  • - Converts an octal value into its decimal equivalent.

  • - Converts text, integer, or decimal types to a bool and returns the result.

  • - Converts text, integer, or bool types to a decimal and returns the result.

  • - Converts text, integer, or bool types to an integer and returns the result.

  • - Converts text, integer, or bool types to text and returns the result.

  • - Converts a text expression (now, next Friday) to timestamp comparable format.

  • - Decodes the value represented as a URL encoded value.

  • - Decodes the value represented as a URL encoded value conforming to RFC3986 specifications

  • - Encodes the value and returns the result as a URL encoded value.

  • - Encodes the value and returns the result as a URL encoded value conforming to RFC3986 specifications

  • - Decodes the value represented as yaml and returns the result.

  • - Encodes the value and returns the result as yaml text.

  • - Decodes the value represented as XML to JSON and returns the result

base64_decode:

Decodes the value represented as base64 and returns the result.

base64_decode_urlsafe:

Decodes the value represented as base64 URL safe text and returns the result.

This filter transforms the base64 URL safe encoded characters -_. back to +/=.

base64_encode:

Encodes the value and returns the result as base64 text.

base64_encode_urlsafe:

Encodes the value and returns the result as base64 URL safe text.

In base64 encoding, a URL safe format is not taken into consideration but there's only three characters we need to be cautious of +/=. With this filter those characters become -_. respectively.

base_convert:

Converts a value between two bases.

  • frombase: Specifies the original base of number. Has to be between 2 and 36, inclusive. Digits in numbers with a base higher than 10 will be represented with the letters a-z, with a meaning 10, b meaning 11 and z meaning 35

  • tobase: Specifies the base to convert to. Has to be between 2 and 36, inclusive. Digits in numbers with a base higher than 10 will be represented with the letters a-z, with a meaning 10, b meaning 11 and z meaning 35

In this example we are converting a hexadecimal number to an octal number:

bin2hex:

Converts a binary value into its hex equivalent.

decbin:

Converts a decimal value into its binary string (i.e. 01010) equivalent.

bindec:

Converts a binary string (i.e. 01010) into its decimal equivalent.

create_object:

Creates an object based on a list of keys and a list of values.

Resulting in a created object:

csv_decode:

Decodes the value represented in the CSV format and returns the result.

  • separator - the field delimiter, one character only (usually a comma)

  • enclosure - the field enclosure, one character only (usually a quotation mark)

  • escape - the escape character that allows the enclosure character to be used within a field

csv_encode:

Encodes the value and returns the result in CSV format

  • separator - the field delimiter, one character only (usually a comma)

  • enclosure - the field enclosure, one character only (usually a quotation mark)

  • escape - the escape character that allows the enclosure character to be used within a field

dechex:

Converts a decimal value into its hex equivalent.

decoct:

Converts a decimal value into its octal equivalent.

hex2bin:

Converts a hex value into its binary equivalent.

hexdec:

Converts a hex value into its decimal equivalent.

json_decode:

Decodes the value represented as json and returns the result. We will decode the json from the json_encode filter example.

json_encode:

Encodes the value and returns the result as json text. The variable object is: { "a":"3", "b":"2", "c":"1" }.

octdec:

Converts an octal value into its decimal equivalent.

to_bool:

Converts text, integer, or decimal types to a bool and returns the result. The different conversions that are possible with this filter are: Converting a text/integer/decimal value of 0 to false. Converting a text/integer/decimal value of 1 to true. Converting a text value of "true" to true. Converting a text value of "false" to false.

to_decimal:

Converts text, integer, or bool types to a decimal and returns the result.

to_int:

Converts text, decimal, or bool types to an integer and returns the result.

to_text:

Converts text, decimal, or bool types to text and returns the result.

to_timestamp:

Converts a text expression (now, next Friday) to timestamp comparable format.

url_decode:

Decodes the value represented as a URL encoded value.

url_decode_rfc3986

url_encode:

Encodes the value and returns the result as a URL encoded value.

url_encode_rfc3986

yaml_decode:

Decodes the value represented as yaml and returns the result. For this example, we will use the example from yaml encode and then decode the variable. The variable gets changed into:

{
  "name": "John",
  "age": 30,
  "car": "ford"
}

yaml_encode:

Encodes the value and returns the result as yaml text.

xml_decode:

Decodes the provided data as XML, to JSON, and returns the result.

Similar to url_decode, this decodes the value represented as a URL encoded value, but conforming to standards.

Similar to url_encode, this encodes the value and returns the result as a URL encoded value, but conforming to standards.

🛠️
rfc3986
rfc3986
base64_decode
base64_decode_urlsafe
base64_encode
base64_encode_urlsafe
base_convert
bin2hex
decbin
bindec
create_object
csv_decode
csv_encode
dechex
decoct
hex2bin
hexdec
json_decode
json_encode
octdec
to_bool
to_dec
to_int
to_text
to_timestamp
url_decode
url_decode_rfc3986
url_encode
url_encode_rfc3986
yaml_decode
yaml_encode
xml_decode
Example: we have a text value of aGVsbG8gd29ybGQ= using the filter base64_decode we get hello world.
Example: we have a text value of hello world using the filter base64_encode we get aGVsbG8gd29ybGQ= .
Keys list is [first_name, company, position]. Values list is [Michael, Xano, Customer Success Lead].
The lists of keys and values are combined to create an object.
Example: we have a text value then use the url_encode filter to change it to Hello+World+%26+Xano.