Rest api » History » Version 41
Jean-Philippe Lang, 2011-07-04 22:05
how to load multiple associations
1 | 26 | Jean-Philippe Lang | {{>toc}} |
---|---|---|---|
2 | |||
3 | 1 | Jean-Philippe Lang | h1. Redmine API |
4 | |||
5 | Redmine exposes some of its data through a REST API. This API provides access and basic CRUD operations (create, update, delete) for the resources described below. |
||
6 | |||
7 | h2. API Description |
||
8 | |||
9 | 24 | Jean-Philippe Lang | |_.Resource |_.Status |_.Notes |_.Availability| |
10 | |[[Rest_Issues|Issues]] | Beta | Usable with some bugs and rough edges. | 1.0 | |
||
11 | |[[Rest_Projects|Projects]] | Beta | Usable with some bugs and rough edges. | 1.0 | |
||
12 | 28 | Jean-Philippe Lang | |[[Rest_Users|Users]] | Beta | | 1.1 | |
13 | 39 | Jean-Philippe Lang | |[[Rest_TimeEntries|Time Entries]] | Beta | | 1.1 | |
14 | 28 | Jean-Philippe Lang | |[[Rest_News|News]] | Prototype | Prototype implementation for @index@ only | 1.1 | |
15 | 39 | Jean-Philippe Lang | |[[Rest_IssueRelations|Issue Relations]] | Beta | | 1.3 | |
16 | 40 | Jean-Philippe Lang | |[[Rest_Versions|Versions]] | Beta | | 1.3 | |
17 | 24 | Jean-Philippe Lang | |
18 | 15 | Eric Davis | Status legend: |
19 | 1 | Jean-Philippe Lang | |
20 | * Stable - feature complete, no major changes planned |
||
21 | * Beta - usable for integrations with some bugs or missing minor functionality |
||
22 | * Alpha - major functionality in place, needs feedback from API users and integrators |
||
23 | * Prototype - very rough implementation, possible major breaking changes mid-version. *Not recommended for integration* |
||
24 | * Planned - planned in a future version, depending on developer availability |
||
25 | |||
26 | 24 | Jean-Philippe Lang | h2. General topics |
27 | 1 | Jean-Philippe Lang | |
28 | 24 | Jean-Philippe Lang | h3. Authentication |
29 | |||
30 | Most of the time, the API requires authentication. To enable the API-style authentication, you have to check *Enable REST API* in Administration -> Settings -> Authentication. Then, authentication can be done in 2 different ways: |
||
31 | * using your regular login/password via HTTP Basic authentication. |
||
32 | 38 | Jean-Philippe Lang | * using your API key which is a handy way to avoid putting a password in a script. The API key may be attached to each request in one of the following way: |
33 | ** passed in as a "key" parameter |
||
34 | ** passed in as a username with a random password via HTTP Basic authentication |
||
35 | ** passed in as a "Redmine-API-Key" HTTP header (added in Redmine 1.1.0) |
||
36 | |||
37 | You can find your API key on your account page ( /my/account ) when logged in, on the right-hand pane of the default layout. |
||
38 | 24 | Jean-Philippe Lang | |
39 | h3. Collection resources and pagination |
||
40 | |||
41 | The response to a GET request on a collection ressources (eg. @/issues.xml@, @/users.xml@) generally won't return all the objets available in your database. Redmine version:1.1.0 introduces a common way to query such ressources using the following parameters: |
||
42 | |||
43 | * @offset@: the offset of the first object to retrieve |
||
44 | * @limit@: the number of items to be present in the response (default is 25, maximum is 100) |
||
45 | |||
46 | 25 | Jean-Philippe Lang | Alternatively, you can use the @page@ parameter, instead of @offset@, in conjunction with @limit@. |
47 | 24 | Jean-Philippe Lang | |
48 | Examples: |
||
49 | |||
50 | <pre> |
||
51 | GET /issues.xml |
||
52 | => returns the 25 first issues |
||
53 | |||
54 | GET /issues.xml?limit=100 |
||
55 | => returns the 100 first issues |
||
56 | |||
57 | GET /issues.xml?offset=30&limit=10 |
||
58 | => returns 10 issues from the 30th |
||
59 | |||
60 | GET /issues.xml?page=3&limit=10 |
||
61 | => same as above |
||
62 | </pre> |
||
63 | |||
64 | Responses to GET requests on collection ressources provide information about the total object count available in Redmine and the offset/limit used for the response. Examples: |
||
65 | |||
66 | <pre> |
||
67 | GET /issues.xml |
||
68 | |||
69 | <issues type="array" total_count="2595" limit="25" offset="0"> |
||
70 | ... |
||
71 | </issues> |
||
72 | </pre> |
||
73 | |||
74 | <pre> |
||
75 | GET /issues.json |
||
76 | |||
77 | { "issues":[...], "total_count":2595, "limit":25, "offset":0 } |
||
78 | </pre> |
||
79 | |||
80 | Note: if you're using a REST client that does not support such top level attributes (total_count, limit, offset), you can set the @nometa@ parameter or @X-Redmine-Nometa@ HTTP header to 1 to get responses without them. Example: |
||
81 | |||
82 | <pre> |
||
83 | GET /issues.xml?nometa=1 |
||
84 | |||
85 | <issues type="array"> |
||
86 | ... |
||
87 | </issues> |
||
88 | </pre> |
||
89 | 23 | Jean-Philippe Lang | |
90 | 29 | Etienne Massip | h3. Fetching associated data |
91 | |||
92 | Since of version:1.1.0, you have to explicitly specify the associations you want to be included in the query result by appending the @include@ parameter to the query url : |
||
93 | |||
94 | Example: |
||
95 | |||
96 | 41 | Jean-Philippe Lang | To retrieve issue journals with its description: |
97 | 29 | Etienne Massip | |
98 | <pre> |
||
99 | GET /issues/296.xml?include=journals |
||
100 | |||
101 | <issue> |
||
102 | <id>296</id> |
||
103 | 30 | Etienne Massip | ... |
104 | 29 | Etienne Massip | <journals type="array"> |
105 | ... |
||
106 | 1 | Jean-Philippe Lang | </journals> |
107 | 41 | Jean-Philippe Lang | </issue> |
108 | </pre> |
||
109 | |||
110 | You can also load multiple associations using a coma separated list of items. |
||
111 | |||
112 | Example: |
||
113 | |||
114 | <pre> |
||
115 | GET /issues/296.xml?include=journals,changesets |
||
116 | |||
117 | <issue> |
||
118 | <id>296</id> |
||
119 | ... |
||
120 | <journals type="array"> |
||
121 | ... |
||
122 | </journals> |
||
123 | <changesets type="array"> |
||
124 | ... |
||
125 | </changesets> |
||
126 | 29 | Etienne Massip | </issue> |
127 | </pre> |
||
128 | |||
129 | 1 | Jean-Philippe Lang | h2. API Usage in various languages/tools |
130 | 5 | Jean-Philippe Lang | |
131 | 1 | Jean-Philippe Lang | * [[Rest_api_with_ruby|Ruby]] |
132 | * [[Rest_api_with_php|PHP]] |
||
133 | 23 | Jean-Philippe Lang | * [[Rest_api_with_python|Python]] |
134 | 27 | Jean-Philippe Lang | * [[Rest_api_with_java|Java]] |
135 | 1 | Jean-Philippe Lang | * [[Rest_api_with_curl|cURL]] |
136 | 37 | Bevan Rudge | * "Drupal Redmine API module, 2.x branch (currently not stable)":http://drupal.org/project/redmine |