Friday, December 21, 2018 at 1:03 PM #119046Tim BuiParticipant
I finally learned to use the API (of course through the patience and help from David and Peter) and all I can say is it’s an amazing system.
A question on the report.id number: does each company has one report.id (as the cik) or each financial statement has its own report.id number (different balance sheet of different years has its own report.id number)?
Secondly, is there anyway that we can query using pd Admin to get a list of ticker, cik and report.id?
- The forum ‘About XBRL US’ is closed to new topics and replies.
Signs for AccRec Change and Inventories Change are reversed 1 day, 9 hours ago
Entity's industry 4 days, 7 hours ago
Extraction and Interpretation of Operating Lease Data 2 weeks, 3 days ago
Duplicate information in instance document 3 weeks, 2 days ago
Extraction and Interpretation of Operating Lease Data 3 weeks, 4 days ago
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Interactive Documentation
- XBRL API Documentation (PDF)
- Get Started with Google Sheets
- OR request account provisioning to use Client ID and secret pairs in your app and:
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.
Ready to work with the API in Excel's Power Query, or with your own system or app?
Contact us at email@example.com to have your existing XBRL US Web account provisioned to generate client ID/Secret pairs to work with the XBRL API in a REST client or other application, including Excel's Power Query.
NOTE: You do not need to generate client ID/Secret pairs if you use the Google Add-on and Google Sheet exclusively to access data - the XBRL API Authentication Add-on handles this automatically.
Your account needs to be provisioned before you can login and generate client ID/secret pairs.
Login or register for a free account.
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table