Skip to content

Instantly share code, notes, and snippets.

@alirobe

alirobe/get-sharepoint-list-json-with-comments-from-console.js

Last active September 18, 2024 03:30
Download ZIP

Revisions

  1. alirobe revised this gist Sep 18, 2024. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion get-sharepoint-list-json-with-comments-from-console.js
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    var listUrl = "https://tenant.sharepoint.com/sites/site/_api/web/lists/getByTitle('List Name')"
    var listUrl = "https://<TENANT>.sharepoint.com/sites/site/_api/<SITE>/lists/getByTitle('<LIST>')"
    var url = `${listUrl}/items?$top=5000`;
    var fetchOptions = { headers: { "Accept": "application/json;odata=nometadata" } };
    var response = await fetch(url, fetchOptions);
  2. alirobe renamed this gist Sep 18, 2024. 1 changed file with 0 additions and 0 deletions.
    0 use-in-console.js → ...t-list-json-with-comments-from-console.js
    View file
    File renamed without changes.
  3. alirobe created this gist Sep 18, 2024.
    18 changes: 18 additions & 0 deletions use-in-console.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,18 @@
    var listUrl = "https://tenant.sharepoint.com/sites/site/_api/web/lists/getByTitle('List Name')"
    var url = `${listUrl}/items?$top=5000`;
    var fetchOptions = { headers: { "Accept": "application/json;odata=nometadata" } };
    var response = await fetch(url, fetchOptions);
    var data = await response.json();
    var items = data.value;
    var commentsPromises = items.map(async item => {
    var commentsUrl = `${listUrl}/items(${item.Id})/Comments()`;
    var commentsResponse = await fetch(commentsUrl, fetchOptions);
    if (commentsResponse.ok) {
    var commentsData = await commentsResponse.json();
    item.Comments = commentsData.value;
    } else {
    item.Comments = [];
    }
    });
    await Promise.all(commentsPromises);
    console.log(items);