0
User filter in REST API to filter Array field.
I have a table, which returns following response via REST API:
{
"City": "BORRALHA",
"Parish": "Borralha",
"CAE": [
11029,
11030
],
"Projetos Relacionados": [
10776,
12135,
13112
],
"Fontes de Dados": [
2,
161,
74332
]
}
I want to filter result and get only records where CAE is 11029. So I used this REST API: ?filters={"fields":{"CAE":11029}} but I get blank result everytime. Is there any way to filter using array fields.
1 reply
-
Use the execute script API query
select Table where testx(concat(CAE), "11029")
GET https://api.ninoxdb.de/v1/teams/:teamid/databases/:databaseid/query?query=YourEncodedQuery
Content aside
- 3 yrs agoLast active
- 1Replies
- 468Views