How can I retrieve info with UrlFetchApp.fetch using Google Apps Script
21:16 12 Sep 2016

I have a question. I coded this piece of Google Apps Script, but I´m not getting the result that I´m waiting for

function getDataFromQuery(myId){

  var data;

  var sqlSlect = encodeURIComponent("select A, B, C, D, E, F, G, H, I,  J, K where A ="+myID+" ");     
  
  try{
         var fullQuery = "https://docs.google.com/a/google.com/spreadsheets/d/MY_GOOGLE_SPREADSHEET_ID/gviz/tq?tq="+sqlSlect+"&gid=THE_SHEET_WHERE_INFO_IS"; 
           
         Logger.log(" "+fullQuery);     
    
         data = UrlFetchApp.fetch(
            "https://docs.google.com/a/google.com/spreadsheets/d/MY_GOOGLE_SPREADSHEET_ID/gviz/tq?tq="+sqlSlect+"&gid=THE_SHEET_WHERE_INFO_IS");
    
         Logger.log(" "+data.getContentText());
    
  } catch (e) {
     Logger.log("< Some error > " + e.toString());
  }
 
  return data;
}

Does anybody can give me an idea about what is happening?

javascript google-apps-script urlfetch