FILTER_HAS_TOO_MANY_VALUES error when making searchstream request

[Anand]

Hi Google Ads API Support team,

We saw the following error when making a search stream request. Our request had 1500 Campaign ids in the filter whereas the official documentation says the limit is 20000. Can you please help check?

API Limits and Quotas  |  Google Ads API  |  Google for Developers

"When making a GAQL query, the maximum number of items within an IN clause is 20,000. If you exceed that limit, a FILTER_HAS_TOO_MANY_VALUES error is returned."

{
  "StatusCode": 3,
  "Details": "Request contains an invalid argument.",
  "RequestId": "KXtCCvdQaLMrLcpXglIURQ",
  "Failure": {
    "errors": [
      {
        "errorCode": {
          "queryError": "FILTER_HAS_TOO_MANY_VALUES"
        },
        "message": "The number of values (right-hand-side operands) in a filter exceeds the limit."
      }
    ],
    "requestId": "KXtCCvdQaLMrLcpXglIURQ"
  }

GAQL:

SELECT campaign.id, campaign.status, campaign.shopping_setting.merchant_id, campaign.performance_max_upgrade.pre_upgrade_campaign
FROM campaign
WHERE campaign.id IN (...)  //1500 campaign Ids
AND campaign.status IN ('ENABLED', 'PAUSED', 'REMOVED')
AND campaign.advertising_channel_type = 'PERFORMANCE_MAX'

Thanks,

Anand

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to Google Ads API Forum.

I understand that you have encountered a FILTER_HAS_TOO_MANY_VALUES query error even though you did not exceed the limit. With this, could you provide us with the complete request and response logs with the request ID and request header generated on your end showing the error? This is so we could further check on our end and provide more appropriate guidance.

You may then send the requested information privately via the Reply to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Reference Links:

• request - https://developers.google.com/google-ads/api/docs/concepts/field-service#request
• response - https://developers.google.com/google-ads/api/docs/concepts/field-service#response
• request ID - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id
• request header - https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers 

This message is in relation to case "ref:_00D1U1174p._5004Q2msIbh:ref"

Thanks,
 

Google Ads API Team