I recently noticed that Subscribers are retrieving more records than it should and after some investigation, I found out that it's doing the wrong query. It's doing lastModified Between last_record - 1 day and last_record and should be lastModified Between last_record and last_record + 1day
{
"bookmarks": {
"list_subscriber": {
"last_record": "2021-01-27T12:04:00Z",
"field": "ModifiedDate"
}
}
}
2021-01-27 18:19:24,859Z tap - INFO Making RETRIEVE call to 'ListSubscriber' endpoint with filters '{'LogicalOperator': 'AND', 'RightOperand': {'SimpleOperator': 'between', 'Value': ['2021-01-26T12:04:00Z', '2021-01-27T12:04:00Z'], 'Property': 'ModifiedDate'}, 'LeftOperand': {'SimpleOperator': 'equals', 'Value': 136, 'Property': 'ListID'}}'.
I recently noticed that Subscribers are retrieving more records than it should and after some investigation, I found out that it's doing the wrong query. It's doing
lastModified Between last_record - 1 day and last_recordand should belastModified Between last_record and last_record + 1day{ "bookmarks": { "list_subscriber": { "last_record": "2021-01-27T12:04:00Z", "field": "ModifiedDate" } } }