Was können wir Ihnen dabei helfen? Produkte Coupa-Produktdokumentation Integration - Technische Dokumentation Coupa Core API Ressourcen Referenzdaten-Ressourcen Datendateiquellen-API (/data_file_sources) Beispielaufrufe der DataFileSources-API

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>

Vergleichbare Artikel

Die Coupa Core-API

Unsere RESTful-API bietet robusten Zugriff zum Lesen, Bearbeiten oder Integrieren Ihrer Daten mit der Coupa-Plattform.

Mehr erfahren

Erste Schritte mit der API

Allgemeine Informationen zur Verwendung der Coupa-API und wann Sie CSV verwenden sollten.

Mehr erfahren

Übergang zu OAuth 2.0 und OIDC

Coupa veraltet ältere API-Schlüssel und erfordert die Verwendung von OAuth 2.0 / OIDC. Ab R34 werden keine neuen API-Schlüssel ausgegeben und API-Schlüssel werden mit R35 nicht mehr unterstützt.

Mehr erfahren

Bauen Sie auf der Coupa-Plattform auf

Unsere API-basierte offene Integrationsplattform ermöglicht Technologiepartnern und unabhängigen Softwareanbietern (ISVs) die Integration ihrer Produkte in Coupa

Mehr erfahren