Different api version missing some folder.

[jeongkim]

Hi,

with api 14 with code below, it is missing LGU+ contents in the folder. 

let
Source = SharePoint.Contents("https://nokia.sharepoint.com/sites/korea-pmo-pbi-data-repository", [ApiVersion = 14]),
#"Documents" = Source{[Name="Documents"]}[Content],
#"KR Cell Status" = #"Documents"{[Name="KR Cell Status"]}[Content],

wherease, api 15, it is not missing any. 

The reason I tried it with 14 was I heard 14 might not missing all the contents and better, but not sure. 

My SP site was created in 2023. Should I keep using api version 15? 

let
Source = SharePoint.Contents("https://nokia.sharepoint.com/sites/korea-pmo-pbi-data-repository", [ApiVersion = 15]),
#"Shared Documents" = Source{[Name="Shared Documents"]}[Content],
#"KR Cell Status" = #"Shared Documents"{[Name="KR Cell Status"]}[Content],

[burakkaragoz · Accepted solution]

Hi @jeongkim ,

Thanks for the detailed explanation and screenshots — they really help clarify the issue.

What you're seeing is actually a known behavior difference between API version 14 and 15 in the SharePoint.Contents function.

Here’s what’s likely happening:

• API 14 was designed for compatibility with older SharePoint structures and sometimes misses modern folders or libraries, especially in newer SharePoint Online sites (like yours, created in 2023).
• API 15 is the newer and more reliable version for modern SharePoint sites. It handles modern document libraries, nested folders, and metadata more consistently.

Even though some sources suggest API 14 might be more stable, in practice:

• It can fail to enumerate certain folders (like your LGU+ folder).
• It may not fully support modern SharePoint features introduced in recent years.

Recommendation:

Stick with API version 15 — especially since your site is relatively new and you're seeing complete results with it. Unless you have a specific legacy compatibility requirement, API 15 is the safer and more future-proof choice.

Let me know if you want help optimizing your query structure or filtering specific folders dynamically.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

---

This response was supported by AI for translation and text editing.