SSIS Components for QuickBooks Time

Build 24.0.9062

UploadFile

Uploads the file. Only .png, .jpeg, .jpg file formats are allowed.

Stored Procedure Specific Information

QuickBooks Time allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. For example:

EXECUTE UploadFile FileLocation = 'D:\\Desktop\\Test.png'

EXECUTE UploadFile FileLocation = 'D:\\Desktop\\Test.png', FileDescription = 'Test file'

Input

Name Type Required Description
FileLocation String False File to upload.
FileName String False Name of the file. If content is not empty.
FileDescription String False Description of this file.
ImageRotation Integer False Original image orientation in degrees. Accepted values are: 0 (top), 90 (right), 180 (bottom), 270 (left).

使用できる値は次のとおりです。0, 90, 180, 270

Result Set Columns

Name Type Description
Success String True if the image is uploaded successfully.

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