Google Ads API v6 Call failing to "change_event" report

[Rukeith Tseng]

Here is my SQL

"""

    SELECT

        change_event.resource_name,

        change_event.change_date_time,

        change_event.change_resource_type,

        change_event.change_resource_name,

        change_event.client_type,

        change_event.user_email,

        change_event.old_resource,

        change_event.new_resource,

        change_event.resource_change_operation,

        change_event.changed_fields,

        change_event.campaign,

        change_event.ad_group

    FROM change_event

    WHERE

        change_event.change_date_time <= '2020-11-19'

            AND change_event.change_date_time >= '2020-11-17'

    LIMIT 10000

"""

But I get this error

If I change Limit to 5 and the API works. The document shows that limit could be to 10000.

[Google Ads API Forum Advisor Prod]

Hi Rukeith,

Could you provide the following details via Reply privately to author option to investigate?

• customer ID
• complete request and response logs
• request ID

If the Reply privately to author option is disabled on your end, please send it on this email address instead googleadsa...@google.com.

Regards,

Abraham Williams Google Ads API Team

ref:_00D1U1174p._5004Q27v2AL:ref

[Google Ads API Forum Advisor Prod]

Hi Rukeith,

I appreciate your patience to this issue.

I received an update from the team that the issue has been fixed. You can verify it on your end and if the issue persists, please provide the following details via Reply privately to author option or send it on this email address instead googleadsa...@google.com if this option is disabled:

• customer ID
• complete request and response logs
• request ID

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q27v2AL:ref