Home Forums The XBRL API Code for XRL API

Viewing 3 reply threads
  • Author
    Posts
    • #192860
      Hasnain jaffery
      Participant

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

    • #192923
      David Tauriello
      Keymaster

      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
      Participant

      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.
      thanks,
      Regards,
      Hasnain

    • #192959
      David Tauriello
      Keymaster

      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.

Comment

Upcoming XBRL US Events

Center for Data Quality Committee Meeting
Wednesday, March 23, 2022