Monday, July 20, 2020 at 3:36 PM #184734Arthur OlevskiyParticipant
Sorry if it was asked already.
I use this endpoint to get concept.local-name and fact.value data:
Unfortunately, I didn’t figure out with following issues:
1. How I can get only facts from cash flow/income/balance sheet statement?
1.1 By the way, what parameters I can use for network.role-description= …
2. Can I get both facts base taxonomy and company specific taxonomy?
Thank you so much.
Tuesday, July 21, 2020 at 10:50 AM #184753David TaurielloKeymaster
Hi Arthur – please see https://xbrl.us/forums/topic/extracting-data-from-a-particular-financial-statement for how to get statement data. There’s also a Google Sheet template – https://xbrl.us/xbrl-api-explorer with queries that might be helpful.
network.role-descriptionparameter is a text field. It can be manipulated with a
stringmatchparameter using a couple of options (this needs to be added to our documentation):
- use like to find the string –
returns nothing because the string consolidate income doesn’t exist in this
network.role-description– remove one of the terms and you get results.
- use ts to find when each word in the string exists –
Last, unless you’re using the ‘concept.is-base’ parameter to filter facts, the query will return both base and extension concepts (see documentation https://xbrl.us/xbrl-api-documentation).
- use like to find the string –
Wednesday, July 22, 2020 at 6:26 PM #184795Arthur OlevskiyParticipant
Thank you David. It clarifies a lot.
By the way, using “stringmatch” can I exclude Disclosures and etc?
And I think last question. If I want to get fact of particular statement, can I put following values for “network.role-description”: consolidate income, cash flow and balance sheet, and it will be valid?
Thursday, August 6, 2020 at 5:35 PM #185238David TaurielloKeymaster
Arthur – sorry for the slow response. The stringmatch parameter is simple text only – no regex or wildcards are currently possible, so excluding results can be complex, especially given that the
network.role-descriptionis a user-defined field, with each company permitted to describe statements and disclosures as they see fit.
I hope by now you tried the query with multiple statements – IMO, you might get a closer approximation to face financials if you use (ts) with something like ‘statement balance cash income’ – ?
- You must be logged in to reply to this topic.
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- OR get access to data for your own app and/or our API Tools
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.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.