How to select select properties of a API JSON response
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