How to select select properties of a API JSON response

Hello,

I have an API returning over 50 properties and 1000s of entries (records), I want to narrow down the reponse to 3 properties for all entries.

I saw a video that allows you to select one property as a path filter in the response part of XANO. Is it possible to select 3 properties together?


Lets say i only want properties A,B,D out of A,B,C,D in the following:

[
{ 'A' : '1',
'B' : '2',
'C':'3',
'D': '4'
},
{ 'A' : '3',
'B' : '3',
'C':'4',
'D': '6'
},
{'A':..
}
]

The output variable should thus be:

{ 'A' : '1',
'B' : '2',
'D':'4'
},
{ 'A' : '3',
'B' : '3',
'D':'6',
},
{'A':..
}
Working with APIs
9 replies