Hi Joeri,
Thank you for your reply.
The query that the API developers gave is as follows (redacted):
{
“WHERE”: [
{
“BvDID”: [
“”
]
}
],
“SELECT”: [
{
“NAME”: {
“AS”: “NAME”
}
},
{
“GRID_MATCH_INDICATOR”: {
“AS”: “GRID_MATCH_INDICATOR”
}
},
{
“GRID_MATCH_SANCTIONS_INDICATOR”: {
“AS”: “GRID_MATCH_SANCTIONS_INDICATOR”
}
},
{
“GRID_MATCH_WATCHLIST_INDICATOR”: {
“AS”: “GRID_MATCH_WATCHLIST_INDICATOR”
}
},
{
“CPYCONTACTS_HEADER_FirstNameOriginalLanguagePreferred”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_FirstNameOriginalLanguagePreferred”
}
},
{
“CPYCONTACTS_HEADER_LastNameOriginalLanguagePreferred”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_LastNameOriginalLanguagePreferred”
}
},
{
“CPYCONTACTS_HEADER_Gender”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_Gender”
}
},
{
“CPYCONTACTS_HEADER_Birthdate”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_Birthdate”
}
},
{
“CPYCONTACTS_MEMBERSHIP_Function”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_MEMBERSHIP_Function”
}
},
{
“CPYCONTACTS_HEADER_IdDirector”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_IdDirector”
}
},
{
“CPYCONTACTS_HEADER_BvdId”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_BvdId”
}
},
{
“CPYCONTACTS_HEADER_GRID_MATCH_INDICATOR”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_GRID_MATCH_INDICATOR”
}
},
{
“CPYCONTACTS_HEADER_GRID_MATCH_SANCTIONS_INDICATOR”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_GRID_MATCH_SANCTIONS_INDICATOR”
}
},
{
“CPYCONTACTS_HEADER_GRID_MATCH_WATCHLIST_INDICATOR”: {
“FILTERS”: [redacted]
“AS”: “CPYCONTACTS_HEADER_GRID_MATCH_WATCHLIST_INDICATOR”
}
},
{
“BO_NAME”: {
“FILTERS”: [redacted]
“AS”: “BO_NAME”
}
},
{
“BO_GRID_MATCH_INDICATOR_FORMATTED”: {
“FILTERS”: [redacted]
“AS”: “BO_GRID_MATCH_INDICATOR_FORMATTED”
}
},
{
“BO_GRID_MATCH_SANCTIONS_INDICATOR_FORMATTED”: {
“FILTERS”: [redacted]
“AS”: “BO_GRID_MATCH_SANCTIONS_INDICATOR_FORMATTED”
}
},
{
“BO_GRID_MATCH_WATCHLIST_INDICATOR_FORMATTED”: {
“FILTERS”: [redacted]
“AS”: “BO_GRID_MATCH_WATCHLIST_INDICATOR_FORMATTED”
}
}
]
}
As you can see, it is already very long even with the actual filters redacted. What I want to show with this is that they use ‘where’, ‘select’ and ‘filter’ queries, and I do not know how to put that into a data definition.