Concatenate (Simple) - State Solutions

Concatenates an incoming array of data into a string.

Version 1

HTTP Request
POST /ado/v1/SimpleConcatenate

Header

Parameter	Description
Ocp-Apim-Subscription-Key	The subscription key you received when you purchased a plan.

Request Body

Mandatory

Parameter	Type	Description
data	Object[]	Array containing one or more primitive objects.

Optional

Parameter	Type	Description
separator	String	Each word determined from the `field` property will be separated by this string.
ignoreEmpty	Boolean	`true` will ignore all item values that are either null or empty strings. Default is `false`.

Common

Further Documentation: Common Parameters

Parameter	Type	Description
filter	String	A fully functioning SQL WHERE statement that will filter the resulting dataset to the records it determines as being included.
sortOrder	String	Sorts the resulting dataset in the desired direction (i.e. `ASC` or `DESC`).
schema	Object	You can use this parameter to override the inferred schema of properties in the incoming dataset(s). A field will be inferred unless specific explicitly within this object.
advancedOptions	Object	Is an object with the following properties. cultureName (String) The specified culture determines the behaviour for aspects like formatting numbers and dates. Is extremely important when converting strings to dates, i.e. 05/03/2022 will determined differently between locales. For more information on the accepted values for this property, please consult the documentation from Microsoft … https://docs.microsoft.com/en-us/dotnet/api/system.globalization.cultureinfo?view=net-6.0#culture-names-and-identifiers isBoolean (string[]) A list if strings that are the names of all properties in the resulting dataset that should be treated as boolean. By default, the framework treats boolean values as 1 (true) or 0 (false). In order to differentiate the integer as a boolean, that property needs to be explicitly called out in this list.

Examples

Basic (Sorted)

Ignore Empty Values

A very basic numeric array (but represented as strings) is loaded and concatenated using a comma.

Request

{
    "separator": ",",
    "sortOrder": "ASC",
    "data": [
        "4",
        "6",
        "1",
        "3",
        "2",
        "5",
        "7"
    ]
}
Code language: JSON / JSON with Comments (json)

Response

1,2,3,4,5,6,7
Code language: JSON / JSON with Comments (json)

This array has multiple elements, two of which are null values. Given the ignoreEmpty parameter is set to true, they will not be included in the resulting string.

Request

{
    "separator": ",",
    "ignoreEmpty": true,
    "data": [
        null,
        "6",
        "1",
        null,
        "2",
        "5",
        "7"
    ]
}
Code language: JSON / JSON with Comments (json)

Response

6,1,2,5,7
Code language: JSON / JSON with Comments (json)