Status code 500 when getting Change Event Data

[Kyotsu]

Dear Google Ads API support teams,
We want to get data of "ChangeEvent", (refer: https://developers.google.com/google-ads/api/reference/rpc/v7/ChangeEvent).

Our request:
curl --location --request POST 'https://googleads.googleapis.com/v7/customers/2638051072/googleAds:search' \
--header 'Authorization: Bearer access_token' \
--header 'developer-token: developer_token' \
--header 'User-Agent: curl' \
--header 'Accept: application/json' \
--header 'login-customer-id: login_customer_id' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "SELECT customer.id,customer.descriptive_name,customer.time_zone,change_event.ad_group,change_event.campaign,change_event.change_date_time,change_event.change_resource_name,change_event.change_resource_type,change_event.changed_fields,change_event.client_type,change_event.feed,change_event.feed_item,change_event.new_resource,change_event.old_resource,change_event.resource_change_operation,change_event.resource_name,change_event.user_email FROM change_event WHERE change_event.change_date_time BETWEEN '\''2021-07-13'\'' AND '\''2021-07-14 00:00:00.000000'\'' ORDER BY change_event.change_date_time ASC LIMIT 10000",
"page_token": "",
"return_total_results_count" : true,
"summary_row_setting": "NO_SUMMARY_ROW"
}'

When we send the request:(Request-Id: 2B8LCQUxDbuLzCsd04jwQQ) to Google Ads API as cURL above, we got the following error:
{
"error": {
"code": 500,
"message": "Internal error encountered.",
"status": "INTERNAL",
"details": [
{
"@type": "type.googleapis.com/google.ads.googleads.v7.errors.GoogleAdsFailure",
"errors": [
{
"errorCode": {
"internalError": "INTERNAL_ERROR"
},
"message": "An internal error has occurred."
}
],
"requestId": "2B8LCQUxDbuLzCsd04jwQQ"
}
]
}
}

Howerver when we try to get the data by using this condition "change_event.change_date_time BETWEEN '2021-07-14' AND '2021-07-15 00:00:00.000000'", we got the success response.

For example:
Our request:
curl --location --request POST 'https://googleads.googleapis.com/v7/customers/2638051072/googleAds:search' \
--header 'Authorization: Bearer access_token' \
--header 'developer-token: developer_token' \
--header 'User-Agent: curl' \
--header 'Accept: application/json' \
--header 'login-customer-id: login_customer_id' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "SELECT customer.id,customer.descriptive_name,customer.time_zone,change_event.ad_group,change_event.campaign,change_event.change_date_time,change_event.change_resource_name,change_event.change_resource_type,change_event.changed_fields,change_event.client_type,change_event.feed,change_event.feed_item,change_event.new_resource,change_event.old_resource,change_event.resource_change_operation,change_event.resource_name,change_event.user_email FROM change_event WHERE change_event.change_date_time BETWEEN '\''2021-07-14'\'' AND '\''2021-07-15 00:00:00.000000'\'' ORDER BY change_event.change_date_time ASC LIMIT 10000",
"page_token": "",
"return_total_results_count" : true,
"summary_row_setting": "NO_SUMMARY_ROW"
}'

Response of the above request (Request-Id: axk8qhwTNuJ-dtI6cvE_3g):
{
"fieldMask": "customer.id,customer.descriptiveName,customer.timeZone,changeEvent.adGroup,changeEvent.campaign,changeEvent.changeDateTime,changeEvent.changeResourceName,changeEvent.changeResourceType,changeEvent.changedFields,changeEvent.clientType,changeEvent.feed,changeEvent.feedItem,changeEvent.newResource,changeEvent.oldResource,changeEvent.resourceChangeOperation,changeEvent.resourceName,changeEvent.userEmail"
}

Can you please check your system and tell me why we got that problem?
In case we used the wrong request, what can we do to avoid the same error?

Best Regards,

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out and providing your request and response. I see that you are using version 7 of the API in your request. As this v7 is now deprecated, with v8 as the current version, can you please retry your request with the current version and let us know if the issue persists?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2KcQr5:ref

[Kyotsu]

Hello, 

When we retry our request with the current version(v8), we still having the same error.

Please refer to the request below for additional information

Our request: 

curl --location --request POST 'https://googleads.googleapis.com/v8/customers/5034684848/googleAds:search' \

--header 'Authorization: Bearer access_token' \

--header 'developer-token: developer_token' \

--header 'User-Agent: curl' \

--header 'Accept: application/json' \

--header 'login-customer-id: login_customer_id' \

--header 'Content-Type: application/json' \

--data-raw '{

    "query": "SELECT customer.id,customer.descriptive_name,customer.time_zone,change_event.ad_group,change_event.campaign,change_event.change_date_time,change_event.change_resource_name,change_event.change_resource_type,change_event.changed_fields,change_event.client_type,change_event.feed,change_event.feed_item,change_event.new_resource,change_event.old_resource,change_event.resource_change_operation,change_event.resource_name,change_event.user_email FROM change_event WHERE change_event.change_date_time BETWEEN '\''2021-07-21'\'' AND '\''2021-07-22 00:00:00.000000'\'' ORDER BY change_event.change_date_time ASC LIMIT 10000",

    "page_token": "",

    "return_total_results_count" : true,

"summary_row_setting": "NO_SUMMARY_ROW"

}'

Response (Request-Id: 2a7pJLXQheS59GbwBtGbcg):

