Artisan SVG > Call Workflow (call-workflow) (flash-1)

Artisan SVG > List Helpers (list-helpers) (view-headline)

Artisan SVG > Script (script) (file-format-javascript)

Left join array of objects using 1 or more shared properties | List helper callable

Workflow

Universal

Intermediate

This is a 'Workflow' template which means that it is a single standalone workflow.

Some workflow templates can be modified to work with other workflow templates - e.g. to convert a data sync between two services from uni-directional to bi-directional

Choose "fire and wait for response" as the callable operation
Select the left join workflow
Map the left and right lists you wish to join
Specify the property names in each list you wish to join upon

Any matches will be returned in the resulting items like this:

1{
2  "response": {
3    "leftTableCount": 1,
4    "rightTableCount": 1,
5    "success": true,
6    "Message": "We successfully joined your items",
7    "result": [
8      {
9        "name": "John",
10        "sysB_id": 698896,
11        "email": "john.599686@replaceme.com",
12        "matches": [
13          {
14            "name": "John",
15            "sysA_id": 599686,
16            "email": "john.599686@replaceme.com"
17          }
18        ]
19      }
20    ]
21  }
22}

We return the matches as an array since technically speaking you could have more than 1 match from the right list for each item in the left list.