Home › Forums › The XBRL API › Duplicate information in instance document
- This topic has 1 reply, 2 voices, and was last updated 4 years, 7 months ago by David Tauriello.
-
AuthorPosts
-
-
Wednesday, June 10, 2020 at 2:22 AM #182635Bhupesh HarchandaniParticipant
I am trying to parse the 10k filing for Amazon Inc. and I see duplicate information in the instance document. The information about Net Income Fact is repeated 5 times with only the ‘ID’ attribute value being distinct. I am trying to figure out if the ‘id’ attribute has any information or is it just a serial number. Below are the snippets I am looking at:
<us-gaap:NetIncomeLoss
contextRef=”FD2017Q4YTD”
decimals=”-6″
id=”d83343256e749-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss><us-gaap:NetIncomeLoss
contextRef=”FD2017Q4YTD”
decimals=”-6″
id=”d83340331e1774-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss><us-gaap:NetIncomeLoss
contextRef=”FD2017Q4YTD”
decimals=”-6″
id=”d83344299e636-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss><us-gaap:NetIncomeLoss
contextRef=”FD2017Q4YTD”
decimals=”-6″
id=”d83354346e1194-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss><us-gaap:NetIncomeLoss
contextRef=”FD2017Q4YTD”
decimals=”-6″
id=”d83380285e1820-wk-Fact-5ADF1B1FA099436C36E180286EB2E9A2″
unitRef=”usd”>3033000000</us-gaap:NetIncomeLoss>Can anyone please help me in finding a solution to this issue?
Thanks in advance. -
Wednesday, June 10, 2020 at 3:48 PM #182716David TaurielloKeymaster
Hi Bhupesh – thanks for writing – the five times you have noted 2017 NetIncomeLoss is returned in Amazon’s 2019 10-K are the same fact. In short, the contextref is identical for each of these occurrences of the concept in the inline XBRL document – https://www.sec.gov/ix?doc=/Archives/edgar/data/1018724/000101872420000004/amzn-20191231x10k.htm. If you parse 2018 or 2017 10-K reports for Amazon (not inline XBRL), you will only see two entries for NetIncomeLoss.
If you use the
fact.ultimus
filter set as true on the XBRL API, the query below returns two instances of 2017 NetIncomeLoss for Amazon across all reports (entity.id=241) – one dimensionalized as part of RetainedEarnings and the other non-dimensionalized.https://api.xbrl.us/api/v1/fact/search?entity.id=241& concept.local-name=NetIncomeLoss&period.fiscal-year=2017& period.fiscal-period=Y&fact.ultimus=TRUE&fields=entity.name, report.filing-date,report.type,fact.value,dimensions, fact.xml-id,report.sec-url
-
-
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 2 months, 3 weeks ago
-
Query for multiple dimensions 4 months, 3 weeks ago
-
Query for multiple dimensions 4 months, 3 weeks ago
-
Showdata function 7 months, 1 week ago
-
Showdata function 7 months, 1 week 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.