Beispielaufrufe der DataFileSources-API
DataFileSources GET
Abfrage-Optionen
Im Folgenden finden Sie eine Tabelle mit verschiedenen Abfrageoptionen und ihren Parametern
Filtername | Zweck |
created_at | Verwenden Sie den Parameter created_at, um die Zeitstempel from und to zu steuern, zwischen denen Sie den detaillierten Status der verarbeiteten Dateien benötigen (Dateistatus, Fehler auf Feldebene) |
quelle für | Verwenden Sie den Parameter source_for, um die Dateien basierend auf dem Objekt von Interesse zu filtern |
typ |
Verwenden Sie den Parameter type, um festzustellen, ob der Dateityp, zu dem Sie Informationen benötigen - Datei an Coupa gesendet oder Datei von Coupa gesendet |
status | Verwenden Sie den Statusparameter, um Datenquellen je nach Ziel Ihrer Abfrage nach dem Verarbeitungsstatus zu filtern |
file_file_name | Verwenden Sie den Parameter file_file_name, um nach Datenquellen für eine bestimmte Datei zu suchen |
Datenstruktur
Im Folgenden finden Sie eine Tabelle mit den verschiedenen Werten, die für einen bestimmten GET-AUFRUF ZURÜCKGEGEBEN WERDEN. Leerzeichen vor einem Feldnamen bedeuten, dass es unter einem der vorhergehenden Tags verschachtelt ist:
Argumentation | Typ | Werte |
iD | ganze Zahl | |
created-at | datum/Uhrzeit | JJJ-MM-TTTHH:MM:SS-HH:MM |
updated-at | datum/Uhrzeit | JJJJ-MM-TTTHH:MM:SS-HH:MM |
typ | zeichenfolge | BackgroundCsvFileLoad, DataFileSource, BackgroundImportCorporateCreditCard... |
source-for | zeichenfolge | InvoiceHeader, Payment, Invoices, ExpenseReport, Supplier, User, Item, Commodity, Address, Contract, Account, Lookup Value... |
status | zeichenfolge | Erledigt, Fehlgeschlagen, Erneut versuchen, Laden, An Resque gesendet, Ausstehend, Hochladen, Angehalten, Gestoppt |
file-file-name | zeichenfolge | Invoices_20141209_234608Z.csv, etc |
file-file-size | zeichenfolge | 9822 |
result-text | zeichenfolge | Das Ergebnis des Prozesses bspw. 27 Zeilen verarbeitet, 0 neue Zeilen erstellt und 11 Zeilen aktualisiert. |
verarbeiten | ganze Zahl | 27 |
startzeit | datum/Uhrzeit | JJJJ-MM-TTTHH:MM:SS-HH:MM |
endzeit | datum/Uhrzeit | JJJJ-MM-TTTHH:MM:SS-HH:MM |
upload-Fehler | array | |
upload-errors/upload-error | ||
upload-errors/upload-error/id | ganze Zahl | 123456 |
upload-errors/upload-error/created-at | datum/Uhrzeit | JJJJ-MM-TTTHH:MM:SS-HH:MM |
upload-errors/upload-error/updated-at | datum/Uhrzeit | JJJJ-MM-TTTHH:MM:SS-HH:MM |
upload-errors/upload-error/type | zeichenfolge | Die Fehlerart, z. B. UploadRowError |
upload-errors/upload-error/row | ganze Zahl | 1 |
upload-errors/upload-error/firstc-column | ||
upload-errors/upload-error/field-with-error | zeichenfolge | Spaltenname, in dem der Fehler aufgetreten ist |
upload-errors/upload-error/value | zeichenfolge |
entwurf, ausstehende_Käuferaktion, ausstehende_Genehmigung, genehmigt, erhalten, bestellt, teilweise erhalten, abgelehnt, mit gezogener |
upload-errors/upload-error/Feldfehler | array | |
upload-errors/upload=error/created-by | benutzer |
Benutzerdatensatz einschließlich ID, Login, Vor- und Nachname, E-Mail usw. |
upload-errors/upload-error/updated-by | benutzer | Benutzerdatensatz einschließlich ID, Login, Vor- und Nachname, E-Mail usw. |
erstellt von | benutzer |
Benutzerdatensatz einschließlich ID, Login, Vor- und Nachname, E-Mail usw. |
aktualisiert von | benutzer | Benutzerdatensatz einschließlich ID, Login, Vor- und Nachname, E-Mail usw. |
Beispiel-API-Aufrufe
- Beispiel 1: Abfragespezifische DataFileSource
- Beispiel 2: Abfrage von DataFileSources für einen bestimmten Tag
- Beispiel 3: Abfrage von DataFileSources für ein bestimmtes Objekt
Beispiel für eine DataFileSources-Abfrage - Abfrage zum angegebenen Datum
In diesem Beispiel suchen wir nach allen DataFileSources, die in den letzten 24 Stunden erstellt wurden (die aktuelle Zeit ist 15:00 UHR PST 17. April 2015 oder '2015-04-17 22:00:00'). Obwohl Sie eine größere Datumszeit verwenden können, ist es wichtig, sich daran zu erinnern, dass die DataFileSource-API eine Reihe von verwandten Objekten und Datensätzen enthält, die auf sie verweisen. Wenn Sie also große Zahlen oder Datensätze abfragen, kann dies zu einer nachteiligen Leistung in Ihrer Instanz führen. Darüber hinaus gibt es, wie bei allen API-Aufrufen an Coupa, ein Limit von 50 Datensätzen, die pro Aufruf zurückgegeben werden. Um den nächsten Satz abzufragen, fügen Sie &offset=50 zum Ende Ihres Anrufs hinzu
https://<instance>.coupahost.com/api/data_file_sources?created_at[gt]='<timestamp>'
https://<instance>.coupahost.com/api/data_file_sources?created_at[gt]='2015-04-16 22:00:00'
Beispiel für tägliche Datenquellen
<?xml version="1.0" encoding="UTF-8"?>
<data-file-sources type="array">
<data-file-source>
<id type="integer">1117</id>
<created-at type="datetime">2015-04-17T08:34:17-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:34:25-07:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>beispiel</status>
<file-file-name>lookup_value_list_wbstype.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>300</file-file-size>
<result-text nil="true" />
<progress nil="true" />
<start-time nil="true" />
<end-time nil="true" />
<upload-errors type="array">
<upload-error>
<id type="integer">920</id>
<created-at type="datetime">2015-04-17T08:34:25-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:34:25-07:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>SAP Upgrade</first-column>
<field-with-error>parent_id</field-with-error>
<value>1</value>
<field-errors type="array">
<field-error>Elternteil kann den passenden Elternteil nicht finden.</field-error>
</field-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</upload-error>
<upload-error>
<id type="integer">921</id>
<created-at type="datetime">2015-04-17T08:34:25-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:34:25-07:00</updated-at>
<type>UploadRowError</type>
<row type="integer">3</row>
Implementierung von<first-column> Coupa</first-column>
<field-with-error>parent_id</field-with-error>
<value>1</value>
<field-errors type="array">
Der <field-error>Elternteil kann den passenden Elternteil nicht finden.</field-error>
</field-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1118</id>
<created-at type="datetime">2015-04-17T08:35:15-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:35:16-07:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>beispiel</status>
<file-file-name>lookup_value_list_wbstype.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>304</file-file-size>
<result-text nil="true" />
<progress nil="true" />
<start-time nil="true" />
<end-time nil="true" />
<upload-errors type="array">
<upload-error>
<id type="integer">922</id>
<created-at type="datetime">2015-04-17T08:35:16-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:35:16-07:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>SAP Upgrade</first-column>
<field-with-error>parent_id</field-with-error>
<value>1</value>
<field-errors type="array">
<field-error>Elternteil kann übereinstimmende Elternteile nicht finden.</field-error>
</field-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</upload-error>
<upload-error>
<id type="integer">923</id>
<created-at type="datetime">2015-04-17T08:35:16-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:35:16-07:00</updated-at>
<type>UploadRowError</type>
<row type="integer">3</row>
Implementierung von<first-column> Coupa</first-column>
<field-with-error>parent_id</field-with-error>
<value>1</value>
<field-errors type="array">
<field-error>Elternteil kann übereinstimmende Elternteile nicht finden.</field-error>
</field-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1119</id>
<created-at type="datetime">2015-04-17T08:36:07-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:36:07-07:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>beispiel</status>
<file-file-name>lookup_value_list_wbstype.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>344</file-file-size>
<result-text nil="true" />
<progress nil="true" />
<start-time nil="true" />
<end-time nil="true" />
<upload-errors type="array">
<upload-error>
<id type="integer">917</id>
<created-at type="datetime">2015-04-17T08:36:08-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:36:08-07:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>SAP Upgrade</first-column>
<field-with-error>parent_id</field-with-error>
<value>1</value>
<field-errors type="array">
<field-error>Elternteil kann übereinstimmende Elternteile nicht finden.</field-error>
</field-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</upload-error>
<upload-error>
<id type="integer">925</id>
<created-at type="datetime">2015-04-17T08:36:08-07:00</created-at>
<updated-at type="datetime">2015-04-17T08:36:08-07:00</updated-at>
<type>UploadRowError</type>
<row type="integer">3</row>
Implementierung von<first-column> Coupa</first-column>
<field-with-error>parent_id</field-with-error>
<value>1</value>
<field-errors type="array">
Der <field-error>Elternteil kann den passenden Elternteil nicht finden.</field-error>
</field-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</created-by>
<updated-by>
<id type="integer">81</id>
<login>bknott</login>
<email>brent.knott+bknott@coupa.com</email>
<employee-number />
<firstname>Brent</firstname>
<lastname>Knoten</lastname>
<salesforce-id nil="true" />
<company-code>100</company-code>
<cost-center>10000</cost-center>
<account-category>Tsd.</account-category>
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1125</id>
<created-at type="datetime">2015-04-17T12:59:44-07:00</created-at>
<updated-at type="datetime">2015-04-17T12:59:45-07:00</updated-at>
<type>DataFileSource</type>
<source-for>Lieferant</source-for>
<status>beispiel</status>
<file-file-name>remit_to_address_list.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>221</file-file-size>
<result-text nil="true" />
<progress nil="true" />
<start-time nil="true" />
<end-time nil="true" />
<upload-errors type="array">
<upload-error>
<id type="integer">926</id>
<created-at type="datetime">2015-04-17T12:59:46-07:00</created-at>
<updated-at type="datetime">2015-04-17T12:59:46-07:00</updated-at>
<type>UploadHeaderError</type>
<row nil="true" />
<first-column nil="true" />
<field-with-error nil="true" />
<value nil="true" />
<field-errors>Der Spaltenkopf Aktiv ist nicht gültig.</field-errors>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1126</id>
<created-at type="datetime">2015-04-17T13:00:05-07:00</created-at>
<updated-at type="datetime">2015-04-17T13:00:04-07:00</updated-at>
<type>DataFileSource</type>
<source-for>Lieferant</source-for>
<status>beispiel</status>
<file-file-name>remit_to_address_list.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>210</file-file-size>
<result-text nil="true" />
<progress nil="true" />
<start-time nil="true" />
<end-time nil="true" />
<upload-errors type="array">
<upload-error>
<id type="integer">927</id>
<created-at type="datetime">2015-04-17T13:00:04-07:00</created-at>
<updated-at type="datetime">2015-04-17T13:00:04-07:00</updated-at>
<type>UploadHeaderError</type>
<row nil="true" />
<first-column nil="true" />
<field-with-error nil="true" />
<value nil="true" />
<field-errors>Der Spaltenkopf Zeile1* ist ungültig.</field-errors>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">1</id>
<login>coupasupport</login>
<email>rakesh.tatineni+01@coupa.com</email>
<employee-number />
<firstname>Coupa</firstname>
<lastname>Support</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
</data-file-sources>
Beispiel für eine DataFileSources-Abfrage - Abfrage für ein bestimmtes Objekt
In diesem Beispiel werden alle eingehenden Lookup-Werte für den 15. Dezember 2014 abgefragt, um festzustellen, ob Fehler bei der Verarbeitung der Dateien in Coupa aufgetreten sind. Dies ist eine mehrstufige Abfrage, wie Sie unten sehen können:
https://<instance>.coupahost.com/api/data_file_sources?created_at[gt]='<day>00:00:00'&created_at[lt]='<day>23:59:59'&source_for=<object>
https://<instance>.coupahost.com/api/data_file_sources?created_at[gt]='2014-12-15 00:00:00'&created_at[lt]='2014-12-15 23:59:59'&source_for=LookupValue
Diese Abfrage besteht aus drei Teilen. Die erste beschränkt sich auf Datendateien, die seit Mitternacht UTC am 15. erstellt wurden, und die zweite legt eine Grenze für Datendateien fest, die vor Mitternacht des 16. erstellt wurden. Der letzte Abschnitt definiert, nach welchem Objekt wir suchen, in diesem Fall LookupValue.
Beispielantwort für LookupValues Inbound am 15.12.14
<?xml version="1.0" encoding="UTF-8"?>
<data-file-sources type="array">
<data-file-source>
<id type="integer">1332</id>
<created-at type="datetime">2014-12-15T08:47:54-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:48:53-08:00</updated-at>
<type>DataFileSource</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>282</file-file-size>
<result-text>0 Zeilen verarbeitet, 0 neue Zeilen erstellt und 0 Zeilen aktualisiert.</result-text>
<progress type="integer">0</progress>
<start-time type="datetime">2014-12-15T08:48:07-08:00</start-time>
<end-time type="datetime">2014-12-15T08:48:53-08:00</end-time>
<upload-errors type="array">
<upload-error>
<id type="integer">964</id>
<created-at type="datetime">2014-12-15T08:48:10-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:48:10-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">1</row>
<first-column>TESTUS1</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
<upload-error>
<id type="integer">965</id>
<created-at type="datetime">2014-12-15T08:48:13-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:48:13-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>TESTEMEA1</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
<upload-error>
<id type="integer">966</id>
<created-at type="datetime">2014-12-15T08:48:13-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:48:13-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">3</row>
<first-column>TESTSales1</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1333</id>
<created-at type="datetime">2014-12-15T08:55:19-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:55:53-08:00</updated-at>
<type>DataFileSource</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>279</file-file-size>
<result-text>0 Zeilen verarbeitet, 0 neue Zeilen erstellt und 0 Zeilen aktualisiert.</result-text>
<progress type="integer">0</progress>
<start-time type="datetime">2014-12-15T08:55:27-08:00</start-time>
<end-time type="datetime">2014-12-15T08:55:53-08:00</end-time>
<upload-errors type="array">
<upload-error>
<id type="integer">967</id>
<created-at type="datetime">2014-12-15T08:55:29-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:55:29-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">1</row>
<first-column>TESTUS</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
<upload-error>
<id type="integer">968</id>
<created-at type="datetime">2014-12-15T08:55:29-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:55:29-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>TESTEMEA</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
<upload-error>
<id type="integer">969</id>
<created-at type="datetime">2014-12-15T08:55:29-08:00</created-at>
<updated-at type="datetime">2014-12-15T08:55:29-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">3</row>
<first-column>TESTSales</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1334</id>
<created-at type="datetime">2014-12-15T09:13:17-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:13:55-08:00</updated-at>
<type>DataFileSource</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>258</file-file-size>
<result-text>0 Zeilen verarbeitet, 0 neue Zeilen erstellt und 0 Zeilen aktualisiert.</result-text>
<progress type="integer">0</progress>
<start-time type="datetime">2014-12-15T09:13:27-08:00</start-time>
<end-time type="datetime">2014-12-15T09:13:55-08:00</end-time>
<upload-errors type="array">
<upload-error>
<id type="integer">970</id>
<created-at type="datetime">2014-12-15T09:13:30-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:13:30-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">1</row>
<first-column>TESTUS</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
<upload-error>
<id type="integer">971</id>
<created-at type="datetime">2014-12-15T09:13:30-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:13:30-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>TESTEMEA</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
<upload-error>
<id type="integer">972</id>
<created-at type="datetime">2014-12-15T09:13:31-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:13:31-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">3</row>
<first-column>TESTSales</first-column>
<field-with-error nil="true" />
<value nil="true" />
<field-errors type="array">
<field-error>Zeile beschädigt oder ungültig.</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1335</id>
<created-at type="datetime">2014-12-15T09:22:15-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:22:32-08:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type />
<file-file-size>282</file-file-size>
<result-text>3 Zeilen verarbeitet, 0 neue Zeilen werden erstellt und 3 Zeilen werden aktualisiert.</result-text>
<progress type="integer">3</progress>
<start-time type="datetime">2014-12-15T09:22:24-08:00</start-time>
<end-time type="datetime">2014-12-15T09:22:32-08:00</end-time>
<upload-errors type="array" />
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1336</id>
<created-at type="datetime">2014-12-15T09:28:19-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:28:32-08:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type />
<file-file-size>282</file-file-size>
<result-text>3 Zeilen verarbeitet, 0 neue Zeilen werden erstellt und 3 Zeilen werden aktualisiert.</result-text>
<progress type="integer">3</progress>
<start-time type="datetime">2014-12-15T09:28:29-08:00</start-time>
<end-time type="datetime">2014-12-15T09:28:32-08:00</end-time>
<upload-errors type="array" />
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1337</id>
<created-at type="datetime">2014-12-15T09:34:24-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:35:00-08:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type />
<file-file-size>332</file-file-size>
<result-text>4 Zeilen verarbeitet, 0 neue Zeilen erstellt und 3 Zeilen aktualisiert.</result-text>
<progress type="integer">4</progress>
<start-time type="datetime">2014-12-15T09:34:32-08:00</start-time>
<end-time type="datetime">2014-12-15T09:35:00-08:00</end-time>
<upload-errors type="array">
<upload-error>
<id type="integer">973</id>
<created-at type="datetime">2014-12-15T09:34:35-08:00</created-at>
<updated-at type="datetime">2014-12-15T09:34:35-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>0200</first-column>
<field-with-error>name</field-with-error>
<value>TESTUS1</value>
<field-errors type="array">
<field-error>Der Name wird bereits verwendet</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
<data-file-source>
<id type="integer">1338</id>
<created-at type="datetime">2014-12-15T10:40:57-08:00</created-at>
<updated-at type="datetime">2014-12-15T10:41:33-08:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type />
<file-file-size>332</file-file-size>
<result-text>4 Zeilen verarbeitet, 0 neue Zeilen erstellt und 3 Zeilen aktualisiert.</result-text>
<progress type="integer">4</progress>
<start-time type="datetime">2014-12-15T10:41:06-08:00</start-time>
<end-time type="datetime">2014-12-15T10:41:33-08:00</end-time>
<upload-errors type="array">
<upload-error>
<id type="integer">974</id>
<created-at type="datetime">2014-12-15T10:41:11-08:00</created-at>
<updated-at type="datetime">2014-12-15T10:41:11-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>0200</first-column>
<field-with-error>name</field-with-error>
<value>TESTUS1</value>
<field-errors type="array">
<field-error>Der Name wird bereits verwendet</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
</data-file-sources>
Beispiel für eine Abfrage von DataFileSources - Abfragespezifische DataFileSource
In diesem Beispiel fragen wir Datafilesource #1338 ab. Dies ist die interne Coupa-ID, die für dieses Objekt automatisch generiert wird und die primäre Identifikationsmethode für diesen Datensatz ist.
Wir haben zwei Methoden, um diesen Datensatz abzufragen:
- Format 1:
https://<instance>.coupahost.com/api/data_file_sources/<id>
https://<instance>.coupahost.com/api/data_file_sources/1338
Die Ausgabe für diese Abfrage wird unten angezeigt
- Format 2:
https://<instance>.coupahost.com/api/data_file_sources?id=<id>
https:/<instance>/
.coupahost.com/api/data_file_sources?id=1338 Bei diesem Format ist die Antwort etwas anders. Die gesamte untenstehende Ausgabe (mit Ausnahme der XML-Versionsinformationen) wird in das <data-file-sources type="array"> </data-file-sources>
Tag eingefügt, da der ? -Parameter mehrere Datensätze zurückgeben könnte, während die Angabe der ID explizit nur den einen zurückgeben kann
Beispiel DataSource GET-Antwort
<?xml version="1.0" encoding="UTF-8"?>
<data-file-source>
<id type="integer">1338</id>
<created-at type="datetime">2014-12-15T10:40:57-08:00</created-at>
<updated-at type="datetime">2014-12-15T10:41:33-08:00</updated-at>
<type>BackgroundCsvFileLoad</type>
<source-for>Suchwert</source-for>
<status>fertig</status>
<file-file-name>_Incoming_LookupValues_Knott_LookupValues.csv</file-file-name>
<file-content-type />
<file-file-size>332</file-file-size>
<result-text>4 Zeilen verarbeitet, 0 neue Zeilen erstellt und 3 Zeilen aktualisiert.</result-text>
<progress type="integer">4</progress>
<start-time type="datetime">2014-12-15T10:41:06-08:00</start-time>
<end-time type="datetime">2014-12-15T10:41:33-08:00</end-time>
<upload-errors type="array">
<upload-error>
<id type="integer">974</id>
<created-at type="datetime">2014-12-15T10:41:11-08:00</created-at>
<updated-at type="datetime">2014-12-15T10:41:11-08:00</updated-at>
<type>UploadRowError</type>
<row type="integer">2</row>
<first-column>0200</first-column>
<field-with-error>name</field-with-error>
<value>TESTUS1</value>
<field-errors type="array">
<field-error>Der Name wird bereits verwendet</field-error>
</field-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</upload-error>
</upload-errors>
<created-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</created-by>
<updated-by>
<id type="integer">93</id>
<login>sftp_integration@coupa.com</login>
<email>sftp_integration@coupa.com</email>
<employee-number nil="true" />
<firstname>sFTP</firstname>
<lastname>Integration</lastname>
<salesforce-id nil="true" />
<company-code />
<cost-center />
<account-category />
</updated-by>
</data-file-source>
Beispiel für eine Abfrage von DataFileSources - Abfragespezifische Datei
In diesem Beispiel fragen wir nach einer Datenquelle, die für eine Datei mit dem Namen lookup_list.csv erstellt wurde.
Wir haben zwei Methoden, um diesen Datensatz abzufragen:
- Format 1:
https://<instance>.coupahost.com/api/data_file_sources?file_file_name=filename
https://<instance>.coupahost.com/api/data_file_sources?file_file_name=lookup_list.csv
Die Ausgabe für diese Abfrage ist unten dargestellt
Beispiel DataSource GET-Antwort
<?xml version="1.0" encoding="UTF-8"?>
<data-file-sources type="array">
<data-file-source>
<id type="integer">990</id>
<created-at type="datetime">2015-07-09T16:32:42-07:00</created-at>
<updated-at type="datetime">2015-07-09T16:34:19-07:00</updated-at>
<type>DataFileSource</type>
<source-for>Suche</source-for>
<status>fertig</status>
<file-file-name>lookup_list.csv</file-file-name>
<file-content-type>text/csv</file-content-type>
<file-file-size>170</file-file-size>
<result-text>0 Zeilen verarbeitet, 0 neue Zeilen erstellt und 0 Zeilen aktualisiert.</result-text>
<progress nil="true" />
<start-time type="datetime">2015-07-09T16:34:05-07:00</start-time>
<end-time type="datetime">2015-07-09T16:34:19-07:00</end-time>
<upload-errors type="array" />
<created-by>
<id type="integer">85</id>
<login>staging@coupa.com</login>
<email>staging@coupa.com</email>
<employee-number nil="true" />
<firstname>John</firstname>
<lastname>Mustermann</lastname>
</created-by>
<updated-by>
<id type="integer">85</id>
<login>staging@coupa.com</login>
<email>staging@coupa.com</email>
<employee-number nil="true" />
<firstname>John</firstname>
<lastname>Mustermann</lastname>
</updated-by>
</data-file-source>
</data-file-sources>