REST filter library (SharePoint Online)

Question

Edit 12/4: I'm also attempted to get the site page url from another list but also giving me an error each time it tries to open the page from SitePages library. (Posted here)

---

I'm trying to dynamically create a link to open the appropriate calendar view based on current users

• List: Staff Directory; Columns: EmailAddress, Section
• Library: SitePages; Columns: Name, Section

The code below works to get the section name of the current user:

$(function(){
var currentUserEmail = _spPageContextInfo.userEmail;
    var requestSecUrl = "https://site/_api/web/Lists/getByTitle('StaffDirectory')/Items?$filter=Title eq '" + currentUserEmail + "'&$select=Section";
    $.ajax({
      url: requestUrl,
      method: "GET",
      async: false,
      headers: { "Accept": "application/json; odata=verbose" },
      success: function (data) {
      var mySection = data.d.results[0].Section
      alert(mySection);
     },
     error: function (data) {alert ("error found"); }
    });

But how do I use the 'mySection' to filter the library and return the filename?

I tried adding the following after the alert(my Section);

var calSecUrl = "https://site/_api/web/Lists/getByTitle('SitePages')/Items?$filter=Section eq '" + mySection + "'&$select=FileLeafRef";
$.ajax({
      url: calSecUrl,
      method: "GET",
      async: false,
      headers: { "Accept": "application/json; odata=verbose" },
      success: function (data) {
      var CalFileName = data.d.results[0].FileLeafRef;
      alert(CalFileName);
      },
      error: function (data) {alert("Calendar not found");}
      });

I keep getting the "Calendar not found" alert.

Answer 1

Use the following code to check if it works.

<script src="//code.jquery.com/jquery-3.2.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
    var currentUserEmail = _spPageContextInfo.userEmail;

    // begin work to call across network
    var requestUri = _spPageContextInfo.webAbsoluteUrl +
                  "/_api/web/Lists/getByTitle('StaffDirectory')/Items?$filter=Title eq '" + currentUserEmail + "'&$select=Section";

    // execute AJAX request
    $.ajax({
        url: requestUri,
        type: "GET",
        headers: { "ACCEPT": "application/json;odata=verbose" },
        success: function (data) {
            if(data.d.results.length>0){
                var mySection = data.d.results[0].Section;
                if(mySection!=null){
                    getFileName(mySection);
                }                               
            }       
        },
        error: function () {
            alert("error found");
        }
    });
});
function getFileName(mySection){
    // begin work to call across network
    var requestUri = _spPageContextInfo.webAbsoluteUrl +
                  "/_api/web/Lists/getByTitle('Site Pages')/Items?$filter=Section eq '" + mySection + "'&$select=FileLeafRef";

    // execute AJAX request
    $.ajax({
        url: requestUri,
        type: "GET",
        headers: { "ACCEPT": "application/json;odata=verbose" },
        success: function (data) {
            if(data.d.results.length>0){
                var CalFileName = data.d.results[0].FileLeafRef;
                alert(CalFileName);
            }       
        },
        error: function () {
            alert("Calendar not found");
        }
    });
}
</script>