Not able to generate network report with admob api

[Monazir Hussain]

Not able to generate network report with admob api. Attached below request for reference

curl -X POST \
      https://admob.googleapis.com/v1/accounts/pub-************/networkReport:generate \
      -H "Content-Type: application/json" \
      -H "$(oauth2l header --json credentials.json \
          https://www.googleapis.com/auth/admob.report)" \
      --data @- << EOF
{
"report_spec":{
  "date_range": {
    "start_date": {"year": 2022, "month": 12, "day": 1},
     "end_date": {"year": 2022, "month": 12, "day": 1}
  },
  "dimensions": ["DATE", "AD_UNIT", "APP", "COUNTRY", "FORMAT", "PLATFORM" ],
  "metrics": ["AD_REQUESTS", "CLICKS", "ESTIMATED_EARNINGS", "IMPRESSIONS", "IMPRESSION_CTR", "MATCHED_REQUESTS", "MATCH_RATE"]
}
}
EOF
[{
  "error": {
    "code": 401,
    "message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
    "status": "UNAUTHENTICATED"
  }
}
]%

[AdMob API Forum Support]

Hi there,

Please ensure you have completed all of the authorization setup steps. The next step will be to copy the command below into your terminal and check that you retrieve a token. Prior to running the command, please replace PATH_TO_CREDENTIALS with your credentials.json file that is retrieved during the authorization setup steps.
 

~/go/bin/oauth2l header --json PATH_TO_CREDENTIALS https://www.googleapis.com/auth/admob.readonly

All the best,

Amira AdMob API Team

ref:_00D1U1174p._5004Q2h1vN8:ref

[AdMob API Forum Support]

Hi there,

Thank you for the screenshot. I believe this issue is being cause by a curl formatting error, please try removing all of the backslashes "\" and submitting the request on a single line as shown below.

curl -X POST https://admob.googleapis.com/v1/accounts/pub-*************/networkReport:generate -H "Content-Type: application/json" -H "$(~/go/bin/oauth2l header --json credentials.json https://www.googleapis.com/auth/admob.readonly)" --data @- << EOF
{
"report_spec":{
  "date_range": {
    "start_date": {"year": 2022, "month": 12, "day": 1},
     "end_date": {"year": 2022, "month": 12, "day": 1}
  },
  "dimensions": ["DATE", "AD_UNIT", "APP", "COUNTRY", "FORMAT", "PLATFORM" ],
  "metrics": ["AD_REQUESTS", "CLICKS", "ESTIMATED_EARNINGS", "IMPRESSIONS", "IMPRESSION_CTR", "MATCHED_REQUESTS", "MATCH_RATE"]
}
}
EOF

Please let me know if this does not resolve your issue.

All the best,

[Monazir Hussain]

Hello There,

It's not working, at all. Response is still the same. Please let me know what I'm doing wrong here. 

Thanks

Monazir

[AdMob API Forum Support]

Hello,

I was unable to reproduce the issue, so I recommend trying to use the API explorer to generate a network request. If you are able to successfully authenticate using the API explorer, found on the right hand side of the page, the issue is likely due to improper project setup. I would then recommend creating a new cloud project and following the Auth setup page from the start for a clean environment.

[Monazir Hussain]

Hello,
I've also tried it on the API explorer page, but it's resulting same response.

Thanks

Monazir

[AdMob API Forum Support]

Hello,

I recommend creating a new google cloud platform project and following the Auth setup page from the start for a clean environment and to confirm all steps were followed. Please ensure that you are signed in to the correct account when accepting the consent screen.

[Monazir Hussain]

Hello ,

I created a new project, but got an error while configuring the consent screen.

Attached screenshot for reference.

Thanks

Monazir

[AdMob API Forum Support]

Hello,

I recommend following the guide that describes Setting Up Your OAuth Consent Screen. If you have additional issues regarding the OAuth consent screen, please reach out to the Google Cloud Platform Console Help Center.

[Monazir Hussain]

Hello,

Now I'm getting a different error while trying to get below data. Attached screenshot for your reference.

{
  "reportSpec": {
    "dateRange": {
      "startDate": {
        "year": 2023,
        "month": 1,
        "day": 1
      },
      "endDate": {
        "year": 2023,
        "month": 1,

        "day": 1
      }
    },
    "dimensions": [
      "DATE",
      "AD_UNIT",
      "APP",
      "COUNTRY",
      "FORMAT",
      "PLATFORM"
    ],
    "metrics": [
      "AD_REQUESTS",
      "CLICKS",
      "ESTIMATED_EARNINGS",
      "IMPRESSIONS",
      "IMPRESSION_CTR",
      "MATCHED_REQUESTS",
      "MATCH_RATE"
    ]
  }
}

 

[AdMob API Forum Support]

Hello,

Did you retry the request 30 seconds after the initial error and did you receive the same error response? I recommend using the API explorer to make a request and if there are issues with the API explorer, to then try the request below in a terminal.
 

curl -X GET https://admob.googleapis.com/v1/accounts/pub-************* -H "Content-Type: application/json" -H "$(~/go/bin/oauth2l header --json credentials.json https://www.googleapis.com/auth/admob.readonly)"

[Monazir Hussain]

Hello,

Now I'm able to download the report after getting the access token, but it needs to be approved every time from the browser.

But It is not possible for us to do it as it will be running on a virtual machine.

As far as I could find It can be done with refresh token and refreshing access token when expired. 

But I didn't find any resources to do this for Desktop project admob api. 

Could you please help me with this?? 

Thanks

Monazir

[AdMob API Forum Support]

Hello,

I recommend using a web app authentication type for your application. The desktop authorization flow is similar to the one used for web server applications. The main difference is that installed apps must open the system browser and supply a local redirect URI to handle responses from Google's authorization server.