Change event service issue fetching more than 10k rows

[Arshdeep Singh Bhargav]

Hi there,
Found a workaround to fetch change_events for LIMIT more than 10000, suggested by this doc from Google 

which states,

The query must also include a LIMIT clause restricting results to at most 10,000 rows. If you're interested in more than 10,000 results, make a note of the timestamp of the last entry in the returned result set, and then set your date range on the following query to start after that time to continue where you left off.

But the `change_date_time` property of `change_event` returned by ChangeEventService does have same value for multiple entries in the result set. In such case, how does the suggested step (to start after that time to continue where you left off ) apply?

[Google Ads API Forum Advisor]

Hi Arshdeep,

Thank you for reaching out to Google Ads API with your change event issue. I reproduced the issue and raised a request with my team to create a method for returning all results when more than 10,000 change events occur in a split second. You may monitor our blog for an update.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2NTe5S:ref

[Arshdeep Singh Bhargav]

Hey thanks for the update, looking forward for an update on the request soon.

Best,

Arsh

[Arshdeep Singh Bhargav]

Just so you are aware, a similar constraint is on ChangeStatusService ,and I could repro the same issue while querying for change_status.

[Google Ads API Forum Advisor]

Hi Arshdeep,

Thank you for the reply.

Allow me to raise it also to my team about the change_status report type. For now, please follow our blog as we will post there relevant updates.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q2NTe5S:ref