Home Forums The XBRL API Getting details for statements and disclosures

Viewing 1 reply thread
  • Author
    Posts
    • #192955
      Christian Yanes
      Participant

      Hi, I am trying to recreate a specific section of a 10-Q report by calling the api. For instance lets say I want to get all the facts that make up the “Condensed Consolidation Balance Sheet” section on the 10-Q report. What api calls should I consume to get the comprehensive set of facts making up this section of the report. Also if there is better way to do this different than finding the set of facts first and then retrieving those facats I am also interested.
      Thanks for you help

    • #192977
      David Tauriello
      Keymaster

      Hi Christian – thanks for writing; we posted Simple Statement and Disclosure template for Excel that uses /report /fact /relationship and /label queries to pull this information together.

      Take a look at the queries buried in hidden columns and rows A1:E4 of that .xlsx. In a nutshell:

      • /report (optional) – filing details like entity name, type of report and date filed (cell F7); you DO need a dts.id integer and can get this from this object
      • /fact – numerical value, year and period information for concepts in a specific part of the report
      • /relationship – filtered on the presentation linkbase* of the taxonomy, where the ‘face’ of the financials is stored
      • /label – the human readable value for taxonomy concepts that are associated with facts

      *remove this from the query to show facts from all linkbases (calculation, definition, label and presentation)

      IMPORTANT: an XBRL filing is made up of an instance document that contains all the facts, and a taxonomy that establishes the structures (linkbases) for those facts.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment

Upcoming XBRL US Events

Communications & Services Steering Committee Meeting
Tuesday, September 21, 2021

Center for Data Quality Committee Meeting
Wednesday, September 29, 2021

Domain Steering Committee Meeting
Thursday, October 7, 2021

XBRL Updates for FERC Filers – Get Ready Now
Wednesday, October 20, 2021

Working with SEC Data for Analysts
Monday, October 25, 2021

Investor Forum 2021: Data that Delivers
Wednesday, November 10, 2021