Data retrieval from "ad" entity

12 views
Skip to first unread message

Hryhorii Bystrychenko

unread,
Jul 5, 2024, 6:39:06 AM (yesterday) Jul 5
to Google Ads API and AdWords API Forum
Hey Team,


May I ask you for support about Ad level data extraction? I have following GAQL:
SELECT ad.resource_name, ad.name FROM ad limit 10
just for testing purposes and when I am running the workflow to get any data I see following:
[2024-07-05 09:22:22,647 - INFO] Received command c on object id p0 2024-07-05 09:22:22,653 - google_ads_source - DEBUG - Writing table 2024-07-05 09:22:22,654 - google_ads_source - DEBUG - Getting DataFrame for table [2024-07-05 09:22:22,916 - INFO] Request ------- Method: /google.ads.googleads.v16.services.GoogleAdsService/SearchStream Host: googleads.googleapis.com Headers: { "developer-token": "REDACTED", "login-customer-id": " REDACTED  ", "x-goog-api-client": "gl-python/3.10.12 grpc/1.64.1 gax/2.19.1 gccl/24.0.0 pb/4.25.3", "x-goog-request-params": "customer_id= REDACTED  " } Request: customer_id: " REDACTED  " query: "SELECT ad.resource_name, ad.name FROM ad limit 10" Response ------- Headers: { "google.ads.googleads.v16.errors.googleadsfailure-bin": "\nF\n\u0002( \u0012@Unrecognized fields in the query: 'ad.resource_name', 'ad.name'.\u0012\u0016x9q7FlflftYNacPW-mSfnA", "grpc-status-details-bin": "\b\u0003\u0012%Request contains an invalid argument.\u001a\u0001\nDtype.googleapis.com/google.ads.googleads.v16.errors.GoogleAdsFailure\u0012`\nF\n\u0002( \u0012@Unrecognized fields in the query: 'ad.resource_name', 'ad.name'.\u0012\u0016x9q7FlflftYNacPW-mSfnA", "request-id": " REDACTED  - REDACTED  " } Fault: errors { error_code { query_error: UNRECOGNIZED_FIELD } message: "Unrecognized fields in the query: \'ad.resource_name\', \'ad.name\'." } request_id: " REDACTED  - REDACTED  " [2024-07-05 09:22:22,918 - WARNING] Request made: ClientCustomerId: REDACTED  , Host: googleads.googleapis.com, Method: /google.ads.googleads.v16.services.GoogleAdsService/SearchStream, RequestId: REDACTED  - REDACTED  , IsFault: True, FaultMessage: Unrecognized fields in the query: 'ad.resource_name', 'ad.name'.

Other GAQL are working flawlessly. Can you, please, let me know why can't I extract data directly from "Ad" entity?
Reply all
Reply to author
Forward
0 new messages