+ Reply to Thread
Results 1 to 3 of 3

Retrieve SharePoint Folder names via REST API

  1. #1
    Registered User
    Join Date
    04-20-2016
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    6

    Red face Retrieve SharePoint Folder names via REST API

    Good day,

    I am a noob to REST API, but has anyone got the experience to utilize the SharePoint REST API to retrieve Folder names via VBA? I am trying to populate a Userform Combobox with Folder names from a SharePoint Online Document Library.

    Any assistance would be appreciated as I have been searching for a solution for weeks now with no success.

    Many thanks in advance.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Retrieve SharePoint Folder names via REST API

    This might get you started: https://pholpar.wordpress.com/2016/0...-vba-and-rest/. You can also post feedback there which might elicit more advice.
    See also: https://officeaccelerators.wordpress...om-sharepoint/
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    04-20-2016
    Location
    Cape Town, South Africa
    MS-Off Ver
    2016
    Posts
    6

    Re: Retrieve SharePoint Folder names via REST API

    Thank you so much for the reply. I have the API string, which is essentially /_api/Web/GetFolderByServerRelativeUrl('Shared%20Documents/General/NewFolder')?$expand=Folders&$FilterField=Name but I need to know how I would get the data stored in VBA, then loop through the output to filter just the d:Name.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Retrieve SharePoint Document Library weburl path P1
    By hnguy71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2019, 03:36 PM
  2. Dynamic Vlookup in Sharepoint folder
    By VincentNL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-31-2018, 10:54 AM
  3. Save as pdf in current folder in Sharepoint
    By Jacc in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 12-22-2015, 08:25 PM
  4. Help with Saving Excel to SharePoint Folder
    By Inez15 in forum Excel General
    Replies: 6
    Last Post: 03-08-2013, 06:59 PM
  5. Retrieve File names from a folder with last modified username
    By elavarasans in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2013, 12:48 PM
  6. Replies: 11
    Last Post: 10-21-2012, 01:40 AM
  7. [SOLVED] Retrieve xml data from SharePoint
    By JimDandy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2006, 11:38 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1