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
Fact Info"This 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? 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. Visit https://xbrl.us/benefits to learn about XBRL US Membership options to return more/all data for your queries.

Got questions or ideas? Post to the XBRL Data Community Discussion Forum - https://xbrl.us/xbrl-api-community
3
DisplayQuery Results
4
Specific Field Namereport.id
5
Display full query?
6
Full Queryhttps://api.xbrl.us/api/v1/fact/search?entity.cik=0001138723&concept.local-name=Assets&period.fiscal-period=Y&period.fiscal-year=2016,2015,2014&fields=report.id,entity.id,fact.decimals,fact.value,unit,entity.cik,report.filing-date,concept.local-name,entity.cik,entity.name,concept.local-name,fact.ultimus-index,fact.id,dimensions,dimensions.count,period.fiscal-year.sort(DESC),period.fiscal-period.sort(DESC)
7
8
9
10
Query Response
11
report.identity.idfact.decimalsfact.valueunitentity.cikreport.filing-dateconcept.local-nameentity.namefact.ultimus-indexfact.iddimensions
dimensions.count
period.fiscal-year
period.fiscal-period
12
1962631721-3469033000USD00011387232017-08-25AssetsACCURAY INC1158973924null02016Y
13
1862451721-3469033000USD00011387232017-05-05AssetsACCURAY INC2151140673null02016Y
14
1691221721-3469033000USD00011387232016-08-24AssetsACCURAY INC5133942370null02016Y
15
1776041721-3469033000USD00011387232017-02-03AssetsACCURAY INC3141024260null02016Y
16
1713671721-3469033000USD00011387232016-11-01AssetsACCURAY INC4135772258null02016Y
17
1496721721-3469971000USD00011387232016-02-01AssetsACCURAY INC3115385127null02015Y
18
1408881721-3469971000USD00011387232015-08-28AssetsACCURAY INC5108256090null02015Y
19
1440111721-3469971000USD00011387232015-11-05AssetsACCURAY INC4110950381null02015Y
20
1603121721-3466773000USD00011387232016-04-29AssetsACCURAY INC2127092143null02015Y
21
1691221721-3466773000USD00011387232016-08-24AssetsACCURAY INC1133942369null02015Y
22
1104011721-3495188000USD00011387232014-08-29AssetsACCURAY INC581089562null02014Y
23
1408881721-3495188000USD00011387232015-08-28AssetsACCURAY INC1108256089null02014Y
24
1291031721-3495188000USD00011387232015-05-07AssetsACCURAY INC299219127null02014Y
25
1189841721-3495188000USD00011387232015-02-06AssetsACCURAY INC388265039null02014Y
26
1146951721-3495188000USD00011387232014-11-07AssetsACCURAY INC484979592null02014Y
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...
Main menu