DataFileSources APIの呼び出し例

DataFileSources GET検索オプション

以下は、さまざまな検索オプションとそのパラメータを示す表です。

フィルター名目的
created_atCreated_atパラメーターを使用して、処理されたファイルの詳細なステータス(ファイルステータス、フィールドレベルのエラー)が必要なfromとtoのタイムスタンプを制御します
ソース元source_forパラメーターを使用して、関心のあるオブジェクトに基づいてファイルをフィルタリングします
typetypeパラメーターを使用して、Coupaに送信されたファイルまたはCoupaから送信されたファイルについての情報が必要なファイルタイプを決定します
ステータスstatusパラメーターを使用して、クエリの目的に応じて処理ステータスでデータソースをフィルタリングします
ファイルファイル名file_file_nameパラメーターを使用して、特定のファイルのデータファイルソースを検索します

データ構造

以下は、特定のGETリクエストに対して返される異なる値をまとめた表です。 フィールド名の前のスペースは、前のタグの1つの下にネストされていることを意味します。

議論Type値
ID整数
作成日時datetimeYYY-MM-DDTHH:MM:SS-HH:MM
updated-atdatetimeYYYY-MM-DDTHH:MM:SS-HH:MM
type文字列BackgroundCsvFileLoad、DataFileSource、BackgroundImportCorporateCreditCard...
source-for文字列請求ヘッダー、支払、請求書、経費リポート、サプライヤー、ユーザー、アイテム、品目カテゴリー、住所、連絡先、アカウント、検索値...
ステータス文字列完了、失敗、再試行、読み込み中、Resqueに送信済み、保留中、アップロード中、一時停止、停止
file-file-name文字列Invoices_20141209_234608Z.csvなど
file-file-size文字列9822
result-text文字列プロセスの結果。例： 27行が処理され、新しい行が0行作成され、11行が更新されました。
progress整数27
start-timedatetimeYYYY-MM-DDTHH:MM:SS-HH:MM
end-timedatetimeYYYY-MM-DDTHH:MM:SS-HH:MM
upload-errorsarray
upload-errors/upload-error
upload-errors/upload-error/id整数123456
upload-errors/upload-error/created-atdatetimeYYYY-MM-DDTHH:MM:SS-HH:MM
upload-errors/upload-error/updated-atdatetimeYYYY-MM-DDTHH:MM:SS-HH:MM
upload-errors/upload-error/type文字列エラーのタイプ、例: UploadRowError
upload-errors/upload-error/row整数1
upload-errors/upload-error/firstc-column
upload-errors/upload-error/field-with-error文字列エラーが発生した列名
upload-errors/upload-error/value文字列ドラフト、バイヤーアクション待ち、承認待ち、承認済み、受領済み、発注済み、部分受領済み、却下済み、撤回済み
upload-errors/upload-error/field errorsarray
upload-errors/upload=error/created-byユーザーID、ログイン、姓名、メールアドレスなどを含むユーザーレコード
upload-errors/upload-error/updated-byユーザーID、ログイン、姓名、メールアドレスなどを含むユーザーレコード
created-byユーザーID、ログイン、姓名、メールアドレスなどを含むユーザーレコード
updated-byユーザーID、ログイン、姓名、メールアドレスなどを含むユーザーレコード

DataFileSources検索の例 - 指定された日付の検索

この例では、過去24時間に作成されたすべてのDataFileSourcesを探しています(現在の時刻は2015年4月17日午後3時(太平洋標準時)または「2015-04-17 22:00:00」)。より大きな日付と時刻を使用できますが、DataFileSource APIには、それを参照する関連するオブジェクトとレコードが多数あることを覚えておくことが重要です。 したがって、多数の数値やレコードを検索すると、インスタンスのパフォーマンスが低下する可能性があります。 さらに、CoupaへのすべてのAPI呼び出しと同様に、呼び出しごとに返されるレコードには50の制限があります。 次のセットを照会するには、通話の最後に & offset = 50 を追加します
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'
毎日のデータソースのサンプル
<?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>LookupValue</source-for> <status>sample</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>Parent unable to find matching parent.</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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> <first-column>Coupa Implementation</first-column> <field-with-error>parent_id</field-with-error> <value>1</value> <field-errors type="array"> <field-error>Parent unable to find matching parent.</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>LookupValue</source-for> <status>sample</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>Parent unable to find matching parent.</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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> <first-column>Coupa Implementation</first-column> <field-with-error>parent_id</field-with-error> <value>1</value> <field-errors type="array"> <field-error>Parent unable to find matching parent.</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>LookupValue</source-for> <status>sample</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>Parent unable to find matching parent.</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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> <first-column>Coupa Implementation</first-column> <field-with-error>parent_id</field-with-error> <value>1</value> <field-errors type="array"> <field-error>Parent unable to find matching parent.</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Knott</lastname> <salesforce-id nil="true" /> <company-code>100</company-code> <cost-center>10000</cost-center> <account-category>K</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>Supplier</source-for> <status>sample</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>Column header Active is not valid.</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>Supplier</source-for> <status>sample</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>Column header Line1* is not valid.</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>

