//Method to send query and get response and then assemble the response. public ArrayList GetData() { ArrayList tempArray = new ArrayList(); try { //tempArray.Add(System.IO.Directory.GetCurrentDirectory()); //var credentials = GoogleCredential.FromFile("./Assets/Scripts/Additional/authKey.json"); //var credentials = GoogleCredential.FromFile("/Additional/authkey.json"); var credentials = GoogleCredential.FromJson("Not Today"); BigQueryClient ourClient = BigQueryClient.Create(projectCode, credentials); String query = this.FormQuery(); Debug.Log(query); BigQueryResults results = ourClient.ExecuteQuery(query, parameters: null); ArrayList stateData = new ArrayList(); StateData currentState = new StateData(); foreach (BigQueryRow row in results) { String date = Convert.ToString(row["date"]); String country = Convert.ToString(row["country_code"]); String state = Convert.ToString(row["subregion1_name"]); String coordinates = Convert.ToString(row["location_geometry"]); int confirmedCases = Convert.ToInt32(row["cumulative_confirmed"]); int deceased = Convert.ToInt32(row["cumulative_deceased"]); if (currentState.IsValidInsertion(state)) { currentState.AddRow(country, state, coordinates, date, confirmedCases, deceased); } else { stateData.Add(currentState); currentState = new StateData(); currentState.AddRow(country, state, coordinates, date, confirmedCases, deceased); getDataSize++; } } Debug.Log("Made it to data"); return(stateData); }catch (Exception e) { tempArray.Add(e.ToString()); return(tempArray); } }