Change_status query not working with date time range values

[Saurabh Suman]

Hi Team,

     We  tried with below  query for getting the change_status details with date time value but its error  for invalid input. After removing time and only using the date format in query it worked fine. Is date time format not supported in Ads API queries.

Query with date time:

SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_status, change_status.resource_type, change_status.ad_group, change_status.ad_group_ad, change_status.ad_group_bid_modifier, change_status.ad_group_criterion, change_status.ad_group_feed, change_status.campaign, change_status.campaign_criterion, change_status.campaign_feed, change_status.feed, change_status.feed_item FROM change_status WHERE change_status.last_change_date_time > '2022-03-25 194638' and change_status.last_change_date_time <= '2022-03-28 123559' AND campaign.id  =1537459886 ORDER BY change_status.last_change_date_time LIMIT 10000

Response: 

com.google.ads.googleads.v9.errors.GoogleAdsException: errors {
  error_code {
    query_error: UNEXPECTED_INPUT
  }
  message: "Error in query: unexpected input -."
}
request_id: "fRM5omwHChhmFchJs4_zHw"

Query with Date:

SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_status, change_status.resource_type, change_status.ad_group, change_status.ad_group_ad, change_status.ad_group_bid_modifier, change_status.ad_group_criterion, change_status.ad_group_feed, change_status.campaign, change_status.campaign_criterion, change_status.campaign_feed, change_status.feed, change_status.feed_item FROM change_status WHERE change_status.last_change_date_time >= '2022-03-25' and change_status.last_change_date_time <= '2022-03-28' AND campaign.id  =1537460285 ORDER BY change_status.last_change_date_time LIMIT 10000

[Google Ads API Forum Advisor]

Hi Saurabh,

I was able to run without errors the following query in REST:

--data '{
"query": "
SELECT change_status.shared_set, change_status.resource_type, change_status.resource_status, change_status.resource_name, change_status.last_change_date_time, change_status.feed_item, change_status.feed, change_status.customer_asset, change_status.campaign_shared_set, change_status.campaign_feed, change_status.campaign_criterion, change_status.campaign_asset, change_status.campaign, change_status.asset, change_status.ad_group_feed, change_status.ad_group_criterion, change_status.ad_group_bid_modifier, change_status.ad_group_asset, change_status.ad_group_ad, change_status.ad_group FROM change_status WHERE change_status.last_change_date_time DURING LAST_MONTH AND change_status.last_change_date_time = '\''2022-02-28 14:22:54.272471'\'' LIMIT 10000", "returnTotalResultsCount": true}'


Feel free to get back to us.

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2YsQ5v:ref