{

    "error": {

        "code": 500,

        "message": "Internal error encountered.",

        "status": "INTERNAL",

        "details": [

            {

                "@type": "type.googleapis.com/google.ads.googleads.v8.errors.GoogleAdsFailure",

                "errors": [

                    {

                        "errorCode": {

                            "internalError": "INTERNAL_ERROR"

                        },

                        "message": "An internal error has occurred."

                    }

                ],

                "requestId": "2a7pJLXQheS59GbwBtGbcg"

            }

        ]

    }

}

Can you please check your system again with our new information?

Thank,

[Google Ads API Forum Advisor]

Hi Kyotsu,

I work with Mat and will assist you. Thank you for the update, I raised this with my team. We will get back to you as soon as possible.

Regards,

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2KcQr5:ref

[Kyotsu, Project]

We've been getting the aforementioned issue a lot lately, even though we've tried using API v9. This data type is desperately needed. Please check the system and respond to us as soon as possible.
Below is information about our most recent error request

curl --location --request POST 'https://googleads.googleapis.com/v9/customers/5298320797/googleAds:search' \

--header 'Authorization: Bearer access_token' \
--header 'developer-token: developer_token' \
--header 'User-Agent: curl' \
--header 'Accept: application/json' \
--header 'login-customer-id: login_customer_id' \
--header 'Content-Type: application/json' \
--data-raw '
{

  "query": "SELECT customer.id,customer.descriptive_name,customer.time_zone,change_event.ad_group,change_event.campaign,change_event.change_date_time,change_event.change_resource_name,change_event.change_resource_type,change_event.changed_fields,change_event.client_type,change_event.feed,change_event.feed_item,change_event.new_resource,change_event.old_resource,change_event.resource_change_operation,change_event.resource_name,change_event.user_email FROM change_event WHERE change_event.change_date_time BETWEEN '\''2021-12-16'\'' AND '\''2021-12-17'\'' LIMIT 10000",
  "return_total_results_count": true,
  "page_token": "",
  "page_size": 10000
}'

Response (Request-Id: VWih4meEEGWPjgUXbyeUJg):

{
    "error": {
        "code": 500,
        "message": "Internal error encountered.",
        "status": "INTERNAL",
        "details": [
            {

                "@type": "type.googleapis.com/google.ads.googleads.v9.errors.GoogleAdsFailure",
                "requestId": "VWih4meEEGWPjgUXbyeUJg"
            }
        ]
    }
}

 Thank,

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/KC1qMGrINQ0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/zblwL000000000000000000000000000000000000000000000QWPTLU00H1HF_AoAQ2OCye5skcjVyA%40sfdc.net.

-----------------------------------------------------------------------------------------
もし、このメッセージが誤って貴殿に送信されたと思われる場合には、
機密情報を含んでいる可能性もありますので、どなたにも転送せず、
付属したファイルも含めて削除していただくとともに、発信者にその旨を
お伝えいただきますようお願いいたします。
This email may be confidential or privileged.
If you received this communication
by mistake, please don't forward it to anyone else,
please erase all copies and documents,
and please let me know that it went to the wrong person.
Thank you very much.
-----------------------------------------------------------------------------------------

[Google Ads API Forum Advisor]

Hi,

For some reason I can't seem to find the request with ID VWih4meEEGWPjgUXbyeUJg in our logs, and I was able to successfully execute your query on some other accounts. Do you have other request IDs you could share? Also, are you seeing this across all of the accounts you query, or just specific customer IDs?

Thanks,
Josh, Google Ads API Team

ref:_00D1U1174p._5004Q2KcQr5:ref

[Kyotsu, Project]

We've tried again with a new request, please double-check the request-id as stated below. We can confirm that the Google Ads API returned the request-id below.

Our request: 

curl --location --request POST 'https://googleads.googleapis.com/v9/customers/1606637017/googleAds:search' \

--header 'Authorization: Bearer access_token' \

--header 'developer-token: developer_token' \

--header 'User-Agent: curl' \

--header 'Accept: application/json' \

--header 'login-customer-id: login_customer_id' \

--header 'Content-Type: application/json' \

--data-raw '

{

  "query": "SELECT customer.id,customer.descriptive_name, customer.time_zone, change_event.ad_group,change_event.campaign,change_event.change_date_time,change_event.change_resource_name,change_event.change_resource_type,change_event.changed_fields,change_event.client_type,change_event.feed,change_event.feed_item,change_event.new_resource,change_event.old_resource,change_event.resource_change_operation,change_event.resource_name,change_event.user_email FROM change_event WHERE change_event.change_date_time BETWEEN '\''2021-12-21'\'' AND '\''2021-12-22'\'' LIMIT 10000",

  "return_total_results_count": true,

  "page_token": "",

  "page_size": 10000

}'

Response (Request-Id: v-JwndrbfBit2xwUmQVHqg):

{

    "error": {

        "code": 500,

        "message": "Internal error encountered.",

        "status": "INTERNAL",

        "details": [

            {

                "@type": "type.googleapis.com/google.ads.googleads.v9.errors.GoogleAdsFailure",

                "requestId": "v-JwndrbfBit2xwUmQVHqg"

            }

        ]

    }

}

We also tried requesting with different customer IDs and got the same result "success".

We also check to request with the above customer ID (1606637017), however, the query with the same change_date_time range (2021-12-21 AND 2021-12-22) returns an error, yet querying with a different change_date_time range returns a success.

Thanks,