JOIN_OBJECT_SOURCE
Description
Returns records from the specified object via the Source connection that match the provided joining field–value pairs, with an optional additional filtering clause.
Syntax
JOIN_OBJECT_SOURCE(object_name, ...[joining_field_name, joining_field_value], additional_clause_optional)
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| object_name | String | Yes | The name of the object from which records are retrieved. |
| joining_field_name | String | No | The field name to match for filtering records. Multiple pairs allowed. Left Join if any pairs are included; Cross Join if all are omitted. |
| joining_field_value | Object | No | The field value used as a filter criterion. |
| additional_clause_optional | String | No | An additional query clause for more specific filtering. |
Example
JOIN_OBJECT_SOURCE(
"Opportunity",
"AccountId", Id,
"IsClosed = true"
)
-- Fetches Opportunities from the $Source connection where AccountId equals the current record’s Id, further filtered to IsClosed = true.Tips
Defines this function during the Scoping stage to retrieve and prepare data for subsequent use in the Mapping stage.
Be careful to provide joining pairs when using this function. Omitting joining criteria can result in cross joins, creating excessively large record sets. Follow Salesforce best practices to prevent exceeding system limits.