申請書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を使用していません。参照線は金額ベースの線です。
<b id="i12"><a id="x13" xid="i22.1.1">URL []に</a></b>投稿しました。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を使用していません。申請品目はカタログアイテムに基づいています。単位、価格、サプライヤーなどを渡す代わりに、アイテム名を渡すだけで、ユーザーインターフェースを介して行うのと同じように、システムがアイテムに基づいてすべてをデフォルト設定することに気づくでしょう。
<b id="i13"><a id="x14" xid="i25.1.1">URL [[]に</a></b>投稿しました。これにより、申請書がドラフト状態になりました。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を使用していません。申請品目は数量ベースの品目です。
<b id="i14"><a id="x15" xid="i28.1.1">URL [[]に</a></b>投稿しました。これにより、申請書がドラフト状態になりました。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 <b id="i15"><a id="x16" xid="i31.1.1">[[]に</a></b>送信しました。申請書が作成され、承認を受けるために送信されました。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を使用して請求を作成する方法について説明します。
申請書作成APIを使用すると、次のことができます。
1.指定されたユーザーのドラフトモードで申請書を作成する
2.指定されたユーザーの代わりに承認申請を作成して送信します。
新規申請をPOSTできる2つのURLがあります:
<instance url>/api/requisitions
-これによりドラフト状態の申請書が作成されます。その後、手動で提出する必要があります。<instance url>/api/requisitions/new/submit_for_approval
-申請書が作成され、承認/購入者のアクションのために申請が試行されます。
どちらの場合も、申請書を保存するには有効で提出可能である必要があります。具体的には、次の要素が必須です。
- 少なくとも1つの請求品目
- 各品目の説明またはアイテム
- 各項目の通貨
- 数量基準品目の数量
- 必須のカスタムフィールド
- すべてのカスタム検証に合格する必要があります
リクエストが成功すると、HTTP 201 Createdが返されます。返答の本文には、作成された申請書が含まれます。
失敗した要求はHTTP 400 Bad Requestを返します。応答の本文には、XML形式の検証エラーが含まれます。
クーパ14
クーパ13
Coupa 13フラットファイル統合マッピングExcelファイルが必要な場合はダウンロードしてください。
参照されるオブジェクト
このAPIは、呼び出しの一部として次のオブジェクトのみを作成します。
- 申請書ヘッダー
- 申請書の品目
- テキスト添付
- URL添付
他のすべての参照オブジェクト(UOM、アイテム、ユーザー、サプライヤー、アカウント、住所、Pカードなど)は、システムにすでに存在している必要があります。
以下は、参照されるオブジェクトのリストと、API呼び出しの一部としてオブジェクトを検索する代替メソッドの方法です。たとえば、申請者のユーザーを指定するときに、ユーザーのID、ログイン、またはメールアドレスを含めると、システムがそれらを検索します。それらを複数含む必要はありません。複数の検索条件が使用されている場合、レコードを正しく検索するには、すべてが一致する必要があります。クリックして [1] CoupaのAPIを使用してクエリを実行する方法の説明と例と手順についてはこちらを。
参照オブジェクト | 検索基準オプション |
申請者 | login |
メールアドレス | |
CoupaユーザーID | |
部署 | name |
Coupa部門ID | |
ship_to_address | ニックネーム |
Coupa住所ID | |
サプライヤー | name |
CoupaサプライヤーID | |
勘定科目タイプ(勘定科目表) | name |
Coupa勘定科目表ID | |
勘定科目コード | |
CoupaアカウントID | |
通貨 | 通貨コード |
Coupa通貨ID | |
数量単位 | code |
Coupa UOM ID | |
payment-term | code |
Coupa支払条件ID | |
発送期間 | code |
Coupa発送条件ID | |
商品 | name |
Coupa商品ID |
フィールド定義
名前 | 必須か? | タイプ | 許容値 | Description |
justification | no | テキスト | 2000文字 | これは、購入が行われた理由を説明するために利用できる申請の正当性フィールドです。 |
添付テキスト | no | テキスト | 2000文字 | これらは、申請書内で通信できるテキストベースの添付ファイルです。 |
添付URL | no | テキスト | 50文字 | これらは、申請書で連絡したいへのURLロケーションを提供しています。 |
description | はい | テキスト | 255文字 | これは、カタログ項目を使用しない場合の品目の説明です。 |
line-num | はい | 整数 | 整数のみ | これは、申請中の申請品目の品目番号です。これは、提出される申請書項目ごとに1ずつ増加する必要があります。 |
source-part-num | いいえ | テキスト | 255文字 | これはサプライヤーの部品番号で、デフォルトでは要求品目のオプションフィールドです。 |
単価 | はい | decimal型 | あなたの精度に基づきます。 | 数量ベースのラインの場合、これは各ユニットの単価です。金額ベースのラインの場合、これは合計サービスの値です。 |
need-by-date | no | 日時 | Datetimne形式 | |
数量 | いいえ | 整数 | UOMの精度設定に基づく | これは数量ベースのラインにのみ使用されます。 |
メモ
- 申請書項目では、説明(自由形式)またはアイテム(カタログアイテム)のいずれかを使用できます。アイテムIDが使用される場合、アイテムは存在しなければなりません。の<source-type></source-type>は使用されず、無視されます。
- 通貨、申請者のユーザー、およびサプライヤーは、ステータスが 有効のシステムに存在する必要があります。
- アイテム:希望するサプライヤーと価格がアイテムで利用可能な場合、単価が指定されていない限り、それが使用されます。単価が指定されている場合、アイテムで利用可能なデフォルトの価格設定が上書きされます。説明とアイテムを指定することはエラーではありませんが、アイテムを使用すると、渡された説明フィールドを無視して、説明がアイテム説明に設定されます。
- 既定値:XMLで特に指定されていない限り、システムはシステム内の関連する既定値を尊重します。サプライヤーレコードからの支払や出荷条件のデフォルトなど。
- 行番号付け:APIは、行番号が新しい行番号ごとに1つ増えることを期待します。同じ行番号を使用すると、システムは同じ番号の他のすべての行を無視します。