Routing Duplicates Bundles

Hello Make Community,

I’m currently working on a scenario where I need to identify and handle duplicate bundles based on a custom field in the Zendesk watch organization module. My goal is to:

  1. Detect duplicates within the incoming bundles from Zendesk.
  2. Route the duplicates bundles to an Excel spreadsheet for reporting purposes.
  3. Allow only unique bundles to continue with the rest of the flow.

I have tried using a Set multiple variables, but it is still not working.

Could you please advise on the best way to:

  • Detect duplicates within the flow
  • Effectively route duplicates and unique bundles using filters or routers?

Any tips, expressions, or best practices would be greatly appreciated!

Thank you in advance!

Example Output from Zendesk Watch Organizations:

[
    {
        "id": 1,
        "name": "Test Org 1",
        ],
        "organization_fields": {
            "external_system_id": "123"
        },
        "result_type": "organization"
    },
    {
        "id": 2,
        "name": "Test Org 2",
        ],
        "organization_fields": {
            "external_system_id": "123"
        },
        "result_type": "organization"
    },
    {
        "id": 3,
        "name": "Test Org 3",
        ],
        "organization_fields": {
            "external_system_id": "456"
        },
        "result_type": "organization"
    }
]