Lookup supplemental data on any record in Boomi

Owned by Lara Juenger
Last updated: Sept 10, 2023
3 min read

A common step when building integrations is to have a set of data and need to add some more attributes to that data. At UConn you might have a list of netids and need to find the name or email associated with that netids. There are many different strategies for combining data like this. An effective real-time mechanism described below is to use a connector in a map.

 Instructions for Lookup with a Connector in a Map

We will take a message shape that contains a list of netids for a small team at UConn and map it to a list that contains the netids with their first and last names added via a connector in a map.

 

  1. Start with a No Data start shape and connect a message shape that has a list of netids

  2. Use an existing connection that queries the table with the lookup values or create a new Operation that uses a default Get on the Names table like what is shown here. This does NOT need to be connected to anything else in the process.

  3. Create two simple flat file profiles. One contains just the netid element and one contains netid, firstname, lastname.

  4. Create a new map. Choose the Just Netid FF profile on the left. Choose the Combined Netid with Name FF Profile on the right. In the functions section in the middle of the map click the plus in the green circle and add a connector call using the operation from step 2. Set the netid to an input and the first_name and last_name as outputs

  5. Click and drag netid as the input to the connector call. Also click and drag the netid to the netid in the target profile. From the output of the function, drag last_name to last_name in the target profile and first_name to first_name.

  6. Click Save and Close in the map and add a Stop shape to the process.

Time to Test!

How to Test

  1. Click Test in the upper right corner of the process pallet.

  2. Pick the Test Atom Cloud (TAC) available in your subaccount and click OK. An example shown here is the generic Test-Atom-Cloud for the mail UConn account.

  3. The process will execute in test mode, and you will see each step get a green halo as it completes successfully. You will see a success message when it is done

  4. Click on the Stop shape when the green halo surrounds it. On the Shape Source Data tab click View Source on the document to confirm the lookup is successful:

 Related articles