period.calendar-period data issue

[dulich viet]

I ran the following query in Google Sheets

=showData(“https://api.xbrl.us/api/v1/fact/search?&concept.local-name=NetCashProvidedByUsedInOperatingActivities&period.calendar-period=1Q,1H,3QCUM,Y&period.year=2015,2016,2017,2018,2019&entity.cik=0000915840&fact.ultimus=1&dimensions.count=0&fields=fact.numerical-value,period.year,period.calendar-period,concept.local-name,period.end.sort(ASC)”)

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!

[david.tauriello@xbrl.us]

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)

[Author]

Posts