Having double-checked the documentation (and run some never ending queries!), am I right in thinking that you cannot retrieve fact values directly with a ticker?
That you need to query the entity or report first to get an id to use in your fact request?
I guess confirming this?, I notice the google sheet exclusively uses CIK’s and where a ticker can be used as an input in BSCompare, a look up is made to a different url – https://csuite.xbrl.us (another API?).
Is this a better source of ticker/CIK mappings? If so, should we use this?
That said, I wouldn’t advise it for heavy lifting as it can be a bit slow, which is why we’re returning tickers with the legacy API in the BScompare template. When the other endpoints are sunset in December, this one will likely remain available for several months into 2019.
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.