topic How to write a crm_objects query to match a substring? in APIs & Integrations

topic How to write a crm_objects query to match a substring? in APIs & Integrations https://community.hubspot.com/t5/APIs-Integrations/How-to-write-a-crm-objects-query-to-match-a-substring/m-p/538520#M49280 Hello,I am writing a custom module to display specific products on a page. I want to filter all my products based on a tag, in this case the `ip__shopify__tags` property. I am trying to write a query like this: {% set products = crm_objects(dynamic_page_crm_object_type_fqn, "ip__shopify__tags__contains=215","ip__shopify__tags") %} But it does not filter them, it returns all 81 of my products and I'm expecting 25.   I tried modifying the query to use "in", like this: `ip__shopify__tags__in=215` But it returned 0 products. I should note that when I remove the query param and simply request all my products I get 81 results. I know this string querying should work in principle, because it is working fine via the REST api using the CONTAINS_TOKEN operator: ``` POST <A href="https://api.hubapi.com/crm/v3/objects/products/search" target="_blank" rel="noopener">https://api.hubapi.com/crm/v3/objects/products/search</A> body:<DIV><DIV>{</DIV><DIV>  "filterGroups": [</DIV><DIV>    {</DIV><DIV>      "filters": [</DIV><DIV>        {</DIV><DIV>          "value": "215",</DIV><DIV>          "propertyName": "ip__shopify__tags",</DIV><DIV>          "operator": "CONTAINS_TOKEN"</DIV><DIV>        }</DIV><DIV>      ]</DIV><DIV>    }</DIV><DIV>  ],</DIV><DIV>  "limit": 100,</DIV><DIV>  "after": 0</DIV><DIV>} ``` The above call produces 25 results, which is what I'm expecting. For example the results look like this:</DIV><DIV> </DIV><DIV><DIV><DIV>{</DIV><DIV>    "total": 25,</DIV><DIV>    "results": [</DIV><DIV>        {</DIV><DIV>            "id": "943773526",</DIV><DIV>            "properties": {</DIV><DIV>                "createdate": "2021-01-12T18:44:52Z",</DIV><DIV>                "hs_lastmodifieddate": "2021-12-08T01:43:25.487Z",</DIV><DIV>                "hs_object_id": "943773526",</DIV><DIV>                "ip__shopify__handle": "215-dry-trimmer",</DIV><DIV>                "ip__shopify__published_at": "2021-04-19T07:21:51Z",</DIV><DIV>                "ip__shopify__tags": "215 Series, 215 trimmer, best dry trimmer, bud, bud sorter, bud trimmer, cannabis, cannabis sorter, dry trimmer, Dry Trimmers, greenbroz 215 dry trimmer, m trimmer, number one dry trimmer, top cannabis trimmer, trimmer",</DIV><DIV>                "name": "215 Dry Trimmer",</DIV><DIV>                "shopify_id": "5991330021539",</DIV><DIV>                "shopify_product_type": null,</DIV><DIV>                "shopify_slug": "215-dry-trimmer"</DIV><DIV>            },</DIV><DIV>            "createdAt": "2021-01-12T18:44:52Z",</DIV><DIV>            "updatedAt": "2021-12-08T01:43:25.487Z",</DIV><DIV>            "archived": false</DIV><DIV>        },</DIV><DIV>        .... ```</DIV><DIV> </DIV><DIV>Alternatively, is there a way to query the REST API directly from a Hubspot module, and avoid using the `crm_objects` method altogether?</DIV></DIV></DIV></DIV> Wed, 08 Dec 2021 05:08:51 GMT jplew 2021-12-08T05:08:51Z