Monday, March 23, 2020 at 11:06 PM #172604dulich vietParticipant
I ran the following query in Google Sheets
Why only the data for 3QCUM and Y are returned? It looks like the data for 1Q and 1H (except for 2016) are missing.
Thank you very much!
Tuesday, March 24, 2020 at 12:14 PM #172654David TaurielloKeymaster
Hi Dulich – please take a look at this post (and the full thread) for some information about calendar period vs. fiscal period. This may help explain why you’re not returning the details you think you should be seeing. Try this query:
https://api.xbrl.us/api/v1/fact/search?concept.local- name=NetCashProvidedByUsedInOperatingActivities&period.fiscal- period=1Q,1H,3QCUM,Y&period.year=2015,2016,2017,2018,2019& entity.cik=0000915840&fact.ultimus=true&fact.has-dimensions= false&fields=fact.numerical-value,period.year,period.fiscal-period, concept.local-name,period.end.sort(ASC)
- You must be logged in to reply to this topic.
Risk factors and other items from 10-Q&10-K filings 1 week, 1 day ago
Tackling issues with operating lease data 1 week, 6 days ago
How to get list of Subsidiaries for a company in a filing 2 weeks, 2 days ago
How to get list of Subsidiaries for a company in a filing 2 weeks, 6 days ago
How to get list of Subsidiaries for a company in a filing 3 weeks, 2 days ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- OR get access to data for your own app and/or our API Tools
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.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.