JDBC Driver for Acumatica

Build 22.0.8462

CreateAttachment

Attach a file to a record.

Note: This procedure makes use of indexed parameters. These input parameters are denoted with a '#' character at the end of their names.

Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

Suppose there is an input parameter named Param#. Input multiple instances of an indexed parameter like this:

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

Input

Name Type Accepts Input Streams Description
TopLevelEntity String False The name of the entity for which you are going to attach a file.
KeyValue# String False The values for one or more key fields of the record to which you are going to attach a file. You should provide the number and order of key fields as they are defined on the corresponding Acumatica ERP form.
LocalFile String False The local file path including the file name of the file to be attached.
Content String True The file's content that you wish to upload should be a stream of input and the FilePath field should be kept blank.
FileName String False The name of the file that you are going to attach with the extension.

Result Set Columns

Name Type Description
Status String Specific message text describing the status or any errors or warning for the stored procedure.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462