XBRL API Sheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
Use the File menu to 'Make a copy...' in your Google account, then authorize the XBRL API Access Add-on and change the B2 dropdown to return data.
2
Select Query from Dropdown
Annual Assets for a CompanyThis file is a starting point for using the XBRL API with the XBRL US Public Database of Filings. After installing the XBRL API Access add-on - https://xbrl.us/xbrl-api-addon - to your Google Account, use the file menu to "Make a copy..." of this XBRL API Sheet file in your account, then follow the prompts to sign in and initialize the add-on under the Add-ons menu.

The 'Config' tab has preloaded queries that can be called by changing the dropdown menu in cell B1 of this 'Main Sheet' tab. Results appear on row 10 and below, using the function =showData(url). By default, the 'Display' is set to return queried data.

Main Sheet Options - Field Tree and Specific Field Name: Change cell B2 on this sheet to "Field Tree" to get a list of fields returned by the query. Use "Specific Field" with forward slashes to return data/details for "Specific Field Name" defined in cell B3. For example, select the query 'Selected US-GAAP 2018 concepts' to get 10 concepts (offset is explained below), then change the display to Field Tree to see what fields are returned. Type label/label.text in the Specific Field Name cell B3 (corresponding to the 'tree' location of the last returned data point for queried records) and change the Display to Specific Field to return only the label.text values for the query.

The 'BSCompare' tab on this file shows data returned and formatted into a very basic Balance Sheet for US GAAP filers.

Not getting all the results you expect? Visit https://xbrl.us/benefits to learn about XBRL US Membership options to return more/all data for your queries.

Non-members can return up to 1,000 records per query, 100 records per page. Use ENDPOINT.offset(INTEGER) in the fields parameter to return additional records that may exist for your query. For example, select the query 'AssetsCurrent for all filers (2015 - 2017)' from the dropdown and fact.offset(900) returns records starting with 900; change the parameter to 0 to see the first results returned (see documentation Section 7. Handling Paging for details).

The API documentation - https://xbrl.us/xbrl-api-documentation - outlines parameters and switches that can be used to update preloaded queries or create your own.
Got questions or ideas? Post to the XBRL Data Community Discussion Forum - https://xbrl.us/xbrl-api-community


3
DisplayQuery Results
4
Specific Field Namerelationship.target-name
5
Display full query?
6
Full Queryhttps://api.xbrl.us/api/v1/fact/search?entity.cik=0000320193&concept.local-name=Assets&fact.has-dimensions=false&fact.ultimus=true&period.fiscal-period=Y&fields=entity.name,fact.value,fact.decimals,unit,report.filing-date.sort(DESC),concept.local-name,period.fiscal-year,dts.id,report.sec-url
7
8
9
10
Query Response
11
entity.namefact.valuefact.decimalsunitreport.filing-date
concept.local-name
period.fiscal-yeardts.idreport.sec-url
12
Apple Inc.338516000000-6USD2020-05-01Assets2019382959
https://www.sec.gov/Archives/edgar/data/320193/000032019320000052/0000320193-20-000052-index.htm
13
Apple Inc.365725000000-6USD2019-10-31Assets2018348264
http://www.sec.gov/Archives/edgar/data/320193/000032019319000119/0000320193-19-000119-index.htm
14
APPLE INC375319000000-6USD2018-11-05Assets2017306447
http://www.sec.gov/Archives/edgar/data/320193/000032019318000145/0000320193-18-000145-index.htm
15
APPLE INC321686000000-6USD2017-11-03Assets2016267134
http://www.sec.gov/Archives/edgar/data/320193/000032019317000070/0000320193-17-000070-index.htm
16
APPLE INC290345000000-6USD2016-10-26Assets2015170749
http://www.sec.gov/Archives/edgar/data/320193/000162828016020309/0001628280-16-020309-index.htm
17
APPLE INC231839000000-6USD2015-10-28Assets2014142669
http://www.sec.gov/Archives/edgar/data/320193/000119312515356351/0001193125-15-356351-index.htm
18
APPLE INC207000000000-6USD2015-01-28Assets2013118521
http://www.sec.gov/Archives/edgar/data/320193/000119312515023732/0001193125-15-023732-index.htm
19
APPLE INC176064000000-6USD2013-10-30Assets201281024
http://www.sec.gov/Archives/edgar/data/320193/000119312513416534/0001193125-13-416534-index.htm
20
APPLE INC116371000000-6USD2013-04-24Assets201164572
http://www.sec.gov/Archives/edgar/data/320193/000119312513170623/0001193125-13-170623-index.htm
21
APPLE INC47501000000-6USD2011-10-26Assets200922881
http://www.sec.gov/Archives/edgar/data/320193/000119312511282113/0001193125-11-282113-index.htm
22
APPLE INC75183000000-6USD2011-10-26Assets201022881
http://www.sec.gov/Archives/edgar/data/320193/000119312511282113/0001193125-11-282113-index.htm
23
APPLE INC36171000000-6USD2010-10-27Assets200822877
http://www.sec.gov/Archives/edgar/data/320193/000119312510238044/0001193125-10-238044-index.htm
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...