Project

General

Profile

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