agroenendijk | 2025-01-08 16:06:15 UTC | #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?
system | 2025-02-07 16:06:25 UTC | #2
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
This post was migrated from the old Developer Forum.
ref: 31100