I want to create a “List of items(lookup)” Entity based on the values stored in another web service.
The web service has an API to GET these values, so I am using the Remote List function.
Unfortunately the API returns values that I don’t want to use as an item, and was wondering if there was a way to filter the API response before assigning it to the list.
This is an idea of what I want to do.
API Response
{response :
{categories :
{“id”: 1, “name”: “aaa”, “deleteFlag”: 0},
{“id”: 2, “name”: “bbb”, “deleteFlag”: 1},
{“id”: 3, “name”: “ccc”, “deleteFlag”: 0},
{“id”: 4, “name”: “ddd”, “deleteFlag”: 0}
}
}
Entity List (I want to filter out the item where the deleteFlag is 1)
ValueKey: 1, Display Name Key: aaa
ValueKey: 3, Display Name Key: ccc
ValueKey: 4, Display Name Key: ddd