CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Meruva
Meruva

Reputation: 59

Keep getting 'Null' when pulling data from google sheets

Whenever I try to pull data from 2 of 3 sheets from using the 'google.script.run' function call from Javascript, I keep getting an error saying the array I am returning is Null, but when I just change the exact same function call to work on another sheet, it returns the data perfectly

I have tried deleting the sheets and giving it the same names, I have tried using 'openWithURL' instead of 'getActive' to access the spreadsheet, I have tried rewriting the code, I have tried the same code in a different project, and checking the documentation to make sure I am not missing any detail. I have tried changing the references to the sheets, some work and some dont.

var SS = SpreadsheetApp.getActive();

var DB_BOOKINGS = SS.getSheetByName("BookingDatabase");
var DB_VEHICLES = SS.getSheetByName("VehicleDatabase");
var DB_REQUESTS = SS.getSheetByName("RequestDatabase");

function getRequestData(){

 return DB_REQUESTS.getDataRange().getValues(); 
}

<script>
      function getRequestData(callingFunction) {
         google.script.run
         .withSuccessHandler(callingFunction)
         .withFailureHandler(CustomAlert)
         .getRequestData();

        }
</script>

I want to retrieve the sheet data but keep getting a null value

Upvotes: 1

Views: 2452

Answers (2)

Matt W
Matt W

Reputation: 91

I was having a similar problem. This was exactly the solution I needed. For my situation, I was able to use getValues() successfully on the initial page load, but when I tried to run it again as a sort of 'refresh' to update the values without reloading the entire page, it would return null. My data did indeed contain dates, so after changing it to getDisplayValues(), it worked perfectly.

Upvotes: 0

ross
ross

Reputation: 2774

Since this is an issue with formatting as you said, try using getDisplayValues() rather than getValues(), this will pull the data as you see it in the sheet (as a string), rather than the unformatted data itself.

Reference:

Upvotes: 3

Related Questions