CONCATENATE (not to be confused with CONCAT) appends strings together.

Function category: Text​

Syntax

CONCATENATE(arg1, [arg2...])

CONCATENATE can take an arbitrary number of additional arguments.

Examples

Let's say we're given a response with the following vehicle information.

{
  "data": {
    "vehicles": {
      "vehicle_1": {
        "make": "Toyota",
        "vin": "A31z056"
      }
    }
  }
}

Example 1: Combine two strings into a single string

If we wanted to concatenate (combine) the values of "make" and "vin" into a single string, use the following function.

# Combine make and vin into a single string
CONCATENATE(data.vehicle_1.make, "-", data.vehicle_1.vin)
​
# Returns "Toyota-A31z056"  

Example 2: Combine the elements of an array into a single string

If we wanted to concatenate the elements of an array into a single string, use the following function.

# Combine an array of strings into a single string
CONCATENATE({"a","a","a","a"})
​
# Returns "aaaa"