DataFileSources APIのサンプル呼び出し
DataFileSources取得
クエリオプション
以下は、さまざまなクエリオプションとそのパラメータを示す表です
フィルター名 | 目的 |
created_at | created_atパラメーターを使用して、処理されたファイルの詳細なステータス(ファイルステータス、フィールドレベルエラー)が必要なfromおよびtoタイムスタンプを制御します |
ソース | source_forパラメーターを使用して、相互承認のオブジェクトに基づいてファイルをフィルター処理します |
type |
タイプパラメータを使用して、情報が必要なファイルタイプ(Coupaに送信されたファイルまたはCoupaによって送信されたファイル)を決定します |
status | ステータスパラメーターを使用して、クエリの目標に応じてステータスを処理することでデータソースを除外します |
ファイル名 | file_file_nameパラメータを使用して、特定のファイルのデータ・ファイル・ソースを検索します |
データ構造
以下は、特定のGET呼び出しに対して返される異なる値の一覧表です。フィールド名の前にスペースがあると、前のタグのいずれかにネストされます。
論争 | タイプ | 値 |
id | 整数 | |
created-at | 日時 | YYY-MM-DDTHH:MM:SS-HH:MM |
updated-at | 日時 | YYYY-MM-DDTHH:MM:SS-HH:MM |
type | string型 | BackgroundCsvFileLoad、DataFileSource、BackgroundImportCorporateCreditCard... |
ソース | string型 | InvoiceHeader、Payment、Invoices、ExpenseReport、Supplier、User、Item、Commodity、Address、Contract、Account、Lookup Value... |
status | string型 | 完了、失敗、再試行中、読み込み中、キュー再割当に送信済、保留中、アップロード中、一時停止中 |
file-file-name | string型 | Invoices_20141209_234608Z.csvなど |
ファイルファイルサイズ | string型 | 9822 |
結果テキスト | string型 | 処理の結果(例:27行が処理され、0行の新しい行が作成され、11行が更新されました。 |
進捗状況 | 整数 | 27 |
開始時刻 | 日時 | YYYY-MM-DDTHH:MM:SS-HH:MM |
終了時刻 | 日時 | YYYY-MM-DDTHH:MM:SS-HH:MM |
アップロードエラー | 配列 | |
upload-errors/upload-error | ||
upload-errors/upload-error/id | 整数 | 123456 |
upload-errors/upload-error/created-at | 日時 | YYYY-MM-DDTHH:MM:SS-HH:MM |
upload-errors/upload-error/updated-at | 日時 | YYYY-MM-DDTHH:MM:SS-HH:MM |
upload-errors/upload-error/type | string型 | エラーのタイプ(例:アップロード行エラー |
upload-errors/upload-error/row | 整数 | 1 |
upload-errors/upload-error/first-column | ||
upload-errors/upload-error/field-with-error | string型 | エラーが発生した列名 |
upload-errors/upload-error/value | string型 |
draft、pending_buyer_action、pending_approval、approved、received、ordered、partially received、rejected、with drawn |
upload-errors/upload-error/field errors | 配列 | |
upload-errors/upload=error/created-by | user |
ID、ログイン、姓と名、メールアドレスなどを含むユーザーレコード |
upload-errors/upload-error/updated-by | user | ID、ログイン、姓と名、メールアドレスなどを含むユーザーレコード |
作成者 | user |
ID、ログイン、姓と名、メールアドレスなどを含むユーザーレコード |
更新者 | user | ID、ログイン、姓と名、メールアドレスなどを含むユーザーレコード |
サンプルAPIコール
- 例1:クエリ - Specific DataFileSource
- 例2:特定の日の DataFileSourcesをクエリする
- 例3:特定のオブジェクトのDataFileSourcesをクエリする
DataFileSourcesクエリの例 – 指定された日付のクエリ
この例では、過去24時間に作成されたすべてのDataFileSourcesを探しています(現在の時間は、2015年4月17日のPSTの3PMまたは「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日のUTC午前0時以降に作成されたデータソースに限定され、2つ目の制限は16日午前0時以前に作成されたデータソースに限定されます。最後のセクションでは、検索するオブジェクトを定義します(この場合はLookupValue)。
14月15日の受信した検索値のサンプルの応答
<?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
この形式の場合、回答は少し異なります。?パラメータが複数のレコードを返すことができますが、idを明示的に指定すると返すことができるの <data-file-sources type="array"> </data-file-sources>
は1つだけであるため、以下の出力全体(xmlバージョン情報を除く)はタグでラップされます
データソースのGET応答のサンプル
<?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>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>
DataFileSourcesクエリの例 – クエリ指定ファイル
この例では、lookup_list.csvという名前のファイルに対して作成されたデータファイルソースをクエリしています。
このレコードを問い合わせる方法は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
このクエリの出力は以下のとおりです
データソースの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-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>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">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>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>
このページに表示されている一部、または全ての内容は、機械翻訳によるものです。ご了承ください。