Exemples d'appels de l'API INVOICE
Différentes options de requête pour les factures
Voici d'autres exemples d'utilisation de l'API de facturation pour interroger et obtenir le jeu de résultats souhaité.
Cette requête renverra toutes les factures avec CDW comme fournisseur :
https ://<instance>.coupahost.com/api/invoices?supplier[name]=CDW
Cette requête renverra toutes les factures avec l'euro comme devise :
https ://<instance>.coupahost.com/api/invoices?currency[code]=EUR
Cette requête renverra toutes les factures créées après le 1er janvier 2010 12:00:00 :
https ://<instance>.coupahost.com/api/invoices?invoice-date[gt]=2010-01-01T12:00:00
OBTENIR UNE facture unique
Dans cet exemple, nous avons demandé un seul enregistrement de facture avec un ID de 1.
Nous avons accédé À l'URL :
https ://<instance>.coupahost.com/api/invoices/1
ou
https ://<instance>.coupahost.com/api/invoices?id=1
<?xml version="1.0" encoding="UTF-8"?>
<invoice-header>
<comments />
<created-at type="datetime">2008-10-28T11:19:49-07:00</created-at>
<handling-amount type="decimal">0,0</handling-amount>
<id type="integer">1</id>
<internal-note />
<invoice-date type="datetime">2008-10-28T00:00:00-07:00</invoice-date>
<invoice-number type="integer">500</invoice-number>
<line-level-taxation type="boolean">faux</line-level-taxation>
<misc-amount type="decimal">0,0</misc-amount>
<shipping-amount type="decimal">0,0</shipping-amount>
<status>approuvé</status>
<supplier-note />
<tax-amount type="decimal">35,14</tax-amount>
<tax-rate type="float">8,25</tax-rate>
<updated-at type="datetime">2008-10-28T11:24:44-07:00</updated-at>
<paid type="boolean">faux</paid>
<payment-date type="datetime" />
<payment-notes />
<exported type="boolean">faux</exported>
<invoice-description type="string" />
<account-type>
<id type="integer">1</id>
<name>Ace Corporate</name>
</account-type>
<created-by>
<email>upgrade+am@coupa.com</email>
<employee-number />
<firstname>Anna (directrice de l'AP)</firstname>
<id type="integer">10</id>
<lastname>Manning</lastname>
<login>amanning</login>
</created-by>
<currency>
<code>USD</code>
<id type="integer">1</id>
</currency>
<supplier>
<id type="integer">17</id>
<name>Aperçus</name>
<number nil="true" />
<primary-contact>
<email>upgrade@coupa.com</email>
<id type="integer">18</id>
<name-additional nil="true" />
<name-family>Henderson</name-family>
<name-fullname nil="true" />
<name-given>Steve</name-given>
<name-prefix nil="true" />
<name-suffix nil="true" />
<notes nil="true" />
<phone-work>
<area-code>650</area-code>
<country-code>1</country-code>
<extension nil="true" />
<number>5856306</number>
</phone-work>
<phone-mobile>
<area-code>650</area-code>
<country-code>1</country-code>
<extension nil="true" />
<number>5856306</number>
</phone-mobile>
<phone-fax>
<area-code>650</area-code>
<country-code>1</country-code>
<extension nil="true" />
<number>5856306</number>
</phone-fax>
</primary-contact>
<primary-address>
<attention nil="true" />
<city>Tempe</city>
<id type="integer">24</id>
<name>Aperçus</name>
<postal-code>85283</postal-code>
<state>AZ</state>
<street1>6820 South Harl Avenue</street1>
<street2 />
<country>
<code>États-Unis</code>
<id type="integer">223</id>
<name>États-Unis</name>
</country>
</primary-address>
</supplier>
<tax-code>
<code>CA</code>
<id type="integer">1</id>
</tax-code>
<updated-by>
<email>upgrade+cj@coupa.com</email>
<employee-number />
<firstname>Carl (réception centrale)</firstname>
<id type="integer">11</id>
<lastname>Johnson</lastname>
<login>cjohnson</login>
</updated-by>
<attachments />
<invoice-lines>
<invoice-line>
<accounting-total type="decimal">425,99</accounting-total>
<created-at type="datetime">2008-10-28T11:19:49-07:00</created-at>
<description>Forfait complet Adobe Acrobat Professional ( v. 9 )</description>
<id type="integer">1</id>
<line-num type="integer">1</line-num>
<order-header-num type="integer">7</order-header-num>
<order-line-id type="integer">10</order-line-id>
<order-line-num type="integer">1</order-line-num>
<price type="decimal">425,99</price>
<quantity type="float">1,0</quantity>
<status>mis en correspondance</status>
<tax-rate type="float" />
<tax-location />
<tax-amount type="decimal">0,00</tax-amount>
<tax-description />
<tax-supply-date type="datetime" />
<total type="decimal">425,99</total>
<type>InvoiceQuantityLine</type>
<updated-at type="datetime">2008-10-28T11:24:44-07:00</updated-at>
<treasury-codes type="string" />
<account>
<active type="boolean">true</active>
<code>SF-IT-Assets</code>
<id type="integer">18</id>
<name>San Francisco -IT, Actifs</name>
<segment-1>SF</segment-1>
<segment-10 />
<segment-11 />
<segment-12 />
<segment-13 />
<segment-14 />
<segment-15 />
<segment-16 />
<segment-17 />
<segment-18 />
<segment-19 />
<segment-2>IT</segment-2>
<segment-20 />
<segment-3>Actifs</segment-3>
<segment-4 />
<segment-5 />
<segment-6 />
<segment-7 />
<segment-8 />
<segment-9 />
<account-type>
<id type="integer">1</id>
<name>Ace Corporate</name>
</account-type>
</account>
<accounting-total-currency>
<code>USD</code>
<id type="integer">1</id>
</accounting-total-currency>
<created-by>
<email>upgrade+am@coupa.com</email>
<employee-number />
<firstname>Anna (directrice de l'AP)</firstname>
<id type="integer">10</id>
<lastname>Manning</lastname>
<login>amanning</login>
</created-by>
<currency>
<code>USD</code>
<id type="integer">1</id>
</currency>
<item>
<id type="integer">23</id>
<created-at type="datetime">2008-10-28T10:12:02-07:00</created-at>
<description>Le logiciel Adobe Acrobat 9 Professional permet aux professionnels de créer, combiner et contrôler de manière fiable des documents Adobe PDF pour une distribution, une collaboration et une collecte de données faciles et plus sécurisées.</description>
<item-number>3235</item-number>
<name>Forfait complet Adobe Acrobat Professional ( v. 9 )</name>
<updated-at type="datetime">2009-05-04T17:19:51-07:00</updated-at>
<commodity>
<active type="boolean">true</active>
<created-at type="datetime">2008-10-28T17:13:45Z</created-at>
<id type="integer">8</id>
<name>Logiciels</name>
<updated-at type="datetime">2009-08-14T16:34:54Z</updated-at>
<created-by>
<email>upgrade@coupa.com</email>
<employee-number nil="true" />
<firstname>Coupa</firstname>
<id type="integer">1</id>
<lastname>Soutien</lastname>
<login>coupasupport</login>
</created-by>
<updated-by>
<email>upgrade+ke@coupa.com</email>
<employee-number />
<firstname>Kyle</firstname>
<id type="integer">16</id>
<lastname>Eisner</lastname>
<login>administrateur</login>
</updated-by>
</commodity>
<support-user>
<email>upgrade@coupa.com</email>
<employee-number nil="true" />
<firstname>Coupa</firstname>
<id type="integer">1</id>
<lastname>Soutien</lastname>
<login>coupasupport</login>
</support-user>
<uom>
<code>EA</code>
<id type="integer">1</id>
</uom>
<support-user>
<email>upgrade@coupa.com</email>
<employee-number nil="true" />
<firstname>Coupa</firstname>
<id type="integer">1</id>
<lastname>Assistance</lastname>
<login>coupasupport</login>
</support-user>
<reorder-alerts />
</item>
<uom>
<code>EA</code>
<id type="integer">1</id>
</uom>
<updated-by>
<email>upgrade+cj@coupa.com</email>
<employee-number />
<firstname>Carl (réception centrale)</firstname>
<id type="integer">11</id>
<lastname>Johnson</lastname>
<login>cjohnson</login>
</updated-by>
</invoice-line>
</invoice-lines>
</invoice-header>
Exemple de mise de facture
Dans cet exemple, nous mettons à jour un seul attribut sur l'enregistrement de facture :
Ce champ doit être un champ personnalisé de la facture.
Nous avons fait une MISE à l'URL : https ://<instance>.coupahost.com/api/invoices/<invoice id>
URL : https ://<instance>.coupahost.com/api/invoices/33
<?xml version="1.0" encoding="UTF-8"?>
<invoice-header>
<invoice_description>Description du test de la facture</invoice_description>
</invoice-header>
L'exemple suivant illustre l'appel put pour l'ajout d'une ligne de facture :
<?xml version="1.0" encoding="UTF-8"?>
<invoice-header>
<invoice-number>320</invoice-number>
<status>brouillon</status>
<invoice-lines type="array">
<invoice-line>
<accounting-total type="decimal">499,00</accounting-total>
<description>iPad avec Wi-Fi est idéal si vous avez un routeur Internet haute vitesse sans fil dans votre maison</description>
<price type="decimal">499,00</price>
<price-per-uom type="decimal">0,00</price-per-uom>
<quantity type="decimal">1,0</quantity>
<status>nouveau</status>
<tax-amount type="decimal">0,00</tax-amount>
<total type="decimal">499,00</total>
<type>InvoiceQuantityLine</type>
<account>
<name>Siège - Informatique, Actifs</name>
<code>HQ-IT-Assets</code>
<active type="boolean">true</active>
<segment-1>Siège social</segment-1>
<segment-2>IT</segment-2>
<segment-3>Actifs</segment-3>
<account-type>
<name>Ace Corporate</name>
</account-type>
</account>
<account-allocations type="array" />
<accounting-total-currency>
<id type="integer">1</id>
<code>USD</code>
</accounting-total-currency>
<currency>
<id type="integer">1</id>
<code>USD</code>
</currency>
<tax-lines type="array" />
</invoice-line>
</invoice-lines>
</invoice-header>