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
Bas van Ditzhuijzen Celigo doesn't support filtering using JSONPath expressions at this time.
Thx, I've submitted a request to the product portal to have this added.
Thank you! we will take your valuable inputs into consideration for future releases.
Please sign in to leave a comment.