Departments API Example Calls
Different Query Options for Departments
Here are more examples of how to use the Departments API to query and get the result set you want.
This query will give you the departments with name=Marketing
https://<instance>.coupahost.com/api/departments?name=Marketing
This query will give you the departments updated by a particular user with Login = coupasupport
https://<instance>.coupahost.com/api/departments?created_by[login]=coupasupport
This query will give you all the expense reports created after Jan 1st 2007
https://<instance>.coupahost.com/api/departments?created_at[gt]=2007-01-01
Get Single Department
In this example, we queried for a single department with an ID of 1.
We did a GET to the URL:
https://<instance>.coupahost.com/api/departments/1
or
https://<instance>.coupahost.com/api/departments?id=1
<?xml version="1.0" encoding="UTF-8"?>
<department>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:00:48-07:00</created-at>
<updated-at type="datetime">2014-03-28T08:53:19-07:00</updated-at>
<name>Marketing</name>
<active type="boolean">true</active>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>upgrade@coupa.com</email>
<employee-number nil="true" />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<mycustom-userfield />
</created-by>
<updated-by>
<id type="integer">69</id>
<login>coupasupport+rohitdemo@coupa.com</login>
<email>coupasupport+rohitdemo@coupa.com</email>
<employee-number nil="true" />
<firstname>Integration</firstname>
<lastname>User</lastname>
<salesforce-id nil="true" />
<mycustom-userfield />
</updated-by>
</department>
Departments Create
In this example we are creating a Department. We are not using any Coupa system ID's for any of the reference objects.
We posted it to the URL:
https://<instance url>/api/departments/.
<?xml version="1.0" encoding="UTF-8"?>
<department>
<name>Marketing</name>
<active>false</active>
</department>
Departments Update
In these examples, we are updating a single Department record.
We did a PUT to the URL: https://instance.coupahost.com/api/departments/
<id>
For Example, to deactivate an existing department with ID 195
<?xml version="1.0" encoding="UTF-8"?>
<department>
<id>195</id>
<active>false</active>
</department>
For Example, to update the name of an existing department with ID 195
<?xml version="1.0" encoding="UTF-8"?>
<department>
<id>195</id>
<name>new name</name>
</department>