Skip to content

Export Vendors From QuickBooks Online

This task will download vendors from Quickbooks Online to a Quickbooks Online Vendor XML file.

Download Vendors

Connection

Required
Select a connection to the Quickbooks Online company you want to use. See Connecting to QuickBooks Online

Export Settings -> Date Created

Required
When the 'Export Modified, New or All Records' setting is set to 'New', only records created after this date will be exported. The date will update automatically each time the task runs, to ensure that only records created since the task last ran will be exported.

Export Settings -> Date Modified

Required
When the 'Export Modified, New or All Records' setting is set to 'Modified', only records created or updated after this date will be exported. The date will update automatically each time the task runs, to ensure that only records modified since the task last ran will be exported.

Export Settings -> Export Modified, New or All Records

Required
Used to choose which records should be included in the export. The available options are:

  • All - All records will be exported, regardless of whether or not they have been created or updated since the task last ran.
  • New - Only records created since the task last ran will be exported.
  • Modified - Only records created or updated since the task last ran will be exported.

Filter

Optional
Allows a filter to be set to limit the data that is returned. The following operators are supported by Quickbooks Online:

  • Equals (e.g. CustomerRef = '123')
  • Greater than (e.g. TxnDate > '2016-01-01')
  • Greater than or equal to(e.g. TxnDate >= '2016-01-01')
  • Less than (e.g. TxnDate < '2016-01-01')
  • Less than or equal to (e.g. TxnDate <= '2016-01-01')
  • In (e.g. CustomerId IN ('1', '2'))
  • Like (e.g. GivenName LIKE 'Fred%')
  • And (e.g. Active = true AND GivenName LIKE 'Fred%')

Output File

Required
The file save exported records to.

Page Size

Required
The number of records to include in each page of results exported from Quickbooks. Increasing this value will speed up the export, but will use more memory. Defaults to 100.

Zynk Settings

See Common Task Settings

Available Filters

  • Id
  • GivenName
  • MiddleName
  • FamilyName
  • Suffix
  • DisplayName
  • CompanyName
  • PrintOnCheckName
  • Active
  • Balance

Examples

Sample output file:

<?xml version="1.0" encoding="utf-8"?>
<ArrayOfVendor
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <RecordOfVendor>
    <Data
      domain="QBO" sparse="false"
      xmlns="http://schema.intuit.com/finance/v3">
      <Id>23</Id>
      <SyncToken>0</SyncToken>
      <MetaData>
        <CreateTime>2018-01-17T14:22:30+00:00</CreateTime>
        <LastUpdatedTime>2018-01-17T14:22:30+00:00</LastUpdatedTime>
      </MetaData>
      <GivenName>Andrew</GivenName>
      <FamilyName>Haberbosch</FamilyName>
      <CompanyName>Andrew Haberbosch</CompanyName>
      <DisplayName>Andrew Haberbosch</DisplayName>
      <PrintOnCheckName>Andrew Haberbosch</PrintOnCheckName>
      <Active>true</Active>
      <BillAddr>
        <Id>24</Id>
        <Line1>Bromley House</Line1>
        <Line2>Staines</Line2>
        <City>Middlesex</City>
        <PostalCode>TW18 3JY</PostalCode>
        <Lat>51.4314384</Lat>
        <Long>-0.4989863</Long>
      </BillAddr>
      <Balance>0</Balance>
      <Vendor1099>false</Vendor1099>
      <CurrencyRef name="British Pound Sterling">GBP</CurrencyRef>
    </Data>
  </RecordOfVendor>
</ArrayOfVendor>