ÃÛ¶¹ÊÓƵ

General functions in ÃÛ¶¹ÊÓƵ Workfront Fusion

Access requirements

You must have the following access to use the functionality in this article:

ÃÛ¶¹ÊÓƵ Workfront plan*
Pro or higher
ÃÛ¶¹ÊÓƵ Workfront license*
Plan, Work
ÃÛ¶¹ÊÓƵ Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime ÃÛ¶¹ÊÓƵ Workfront Plan, your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion as well as ÃÛ¶¹ÊÓƵ Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion as well as ÃÛ¶¹ÊÓƵ Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.

get (object or array; path)

Returns the value path of an object or array. To access nested objects, use dot notation. The first item in an array is index 1.

INFO
Examples:
  • get( array ; 1 + 1 )
  • get( array ; 5.raw_name )
  • get( object ; raw_name )
  • get( object ; raw_name.sub_raw_name )

if (expression; value1; value2)

Returns the value1 if the expression is evaluated to true; otherwise it returns the value2.

To create an if statement that returns a value only if two or more expressions are evaluated to true, use the and keyword.

To combine if statements, use the and and or operators.

and operator

INFO
Examples:
  • if( 1 = 1 ; A ; B )

    Returns A

  • if( 1 = 2 ; A ; B )

    Returns B

  • if( 1 = 2 and 1 = 2 ; A ; B )

    Returns B

ifempty (value1; value2)

Returns the value1 if this value is not empty; otherwise it returns the value2.

INFO
Examples:
  • ifempty( A ; B )

    Returns A

  • ifempty( unknown ; B )

    Returns B

  • ifempty( "" ; B )

    Returns B

switch (expression; value1; result1; [value2; result2; …]; [else])

Evaluates one value (called the expression) against a list of values; returns the result corresponding to the first matching value. To include an else value, add it after the final expression or value.

INFO
Examples:
  • switch( B ; A ; 1 ; B ; 2 ; C ; 3 )

    Returns 2

  • switch( C ; A ; 1 ; B ; 2 ; C ; 3 )

    Returns 3

  • switch( X ; A ; 1 ; B ; 2 ; C ; 3 ; 4 )

    Returns 4

    In this function, 4 is the value to be returned if no expressions apply (the else value).

omit(object; key1; [key2; …])

Omits the given keys of the object and returns the rest.

INFO
Example:
omit( User ; password )
Returns a collection of the user’s information, excluding the password.

pick(object; key1; [key2; …])

Picks only the given keys from the object.

INFO
Example:
pick( User ; password ; email )
Returns a collection of only the user’s password and email address.

mergeCollections(collection1 ; collection2)

Merges two collections by combining their key-value pairs. If both collections contain the same key, the value from the second collection overwrites that value from the first collection.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43