Try these in your RESTful interface or add them to the ‘Config’ tab of your copy of the XBRL Spreadsheet (Google Sheet linked at right):


Description Query string
Filing Results page queries /report/search?fields=report.id,report.entity-name,report.filing-date,report.base-taxonomy,report.document-type,report.accession,entity.ticker,report.sic-code,entity.cik,report.entry-type,report.period-end,report.sec-url,report.checks-run,report.accepted-timestamp.sort(DESC),report.limit(20),report.offset(0)

and

/assertion/search?fields=assertion.severity,assertion.type,assertion.code,
assertion.detail,report.id,report.filing-date,assertion.effective_date&assertion.source=DQC&
report.id={list-of-report-ids}*

* returned from /report query
XBRL API page query /report/fact/search?report.document-type=10-K&report.is-most-current=true&concept.local-name=CashAndCashEquivalentsAtCarryingValue,LiabilitiesAnd
StockholdersEquity,RetainedEarningsAccumulatedDeficit
&fact.has-dimensions=false&period.fiscal-year=2019&fields=report.accepted-timestamp.sort(DESC),concept.local-name.sort(ASC),entity.cik,fact.value,fact.decimals,period.instant,
report.creation-software,report.document-type,report.entity-name,report.entry-type,report.sec-url,report.limit(2)
Last 20 filings using the IFRS Taxonomy (2017) /report/search?report.is-most-current=true&fields=report.*,report.limit(10),report.accepted-timestamp.sort(DESC)&report.base-taxonomy=IFRS%202017
Look up the first role where the element Cash appears in the 2018 US GAAP Taxonomy /relationship/search?dts.id=292503&network.link-name=presentationLink&relationship.target-name=Cash&fields=network.role-description.sort(ASC),relationship.limit(1)
Facts in a filing using an extension member /fact/search?report.id=207773&fields=fact.numerical-value,entity.cik,report.filing-date,concept.local-name,entity.cik,entity.name,concept.local-name,fact.ultimus-index,dimensions.count,period.fiscal-year,period.fiscal-period,report.sic-code,fact.limit(10),period.calendar-period,dimension.is-base,member.local-name&member.is-base=false
Get concept details for the concept Assets in the 2018 US GAAP Taxonomy /concept/Assets/search?dts.id=292503&fields=concept.*,label.text,reference.*,parts.local-name,parts.part-value
Company filing size and software/service (2017 10-K) /report/search?report.document-type=10-K&report.period-year=2017&fields=report.filer-category,report.entity-name,entity.cik,report.creation-software
Non-dimensional monetary facts for 2018 in Apple’s 10-K filing for 2018 /fact/search?entity.cik=0000320193&period.fiscal-year=2018&report.type=10-K&fields=concept.local-name.sort(ASC),concept.namespace,fact.*,fact.offset(0)

Learn about using ENDPOINT.offset(0) to return additional records

Comment

Using Data

XBRL API Resources

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 info@xbrl.us 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.

Who's using this free data?

API Use 2019 || API Use 2018

Join XBRL US

XBRL Data Events

Upcoming: