Single quote in campaign name

[teamvadw...@gmail.com]

Hi,   

     Here we facing issue ({{ "errorCode": { "queryError": "BAD_VALUE" }, "message": "Error in WHERE clause: invalid value '." }}) with below query which having single quote in campaign name. Please suggest for any work arounds

 

SELECT

metrics.cost_micros,

campaign.status,

metrics.search_impression_share,

metrics.search_absolute_top_impression_share,

metrics.search_budget_lost_impression_share,

metrics.search_rank_lost_impression_share,

metrics.average_cpc,

campaign.name,

campaign.id

FROM

campaign

WHERE

campaign.status IN ('ENABLED','PAUSED')

AND campaign.name IN ('Marine's Day Video')

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out.

You may try following the below examples :

If you're using single quotes ('), you would need an escape character (\) same as below :

WHERE
campaign.status IN ('ENABLED','PAUSED')
AND campaign.name IN ('Marine\'s Day Video')

However, when using double quotes ("), no need to include an escape character. See below :

WHERE
campaign.status IN ('ENABLED','PAUSED')
AND campaign.name IN ("Marine's Day Video")

Let me know if this helps.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2CR39Y:ref

[Jobin Joy]

Hi Peter,
I tried adding a \ symbol for preceding a single quotes but I am getting response as below,
{
    "error": {
        "code": 400,
        "message": "Request contains an invalid argument.",
        "status": "INVALID_ARGUMENT",
        "details": [
            {
                "@type": "type.googleapis.com/google.ads.googleads.v14.errors.GoogleAdsFailure",
                "errors": [
                    {

                        "errorCode": {
                            "queryError": "BAD_VALUE"
                        },
                        "message": "Error in WHERE clause: invalid value '."
                    }

                ],
                "requestId": "xxxxx"
            }
        ]
    }
}

Request as follows,
{"pageSize": 10000,"query": "SELECT ad_group_criterion.keyword.text,
  campaign.name,
  ad_group.name
FROM keyword_view
WHERE ad_group_criterion.keyword.text IN ('Marine\'s Day Video','Video')"}

Could you kindly help me on this to pass single quotes in where condition? Thanks in advance