DataFileSources API Example Calls
DataFileSources GET Query Options
Below is a table showing various query options and their parameters
| Filter Name | Purpose |
| created_at | Use the created_at parameter to control the from and to timestamps between which you need the detailed status of the files processed (file status, field level errors) |
| source_for | Use the source_for parameter to filter the files based on the object of interesta |
| type | Use the type parameter to determine whether the file type you need information about - file sent to Coupa or file sent by Coupa |
| status | Use the status parameter to filter out data sources by processing status depending on the goal of your query |
| file_file_name | Use the file_file_name parameter to search for datafilesources for a specific file |
Data Structure
Below is a table outlining the different values returned for a given GET call. Spaces before a field name mean it is nested under one of the preceding tags:
| Arguement | Type | Values |
| id | integer | |
| created-at | datetime | YYY-MM-DDTHH:MM:SS-HH:MM |
| updated-at | datetime | YYYY-MM-DDTHH:MM:SS-HH:MM |
| type | string | BackgroundCsvFileLoad, DataFileSource, BackgroundImportCorporateCreditCard... |
| source-for | string | InvoiceHeader, Payment, Invoices, ExpenseReport, Supplier, User, Item, Commodity, Address, Contract, Account, Lookup Value... |
| status | string | Done, Failed, Retrying, Loading, Submitted to Resque, Pending, Uploading, Paused, Stopped |
| file-file-name | string | Invoices_20141209_234608Z.csv, etc |
| file-file-size | string | 9822 |
| result-text | string | The result of the process ex. 27 rows processed, creating 0 new rows and updating 11 rows. |
| progress | integer | 27 |
| start-time | datetime | YYYY-MM-DDTHH:MM:SS-HH:MM |
| end-time | datetime | YYYY-MM-DDTHH:MM:SS-HH:MM |
| upload-errors | array | |
| upload-errors/upload-error | ||
| upload-errors/upload-error/id | integer | 123456 |
| upload-errors/upload-error/created-at | datetime | YYYY-MM-DDTHH:MM:SS-HH:MM |
| upload-errors/upload-error/updated-at | datetime | YYYY-MM-DDTHH:MM:SS-HH:MM |
| upload-errors/upload-error/type | string | The type of error, ex. UploadRowError |
| upload-errors/upload-error/row | integer | 1 |
| upload-errors/upload-error/firstc-column | ||
| upload-errors/upload-error/field-with-error | string | Column name where the error occurred |
| 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 | array | |
| upload-errors/upload=error/created-by | user | User record including id, login, first and last name, email etc |
| upload-errors/upload-error/updated-by | user | User record including id, login, first and last name, email etc |
| created-by | user | User record including id, login, first and last name, email etc |
| updated-by | user | User record including id, login, first and last name, email etc |
DataFileSources Query Example - Query for Given Date
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 Query Example - Query for Specific Object
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=LookupValueThis query has three parts. The first one limits to just datafilesources created since midnight UTC on the 15th, and the second puts a limit of datafilesources created prior to midnight of the 16th. The final section defines what object we are looking for, in this case LookupValue.
<?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 Query Example - Query Specific DataFileSource
In this example we are querying datafilesource #1338. This is the internal Coupa ID automatically generated for this object and is the primary method of identification for this record.
We have two methods to query this record:
- Format 1:
https://<instance>.coupahost.com/api/data_file_sources/<id>
https://<instance>.coupahost.com/api/data_file_sources/1338
The Output for this query is show below
- Format 2:
https://<instance>.coupahost.com/api/data_file_sources?id=<id>
https://<instance>.coupahost.com/api/data_file_sources?id=1338
<data-file-sources type="array">
</data-file-sources> tag as the ? parameter could return multiple records,
while specifying the id explicitly can only return the one<?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 Query Example - Query Specific File
In this example we are querying for a datafilesource created for a file named lookup_list.csv.
We have two methods to query this record:
-
Format 1:
https://<instance>.coupahost.com/api/data_file_sources?file_file_name=filenamehttps://<instance>.coupahost.com/api/data_file_sources?file_file_name=lookup_list.csvThe Output for this query is show below
<?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>