Home › Forums › The XBRL API › Why does XBRL return differing values for same concept and how to address it
Tagged: fact xbrl api
This topic contains 4 replies, has 2 voices, and was last updated by Teji Abraham 2 months, 3 weeks ago.
-
AuthorPosts
-
Tuesday, September 17, 2019 at 8:49 PM #151749
Hi David,
I have run into some cases where I get differing values for the exact same concept, with same ultimus value. Any idea why this happens and how to address it to return a single valid value? See example below:
Thanks much.For e.g for AAL, cik=0000006201, fiscal year=2017, concept: OperatingLeasesFutureMinimumPaymentsDueCurrent returns the data below with two different values.
"data": [ { "concept.local-name": "OperatingLeasesFutureMinimumPaymentsDueCurrent", "report.type": "10-K", "period.fiscal-period": "Y", "period.fiscal-year": 2017, "fact.value": "2555000000", "fact.ultimus": true }, { "concept.local-name": "OperatingLeasesFutureMinimumPaymentsDueCurrent", "report.type": "10-K", "period.fiscal-period": "Y", "period.fiscal-year": 2017, "fact.value": "2572000000", "fact.ultimus": true } ]
-
Tuesday, September 17, 2019 at 11:38 PM #151752
Teji – both values are valid; fact.id 195333267 is a dimensional fact of ConsolidatedEntitiesAxis / SubsidiariesMember (value = 2555000000).
Add fact.has-dimensions=false to your query to return non-dimensional facts.
-
Wednesday, September 18, 2019 at 12:23 AM #151753
Many thanks David – is there per chance a reference document where I can find info for a particular fact.id and also perhaps explains the difference between two facts that outwardly seem to share most characteristics ?
Thanks again, Teji -
Wednesday, September 18, 2019 at 4:55 PM #151833
Teji – you can wildcard fact.* as the attribute of fields parameter to get all details for facts.
CAVEAT: use this with fact.limit() to get a sample return; it’s not recommended as a default because performance will be bad with a broad query.
For this CIK look for all of the latest 2017 Year facts appearing in a 10-K and show all the details for each fact, with a limit on the number of facts at 10.
-
Wednesday, September 18, 2019 at 5:40 PM #151837
Sounds good, thanks again David
Teji -
AuthorPosts
You must be logged in to reply to this topic.
Search Forums
Recent Topics
-
Getting error – 'Bad or expired token'
by
Sriram Srinivasan
-
Retrieving Market Cap as a concept.local-name item from a report.id
by
Jason Mellone
-
Google Sheet – margin time series not working
by
Kevin Monahan
-
Why does XBRL return differing values for same concept and how to address it
by
Teji Abraham
-
Code for publicly traded companies
by
Tim Bui
Recent Replies
-
Getting error – 'Bad or expired token' 3 weeks, 4 days ago
-
Getting error – 'Bad or expired token' 3 weeks, 4 days ago
-
Getting started with the XBRL Google Sheet and add-on 1 month, 1 week ago
-
Getting started with the XBRL Google Sheet and add-on 1 month, 1 week ago
-
Retrieving Market Cap as a concept.local-name item from a report.id 1 month, 3 weeks ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Getting Started with Google Sheets
- Sample API Queries (works with Insomina) or Excel Power Query Template
these options require account provision
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.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at info@xbrl.us to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Who's using this free data?
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Upcoming XBRL US Events




Comment
You must be logged in to post a comment.