Home Forums The XBRL API Data not returned

This topic contains 3 replies, has 2 voices, and was last updated by  Angelo Brizi 3 months, 1 week ago.

  • Author
    Posts
  • #120428

    Angelo Brizi
    Participant

    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.
    Thanks

  • #120467

    Angelo Brizi
    Participant

    the above query is not shown properly in the message above but is the following

    =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)”)

  • #120543

    David Tauriello
    Keymaster

    Hi Angelo – in the query below, I’m returning period.fiscal-period as part of the fields to show how the fact corresponds to reporting periods defined by the filer for their annual cycle, which does not always follow the 1/1 – 12/31 calendar.

    /fact/search?&concept.local-name=NetCashProvidedByUsedInOperatingActivities&period.fiscal-year=2015,2016,2017,2018,2019&entity.cik=0000915840&fact.ultimus=1&fact.has-dimensions=false&fields=period.end.sort(DESC),concept.local-name,fact.value,period.fiscal-period,period.calendar-period,period.fiscal-year,period.year

    If you replace the concept.local-name in the query with a US GAAP element in every filing called DocumentFiscalPeriodFocus the model for this filer’s fiscal year should become clear (10/1 – 9/30).

    See this discussion for more detail on periods, and check out the Balance Sheet Compare – SEC Filers Google Sheet for queries that translate the DocumentFiscalPeriodFocus for the presentation.

  • #120572

    Angelo Brizi
    Participant

    Thanks a lot for the detailed answer David. That was really helpful.
    Best regards,

    Angelo

You must be logged in to reply to this topic.

Comment