Transforms - INSTALINK.io

_id (Primary Key) objectid

The unique identifier for the record

Requires a Non-Null Value

Yes

findIn Look For Key in... options

The process data that where the transform operator will search for the from key

Requires a Non-Null Value

Yes

Allowed Values

parameters	Will search in all areas of the process data.
query	Will search only in the request query string.
body	Will search only in the request body data.
headers	Will search only in the request header.

Default Value

parameters

fromKey Input Key string

The lookup path for the data that will be transformed

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

toKey Output Key string

The lookup path for where the result of the transformation will be stored.

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

transformAs Transform As options

The operation that will be used to transform the input data found at the path listed in fromKey. All operations are also available via scripting. See the Instalink Scripting Documentation for more information

Requires a Non-Null Value	Yes
Allowed Values	NONE, COPY, INTEGER, FLOAT, STRING, MAP, ARRAY, DATE, DATE_TO_STRING, TIMESTAMP, BOOLEAN, NUMBER_TO_STRING, ARRAY_GET, ARRAY_SET, ARRAY_DELETE, ARRAY_LENGTH, ARRAY_FIRST, ARRAY_TAIL, ARRAY_LAST, ARRAY_INIT, ARRAY_PLUCK, ARRAY_SAMPLE, ARRAY_RANDOMIZE, ARRAY_EACH, ARRAY_CONCAT, ARRAY_FILTER, ARRAY_MATCH, ARRAY_UNIQUE, ARRAY_SORT, ARRAY_UNIQUEBY, ARRAY_SORTBY, ARRAY_FLATTEN, ARRAY_FLATTEN_DEEP, ARRAY_JOIN, ARRAY_REVERSE, ARRAY_TRANSPOSE, ARRAY_GET_INDEX, ARRAY_CONTAINS, ARRAY_SUB, ARRAY_GROUP_BY, ARRAY_AGGREGATE, ARRAY_GROUP_AGGREGATE, ARRAY_UNION, ARRAY_DIFFERENCE, ARRAY_INTERSECTION, ARRAY_TO_MAP, TEXT_SEARCH, TEXT_MATCH, TEXT_CONTAINS, TEXT_CONCAT, TEXT_PREPEND, TEXT_APPEND, TEXT_SUB, TEXT_REPLACE, TEXT_LENGTH, TEXT_LOWER_CASE, TEXT_UPPER_CASE, TEXT_CAPITALIZE_WORDS, TEXT_TRIM, TEXT_TRIM_LEFT, TEXT_TRIM_RIGHT, TEXT_SPLIT, TEXT_LINES, TEXT_WORDS, TEXT_HMAC, TEXT_HASH, LESS_THAN, GREATER_THAN, LESS_THAN_OR_EQUAL, GREATER_THAN_OR_EQUAL, EQUAL, NOT_EQUAL, AND, OR, XOR, EXISTS, DATE_YEARS_AGO, DATE_MONTHS_AGO, CURRENT_DATE, CURRENT_TIMESTAMP, DATE_YEAR, DATE_MONTH, DATE_MONTH_STRING, DATE_DAY_OF_MONTH, DATE_DAY_OF_WEEK, DATE_DAY_OF_WEEK_STRING, DATE_TRUNCATE_TO_MINUTE, DATE_TRUNCATE_TO_HOUR, DATE_TRUNCATE_TO_DAY, DATE_TRUNCATE_TO_MONTH, DATE_TRUNCATE_TO_YEAR, TIMEZONE, MATH_NEGATE, MATH_ADD, MATH_SUBTRACT, MATH_MULTIPLY, MATH_DIVIDE, MATH_DIVIDE_INT, MATH_REMAINDER, MATH_POWER, MATH_SQUARE_ROOT, MATH_CUBE_ROOT, MATH_ABSOLUTE_VALUE, MATH_CEILING, MATH_FLOOR, MATH_TRUNCATE, MATH_ROUND, MATH_RANDOM, MATH_RANDOM_INT, MAP_GET, LOOKUP, MAP_PAIRS, MAP_HAS, MAP_SIZE, MAP_MERGE, MAP_KEYS, MAP_VALUES, MAP_SET, MAP_DELETE, SCRIPT, ENCODE_BASE64, DECODE_BASE64, ENCODE_JSON, DECODE_JSON, EXTRACT_INNER_HTML, EXTRACT_OUTER_HTML, EXTRACT_HTML_ATTRIBUTE, EXTRACT_HTML_TEXT, DECODE_XML, ENCODE_CSV, ENCODE_X12, DECODE_X12_V2, DECODE_X12, DECODE_CSV, ENCODE_URI, DECODE_URI, ISO_COUNTRY, ISO_SUBDIVISION, MATCH
Default Value	NONE

arg1 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg2 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg3 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg4 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg5 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg6 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg7 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg8 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg9 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg10 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg11 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

arg12 string

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	No
Converts to Lowercase	No
Converts to Uppercase	No

script Script string

User defined script that performs a transformation on the input data. See the Instalink Scripting Documentation for more information

Requires a Non-Null Value	Yes
Default Value	""
Trims Whitespace	No
HTML Tags Allowed	Yes
Converts to Lowercase	No
Converts to Uppercase	No

parentProcess Parent Process objectid

A reference to the process that will execute the transformation.

Requires a Non-Null Value

No

projectId objectid

A reference to the project that contains parent process.

Requires a Non-Null Value

Yes

accountId objectid

A reference to the account that owns the project.

Requires a Non-Null Value

Yes

createdTime datetime

System managed property. Set to the timestamp of when the record is created.

Requires a Non-Null Value	Yes
Default Value	__auto__

modifiedTime datetime

System managed property. Set to the timestamp of when the record is updated.

Requires a Non-Null Value	Yes
Default Value	__auto__