SharePoint Hosted App: Using Cross Domain call to access list items on Host Web

Question

I can use Chrome Advanced REST tools to test out a get list items request on the host web

http://mydev/records/_api/Web/Lists/GetByTitle('Uber Documents')/Items?$select=Title

Ok now I want to use a similar call in SharePoint hosted app that makes a cross domain call to Host Web from Appp Web.

  var listName = "Uber Documents";
  executor.executeAsync(
    {

        url: appweburl +
       "/_api/SP.AppContextSite(@target)/web/lists/getbytitle('" + listName + "')/items?@target='" +
             hostweburl + "'&$select=Title&$select=Target",
        method: "GET",
        headers: { "Accept": "application/json; odata=verbose" },
        success: SuccessHandler,
        error: errorHandler

I think my syntax is incorrect as the SuccessHandler fires but I get
Could not complete cross-domain call: Bad Request

Anybody got any tips on how you formulate the syntax.

Answer 1

It's unlikely that you have a field called 'Target' in any given list that you might call with this function...

It's probable that your first request in your original post worked just fine, while the second failed because the first didn't attempt to $select a field called Target

Something to try:

var executor = new SP.RequestExecutor(appweburl);
function execCrossDomainRequest(listTitle) {
    executor.executeAsync(
        {
            url:
                appweburl +
                "/_api/SP.AppContextSite(@target)/web/lists/getByTitle('" + listTitle + "')/items?$select=Title&@target='" +
                hostweburl + "'",
            method: "GET",
            headers: { "Accept": "application/json; odata=verbose" },
            success: successHandler,
            error: errorHandler
        }
    );
}

function successHandler(data) {
    console.log(data);
    var jsonObject = JSON.parse(data.body),
        results = jsonObject.d.results;

    console.log(results);
}

function errorHandler(data, errorCode, errorMessage) {
    document.getElementById("renderAnnouncements").innerText =
        "Could not complete cross-domain call: " + errorMessage;
}

Then you can call it with execCrossDomainRequest('Uber Documents') and it should log the output into your console.

Answer 2

Try with this URL

EDIT

var url = appweburl +
               "/_api/SP.AppContextSite(@target)/web/lists/getbytitle('" + listName + "')/items?@target='" + hostweburl + "'&$select=Title,Target"

$.ajax({    

url: url,
type: "GET",    
contentType: "application/json;odata=verbose",    
headers: {      "Accept": "application/json;odata=verbose" }, 
success: function (data) {      
        alert('Success')    
     },    
error: function (data) {      
        alert('Failed')    
    } 

});