Skip to Content

Recipient() mvSQL runtime function in Jitterbit App Builder

Summary

Generates an internal URN recipient string that can be used in the To() field of an App Builder alert to send a notification to a set of users, such as all users in a given group.

Note

This function was added in App Builder 4.40.

Syntax

RECIPIENT(<type>, <id-or-name>)

Parameters

type

A string indicating the recipient type, one of the following:

  • User
  • Group
  • Role
  • Application
  • DataSource
  • Session

id-or-name

A string identifying the recipient, either of the following:

  • Name: A username, or the name of a group, role, application, or data source.

    Note

    When using a role name, the role must belong to the rule's data source.

  • Identifier: A unique and unambiguous identifier for the user, group, or role across data sources, applications, or sessions.

Returns

A string in the internal URN format, using the object’s ID.

Examples

# Call Returns
1 RECIPIENT(group, 'Adminstrators') urn:groupid:59baf94e-6990-4991-aacb-cab9265a4a42
2 RECIPIENT(group, '59baf94e-6990-4991-aacb-cab9265a4a42') urn:groupid:59baf94e-6990-4991-aacb-cab9265a4a42