SSIS Components for QuickBooks Online

Build 24.0.9062

Attachables

Attachables

Table Specific Information

Select

All filterable columns support the following operators:

  • =
  • !=
  • >=
  • <=
  • >
  • <
  • IN
  • LIKE
  • CONTAINS

The driver processes other filters client-side within the driver.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

The Id of the attachable.

SyncToken String True False False

The version number of the entity. This must be specified when executing an update or delete.

MetaData_CreateTime Datetime True True True

The time the record was created.

MetaData_LastUpdatedTime Datetime True True True

The time the record was last updated.

FileName String False True True

FileName of the attachment.

Size Integer False True True

Size of the attachment.

ContentType String False True True

ContentType of the attachment.

Category String False True True

Category of the attachment.

Latitude Double False True True

Latitude from where the attachment was requested.

Longitude Double False True True

Longitude from where the attachment was requested.

Note String False True True

Note either related to the attachment or as a standalone note.

PlaceName String False True True

PlaceName from where the attachment was requested.

Tag String False True True

Tag name for the requested attachment.

AttachableRefAggregate String False False False

Aggregate that specifies the transaction object to which this attachable file is to be linked

FileAccessUri String False True True

FullPath FileAccess URI of the attachment.

TempDownloadUri String False True True

TempDownload URI which can be directly downloaded by clients.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062