call-workflow
script

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

universalIntermediate
  1. Choose "fire and wait for response" as the callable operation
  2. Select the left join workflow
  3. Map the left and right lists you wish to join
  4. Specify the property names in each list you wish to join upon Left join list setup demo Any matches will be returned in the resulting items like this:
{
  "response": {
    "leftTableCount": 1,
    "rightTableCount": 1,
    "success": true,
    "Message": "We successfully joined your items",
    "result": [
      {
        "name": "John",
        "sysB_id": 698896,
        "email": "john.599686@replaceme.com",
        "matches": [
          \{
            "name": "John",
            "sysA_id": 599686,
            "email": "john.599686@replaceme.com"
          \}
        ]
      }
    ]
  }
}

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.