String operator for "does not contain"?

[LK165]

Hi there, I'm new to using HubSpot Api and thought I would reach out for some help. I am writing a script to create a contact list using the API and I have a specific property (string type) which needs to be included in the filter criter such as :

{ "operator": "xxxxx",//xxxx needs replacing with appropriate operator
"filterFamily":"PropertyValue",
"property": "mypropertyname",

"type": "string",
"value":"ab;ac;abc;10;11"};

where the opertaor needed is the opposite of "CONTAINS" - equivalent to the SET_NOT_ALL operator, but for string values. Essentially if my property contains values such as:

xx_ab_aa

x_ac_ac

xx_aa_10 

xx_xa_6

xx_ya_1

then  only contacts with property values xx_xa_6 and xx_ya_1  should meet the criteria. 

The error that showed when I tried SET_NOT_ALL is :

"status":"error","message":"Operator SET_ANY is not valid for this property type string.

TIA

[IsaacTakushi · Accepted solution]

Welcome, @LK165.

Thanks for reaching out. I'm happy to help.

It sounds like the DOESNT_CONTAIN operator may serve your purpose:

"filters": [
  [
    {
      "operator": "DOESNT_CONTAIN",
      "filterFamily": "PropertyValue",
      "property": "mypropertyname",
      "type": "string",
      "value": "ab;ac;abc;10;11"
    }
  ]
]

 I created a simple active list in-app using the "doesn't contain any of" filter and then retreived the filter definitions with this endpoint.

[LK165]

Thank you! It worked.