申請書APIコールの例
申請書クエリの例 – 特定のユーザーによるクエリ
この例では、「ejohnson」のログインでユーザーが作成した申請書を探しています。以下のログインパラメーターをメールまたは従業員番号に簡単に置き換えることができます
- HTTP GET
https://<instance>.coupahost.com/api/requisitions?requested-by[login]=<login>
この場合https://<instance>.coupahost.com/api/requisitions?requested-by[login]=ejohnson
<?xml version="1.0" encoding="UTF-8"?>
<requisition-headers type="array">
<requisition-header>
<id type="integer">97</id>
<created-at type="datetime">2009-04-27T09:27:56-07:00</created-at>
<updated-at type="datetime">2009-04-27T09:27:56-07:00</updated-at>
<buyer-note nil="true" />
<justification nil="true" />
<need-by-date nil="true" />
<reject-reason-comment nil="true" />
<status>draft</status>
<submitted-at nil="true" />
<exported type="boolean">false</exported>
<ship-to-attention>Ellis (Marketing Lead) Johnson</ship-to-attention>
<total type="decimal">20575.00</total>
<height-passthrough />
<custom-attach />
<custom-field-3 />
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<department>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:00:48-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:20:29-07:00</updated-at>
<name>Marketing</name>
<active type="boolean">true</active>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</department>
<requested-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</requested-by>
<ship-to-address>
<id type="integer">16</id>
<created-at type="datetime">2008-10-27T13:00:19-07:00</created-at>
<updated-at type="datetime">2009-07-11T13:33:25-07:00</updated-at>
<name>HQ</name>
<street1>28 Nevada Blvd</street1>
<street2 />
<city>Laughlin</city>
<state>NV</state>
<postal-code>89028</postal-code>
<attention />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</ship-to-address>
<attachments type="array" />
<requisition-lines type="array">
<requisition-line>
<id type="integer">179</id>
<created-at type="datetime">2009-04-27T09:27:56-07:00</created-at>
<updated-at type="datetime">2009-04-27T09:27:57-07:00</updated-at>
<description>Facility Rental for 8 hours</description>
<line-num type="integer">1</line-num>
<need-by-date nil="true" />
<order-line-id nil="true" />
<quantity type="float">8.0</quantity>
<source-part-num />
<status nil="true" />
<sub-line-num nil="true" />
<supp-aux-part-num nil="true" />
<total type="decimal">16400.00</total>
<source-type>Non-Catalog Request</source-type>
<line-type>RequisitionQuantityLine</line-type>
<unit-price type="decimal">2050.00</unit-price>
<account>
<id type="integer">164</id>
<created-at type="datetime">2009-05-04T22:06:02-07:00</created-at>
<updated-at type="datetime">2009-05-05T23:23:54-07:00</updated-at>
<name>HQ -Marketing, Events</name>
<code>HQ-Marketing-Events</code>
<active type="boolean">true</active>
<segment-1>HQ</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Events</segment-3>
<segment-4 />
<segment-5 />
<segment-6 />
<segment-7 />
<segment-8 />
<segment-9 />
<segment-10 />
<segment-11 />
<segment-12 />
<segment-13 />
<segment-14 />
<segment-15 />
<segment-16 />
<segment-17 />
<segment-18 />
<segment-19 />
<segment-20 />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">10</id>
<login>amanning</login>
<email>upgrade+am@coupa.com</email>
<employee-number />
<firstname>Anna (AP Director)</firstname>
<lastname>Manning</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</account>
<account-allocations type="array" />
<commodity>
<id type="integer">7</id>
<created-at type="datetime">2008-10-27T13:04:00-07:00</created-at>
<updated-at type="datetime">2011-04-12T14:08:22-07:00</updated-at>
<active type="boolean">false</active>
<name>Marketing-Services</name>
<acct />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</commodity>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<supplier>
<id type="integer">25</id>
<name>Aston's Hotel</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">27</id>
<created-at type="datetime">2008-12-09T13:08:11-08:00</created-at>
<updated-at type="datetime">2011-07-25T16:49:07-07:00</updated-at>
<email />
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Sanae</name-given>
<name-family>Kadomoto</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">33</id>
<created-at type="datetime">2008-12-09T13:08:11-08:00</created-at>
<updated-at type="datetime">2011-07-25T16:49:07-07:00</updated-at>
<name>Aston's Hotel</name>
<street1>3615 Lower Honoapiilani Road</street1>
<street2 />
<city>Lahaina</city>
<state>HI</state>
<postal-code>96761</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-address>
</supplier>
<uom>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>EA</code>
<name>Each</name>
<allowable-precision type="integer">0</allowable-precision>
<active type="boolean">true</active>
</uom>
<payment-term>
<id type="integer">3</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>2/10 Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment type="integer">10</days-for-discount-payment>
<discount-rate type="float">2.0</discount-rate>
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
<requisition-line>
<id type="integer">180</id>
<created-at type="datetime">2009-04-27T09:27:56-07:00</created-at>
<updated-at type="datetime">2009-04-27T09:27:57-07:00</updated-at>
<description>Ice Sculpture</description>
<line-num type="integer">2</line-num>
<need-by-date nil="true" />
<order-line-id nil="true" />
<source-part-num />
<status nil="true" />
<sub-line-num nil="true" />
<supp-aux-part-num nil="true" />
<total type="decimal">1500.00</total>
<source-type>Non-Catalog Request</source-type>
<line-type>RequisitionAmountLine</line-type>
<unit-price type="decimal">1500.00</unit-price>
<account>
<id type="integer">164</id>
<created-at type="datetime">2009-05-04T22:06:02-07:00</created-at>
<updated-at type="datetime">2009-05-05T23:23:54-07:00</updated-at>
<name>HQ -Marketing, Events</name>
<code>HQ-Marketing-Events</code>
<active type="boolean">true</active>
<segment-1>HQ</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Events</segment-3>
<segment-4 />
<segment-5 />
<segment-6 />
<segment-7 />
<segment-8 />
<segment-9 />
<segment-10 />
<segment-11 />
<segment-12 />
<segment-13 />
<segment-14 />
<segment-15 />
<segment-16 />
<segment-17 />
<segment-18 />
<segment-19 />
<segment-20 />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">10</id>
<login>amanning</login>
<email>upgrade+am@coupa.com</email>
<employee-number />
<firstname>Anna (AP Director)</firstname>
<lastname>Manning</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</account>
<account-allocations type="array" />
<commodity>
<id type="integer">7</id>
<created-at type="datetime">2008-10-27T13:04:00-07:00</created-at>
<updated-at type="datetime">2011-04-12T14:08:22-07:00</updated-at>
<active type="boolean">false</active>
<name>Marketing-Services</name>
<acct />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</commodity>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<supplier>
<id type="integer">25</id>
<name>Aston's Hotel</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">27</id>
<created-at type="datetime">2008-12-09T13:08:11-08:00</created-at>
<updated-at type="datetime">2011-07-25T16:49:07-07:00</updated-at>
<email />
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Sanae</name-given>
<name-family>Kadomoto</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">33</id>
<created-at type="datetime">2008-12-09T13:08:11-08:00</created-at>
<updated-at type="datetime">2011-07-25T16:49:07-07:00</updated-at>
<name>Aston's Hotel</name>
<street1>3615 Lower Honoapiilani Road</street1>
<street2 />
<city>Lahaina</city>
<state>HI</state>
<postal-code>96761</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-address>
</supplier>
<payment-term>
<id type="integer">3</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>2/10 Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment type="integer">10</days-for-discount-payment>
<discount-rate type="float">2.0</discount-rate>
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
<requisition-line>
<id type="integer">181</id>
<created-at type="datetime">2009-04-27T09:27:56-07:00</created-at>
<updated-at type="datetime">2009-04-27T09:27:58-07:00</updated-at>
<description>Food from Cheung</description>
<line-num type="integer">3</line-num>
<need-by-date nil="true" />
<order-line-id nil="true" />
<source-part-num />
<status nil="true" />
<sub-line-num nil="true" />
<supp-aux-part-num nil="true" />
<total type="decimal">2675.00</total>
<source-type>Non-Catalog Request</source-type>
<line-type>RequisitionAmountLine</line-type>
<unit-price type="decimal">2675.00</unit-price>
<account>
<id type="integer">164</id>
<created-at type="datetime">2009-05-04T22:06:02-07:00</created-at>
<updated-at type="datetime">2009-05-05T23:23:54-07:00</updated-at>
<name>HQ -Marketing, Events</name>
<code>HQ-Marketing-Events</code>
<active type="boolean">true</active>
<segment-1>HQ</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Events</segment-3>
<segment-4 />
<segment-5 />
<segment-6 />
<segment-7 />
<segment-8 />
<segment-9 />
<segment-10 />
<segment-11 />
<segment-12 />
<segment-13 />
<segment-14 />
<segment-15 />
<segment-16 />
<segment-17 />
<segment-18 />
<segment-19 />
<segment-20 />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">10</id>
<login>amanning</login>
<email>upgrade+am@coupa.com</email>
<employee-number />
<firstname>Anna (AP Director)</firstname>
<lastname>Manning</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</account>
<account-allocations type="array" />
<commodity>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:03:59-07:00</created-at>
<updated-at type="datetime">2011-04-12T14:58:18-07:00</updated-at>
<active type="boolean">true</active>
<name>Labor</name>
<acct>Temp Labor</acct>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</commodity>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<supplier>
<id type="integer">24</id>
<name>Cheung Catering</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">26</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<email />
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Conway</name-given>
<name-family>Cheung</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<phone-work>
<id type="integer">67</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-work>
<phone-mobile>
<id type="integer">68</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-mobile>
<phone-fax>
<id type="integer">69</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-fax>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">32</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<name>Cheung Catering</name>
<street1>2516 Pacific Coast Hwy</street1>
<street2 />
<city>Hermosa Beach</city>
<state>CA</state>
<postal-code>90254</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</primary-address>
</supplier>
<payment-term>
<id type="integer">3</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>2/10 Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment type="integer">10</days-for-discount-payment>
<discount-rate type="float">2.0</discount-rate>
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
</requisition-lines>
<approvals type="array">
<approval>
<id type="integer">480</id>
<created-at nil="true" />
<updated-at nil="true" />
<position type="integer">1</position>
<approval-chain-id nil="true" />
<status>pending_approval</status>
<approval-date nil="true" />
<note nil="true" />
<type>ManagementHierarchyApproval</type>
<approvable-type>RequisitionHeader</approvable-type>
<approvable-id type="integer">97</approvable-id>
<approver>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</approver>
</approval>
</approvals>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-header>
<requisition-header>
<id type="integer">99</id>
<created-at type="datetime">2009-04-27T09:41:52-07:00</created-at>
<updated-at type="datetime">2009-05-11T11:39:23-07:00</updated-at>
<buyer-note nil="true" />
<justification>Blair -this is for the Q2 marketing offsite you wanted me to setup. I kept it under 25k so it fits within your budget.</justification>
<need-by-date nil="true" />
<reject-reason-comment nil="true" />
<status>ordered</status>
<submitted-at type="datetime">2009-05-11T11:38:58-07:00</submitted-at>
<exported type="boolean">false</exported>
<ship-to-attention>Ellis (Marketing Lead) Johnson</ship-to-attention>
<total type="decimal">22500.00</total>
<height-passthrough />
<custom-attach />
<custom-field-3 />
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<department>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:00:48-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:20:29-07:00</updated-at>
<name>Marketing</name>
<active type="boolean">true</active>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</department>
<requested-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</requested-by>
<ship-to-address>
<id type="integer">16</id>
<created-at type="datetime">2008-10-27T13:00:19-07:00</created-at>
<updated-at type="datetime">2009-07-11T13:33:25-07:00</updated-at>
<name>HQ</name>
<street1>28 Nevada Blvd</street1>
<street2 />
<city>Laughlin</city>
<state>NV</state>
<postal-code>89028</postal-code>
<attention />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</ship-to-address>
<attachments type="array" />
<requisition-lines type="array">
<requisition-line>
<id type="integer">219</id>
<created-at type="datetime">2009-05-10T21:22:32-07:00</created-at>
<updated-at type="datetime">2009-05-11T11:39:19-07:00</updated-at>
<description>Facility Rental for Q2 Marketing Offsite</description>
<line-num type="integer">1</line-num>
<need-by-date type="datetime">2009-05-11T00:00:00-07:00</need-by-date>
<order-line-id type="integer">127</order-line-id>
<quantity type="float">8.0</quantity>
<source-part-num />
<status nil="true" />
<sub-line-num nil="true" />
<supp-aux-part-num nil="true" />
<total type="decimal">16000.00</total>
<source-type>Non-Catalog Request</source-type>
<line-type>RequisitionQuantityLine</line-type>
<unit-price type="decimal">2000.00</unit-price>
<account>
<id type="integer">182</id>
<created-at type="datetime">2009-05-10T21:22:32-07:00</created-at>
<updated-at type="datetime">2009-06-29T19:38:09-07:00</updated-at>
<name nil="true" />
<code>HQ-Marketing-Events</code>
<active type="boolean">false</active>
<segment-1>HQ</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Events</segment-3>
<segment-4 nil="true" />
<segment-5 nil="true" />
<segment-6 nil="true" />
<segment-7 nil="true" />
<segment-8 nil="true" />
<segment-9 nil="true" />
<segment-10 nil="true" />
<segment-11 nil="true" />
<segment-12 nil="true" />
<segment-13 nil="true" />
<segment-14 nil="true" />
<segment-15 nil="true" />
<segment-16 nil="true" />
<segment-17 nil="true" />
<segment-18 nil="true" />
<segment-19 nil="true" />
<segment-20 nil="true" />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account>
<account-allocations type="array" />
<commodity>
<id type="integer">5</id>
<created-at type="datetime">2008-10-27T13:04:00-07:00</created-at>
<updated-at type="datetime">2011-08-25T06:43:41-07:00</updated-at>
<active type="boolean">true</active>
<name>Facilities</name>
<acct>98765</acct>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</commodity>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<supplier>
<id type="integer">19</id>
<name>Metro Gateway Center</name>
<number>233434</number>
<supplier-diversity />
<primary-contact>
<id type="integer">20</id>
<created-at type="datetime">2009-05-04T18:08:08-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:08:08-07:00</updated-at>
<email>regus.berry@metro.com</email>
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Regus</name-given>
<name-family>Berry</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<phone-work>
<id type="integer">47</id>
<created-at type="datetime">2009-05-04T18:08:08-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:08:08-07:00</updated-at>
<country-code>1</country-code>
<area-code>650</area-code>
<number>2321991</number>
<extension nil="true" />
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-work>
<phone-mobile>
<id type="integer">48</id>
<created-at type="datetime">2009-05-04T18:08:08-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:08:08-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-mobile>
<phone-fax>
<id type="integer">49</id>
<created-at type="datetime">2009-05-04T18:08:08-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:08:08-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-fax>
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">26</id>
<created-at type="datetime">2009-05-04T18:08:09-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:08:09-07:00</updated-at>
<name>Metro Gateway Center</name>
<street1>239 Blizzard Drive</street1>
<street2 />
<city>San Francisco</city>
<state>CA</state>
<postal-code>92302</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</primary-address>
</supplier>
<uom>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>EA</code>
<name>Each</name>
<allowable-precision type="integer">0</allowable-precision>
<active type="boolean">true</active>
</uom>
<payment-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment nil="true" />
<discount-rate nil="true" />
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
<requisition-line>
<id type="integer">222</id>
<created-at type="datetime">2009-05-10T21:35:45-07:00</created-at>
<updated-at type="datetime">2009-05-11T11:39:21-07:00</updated-at>
<description>Catering and Cleaning services for Q2 Marketing Offiste</description>
<line-num type="integer">2</line-num>
<need-by-date type="datetime">2009-05-11T00:00:00-07:00</need-by-date>
<order-line-id type="integer">128</order-line-id>
<source-part-num />
<status nil="true" />
<sub-line-num nil="true" />
<supp-aux-part-num nil="true" />
<total type="decimal">6500.00</total>
<source-type>Non-Catalog Request</source-type>
<line-type>RequisitionAmountLine</line-type>
<unit-price type="decimal">6500.00</unit-price>
<account>
<id type="integer">182</id>
<created-at type="datetime">2009-05-10T21:22:32-07:00</created-at>
<updated-at type="datetime">2009-06-29T19:38:09-07:00</updated-at>
<name nil="true" />
<code>HQ-Marketing-Events</code>
<active type="boolean">false</active>
<segment-1>HQ</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Events</segment-3>
<segment-4 nil="true" />
<segment-5 nil="true" />
<segment-6 nil="true" />
<segment-7 nil="true" />
<segment-8 nil="true" />
<segment-9 nil="true" />
<segment-10 nil="true" />
<segment-11 nil="true" />
<segment-12 nil="true" />
<segment-13 nil="true" />
<segment-14 nil="true" />
<segment-15 nil="true" />
<segment-16 nil="true" />
<segment-17 nil="true" />
<segment-18 nil="true" />
<segment-19 nil="true" />
<segment-20 nil="true" />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account>
<account-allocations type="array" />
<commodity>
<id type="integer">5</id>
<created-at type="datetime">2008-10-27T13:04:00-07:00</created-at>
<updated-at type="datetime">2011-08-25T06:43:41-07:00</updated-at>
<active type="boolean">true</active>
<name>Facilities</name>
<acct>98765</acct>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</commodity>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<supplier>
<id type="integer">24</id>
<name>Cheung Catering</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">26</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<email />
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Conway</name-given>
<name-family>Cheung</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<phone-work>
<id type="integer">67</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-work>
<phone-mobile>
<id type="integer">68</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-mobile>
<phone-fax>
<id type="integer">69</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<country-code>1</country-code>
<area-code nil="true" />
<number />
<extension nil="true" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-fax>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">32</id>
<created-at type="datetime">2008-12-09T12:56:47-08:00</created-at>
<updated-at type="datetime">2009-08-13T14:30:23-07:00</updated-at>
<name>Cheung Catering</name>
<street1>2516 Pacific Coast Hwy</street1>
<street2 />
<city>Hermosa Beach</city>
<state>CA</state>
<postal-code>90254</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</primary-address>
</supplier>
<payment-term>
<id type="integer">3</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>2/10 Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment type="integer">10</days-for-discount-payment>
<discount-rate type="float">2.0</discount-rate>
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
</requisition-lines>
<approvals type="array">
<approval>
<id type="integer">562</id>
<created-at nil="true" />
<updated-at nil="true" />
<position type="integer">1</position>
<approval-chain-id nil="true" />
<status>approved</status>
<approval-date type="datetime">2009-05-11T11:39:19-07:00</approval-date>
<note nil="true" />
<type>ManagementHierarchyApproval</type>
<approvable-type>RequisitionHeader</approvable-type>
<approvable-id type="integer">99</approvable-id>
<approver>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</approver>
</approval>
</approvals>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-header>
</requisition-headers>
申請書クエリの例 – ステータスが注文済みで、日付範囲内で作成された申請書をクエリします
この例では、ステータスが[注文済み作成済み]の申請書を2つの日付間で検索しています。
このレコードをクエリするには2つの方法があります。以下を使用できます。
- HTTP GET
https://<instance>.coupahost.com/api/requisitions?status=<status>&created-at[gt]=<date>&created-at[lt]=<date>
この場合https
://<instance>.coupahost.com/api/requisitions?status=ordered&created-at[gt]=2010-01-01&created-at[lt]=2010-02-01
<?xml version="1.0" encoding="UTF-8"?>
<requisition-headers type="array">
<requisition-header>
<id type="integer">187</id>
<created-at type="datetime">2010-01-06T13:26:54-08:00</created-at>
<updated-at type="datetime">2010-02-09T10:26:39-08:00</updated-at>
<buyer-note nil="true" />
<justification />
<need-by-date nil="true" />
<reject-reason-comment nil="true" />
<status>ordered</status>
<submitted-at type="datetime">2010-02-09T10:26:14-08:00</submitted-at>
<exported type="boolean">false</exported>
<ship-to-attention>Blair (Marketing VP) Hostler</ship-to-attention>
<total type="decimal">750.00</total>
<height-passthrough />
<custom-attach />
<custom-field-3 />
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<department>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:00:48-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:20:29-07:00</updated-at>
<name>Marketing</name>
<active type="boolean">true</active>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</department>
<requested-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</requested-by>
<ship-to-address>
<id type="integer">16</id>
<created-at type="datetime">2008-10-27T13:00:19-07:00</created-at>
<updated-at type="datetime">2009-07-11T13:33:25-07:00</updated-at>
<name>HQ</name>
<street1>28 Nevada Blvd</street1>
<street2 />
<city>Laughlin</city>
<state>NV</state>
<postal-code>89028</postal-code>
<attention />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</ship-to-address>
<attachments type="array" />
<requisition-lines type="array">
<requisition-line>
<id type="integer">588</id>
<created-at type="datetime">2010-02-09T10:25:56-08:00</created-at>
<updated-at type="datetime">2010-02-09T10:26:37-08:00</updated-at>
<description>Ads</description>
<line-num type="integer">1</line-num>
<need-by-date nil="true" />
<order-line-id type="integer">340</order-line-id>
<quantity type="float">1.0</quantity>
<source-part-num nil="true" />
<status>draft</status>
<sub-line-num nil="true" />
<supp-aux-part-num nil="true" />
<total type="decimal">750.00</total>
<source-type>Web Form</source-type>
<line-type>RequisitionQuantityLine</line-type>
<unit-price type="decimal">750.00</unit-price>
<account>
<id type="integer">14</id>
<created-at type="datetime">2008-10-27T13:20:36-07:00</created-at>
<updated-at type="datetime">2011-09-22T16:25:23-07:00</updated-at>
<name>San Francisco -Marketing, Assets</name>
<code>SF-Marketing-Assets</code>
<active type="boolean">true</active>
<segment-1>SF</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Assets</segment-3>
<segment-4 />
<segment-5 />
<segment-6 />
<segment-7 />
<segment-8 />
<segment-9 />
<segment-10 />
<segment-11 />
<segment-12 />
<segment-13 />
<segment-14 />
<segment-15 />
<segment-16 />
<segment-17 />
<segment-18 />
<segment-19 />
<segment-20 />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">17</id>
<login>coupa_metrics_gatherer</login>
<email>do_not_reply_metrics@coupa.com</email>
<employee-number nil="true" />
<firstname>Coupa</firstname>
<lastname>Metrics</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</account>
<account-allocations type="array" />
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<form-response type="array">
<prompt-response>
<responses type="array">
<response>Advertising</response>
</responses>
<prompt>Type of Marketing Request</prompt>
</prompt-response>
<prompt-response>
<responses type="array">
<response>Ad in Local papers</response>
</responses>
<prompt>Description</prompt>
</prompt-response>
</form-response>
<supplier>
<id type="integer">15</id>
<name>Omniture Marketing Services</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">16</id>
<created-at type="datetime">2008-10-27T14:04:45-07:00</created-at>
<updated-at type="datetime">2008-10-27T14:04:45-07:00</updated-at>
<email>upgrade@coupa.com</email>
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Brad</name-given>
<name-family>Franklin</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<phone-work>
<id type="integer">16</id>
<created-at type="datetime">2008-10-27T14:04:45-07:00</created-at>
<updated-at type="datetime">2009-08-12T17:01:02-07:00</updated-at>
<country-code>1</country-code>
<area-code>650</area-code>
<number>5856306</number>
<extension nil="true" />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-work>
<phone-mobile>
<id type="integer">17</id>
<created-at type="datetime">2008-10-27T14:04:45-07:00</created-at>
<updated-at type="datetime">2009-08-12T17:01:02-07:00</updated-at>
<country-code>1</country-code>
<area-code>650</area-code>
<number>5856306</number>
<extension nil="true" />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-mobile>
<phone-fax>
<id type="integer">18</id>
<created-at type="datetime">2008-10-27T14:04:45-07:00</created-at>
<updated-at type="datetime">2009-08-12T17:01:02-07:00</updated-at>
<country-code>1</country-code>
<area-code>650</area-code>
<number>5856306</number>
<extension nil="true" />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</phone-fax>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">19</id>
<created-at type="datetime">2008-10-27T14:04:45-07:00</created-at>
<updated-at type="datetime">2008-10-27T14:04:45-07:00</updated-at>
<name>Omniture Marketing Services</name>
<street1>2200 Old Germantown Road</street1>
<street2 />
<city>Redwood City</city>
<state>CA</state>
<postal-code>94402</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-address>
</supplier>
<uom>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>EA</code>
<name>Each</name>
<allowable-precision type="integer">0</allowable-precision>
<active type="boolean">true</active>
</uom>
<payment-term>
<id type="integer">3</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>2/10 Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment type="integer">10</days-for-discount-payment>
<discount-rate type="float">2.0</discount-rate>
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">2</id>
<login>mjordan</login>
<email>upgrade+mj@coupa.com</email>
<employee-number />
<firstname>Meg (CEO)</firstname>
<lastname>Jordan</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
</requisition-lines>
<approvals type="array">
<approval>
<id type="integer">1704</id>
<created-at nil="true" />
<updated-at nil="true" />
<position type="integer">1</position>
<approval-chain-id nil="true" />
<status>approved</status>
<approval-date type="datetime">2010-02-09T10:26:37-08:00</approval-date>
<note nil="true" />
<type>ManagementHierarchyApproval</type>
<approvable-type>RequisitionHeader</approvable-type>
<approvable-id type="integer">187</approvable-id>
<approver>
<id type="integer">2</id>
<login>mjordan</login>
<email>upgrade+mj@coupa.com</email>
<employee-number />
<firstname>Meg (CEO)</firstname>
<lastname>Jordan</lastname>
<salesforce-id nil="true" />
<height />
</approver>
</approval>
</approvals>
<created-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">2</id>
<login>mjordan</login>
<email>upgrade+mj@coupa.com</email>
<employee-number />
<firstname>Meg (CEO)</firstname>
<lastname>Jordan</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-header>
</requisition-headers>
申請書クエリの例 – 特定の申請書をクエリする
この例では、申請書を探しています #235。これは、この申請書に対してCoupaが自動的に生成した番号であり、このレコードのCoupa IDとしても機能します。
このレコードをクエリするには2つの方法があります。以下を使用できます。
- 形式1:
https://<instance>.coupahost.com/api/requisitions/<id>
この場合https://<instance>.coupahost.com/api/requisitions/235
出力は以下のとおりです。 - 形式2:
https://<instance>.coupahost.com/api/requisitions?id=<id>
この場合https://<instance>.coupahost.com/api/requisitions?id=235
このフォーマットを使用した出力には若干の違いがあります。 以下に<requisition-header>
示すタグはルート要素ではありません。 代わりに、<requisition-headers type="array">
<?xml version="1.0" encoding="UTF-8"?>
<requisition-header>
<id type="integer">235</id>
<created-at type="datetime">2010-02-06T19:03:50-08:00</created-at>
<updated-at type="datetime">2010-02-06T19:07:50-08:00</updated-at>
<buyer-note nil="true" />
<justification />
<need-by-date nil="true" />
<reject-reason-comment nil="true" />
<status>ordered</status>
<submitted-at type="datetime">2010-02-06T19:05:25-08:00</submitted-at>
<exported type="boolean">false</exported>
<ship-to-attention>Ellis (Marketing Lead) Johnson</ship-to-attention>
<total type="decimal">22.56</total>
<height-passthrough />
<custom-attach />
<custom-field-3 />
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<department>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:00:48-07:00</created-at>
<updated-at type="datetime">2009-05-04T18:20:29-07:00</updated-at>
<name>Marketing</name>
<active type="boolean">true</active>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</department>
<requested-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</requested-by>
<ship-to-address>
<id type="integer">14</id>
<created-at type="datetime">2008-10-27T12:58:55-07:00</created-at>
<updated-at type="datetime">2010-03-23T21:03:22-07:00</updated-at>
<name>San Francisco Office</name>
<street1>150 Main Street</street1>
<street2 />
<city>San Francisco</city>
<state>CA</state>
<postal-code>94450</postal-code>
<attention />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</ship-to-address>
<attachments type="array" />
<requisition-lines type="array">
<requisition-line>
<id type="integer">573</id>
<created-at type="datetime">2010-02-06T19:05:12-08:00</created-at>
<updated-at type="datetime">2010-02-06T19:07:48-08:00</updated-at>
<description>Standard Battery, Battery Type Alkaline, Battery Size C, Voltage 1.5, Package Quantity 6</description>
<line-num type="integer">1</line-num>
<need-by-date nil="true" />
<order-line-id type="integer">330</order-line-id>
<quantity type="float">2.0</quantity>
<source-part-num>3WA31</source-part-num>
<status nil="true" />
<sub-line-num nil="true" />
<supp-aux-part-num>WWG3WA31</supp-aux-part-num>
<total type="decimal">22.56</total>
<source-type>Punchout</source-type>
<line-type>RequisitionQuantityLine</line-type>
<unit-price type="decimal">11.28</unit-price>
<account>
<id type="integer">50</id>
<created-at type="datetime">2009-05-04T17:45:26-07:00</created-at>
<updated-at type="datetime">2009-05-05T23:23:31-07:00</updated-at>
<name>San Francisco -Marketing, Marketing Services</name>
<code>SF-Marketing-Marketing Services</code>
<active type="boolean">true</active>
<segment-1>SF</segment-1>
<segment-2>Marketing</segment-2>
<segment-3>Marketing Services</segment-3>
<segment-4 />
<segment-5 />
<segment-6 />
<segment-7 />
<segment-8 />
<segment-9 />
<segment-10 />
<segment-11 />
<segment-12 />
<segment-13 />
<segment-14 />
<segment-15 />
<segment-16 />
<segment-17 />
<segment-18 />
<segment-19 />
<segment-20 />
<account-type>
<id type="integer">1</id>
<created-at type="datetime">2008-10-27T13:10:01-07:00</created-at>
<updated-at type="datetime">2011-09-01T11:57:27-07:00</updated-at>
<name>Ace Corporate</name>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</account-type>
<created-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</created-by>
<updated-by>
<id type="integer">10</id>
<login>amanning</login>
<email>upgrade+am@coupa.com</email>
<employee-number />
<firstname>Anna (AP Director)</firstname>
<lastname>Manning</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</account>
<account-allocations type="array" />
<contract>
<id type="integer">7</id>
<created-at type="datetime">2009-04-16T19:09:26-07:00</created-at>
<updated-at type="datetime">2010-02-17T14:56:47-08:00</updated-at>
<name>Grainger</name>
<number>5</number>
<version nil="true" />
<start-date type="datetime">2009-04-16T00:00:00-07:00</start-date>
<end-date type="datetime">2010-04-16T00:00:00-07:00</end-date>
<status>inactive</status>
<minimum-value type="decimal">0.00</minimum-value>
<maximum-value type="decimal">0.00</maximum-value>
<terms nil="true" />
<preferred nil="true" />
<savings-pct type="decimal">8.0</savings-pct>
<min-commit type="decimal">0.00</min-commit>
<max-commit type="decimal">0.00</max-commit>
<supplier-invoiceable type="boolean">false</supplier-invoiceable>
<is-default type="boolean">false</is-default>
<supplier>
<id type="integer">9</id>
<name>Grainger</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">9</id>
<created-at type="datetime">2008-10-27T12:56:40-07:00</created-at>
<updated-at type="datetime">2008-10-27T12:56:40-07:00</updated-at>
<email>upgrade@coupa.com</email>
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Ben</name-given>
<name-family>Miller</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">9</id>
<created-at type="datetime">2008-10-27T12:56:40-07:00</created-at>
<updated-at type="datetime">2008-10-27T12:56:40-07:00</updated-at>
<name nil="true" />
<street1>1 Grainger Road</street1>
<street2 nil="true" />
<city>Newark</city>
<state>NJ</state>
<postal-code>92321</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-address>
</supplier>
<content-groups type="array">
<content-group>
<id type="integer">1</id>
<created-at type="datetime">2006-08-27T19:40:04-07:00</created-at>
<updated-at type="datetime">2008-10-27T13:00:19-07:00</updated-at>
<name>Global</name>
<description>Default business group that all users have access to</description>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</content-group>
</content-groups>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">16</id>
<login>administrator</login>
<email>jonathan.fear@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<lastname>Eisner</lastname>
<salesforce-id nil="true" />
<height>hello,,,,</height>
</updated-by>
</contract>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<supplier>
<id type="integer">9</id>
<name>Grainger</name>
<number nil="true" />
<supplier-diversity />
<primary-contact>
<id type="integer">9</id>
<created-at type="datetime">2008-10-27T12:56:40-07:00</created-at>
<updated-at type="datetime">2008-10-27T12:56:40-07:00</updated-at>
<email>upgrade@coupa.com</email>
<name-prefix nil="true" />
<name-suffix nil="true" />
<name-additional nil="true" />
<name-given>Ben</name-given>
<name-family>Miller</name-family>
<name-fullname nil="true" />
<notes nil="true" />
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-contact>
<primary-address>
<id type="integer">9</id>
<created-at type="datetime">2008-10-27T12:56:40-07:00</created-at>
<updated-at type="datetime">2008-10-27T12:56:40-07:00</updated-at>
<name nil="true" />
<street1>1 Grainger Road</street1>
<street2 nil="true" />
<city>Newark</city>
<state>NJ</state>
<postal-code>92321</postal-code>
<attention nil="true" />
<active type="boolean">true</active>
<country>
<id type="integer">223</id>
<code>US</code>
<name>United States</name>
</country>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>robert.monahon+feardemo@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</primary-address>
</supplier>
<uom>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>EA</code>
<name>Each</name>
<allowable-precision type="integer">0</allowable-precision>
<active type="boolean">true</active>
</uom>
<payment-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Net 30</code>
<description />
<days-for-net-payment type="integer">30</days-for-net-payment>
<days-for-discount-payment nil="true" />
<discount-rate nil="true" />
<active type="boolean">true</active>
</payment-term>
<shipping-term>
<id type="integer">1</id>
<created-at nil="true" />
<updated-at nil="true" />
<code>Standard</code>
</shipping-term>
<asset-tags type="array" />
<attachments type="array" />
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-line>
</requisition-lines>
<approvals type="array">
<approval>
<id type="integer">1672</id>
<created-at nil="true" />
<updated-at nil="true" />
<position type="integer">1</position>
<approval-chain-id nil="true" />
<status>approved</status>
<approval-date type="datetime">2010-02-06T19:07:48-08:00</approval-date>
<note nil="true" />
<type>ManagementHierarchyApproval</type>
<approvable-type>RequisitionHeader</approvable-type>
<approvable-id type="integer">235</approvable-id>
<approver>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</approver>
</approval>
</approvals>
<created-by>
<id type="integer">7</id>
<login>ejohnson</login>
<email>upgrade+ej@coupa.com</email>
<employee-number />
<firstname>Ellis (Marketing Lead)</firstname>
<lastname>Johnson</lastname>
<salesforce-id nil="true" />
<height />
</created-by>
<updated-by>
<id type="integer">6</id>
<login>bhostler</login>
<email>upgrade+bh@coupa.com</email>
<employee-number />
<firstname>Blair (Marketing VP)</firstname>
<lastname>Hostler</lastname>
<salesforce-id nil="true" />
<height />
</updated-by>
</requisition-header>
申請書の作成 – 金額ベースの品目の例
この例では、ユーザー「kyle」のドラフト申請書を作成しています。参照オブジェクトにCoupaシステムIDは使用していません。参照品目は金額ベースの品目です。
URL:に投稿しましたhttps://<instance>.coupahost.com/api/requisitions
。 これにより、申請書はドラフトステータスになりました。
<?xml version="1.0" encoding="UTF-8"?>
<requisition-header>
<requested-by>
<login>kyle</login>
</requested-by>
<department>
<name>Marketing</name>
</department>
<pcard />
<ship-to-address>
<name>Headquarters</name>
</ship-to-address>
<justification />
<attachments />
<requisition-lines>
<requisition-line>
<description>Cleaning Services for Building A</description>
<line-num type="integer">1</line-num>
<need-by-date type="datetime">2010-09-23T00:00:00-07:00</need-by-date>
<source-part-num />
<supp-aux-part-num />
<unit-price type="decimal">3000.00</unit-price>
<supplier>
<name>Maintenance Mart</name>
</supplier>
<account>
<code>Cleaning Services</code>
<account-type>
<name>Chart of Accounts</name>
</account-type>
</account>
<currency>
<code>USD</code>
</currency>
<payment-term>
<code>Net30</code>
</payment-term>
<shipping-term>
<code>UPS</code>
</shipping-term>
<commodity>
<name>Consulting Services</name>
</commodity>
</requisition-line>
</requisition-lines>
</requisition-header>
申請書作成の例 – カタログアイテム
この例では、ユーザー「kyle」のドラフト申請書を作成しています。参照オブジェクトにCoupaシステムIDは使用していません。申請書の品目はカタログアイテムに基づいています。UOM、価格、サプライヤーなどを渡す代わりに、アイテム名を渡すだけで、システムはユーザーインターフェイスを介して行うのと同じように、アイテムに基づいてすべてをデフォルト設定します。
URLに投稿しました:これにより申請https://<instance>.coupahost.com/api/requisitions.
書がドラフトステータスで作成されました。
<?xml version="1.0" encoding="UTF-8"?>
<requisition-header>
<requested-by>
<login>kyle</login>
</requested-by>
<department>
<name>Marketing</name>
</department>
<pcard />
<ship-to-address>
<name>Headquarters</name>
</ship-to-address>
<justification />
<attachments />
<requisition-lines>
<requisition-line>
<item>
<name>Window Cleaner</name>
</item>
<line-num type="integer">1</line-num>
<need-by-date type="datetime">2010-09-23T00:00:00-07:00</need-by-date>
<account>
<code>Cleaning Services</code>
<account-type>
<name>Chart of Accounts</name>
</account-type>
</account>
</requisition-line>
</requisition-lines>
</requisition-header>
申請書の作成 – 数量ベースの品目の例
この例では、ユーザー「kyle」のドラフト申請書を作成しています。参照オブジェクトにCoupaシステムIDは使用していません。申請書の品目は数量ベースの品目です。
URLに投稿しました:これにより申請https://<instance>.coupahost.com/api/requisitions.
書がドラフトステータスで作成されました。
<?xml version="1.0" encoding="UTF-8"?>
<requisition-header>
<requested-by>
<login>kyle</login>
</requested-by>
<department>
<name>Marketing</name>
</department>
<pcard />
<ship-to-address>
<name>Headquarters</name>
</ship-to-address>
<justification />
<attachments />
<requisition-lines>
<requisition-line>
<description>New Projector Bulbs</description>
<line-num type="integer">1</line-num>
<need-by-date type="datetime">2010-07-23T00:00:00-07:00</need-by-date>
<source-part-num />
<supp-aux-part-num />
<unit-price type="decimal">3000.00</unit-price>
<quantity>2</quantity>
<uom>
<code>EA</code>
</uom>
<supplier>
<name>Maintenance Mart</name>
</supplier>
<account>
<code>Cleaning Services</code>
<account-type>
<name>Chart of Accounts</name>
</account-type>
</account>
<currency>
<code>USD</code>
</currency>
<payment-term>
<code>Net30</code>
</payment-term>
<shipping-term>
<code>UPS</code>
</shipping-term>
<commodity>
<name>Consulting Services</name>
</commodity>
</requisition-line>
</requisition-lines>
</requisition-header>
申請書の作成例 – 複数品目の申請書
この例では、ユーザー「kyle」の申請書を作成して送信しています。参照オブジェクトにCoupaシステムIDは使用していません。申請書には、数量品目、金額品目、カタログ品目の3つの品目があります。
URLに投稿しました:これは承認 https://<instance>.coupahost.com/api/requisitions/new/submit_for_approval.
を得るために申請書を作成して送信しました。
<?xml version="1.0" encoding="UTF-8"?>
<requisition-header>
<requested-by>
<login>kyle</login>
</requested-by>
<department>
<name>Marketing</name>
</department>
<pcard />
<ship-to-address>
<name>Headquarters</name>
</ship-to-address>
<justification />
<attachments />
<requisition-lines>
<requisition-line>
<description>New Projector Bulbs</description>
<line-num type="integer">1</line-num>
<need-by-date type="datetime">2010-07-23T00:00:00-07:00</need-by-date>
<source-part-num />
<supp-aux-part-num />
<unit-price type="decimal">3000.00</unit-price>
<quantity>2</quantity>
<uom>
<code>EA</code>
</uom>
<supplier>
<name>Maintenance Mart</name>
</supplier>
<account>
<code>Cleaning Services</code>
<account-type>
<name>Chart of Accounts</name>
</account-type>
</account>
<currency>
<code>USD</code>
</currency>
<payment-term>
<code>Net30</code>
</payment-term>
<shipping-term>
<code>UPS</code>
</shipping-term>
<commodity>
<name>Consulting Services</name>
</commodity>
</requisition-line>
<requisition-line>
<description>Cleaning Services for Building A</description>
<line-num type="integer">2</line-num>
<need-by-date type="datetime">2010-09-23T00:00:00-07:00</need-by-date>
<source-part-num />
<supp-aux-part-num />
<unit-price type="decimal">3000.00</unit-price>
<supplier>
<name>Maintenance Mart</name>
</supplier>
<account>
<code>Cleaning Services</code>
<account-type>
<name>Chart of Accounts</name>
</account-type>
</account>
<currency>
<code>USD</code>
</currency>
<payment-term>
<code>Net30</code>
</payment-term>
<shipping-term>
<code>UPS</code>
</shipping-term>
<commodity>
<name>Consulting Services</name>
</commodity>
</requisition-line>
<requisition-line>
<item>
<name>Window Cleaner</name>
</item>
<line-num type="integer">3</line-num>
<need-by-date type="datetime">2010-09-23T00:00:00-07:00</need-by-date>
<account>
<code>Cleaning Services</code>
<account-type>
<name>Chart of Accounts</name>
</account-type>
</account>
</requisition-line>
</requisition-lines>
</requisition-header>
申請書GET(クエリ)
申請書POST
概要
以下は、Coupa APIを使用して申請書を作成する方法について説明します。
Coupaの申請書作成APIを使用すると、次のことができます。
1.指定されたユーザーのドラフトモードで申請書を作成する
2.指定されたユーザーの代わりに承認を得るために申請書を作成して送信します。
新しい申請書をPOSTできるURLが2つあります。
<instance url>/api/requisitions
– これにより、ドラフト状態の申請書が作成されます。その後、手動で送信する必要があります。<instance url>/api/requisitions/new/submit_for_approval
– これにより、申請書が作成され、承認/購入者のアクションのために送信されます。
どちらの場合も、保存するには申請書が有効で送信可能である必要があります。具体的には、次の要素が必要です。
- 1つ以上の申請品目
- 各項目の説明またはアイテム
- 品目ごとの通貨
- 数量ベース品目の数量
- 必須のカスタムフィールド
- すべてのカスタム検証が合格する必要があります
成功したリクエストは「HTTP 201 Created」を返します。回答の本文には、作成された申請書が含まれます。
失敗したリクエストはHTTP 400 Bad Requestを返します。応答の本文には、XMLとしてフォーマットされた検証エラーが含まれます。
Coupa 14
Coupa 13
Coupa 13フラットファイルインテグレーションマッピングExcelファイルがまだ必要な場合は、ダウンロードしてください。
参照オブジェクト
このAPIは、コールの一部として次のオブジェクトのみを作成します。
- 申請書ヘッダー
- 申請書の品目
- テキスト添付
- URL添付
他のすべての参照オブジェクト(UOM、アイテム、ユーザー、サプライヤー、アカウント、住所、Pカードなど)がシステムにすでに存在している必要があります。
以下は、参照オブジェクトのリストと、APIコールの一部としてオブジェクトを検索する代替方法です。たとえば、申請者ユーザーを指定する場合、ユーザーのID、ログイン、またはメールアドレスを含めると、システムが検索します。複数を含める必要はありません。複数の検索条件を使用する場合、レコードを正常に検索するには、すべての条件が一致する必要があります。Coupa APIを使用してクエリを実行する方法の手順と例、手順については、ここをクリックしてくださ い 。
参照オブジェクト | 検索基準オプション |
申請者 | login |
メールアドレス | |
CoupaユーザーID | |
部署 | name |
Coupaの部署ID | |
発送先住所 | ニックネーム |
Coupaの住所ID | |
サプライヤー | name |
CoupaサプライヤーID | |
勘定科目タイプ(勘定科目表) | name |
Coupa勘定科目表ID | |
勘定科目コード | |
CoupaアカウントID | |
通貨 | 通貨コード |
Coupaの通貨ID | |
数量単位 | code |
Coupa UOM ID | |
支払条件 | code |
Coupa支払条件ID | |
配送条件 | code |
Coupa発送条件ID | |
商品 | name |
Coupa商品ID |
フィールド定義
名前 | 必須か? | タイプ | 許容値 | Description |
理由 | no | テキスト | 2,000文字 | これは、購入理由を説明するために使用できる申請書の理由フィールドです。 |
添付ファイル(テキスト) | no | テキスト | 2,000文字 | これらは、申請書内で通信できるテキストベースの添付ファイルです。 |
添付ファイル(url) | no | テキスト | 500文字 | これらは、申請書で連絡するURLの場所をに提供します。 |
description | はい | テキスト | 255文字 | カタログアイテムを使用していない場合、これは品目アイテムの説明です。 |
line-num | はい | 整数 | 整数のみ | これは、渡している申請書の品目の品目番号です。これは、提出される申請書の品目ごとに1ずつ増加する必要があります。 |
source-part-num | いいえ | テキスト | 255文字 | これは、既定で申請書の品目のオプションフィールドであるサプライヤーの品番です。 |
単価 | はい | decimal型 | 御社の精度に基づきます。 | 数量ベースの品目の場合、これは各単位の単価です。金額ベースの品目の場合、これはサービス合計の値です。 |
need-by-date | no | 日時 | 日付フォーマット | |
数量 | いいえ | 整数 | 数量単位の精度設定に基づく | これは数量ベースの品目にのみ使用されます。 |
メモ
- 申請書の品目では、説明(フリーフォーム)またはアイテム(カタログアイテム)を使用できます。アイテムIDが使用される場合、そのアイテムは存在する必要があります。
は使用されず、無視されます。 - 通貨、申請者およびサプライヤーのユーザーは、ステータスが有効であるシステム内である必要があ ります。
- アイテム:推奨サプライヤーと価格がアイテムで利用可能な場合、単価が指定されていない限り、それが使用されます。単価を指定すると、アイテムで利用可能な既定の価格が上書きされます。説明とアイテムを指定することはエラーではありませんが、アイテムを使用すると、渡された説明フィールドを無視して、説明がアイテムの説明に設定されます。
- デフォルト設定:XMLで特に指定されていない限り、システムはシステム内の関連するデフォルト設定を優先します。サプライヤー記録からの支払条件や配送条件の既定値の設定など。
- 項目番号:APIは、新しい項目番号ごとに項目番号が1ずつ増加することを想定しています。同じline-numを使用すると、同じ番号の他のすべての項目が無視されます。
このページに表示されている一部、または全ての内容は、機械翻訳によるものです。ご了承ください。