CONCATENATE
(not to be confused with CONCAT) appends strings together.
Function category: Text​
CONCATENATE(arg1, [arg2...])
CONCATENATE
can take an arbitrary number of additional arguments.
Arguments | Description |
| A string. |
| Optional. Same as |
Let's say we're given a response with the following vehicle information.
{"data": {"vehicles": {"vehicle_1": {"make": "Toyota","vin": "A31z056"}}}}
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 stringCONCATENATE(data.vehicle_1.make, "-", data.vehicle_1.vin)​# Returns "Toyota-A31z056"
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 stringCONCATENATE({"a","a","a","a"})​# Returns "aaaa"