Filter values Asana-HubSpot. Arrays?

Getting Started
, , ,
1

Hello there! I am new in this world and need some help.

I am trying to do something very simple, translate deals from HubSpot to Asana. I have the following nodes.

  1. Asana - List Tasks
  2. HubSpot - Get Deals
  3. HubSpot - Get Owners
  4. Router
    4.1) Create Task
    4.2) Update Task

image
image1538×879 54 KB

I have problems with the filter. Obviously, I want to update the existing tasks and create the tasks if they doesn’t exist in Asana.

The filter I’m using for the ‘Update’ Option is the follow one:

image
image434×527 26.6 KB

It compares the ID from HubSpot to the ID in Asana (Each task in asana contains a field named ‘HubSpot ID’ with the ID of the Deal in HubSpot). This works well.

The problem relays on the other option. I cannot make it work, I have tried several filters.
If I choose this:

image
image452×532 25.6 KB

The problem is that the filter compares:
value A from node 1 against Value A,B,C,D,E from node 2.
Value B from node 1 against Value A,B,C,D,E from node 2.

This ends with multiple and duplicated tasks. (ex: 1 correct, 4 wrong → 4 task created)

I have tried using Arrays, Setting Variables, but it doesn’t seems to work.
Anyone would help me? thanks in advance!

2

Hi @Bruno_Alarcon,

I believe the simplest solution is to designate the second route as a fallback. This way, Make will automatically select it if no other route is matched.

Hope this helps.

3

I’ve tried that option, but it keeps creating duplicated registries.

This happens because each ID from HubSpot is compared with ALL the IDs from Asana. So, if I have 10 IDs in Asana, the filter will run 10 times. If the task exist, 9/10 will fail, leading to 9 registries going to the fallback route.