Can't get data "ChangeEvent" by using operators "!=" and "NOT IN"

[Kyotsu]

Dear Google Ads API support teams,

We want to get data of "ChangeEvent", (refer: https://developers.google.com/google-ads/api/reference/rpc/v6/ChangeEvent).

We can get the data by using operators "=" and "IN" in Picture 1 and 2.

Howerver when we get the data by using operators "!=" and "NOT IN" in the query, we got the response with error (in picture 3 and 4).

So, I have a question:

when we call api to get data of ChangeEvent, can we use the operators "!=' and "NOT IN" in WHERE clause? And why we got that error when using "!=' and "NOT IN"?

if we can not use "!=' and "NOT IN", can you please tell me which operators we should use instead?

Best Regards,

[Google Ads API Forum Advisor Prod]

Hello,

Thanks for reaching out. So we can have a closer look at this issue, can you please privately reply with a text version of your query, along with the request headers? Please ensure that your response is private. 

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2DMHsy:ref

[Kyotsu]

Hello,

Currently, We really need to get these data. Could you tell me when it will be done?

Thank you, 

[Google Ads API Forum Advisor Prod]

Hello - 

A fix for this issue has been rolled out, can you confirm whether you're still having any issues?

Thanks,
Ben, Google Ads API Team

ref:_00D1U1174p._5004Q2DMHsy:ref

[Kyotsu]

Hello, 

We still cannot get data by using "NOT IN" or "!=" operators. 

Please refer to the attached image and the query sentence below for additional information

Request-Id: Y2FzO2M4kb0mq8zqdD2cow

CURL: 

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

--header 'Authorization: Bearer ' \

--header 'developer-token: token' \

--header 'User-Agent: curl' \

--header 'Accept: application/json' \

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

--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-03-16'\'' AND '\''2021-03-22'\'' AND change_event.resource_name NOT IN ('\''customers/4818982099/changeEvents/1615949101316671~0~1'\'') ORDER BY change_event.change_date_time ASC LIMIT 10000",

"summary_row_setting":"NO_SUMMARY_ROW",

"return_total_results_count": true,

"page_token": "",

"page_size": 10000

}'

Thank you,

[Google Ads API Forum Advisor Prod]

Hello - 

Thanks for letting me know. I reopened this issue with the team so they can investigate further, I'll let you know as soon as I have more information.