cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to filter json data

maisie_wang
New Contributor

Like below json structure, we want remove wd:Compensation_Element_Reference/wd:ID:@type=WID,
and just leave wd:ID:@type=Compensation_Element_ID
image

3 REPLIES 3

Supratim
Contributor III

Hi @maisie_wang , from this image itโ€™s difficult to replicate the value but you can add one mapper and
drag and drop till wd:ID and then put ?(value[โ€˜@wd:typeโ€™] == 'Compensation_Element_ID) inside that wd:ID[here]. If you still face issue please share the json.

jsonPath($, โ€œ$till Compensation_Reference.wd:ID [?(value[โ€˜@wd:typeโ€™] == 'Compensation_Element_ID)]โ€)

bojanvelevski
Valued Contributor

Hi @maisie_wang ,

Use a mapper, and map your incoming path up until โ€œ@wd:IDโ€. Than use the following expression:

$โ€ฆwd:ID.filter(x=>x.get(โ€˜@wd:typeโ€™) != โ€˜WIDโ€™)

Regards,
Bojan

winosky
New Contributor III

Hi @maisie_wang, a json parser snap and the filter path parameter in the snap might do the trick.