Sunday, July 25, 2021 at 3:43 AM #192860Hasnain jafferyParticipant
Q: is it possible to see the SQL code behind any API?
Wednesday, July 28, 2021 at 10:45 AM #192923David TaurielloKeymaster
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.
Wednesday, July 28, 2021 at 11:09 AM #192924Hasnain jafferyParticipant
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.
Thursday, July 29, 2021 at 5:54 PM #192959David TaurielloKeymaster
Hi Hasnain – if I understand correctly, you’re trying to display the human-readable label AND the corresponding fact value.
If you know the
concept.id, you can pass these as
/label/<em>dts.id</em>/search?concept.id=to get the
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!
- You must be logged in to reply to this topic.
Documentation & Discussion
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.