get list item from SharePoint online 365 using rest api

Question

I need to get data from SharePoint online list by using rest api. I will use the GET and POST method (post method in camel query case).

urlapp: the encoded url such as https://name-29a8f2a9e3342d....

$.ajax({
   url: urlapp + "/../_api/web/lists/getbytitle('Letters')",
    method: "GET",
    headers: {
        "accept": "application/json;odata=verbose",
        "content-type": "application/json;odata=verbose",  
    },
    async: false,
    success: function (data) {
        console.log(data);//Debug statement                 
    },
    error: function (error) {
        console.log(error);
    }
});

the previous code generate the 403 (Forbidden) error.

After searching I found solution by using executeAsyn (new SP.RequestExecutor), but I need some way is sync execution not async.

Navigate to url value. If it returns any results, then you shouldn't be getting any errors. — Ashik Paul
– Ashik Paul, Commented Sep 24, 2018 at 7:02
I dont think you need sync code, you can do the next operations in the async success callback. — Mikel
– Mikel, Commented Sep 24, 2018 at 10:22

Ankitkumar Malde · Accepted Answer · 2017-04-10 09:09:48Z

0

You can try .done() method to achieve your synchronous effect on your calls.

For Example:

function AjaxCall(url) {
var call = $.ajax({
    url: url,
    type: "GET",
    headers: {
        "accept": "application/json;odata=verbose",
    },
    error: function(error) {
        console.log(JSON.stringify(error));
    }
});
return call;
}
$(document).ready(function() {
var firstCall = AjaxCall(_spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/GetByTitle('Letters')/items");
firstCall.done(function(data, textStatus, jqXHR) {
    $.each(data.d.results, function(i, val) {
       //doSomething
    });
    var secondCall = AjaxCall(_spPageContextInfo.webAbsoluteUrl + "/_api/Web/Lists/GetByTitle('newList')/items");
    secondCall.done(function(data, textStatus, jqXHR) {
        $.each(data.d.results, function(i, val) {
           //doSomething
        });
    });
});

This will help you achieve synchronous effect with asynchronous calls..

answered Apr 10, 2017 at 9:09

Ankitkumar Malde

1,47314 silver badges28 bronze badges

thank you for response but if i put any code after done calling will execute before finish the done calling and I can not insert all the code inside done

myomyo
– myomyo

2017-04-10 11:16:17 +00:00
Commented Apr 10, 2017 at 11:16
You can write function and call that function inside done

Ankitkumar Malde
– Ankitkumar Malde

2017-04-11 06:37:13 +00:00
Commented Apr 11, 2017 at 6:37

Add a comment |

Samir Khimani · Accepted Answer · 2017-04-10 11:55:23Z

0

Please try below code.

 var executor = new SP.RequestExecutor('AppWebURL');
     executor.executeAsync(
                {
                    url: "AppWebURL" + "/_api/SP.AppContextSite(@target)/Web/Lists/GetByTitle('Letters')/Items?@target='HostWebURL'",
                    method: "GET",
                    headers: { "Accept": "application/json; odata=verbose" },
                    success: function (data) {
                        console.log('success');
                    },
                    error: function () {
                        console.log("error");
                    }
                });

Hope it works for you.

answered Apr 10, 2017 at 11:55

Samir Khimani

2,22313 silver badges16 bronze badges

Sorry for that but this solution is async and I have to use the rest api with online sharepoint

myomyo
– myomyo

2017-04-11 05:37:15 +00:00
Commented Apr 11, 2017 at 5:37
It is not possible to do sync call while access data from host web from app web.

Samir Khimani
– Samir Khimani

2017-04-11 06:05:25 +00:00
Commented Apr 11, 2017 at 6:05

Add a comment |

Lee · Accepted Answer · 2018-01-01 01:04:48Z

You could use jQuery Deffered for this.

Sample Script:

<script type="text/javascript">
    function testCreateFolder() {
        CreateFoldersbyparent("abc", "MyDoc/").done(function () {
            CreateFoldersbyparent("test", "MyDoc/abc/");
        })
    }

    function CreateFoldersbyparent(name, parent, callback) {
        var deferred = $.Deferred();
        // replace below with your logic
        var documentLibraryName = "MyDoc";
        var fileCollectionEndpoint = _spPageContextInfo.webAbsoluteUrl + "/_api/web/getfolderbyserverrelativeurl('" + documentLibraryName + "')/folders/add('" + parent + name + "')";
        $.ajax({
            url: fileCollectionEndpoint,
            type: "POST",
            async: false,
            headers: {
                "X-RequestDigest": $("#__REQUESTDIGEST").val(),
                "accept": "application/json;odata=verbose",
                "content-type": "application/json;odata=verbose"
            },
            success: function (data) {
                console.log("done");
                deferred.resolve(data);
            },
            error: function (jqXHR, textStatus, errorThrown) {
                //handle error...
                console.log(jqXHR);
            }
        });
        return deferred.promise();
    }
</script>

Stack Exchange Network

get list item from SharePoint online 365 using rest api

3 Answers 3

Your Answer

Hot Network Questions

get list item from SharePoint online 365 using rest api

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions