SSIS Components for Pipedrive

Build 24.0.9060

OrganizationsFiles

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.

  • OrgId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OrganizationsFiles WHERE OrgId = 6 

Columns

Name Type Description
Id [KEY] Integer ID of the organizations.
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 Produc tId.
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 LeadId.
LeadName String LeadName.

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