DataFileSources検索の例 - 特定のオブジェクトの検索

この例では、2014年12月15日のすべての受信ルックアップ値を検索して、Coupaで処理されているファイルにエラーがあるかどうかを確認しています。 これは、以下に示すように、マルチステージ検索です。
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

このクエリには3つの部分があります。 1つ目は、15日の午前0時(協定世界時)以降に作成されたデータファイルソースのみに制限され、2つ目は、16日の午前0時(協定世界時)より前に作成されたデータファイルソースに制限されます。 最後のセクションでは、探しているオブジェクト、つまりLookupValueを定義します。

2014年12月15日のLookupValues Inboundの応答例
<?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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 0 rows.</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>Row corrupt or invalid.</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>Row corrupt or invalid.</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>Row corrupt or invalid.</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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 0 rows.</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>Row corrupt or invalid.</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>Row corrupt or invalid.</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>Row corrupt or invalid.</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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 0 rows.</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>Row corrupt or invalid.</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>Row corrupt or invalid.</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>Row corrupt or invalid.</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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 3 rows.</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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 3 rows.</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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 3 rows.</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>Name has already been taken</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>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 3 rows.</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>Name has already been taken</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>

DataFileSources検索の例 - 特定のDataFileSourceの検索

この例では、datafilesource #1338を検索しています。 これは、このオブジェクトに自動的に生成される内部Coupa IDであり、このレコードの主要な識別方法です。

このレコードを検索するには、次の2つの方法があります。

  • 形式1: https ://<instance>.coupahost.com/api/data_file_sources/<id>

https ://<instance>.coupahost.com/api/data_file_sources/1338

この検索の出力は以下のとおりです

  • フォーマット2: https ://<instance>.coupahost.com/api/data_file_sources?id =<id>

https ://<instance>.coupahost.com/api/data_file_sources?id=1338

この形式の場合、レスポンスは少し異なります。 以下の出力全体(XMLバージョン情報を除く)は、次のタグで囲まれます
<data-file-sources type="array"> </data-file-sources>
これは、? パラメータを使用すると複数のレコードが返される可能性があるのに対し、IDを明示的に指定した場合は1件のみが返されるためです
サンプルDataSource GET応答
<?xml version="1.0" encoding="UTF-8"?> <data-file-source> <id type="integer">1338</id> <created-at type="datetime">2014 -12 -15 T 10:40:57 - 08:00</created-at> <updated-at type="datetime">2014 -12 -15 T 10:41:33 - 08:00</updated-at> <type>BackgroundCsvFileLoad</type> <source-for>LookupValue</source-for> <status>done</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 rows processed, creating 0 new rows and updating 3 rows.</result-text> <progress type="integer">4</progress> <start-time type="datetime">-12 -15 T 10:41:06 - 08:00</start-time> <end-time type="datetime">2014 -12 -15 T 10:41:33 - 08:00</end-time> <upload-errors type="array"> <upload-error> <id type="integer">974</id> <created-at type="datetime">2014 -12 -15 T 10:41:11 - 08:00</created-at> <updated-at type="datetime">2014 -12 -15 T 10: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>TESTUS 1</value> <field-errors type="array"> <field-error>Name has already been taken</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"></id> <login>sftp_integration@coupa.com</login> <email>sftp_integration@coupa.com</email> <employee-number nil="true" /> <firstname>sFTP</firstname> <lastname>統合</lastname> <salesforce-id nil="true" /> <company-code /> <cost-center /> <account-category /> </updated-by> </data-file-source>

DataFileSources検索の例 - 特定のファイルの検索

この例では、lookup_list.csvという名前のファイルに対して作成されたdatafilesourceを検索しています。

このレコードを検索するには、次の2つの方法があります。

  • 形式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

    この検索の出力は以下のとおりです

サンプルDataSource GET応答
<?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 -09 T 16:32:42 - 07:00</created-at> <updated-at type="datetime">2015 -07 -09 T 16:34:19 - 07:00</updated-at> <type>DataFileSource</type> <source-for>Lookup</source-for> <status>done</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 rows processed, creating 0 new rows and updating 0 rows.</result-text> <progress nil="true" /> <start-time type="datetime">07 -09 T 16:34:05 - 07:00</start-time> <end-time type="datetime">2015 -07 -09 T 16: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>DOE</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>DOE</lastname> </updated-by> </data-file-source> </data-file-sources>