Home Forums The XBRL API period.calendar-period data issue

Viewing 1 reply thread
  • Author
    Posts
    • #172604
      Anonymous
      Inactive

      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!

    • #172654
      David Tauriello
      Keymaster

      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)
Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Upcoming XBRL US Events

Domain Steering Committee Meeting
Tuesday, July 15, 2025

Communications & Services Steering Committee Meeting
Tuesday, July 15, 2025

SEC Filing Fee Requirements – Phase 1 Lessons Learned
Wednesday, July 16, 2025

EDGAR Next Enrollment – Lessons Learned & Special Situations
Wednesday, July 23, 2025

GovFin 2025: Designing a Digital Future
Thursday, July 31, 2025