I'm trying to pull a report from the Google Ads API into Google sheets and I can't get the API to recognize my query as a query

Here's the code and error I'm getting:

    function basicReport() {   var query = {     "query" : "SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id"   };      var body = JSON.stringify(query);      var head = {     'Developer-token' : "<Dev token>",     'login-customer-id' : <Manager ID>,     'Authorization' : "Bearer <Auth token>",   }; var options = {   'method' : 'POST',   'content-type': 'application/json',   'headers' : head,   'payload' : body,   'muteHttpExceptions' : true };    var response = UrlFetchApp.fetch('https://googleads.googleapis.com/v4/customers/<Customer ID>/googleAds:searchStream', options);   var json = response.getContentText();   var data = JSON.parse(json); 

But I constantly get the error:

"error": {     "code": 400,     "message": "Invalid JSON payload received. Unknown name \"{\"query\":\"SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id\"}\": Cannot bind query parameter. Field '{\"query\":\"SELECT campaign' could not be found in request message.",     "status": "INVALID_ARGUMENT",     "details": [       {         "@type": "type.googleapis.com/google.rpc.BadRequest",         "fieldViolations": [           {             "description": "Invalid JSON payload received. Unknown name \"{\"query\":\"SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id\"}\": Cannot bind query parameter. Field '{\"query\":\"SELECT campaign' could not be found in request message." 

I've run the query in OAuth playground (https://developers.google.com/oauthplayground) and it worked there, so I know the query is ok.

I've tried passing the body as an object not a string, but then I get a 500 error.

I'm trying to activate the Google Ads Api for my Google Cloud project. But every time I try it throws the following error:

An unknown error occurred when attempting to verify your billing information. Please try again or return later Tracking number: NUMBER 

I was able to activate other APIs normally. Contacted the billing support and they didn't find any billing problem. Google Ads API support is offline.

Any ideas on how to solve it or how to get help? :)

i started working on existing react native projet, that have Google ads which is already working on the playStore.

However,is not working on dev environment, is this is normal ? Does the Google ads works only after uploading the app on the store ?

I've been trying to get the results from the bid simulator in Google ads via the API but have not been successful. I have tried to follow the steps outlined by google in these guides:

https://support.google.com/google-ads/answer/9634060?hl=en https://developers.google.com/adwords/api/docs/guides/bid-landscapes#python_3

I have very slightly modified the code and it does run:

from googleads import adwords CAMPAIGN_ID = '---------' PAGE_SIZE = 100 def main(client, campaign_id):     # Initialize appropriate service.     data_service = client.GetService('DataService', version='v201809')     # Get all the campaigns for this account.     selector = {         'fields': ['CampaignId', 'CriterionId', 'StartDate', 'EndDate',                    'BidModifier', 'LocalClicks', 'LocalCost', 'LocalImpressions',                    'TotalLocalClicks', 'TotalLocalCost', 'TotalLocalImpressions',                    'RequiredBudget'],         'paging': {             'startIndex': 0,             'numberResults': PAGE_SIZE         },         'predicates': [{             'field': 'CampaignId', 'operator': 'IN', 'values': [campaign_id]         }]     }     # Set initial values.     offset = 0     more_pages = True     while more_pages is True:         num_landscape_points = 0         page = data_service.getCampaignCriterionBidLandscape(selector)         # Display results.         if 'entries' in page:             for bid_modifier_landscape in page['entries']:                 num_landscape_points = 0             print(f'Found campaign-level criterion bid modifier landscapes for '                   f"criterion with ID {bid_modifier_landscape['criterionId']},"                   f" start date {bid_modifier_landscape['startDate']}, end date     {bid_modifier_landscape['endDate']},"                   f" and landscape points:")             for landscape_point in bid_modifier_landscape['landscapePoints']:                 num_landscape_points += 1                 print(f"\tbid modifier: {landscape_point['bidModifier']},"                       f" clicks: {landscape_point['clicks']},"                       f" cost: {landscape_point['cost']['microAmount']},"                       f" impressions: {landscape_point['impressions']},"                       f"total clicks: {landscape_point['totalLocalClicks']},"                       f" total cost: {landscape_point['totalLocalCost']['microAmount']},"                       f" total impressions: {landscape_point['totalLocalImpressions']},"                       f"and required budget: {landscape_point['requiredBudget']['microAmount']}")         else:             print('No bid modifier landscapes found.')         # Need to increment by the total # of landscape points within the page,         # NOT the number of entries (bid landscapes) in the page.         offset += num_landscape_points         selector['paging']['startIndex'] = str(offset)         more_pages = num_landscape_points >= PAGE_SIZE if __name__ == '__main__':     # Initialize client object.     adwords_client = adwords.AdWordsClient.LoadFromStorage()     main(adwords_client, CAMPAIGN_ID) 

This does not however let me get the predicted conversion value, only the clicks and impressions etc which is not really what I am looking for. This seems to line up with the documentation but in the GUI I can get conversion value but seemingly no matter what key I try to query for the API won't let me get the same simulator output as in the GUI.

Any thoughts?

I downloaded Xcode12 beta 5 to apply Google Ads SDK v7.64 and AppTrackingTransparency framework to my app. But when I build my project with Xcode12 beta 5, I meet "library not found for -lGoogleUtilities" even though I didn't change my project file anything. When I use Xcode11 to build my project, it's okay.

Is it a bug of Xcode12? Or How can I fix the problem?

I use pod to setting and opened *.xcworkspace file to open project.