Illustrated below is an example of a flow where a Record Generator is used as the source step and the Buffer Lookup step is used to reference the data that is in the Record Generator step.
The page below shows an example of the data stored in the buffer.
The image below shows partial data that is stored in a buffer, and one field is referenced in the Record Generator source step.
Using a Buffer Lookup Mapper Step
To add a source step:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for the Buffer Lookup Mapper step.
Configuring the Buffer Lookup Mapper Step
Illustrated in the below image is the configuration that is available in the Buffer Lookup Mapper step.
Buffer ID – The source Buffer that is used to retrieve data from in the flow. Click the dropdown to select a Buffer.
Lookup Type – Type of lookup to perform. The options available are ID, Query, or Cache.
The Query lookup type has been selected in this example. The field on the left ( “FirstName” ) refers to the field that is in the buffer. The equal to ( = ) operator is selected and on the right field, @record.Name is used to reference the field that is in the current dataset in the flow.
The link below provides more information on the different Lookup Types:
Fields – Fields to be selected. Leave blank to select all fields.
Mappings – Mappings from the lookup object to the record object.
Add a field by clicking on the highlighted icon and populate the To Field with a field name (e.g. BufferLookup in this example). All lookup steps have to be mapped to a new field to reference the required data in a new object.
On Not Found – Action to be taken if data is not found. The options available are Error, Null, Discard, or Skip.
Enable Caching Checkbox – Cache results so that they are only fetched once for a specific ID when checked.
Illustrated below is the output results where the source data is returned with the created “BufferLookup” object that references the data from the buffer.
