Home › Forums › The XBRL API › Inline vs. instance document reports
- This topic has 3 replies, 2 voices, and was last updated 3 years, 4 months ago by David Tauriello.
-
AuthorPosts
-
-
Wednesday, August 18, 2021 at 5:19 PM #193400David TaurielloKeymaster
From a data user: We are trying to get net income for publicly traded companies but the following stocks are missing info through XBRL even through they are tagged by the SEC. Can you let me know when you guys can get this done? My developers are waiting on this data to complete part of a project.
I’m attaching the list for the stocks that are missing net income information even though they have been tagged in the SEC docs.
Can’t post this on the forum as these are attachments.
Thanks for your assistance.
Tanvir.
-
Wednesday, August 18, 2021 at 5:20 PM #193401David TaurielloKeymaster
Hi Tanvir – We copy each XBRL filing’s details in EDGAR to our database from the .zip file a company submits to the SEC – while we’ve missed entire filings in the past (and I’m not aware of any missing at this point), I’ve never seen us drop a fact within a filing(?).
Can you provide a specific report as an example, instead of files full of tickers?
Also, without an XBRL US Membership, an account won’t be able to return all possible rows and this may be the issue.
-
Thursday, August 19, 2021 at 2:24 PM #193413Nik ZParticipant
Hi David,
I am one of the developers on this team. This question is regarding reports not having any data available searchable with XBRL when it looks like they should.
One example is 1-800-Flowers most recent 10-K. Where I receive the error “Inline XBRL viewing features are minimal because no supporting file was found”.
I believe there should be XBRL data as there appears to be XBRL files on the Filing Detail Page. I also noticed “us-gaap” tags in the documents which is initially why I thought it would be possible for these cases.
Note that in these cases I am still able to request the report, just not any facts within it. Any clarification on why this is the case or assistance in resolving it would help us out greatly.
Thank you,
Nik-
Thursday, August 19, 2021 at 2:31 PM #193444David TaurielloKeymaster
Hi Nik – thanks for sharing detail. The 1-800-Flowers 10-K you’re looking at is not an inline XBRL file, so it will not render in the SEC’s inline viewer (the
ix?doc=
part of the URL).If you return 1-800-Flowers reports with this query, you’ll see a field called
report.entry-type
– this distinguishes inline filings from older instance.xml files.https://api.xbrl.us/api/v1/report/search?entity.id=1085&fields=dts.id,report.filing-date.sort(DESC),report.entry-type,report.document-type,report.entity-name,report.sec-url
Here’s a recent 1-800-Flowers Filing Detail Page for an inline report – compare it to your link for the 10-K
-
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
Recent Replies
-
Spreadsheet Commands: Query Worksheet and Query Workbook Query Workbook 1 month, 3 weeks ago
-
Query for multiple dimensions 3 months, 3 weeks ago
-
Query for multiple dimensions 4 months ago
-
Showdata function 6 months, 2 weeks ago
-
Showdata function 6 months, 2 weeks ago
Documentation & Discussion
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
- XBRL API Interactive Documentation
- Ten Tips & Techniques
- The XBRL API
- XBRL Data Community
- 2024 US GAAP Taxonomy Viewer
- Live support - Monday, 3:30 - 4:30 PM ET
Who's using this free data?
API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.