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 | Accepts Input Streams | Description |
FileLocation | String | False | False | File to upload. |
FileName | String | False | False | Name of the file. If content is not empty. |
Content | String | False | True | The content as InputStream to be uploaded when FileLocation is not specified. |
FileDescription | String | False | False | Description of this file. |
ImageRotation | Integer | False | 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. |