Overview

In these pages, you can find the API reference for all the functions in our implementation of JMESPath, the querying language that we based our data transformations on. The functions are divided into categories for easier navigation, and here is an index of all the functions:

• General
  • cached_service
  • datasource
  • datasource_many
  • format
  • has_value
  • if
  • not_null
  • parent
  • parse_json
  • safe_mode
  • safe_not_null
  • service
  • to_array
  • template
  • type
• Numerical
  • abs
  • add
  • avg
  • calculate
  • ceil
  • divide
  • floor
  • max
  • max_by
  • min
  • min_by
  • multiply
  • subtract
  • sum
• Arrays
  • append
  • contains
  • distinct
  • distinct_by
  • group_adjacent
  • length
  • list_join
  • list_range_fill
  • map
  • parent_child_index
  • reverse
  • sort
  • sort_by
  • split
  • split_array
  • sum
  • take_or_default
  • to_dictionary
• Objects
  • get_property
  • items
  • keys
  • length
  • merge
  • numbered_props_to_array
  • replace_properties
  • values
• String
  • decode_html
  • ends_with
  • join
  • join_hide
  • length
  • replace
  • reverse
  • split_on
  • starts_with
  • string_interpolate
  • substring
  • to_datetime
  • to_lower
  • to_number
  • to_sentencecase
  • to_titlecase
  • to_upper
  • trim
  • trim_end
  • trim_start
• Datetime
  • add_time
  • current_time
  • format_datetime_to_timezone
  • to_datetime