CDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAM
1
1. Use 'Make a copy' in the file menu to create a version you can edit.
2. Under the Extensions menu choose Get Add-ons to search for and install XBRL API Access.
3. Use the Add-ons menu to authorize the XBRL API, then remove the * character from the formula in cell C3.
If the data doesn't appear after you've followed these instructions, use the troubleshooting information at https://xbrl.us/forums/topic/api-google-sheet/#troubleshooting.
5. Explore the queries using the dropdown in cell C2 on this tab, then move to the CompanyFacts tab and complete the activity to display the same data as in the image (solution).
2
Facts for 2018 from APPLE 10-Khttps://api.xbrl.us/api/v1/fact/search?dts.id=306447&period.fiscal-year=2018&fields=concept.local-name.sort(ASC),fact.decimals,fact.value,unit,entity.name,entity.cik,repot.filing-date,report.id,entity.id,fact.ultimus-index,fact.id,dimensions,dimensions.count,period.fiscal-year.sort(DESC),period.fiscal-period.sort(DESC)
3
4
*=showData(D2)
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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