Home Forums The XBRL API Code for XRL API

Viewing 3 reply threads
  • Author
    • #192860
      Hasnain jaffery

      Hi David,
      Q: is it possible to see the SQL code behind any API?

    • #192923
      David Tauriello

      Hi Hasnain – we don’t currently publish these details publicly. If you can give me an idea of what specific XBRL API query you’re looking for details to, I’ll see what I can do to make this available.

    • #192924
      Hasnain jaffery

      Thanks David,
      I am just trying to get to establish the correct label link for any fact ID.
      Currently, I am using excel Add-on but I have to run this on a mass scale or do something more than what is provided, then I am lost.

    • #192959
      David Tauriello

      Hi Hasnain – if I understand correctly, you’re trying to display the human-readable label AND the corresponding fact value.

      If you know the dts.id and concept.id, you can pass these as /label/<em>dts.id</em>/search?concept.id= to get the label.text value.

      Take a look at the XBRL Statements and Disclosures template for Excel (be sure to unhide columns A-E and rows 1-4).

      IMPORTANT: the task pane in Excel is a very cut-down version of filter options available – keep our XBRL API documentation handy!

Viewing 3 reply threads
  • You must be logged in to reply to this topic.


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