Missing/Unable to Find Schedule D Section 5.K Asset Mix Fields

[nschmidt1979]

Hi,

I’m using SEC-API (Python SDK and REST) to extract Schedule D, Section 5.K “asset mix” fields from Form ADV filings. I have a batch of Filing IDs (e.g., 1863428, 1951853, and others from 2024–2025) that are present in the official SEC Form ADV CSVs and visible on the SEC IAPD website.

When I query SEC-API by Filing.id or by CRD and Filing ID, many recent filings are missing, especially those dated in non-quarter-end months (e.g., April 2024). Even for major advisers like Goldman Sachs Asset Management, L.P., I’m unable to retrieve any Schedule D Section 5.K asset mix data, even though these fields are present in the public data.

I’ve tried every likely field path (ScheduleD.5K.1.b.i, 1-separatelyManagedAccounts.b.i-exchangeTradedEquity, 5K(1)(b)(i), etc.), but these data are always empty or missing.

Questions:

Does SEC-API ingest Form ADV filings for every month, or only quarterly/annual amendments?

Is Schedule D, Section 5.K asset mix ever present in SEC-API’s JSON? If so, what is the field path or object structure?

Is there a workaround to reliably retrieve these data points, or should I use the SEC CSV files instead?

Thanks in advance for your help and clarification!