Error when using BigQuery in Google Ads Script

[Chris]

I am trying to use script provided in the below link to try to use BigQuery in the script.

https://developers.google.com/google-ads/scripts/docs/solutions/adsmanagerapp-bigquery-exporter

However, "ReferenceError: 'dataset' is not defined." error message is printed in the Logs.

The problem seems to be from the createDataset() method. Why is this happening and how do I fix this error?

[Chris]

Ok for some reason, the .list() method to get all the available datasets doesn't return all the datasets. Maybe there is a limit on how many results get returned...

I had used .get() method instead to get the dataset I need.

I still would like to know why list all of a sudden failed to work..

[Google Ads API Forum Advisor]

Hi Chris,

Thank you for reaching out to us.

This support channel specializes in AdWords / Google Ads API related concerns. Since your query is related to the Google Ads Scripts, you can reach their support team via their forum channel instead. We hope that you get a positive response from them the soonest time possible.

Regards,

Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Princess Pamela Pineda Google Ads API Team

ref:_00D1U1174p._5004Q2Rvwd4:ref