Query report, the fields in the query condition contain double quotes, 400

[li qian]

Query the ad based on the ad group name and get the following results:

HTTP Response Code: 400

, Type: QueryError.PARSING_FAILED

Content:

__rdquery: SELECT CampaignName, AdGroupName, AdType FROM AD_PERFORMANCE_REPORT WHERE Status IN ["ENABLED", "PAUSED"] AND AdGroupName = "55" led tv" DURING LAST_7_DAYS

__fmt: CSV

I guess because the ad group name has double quotes, How should I solve him? I am using a java client

[Google Ads API Forum Advisor Prod]

Hello,

I was able to select a campaign from my account with the name 'quote"test' by using the following query:
__rdquery=select+CampaignName%2C+CampaignId+from+CAMPAIGN_PERFORMANCE_REPORT+where+CampaignName+%3D+%22quote%5C%22test%22&__fmt=CSV

From looking at the URL unescaped version of the above, it appears that you're missing a backslash in your attempt. Try manually adding a backslash before the quote in your query.

Regards,
Mike, Google Ads API Team

ref:_00D1U1174p._5001UHET6Q:ref