Tuesday, October 30, 2018 at 12:20 PM #114392
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?
Wednesday, October 31, 2018 at 9:19 PM #114719
you can search on
entity.tickerto return facts, see
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.
Thursday, November 1, 2018 at 5:54 AM #114754
I am not sure it will work much quicker, but you could also use:
in Google Sheets where cell D2 contains your ticker.
You must be logged in to reply to this topic.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Getting Started with Google API Access
- Sample Queries (Insomina REST client) - requires account provision