Illustrated below is an example where a Buffer Query Source step is used.
The Record Generator step is used as the main source step and populated is an AccountID as illustrated below.
Adding a Buffer Query Source Step
To add a Query Source source step, follow these instructions:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for a Buffer Query.
Configuring the Buffer Query Source Step
Illustrated in the below image is the configuration that is available in the Buffer Source step.
Query
Select the required buffer by clicking on the drop-down list which is outlined in red in the above image. This returns the buffer ID (highlighted in the image above). Type out the SQL query in the Query section. A record in the data set can be referenced by using 'inputRecord.fieldName' in the SQL query. Click on the Validate button to validate the SQL query.
The available SQL syntax to query a buffer are in the link below:
Limit field
Set the maximum number of records required to be returned.
Skip
Number of records to skip.
Force Aggregate checkbox
Force an aggregate query regardless of the query type.
Debug checkbox
Log queries for debug purposes.
Using the Buffer Query Source step
In this example, an inner join is used to get the account name from the SFAccount buffer and the case details from the SFCase buffer based on what the AccountID is in the Record Generator step.
The below image is an output of the various cases that are linked to the AccountID with the account name showing above the cases.
