Hi Jeff – the 303000000 values are not identical; one is for the US and one is Egypt, so the only way to show one of these facts is to add fact.limit(1) to the fields. Depending on how you structure the query, you may get a different fact (US or Egypt).
Here’s the entire OilReservesMember ‘story’ – I’ve sorted by fact.value so you can see US and Egypt easily:
At this level, you’ll need to rely on your application to filter out the unwanted results, or specify additional an additional filter on the fact (fact.id, fact.xml-id, fact.hash) so you get the exact fact you intend.
The report.sec-url is included in the results for this query, so you can open the inline filing, enter ‘303’ (no quotes) in the search and see these facts in the report.
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.
The national consortium for the business reporting standard
XBRL US is a not-for-profit organization supporting the implementation of digital business reporting standards through the development of taxonomies for use by U.S. public and private sectors, with a goal of interoperability between sectors, and by promoting XBRL adoption through marketplace collaboration.