SSIS Components for QuickBooks Online

Build 20.0.7587




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

The ID of the Entity Ref of the attachable.

AttachableId [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.

AttachableRef_EntityRef# String False true false


AttachableRef_EntityRef_type# String False true false


AttachableRef_EntityRef_name# String False false false

Type name

AttachableRef_IncludeOnSend# Boolean False true false

On sending email to customer (most likely for txns), this field indicates whether or not the attachment is to be sent together with the email.

AttachableRef_LineInfo# String False true true

If the entity is a transaction, user can also specify a transaction detail line to reference.

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587