Filtering outbound contactlist

Platform API
1

We are running into the following problem when using the API calls below where we want to filter on a contactlist of 990000 contacts.
If we use the filter below on the system column callRecords.Phone01.lastAttempt then it crashes and gives a timeout.
If we change the filter to a custom column, BatchDate, then the filter works fine.

Both columns are of the string type and the format of the data is the same.
If we use the filter on a small contact list, then it is possible to filter on the system column.

APIcalls:
post
/api/v2/outbound/contactlists/{contactListId}/contacts/search
post
/api/v2/outbound/contactlists/{contactListId}/export

Used filter:

filter:
{
"contactListFilterId": "",
"criteria": {
"clauses": [
{
"predicates": [
{
"column": "callRecords.Phone01.lastAttempt",
"columnType": "alphabetic",
"operator": "BEGINS_WITH",
"value": "2025-01-08T11:3"

      }
    ]
  }
]

},
"pageNumber": 1,
"pageSize": 25
}

Does anyone know the solution for this?

2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.