REST get Lists From Current Web

By fredericdietrich On 08/10/2018

In javascript

function getlists() {

$.ajax({

url: _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists",

method: "GET",

headers: {

"Accept": "application/json; odata=verbose"

success: function (data) {

var lists = data.d.results;

console.clear();

console.dir(lists);

for (var i = 0 ; i < lists.length ; i++) {

var lst = lists[i];

//console.dir(lst);

$.ajax({

async: false,

headers: { "accept": "application/json; odata=verbose" },

method: "GET",

url: lst.RootFolder.__deferred.uri,

success: function (data) {

// get the rootFolder

var folder = data.d;

console.log("Title : " + lst.Title + "; RootFolder :" + folder.ServerRelativeUrl

+ "; Hidden :" + lst.Hidden + "; ItemCount :" + lst.ItemCount + "; LastItemModifiedDate :" + lst.LastItemModifiedDate

+ "; BaseTemplate :" + lst.BaseTemplate);

}

});

}

error: function (data) {

console.log(data);

}

});

}

get the code only

REST

In Power plateform

PowerAutomate Add Folder

By fredericdietrich On 10/02/2023

Powerautomate get folder by url


/_api/web/GetFolderByServerRelativeUrl('@{variables('WebserverRelativeUrl')}/@{variables('DoclibUrl')}/Fiche_@{variables('FicheId')}')
Verify status (exists = 200, does not exists = 404)


@{outputs('HttpGetFolder')['statusCode']}

Create folder


/_api/web/folders/add('@{variables('DoclibUrl')}/Fiche_@{variables('FicheId')}')

Createfolder

In javascript

How to resolve the 5000 item limit

By fredericdietrich On 24/01/2022

     var firstItems = listLocation.web.getList(listLocation.listUri).items.select("ID").top(1).orderBy("Id").get();
     var lastItems = listLocation.web.getList(listLocation.listUri).items.select("ID").top(1).orderBy("Id", false).get(); 

    if (firstItems.length === 1 && lastItems.length === 1) {
      const firstId: number = firstItems[0].ID;
      const lastId: number = lastItems[0].ID;
      let startId = firstId;
      let endId = firstId + 5000;
      do {
        let mySites: ISite[] = await listLocation.web.getList(listLocation.listUri).items

          .select("ID", "Title", "Url")
          .filter(`Id ge ${startId} and Id lt ${endId} and ProprietairesPeople/Id eq ${userId}`)
          .expand('ProprietairesPeople')
          .orderBy("Title")
          .top(5000)
          .getAll(); 

          allMySites.push(...mySites);
          startId = startId + 5000;
          endId = endId + 5000;
      }
      while (endId < lastId);
    }
    return allMySites;