2

here am trying to get reccurring events from calendar list for sharepoint Online app and there am using code as like

hostWebUrl = decodeURIComponent(manageQueryStringParameter('SPHostUrl'));
    function GetListData() {
        var webUrl = hostWebUrl;// = "http://server/sitewhereyourlistexists";
        var listGuid = "{2000da75-8663-42d9-9999-ad855c54b4e0}"


        // An XMLHttpRequest object is used to access the web service
        var xhr = new XMLHttpRequest();
        var url = webUrl + "/_vti_bin/Lists.asmx";
        xhr.open("POST", url, true);
        xhr.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
        xhr.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/sharepoint/soap/GetListItems");

        // The message body consists of an XML document 
        // with SOAP elements corresponding to the GetListItems method parameters
        // i.e. listName, query, and queryOptions
        var data = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
            "<soap:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\">" +
                "<soap:Body>" +
                "<GetListItems xmlns=\"http://schemas.microsoft.com/sharepoint/soap/\">" +
                        "<listName>" + listGuid + "</listName>" +
                        "<query>" +
                            "<Query><Where>" +
                                "<DateRangesOverlap>" +
                                    "<FieldRef Name=\"EventDate\"/>" +
                                    "<FieldRef Name=\"EndDate\"/>" +
                                    "<FieldRef Name=\"RecurrenceID\"/>" +
                                    "<Value Type=\"DateTime\"><Today/></Value>" +
                                "</DateRangesOverlap>" +
                            "</Where></Query>" +
                        "</query>" +
                        "<queryOptions>" +
                            "<QueryOptions>" +
                                "<ExpandRecurrence>TRUE</ExpandRecurrence>" +
                            "</QueryOptions>" +
                        "</queryOptions>" +
                "</GetListItems>" +
                "</soap:Body>" +
            "</soap:Envelope>";

        // Here we define what code we want to run upon successfully getting the results
        xhr.onreadystatechange = function () {
            if (xhr.readyState == 4) {
                if (xhr.status == 200) {
                    var doc = xhr.responseXML;
                    // grab all the "row" elements from the XML results
                    var rows = doc.getElementsByTagName("z:row");
                    var results = "Today's Schedule (" + rows.length + "):\n\n";
                    var events = {};
                    for (var i = 0, len = rows.length; i < len; i++) {
                        var id = rows[i].getAttribute("ows_FSObjType"); // prevent duplicates from appearing in results
                        if (!events[id]) {
                            events[id] = true;
                            var allDay = rows[i].getAttribute("ows_fAllDayEvent"),
                                title = rows[i].getAttribute("ows_Title"),
                                start = rows[i].getAttribute("ows_EventDate");
                            var index = start.indexOf(" ");
                            var date = start.substring(5, index) + "-" + start.substring(2, 4); // get the date in MM-dd-yyyy format
                            start = start.substring(index, index + 6); // get the start time in hh:mm format
                            var end = rows[i].getAttribute("ows_EndDate");
                            index = end.indexOf(" "); end = end.substring(index, index + 6); // get the end time in hh:mm format
                            results += date + " " + (allDay == "1" ? "All Day\t" : start + " to " + end) + " \t " + title + "\n";
                        }
                    }
                    alert(results);
                } else {
                    alert("Error " + xhr.status);
                }
            }
        };

        // Finally, we actually kick off the query
        xhr.send(data);
    }


after calling this function in decument. ready section it is not retrieving any data but there is ine error which i can see in console of browser that is as below
enter image description here

  • Have you got any solution? I am too facing the same – Trimantra Software Solution Oct 25 '16 at 10:12
  • yes,i was having issue with sp service js file that i was referring in my html page – Madhav Oct 25 '16 at 10:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.