JDBC Driver for Pipedrive

Build 22.0.8462

AddFile

Upload a file and associate it with Deal, Person, Organization, Activity or Product.

Stored Procedure Specific Information

Pipedrive allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. The required columns in AddFile are FileLocation . For example:

EXECUTE AddFile DealId = '12', FileLocation = 'C:\Users\Downloads\file_example_MP3_1MG.mp3'

Input

Name Type Required Accepts Input Streams Description
DealId Integer False False ID of the deal to associate file(s) with.
PersonId Integer False False ID of the person to associate file(s) with.
OrgId Integer False False ID of the organization to associate file(s) with.
ProductId Integer False False ID of the product to associate file(s) with.
ActivityId Integer False False ID of the activity to associate file(s) with.
FileLocation String False False File to upload.
Content String False True The content as InputStream to be uploaded when FileLocation is not specified.

Result Set Columns

Name Type Description
Status String Execution status of the stored procedure.

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