How to escape single quotes in Google Ads API query language?

[Exos Solutions]

Hi everyone,

I am sending a query with the Google Ads API, in which I search for a product_brand that has single quotes and it returns the BAD_VALUE error.

This is the query that I send and the error that it returns: 

Request

-------

MethodName: google.ads.googleads.v5.services.GoogleAdsService/SearchStream

Endpoint: googleads.googleapis.com:443

Headers: {developer-token=REDACTED, login-customer-id=xxx, x-goog-api-client=gl-java/11.0.3 gapic/ gax/1.57.0 grpc/1.30.0}

Body: customer_id: "xxx"

query: "SELECT ad_group.id, campaign.id, shopping_performance_view.resource_name,  metrics.impressions, metrics.clicks, metrics.cost_micros, metrics.average_cpc,   metrics.conversions_from_interactions_rate, metrics.cost_per_all_conversions,   metrics.search_click_share, metrics.search_impression_share,   metrics.all_conversions, metrics.conversions,   segments.ad_network_type,   segments.product_brand,   segments.product_item_id, segments.product_merchant_id,   segments.product_type_l1, segments.product_type_l2, segments.product_type_l3,   segments.product_type_l4, segments.product_type_l5  FROM shopping_performance_view   WHERE segments.product_brand = \'joe\'s\'  and segments.date BETWEEN \'2020-11-13\' AND \'2020-12-02\'"

Response

--------

Headers: Metadata(content-type=application/grpc,request-id=0kZ5xU1wAU2rTjFt-9cHgg,date=Thu, 10 Dec 2020 07:36:29 GMT,alt-svc=h3-29=":443"; ma=2592000,h3-T051=":443"; ma=2592000,h3-Q050=":443"; ma=2592000,h3-Q046=":443"; ma=2592000,h3-Q043=":443"; ma=2592000,quic=":443"; ma=2592000; v="46,43")

Body: null

Failure message: errors {

  error_code {

    query_error: BAD_VALUE

  }

  message: "Error in WHERE clause: invalid value \'."

}

Status: Status{code=INVALID_ARGUMENT, description=Request contains an invalid argument., cause=null}.

How can I escape joe's single quote? 

Thanks and regards,

Gloria Muñoz.

[Google Ads API Forum Advisor Prod]

Hello,

Thank you for reaching out. Can you please modify the query so that outer single quotes are not escaped and retry the call?

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

 

ref:_00D1U1174p._5004Q28otkR:ref