Filter json that contains data of an array

I am following this tutorial to filter data on json https://support.klipfolio.com/hc/en-us/articles/215547118-About-JSON-and-XML-data-sources?query=JSON

But I didn't find out how I filter data that is contained in an array.

For example:

ARRAY = SELECT(ID; DEALERSHIP_GROUP_ID;=$ncm__dealership_group_id)

To get all dealerships ID that belongs to a group XPTO.

I need now to filter the json to get only the data where @/data/url_variables/dealership/value; is contained on the array above.

How do I do that please?

1 comment

  • 0
    Meggan King


    If you are trying to check an array of values, you can use the function IN https://support.klipfolio.com/hc/en-us/articles/360011416893-Klipfolio-functions#IN


    It would be something like: IN(ARRAY,@/data/url_variables/dealership/value;) and that would return a TRUE or FALSE.


    We'd be happy to investigate more specifically, if you'd like to contact the support team. 



Please sign in to leave a comment.