SSIS Components for Pipedrive

Build 24.0.9060

CreateRemoteFile

Creates a new empty file in the remote location (googledrive).

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 CreateRemoteFile are Filetype, Title,Itemid , Remotelocation and Itemtype. For example:

EXECUTE CreateRemoteFile Filetype = 'gdoc',  Title = 'tests', Itemid = '8230170', Remotelocation = 'googledrive', Itemtype = 'deal'

Input

Name Type Required Description
ItemId Integer True ID of the item to associate the file with.
FileType String True File type.

The allowed values are gdoc, gslides, gsheet, gform, gdraw.

Title String True Id of call logs.
ItemType String True Item type.

The allowed values are deal, organization, person.

RemoteLocation String True The location type to send the file to. Only googledrive is currently supported.

The allowed values are googledrive.

Result Set Columns

Name Type Description
Status String Execution status of the stored procedure

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