• Zuletzt bearbeitet am: 12 August 2019

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 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>
  • Inhalt