SSIS Components for Pipedrive

Build 24.0.9060

DealsFiles

Get details of deals file.

Select

The component will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the component.

  • DealId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM DealsFiles WHERE DealId = 246

Columns

Name Type Description
Id [KEY] Integer ID of the deal.
ActiveFlag Boolean Active Flag.
ActivityId String Activity Id.
AddTime Datetime AddTime.
Cid String Cid.
DealId String Deal Id.
DealName String DealName.
Description String Description.
FileName String File Name.
FileSize Integer File Size.
FileType String File Type.
InlineFlag Boolean Inline Flag.
LogId String Log Id.
MailMessageId String MailMessage Id.
MailTemplateId String MailTemplate Id.
Name String Name.
OrgId Integer Org Id.
OrgName String Org Name.
PeopleName String People Name.
PersonId String PersonId.
PersonName String Person Name.
ProductId String Product Id.
ProductName String Product Name.
RemoteId String Remote Id.
RemoteLocation String Remote Location.
S3Bucket String S3Bucket.
UpdateTime Datetime Update Time.
Url String Url.
UserId Integer UserId.
LeadId String Lead Id.
LeadName String Lead Name.

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