Element Connect - Root element, filtering

Joel Batac

HI,

 First time EC user here . How do I filter my json file? I only want to display in my jira if it is in approved status 

 

{
"data": {
"iterateIP": {
"IP": [
{
"name": "ACME Corp",
"shortId": "12345",
"state": {
"id": "approved"
}
},
{
"name": "WACO 123",
"shortId": "abcd3",
"state": {
"id": "cancelled"
}
},

{
"name": "Mickey Mouse Inc",
"shortId": "000314",
"state": {
"id": "open"
}
}
]
}
}
}

I tried this but not working

 

$.data.iterateIP.IP.*[?(@.id=="approved")]

 

@Julie d_Antin _Elements_ 

 

Sebastian Krzewiński

Hi @Joel Batac 

 

Can you share whole configuration of EC field? It will be easier to investigate this.

IMHO you should use $.data.iterateIP.IP[?(@.id=="approved")] but as I said - it will be better when you will share field config (can be a screenshot)

 

Regards,

Seba