String r = null;
try {
log.info("BigQuery projects().list()");
Bigquery.Projects.List listrequest = bigquery.projects().list();
log.info("BigQuery listrequest.execute()");
ProjectList projectlist = listrequest.execute();
String list = projectlist.toPrettyString();
log.info("Project list: " + list);
java.util.List<Projects> projects = projectlist.getProjects();
for (Projects p : projects) {
String s = p.toPrettyString();
log.info("Project: " + s);
String projectid = p.getId(); // Get the project id
log.info("Projectid: " + projectid);