JSONPath filtering in Transformation 2.0

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
        }
    ]
}

 

2

Comments

3 comments
Date Votes
  • Bas van Ditzhuijzen Celigo doesn't support filtering using JSONPath expressions at this time. 

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

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

    0

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post