JSONPath filtering in Transformation 2.0

Integrator.io
, , , ,
1

Does Celigo support JSONPath filtering in Mapper/Transformation 2.0? For the below data array I would like to get only the quantity of hats, using jsonpath filtering this would be

$.items[?(@.type=='Hat')].qty

This works on JSONPath.com, but in Celigo I get the error ' Eval [?(expr)] prevented in JSONPath expression.', which leads me to believe this is being blocked.

{
    "items": [{
            "type": "Hat",
            "qty": 3
        }, {
            "type": "Shoes",
            "qty": 1
        }
    ]
}

5301043caa20740200000001-1d6b0854b5044fd4aec236f815a5578c.png
5301043caa20740200000001-1d6b0854b5044fd4aec236f815a5578c.png678×148 2.59 KB

2

@basvanditzhuijzen Celigo doesn't support filtering using JSONPath expressions at this time.

3

Thx, I've submitted a request to the product portal to have this added.

4

Thank you! we will take your valuable inputs into consideration for future releases.