
Configuring Agendor as a Source
In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the Agendor option from the list of connectors. Click Next and you’ll be prompted to add your access.1. Add account access
You’ll need your Agendor API Token for this connection. You can find it in your Agendor account settings under Menu > Integrações. Once you have it, add the account access and the connector configuration. The following configurations are available:- Auth token: The token to authenticate against the API service.
- Start Date: The earliest date from which records will be synced. This should be in DD-MM-YYYY format. Records created or updated after this date will be extracted from the source.
2. Select streams
Choose which data streams you want to sync - you can select all streams or pick specific ones that matter most to you.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
3. Configure data streams
Customize how you want your data to appear in your catalog. Select a name for each table (which will contain the fetched data) and the type of sync.- Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix and make this process faster!
-
Sync Type: you can choose between INCREMENTAL and FULL_TABLE.
- Incremental: every time the extraction happens, we’ll get only the new data - which is good if, for example, you want to keep every record ever fetched.
- Full table: every time the extraction happens, we’ll get the current state of the data - which is good if, for example, you don’t want to have deleted data in your catalog.
4. Configure data source
Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can determine when to execute a full sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while. Once you are ready, click Next to finalize the setup.5. Check your new source
You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.For you to be able to see it on your Catalog, you need at least one successful source run.
Streams and Fields
Below you’ll find all available data streams from Agendor and their corresponding fields:Users
Users
Stream for managing team members and user accounts in Agendor.Key Fields:
id
- Unique identifier for the username
- Full name of the useraccountId
- Account IDcreatedAt
- When the user was createdisBlocked
- Whether the user is blocked
account
- Account details including features and capabilitiesaccount.features
- Available account features (elasticsearch, new_funnel, etc.)
contact
- Contact details including:email
- Email addresswork
- Work phone numbermobile
- Mobile phone numberfax
- Fax numberramal
- Extension numberradio
- Radio contactwhatsapp
- WhatsApp numberfacebook
- Facebook profiletwitter
- Twitter profilelinkedIn
- LinkedIn profileskype
- Skype contactinstagram
- Instagram profile
teams
- Array of teams the user belongs to, including team ID and leadership status
Deals
Deals
Core stream for deal management and sales pipeline tracking.Key Fields:
id
- Unique identifier for the dealtitle
- Title of the dealdescription
- Deal descriptionvalue
- Monetary value of the dealranking
- Deal ranking (1-5)startTime
- Deal start timeendTime
- Deal end timewonAt
- When the deal was wonlostAt
- When the deal was lostcreatedAt
- When the deal was createdupdatedAt
- When the deal was last updated
organization
- Related organization detailsperson
- Related person/contact detailsauthor
- User who created the dealowner
- User who owns the dealdealStage
- Current stage in the sales funneldealStatus
- Current status of the deallossReason
- Reason for deal loss (if applicable)
parentDealId
- Parent deal ID for deal hierarchiesaccountId
- Account IDproducts
- Array of products associated with the dealallowedUsers
- Users with access to this deal
customFields
- Custom field values specific to your organization
Organizations
Organizations
Stream for managing company and organization records.Key Fields:
id
- Unique identifier for the organizationname
- Organization namelegalName
- Legal name of the organizationemail
- Organization email addresscnpj
- Brazilian tax identification numberdescription
- Organization descriptionranking
- Organization rankingwebsite
- Organization websitecreatedAt
- When the organization was createdupdatedAt
- When the organization was last updated
logo
- Logo URLs in different sizes (full, thumb, thumb_large)
contact
- Complete contact details including phone numbers, social media, and messaging platforms
address
- Complete address including:country
- Countrystate
- State/Provincecity
- Citydistrict
- District/NeighborhoodstreetName
- Street namestreetNumber
- Street numberpostalCode
- Postal/ZIP codeadditionalInfo
- Additional address information
category
- Organization categoryleadOrigin
- Lead origin sourcesector
- Business sector
products
- Products associated with the organizationpeople
- People/contacts associated with the organizationauthor
- User who created the organizationownerUser
- User who owns the organizationallowedUsers
- Users with access to this organization
customFields
- Custom field values specific to your organization
People
People
Stream for managing contact information and person records.Key Fields:
id
- Unique identifier for the personname
- Full name of the personemail
- Email addresscpf
- Brazilian individual tax identification numberrole
- Person’s roleranking
- Person rankingdescription
- Person descriptionbirthday
- Birthdayavatar
- Avatar URLcreatedAt
- When the person was createdupdatedAt
- When the person was last updated
organization
- Organization this person belongs to
contact
- Complete contact details including phone numbers, social media, and messaging platforms
address
- Complete address including country, state, city, district, street details, and postal code
category
- Person categoryleadOrigin
- Lead origin source
products
- Products associated with the personauthor
- User who created the personownerUser
- User who owns the personallowedUsers
- Users with access to this person
customFields
- Custom field values specific to your organization
Tasks
Tasks
Stream for managing activities, tasks, and appointments.Key Fields:
id
- Unique identifier for the tasktext
- Task descriptiontype
- Task typedueDate
- Task due datefinishedAt
- When the task was completedcreatedAt
- When the task was createdupdatedAt
- When the task was last updated
user
- User assigned to the taskassignedUsers
- Array of users assigned to the taskfinishedBy
- User who completed the task
organization
- Related organizationperson
- Related person/contactdeal
- Related deal
metrics
- Array of task metrics including metric ID, name, and value
Funnels
Funnels
Stream for managing sales funnels and their configuration.Key Fields:
id
- Unique identifier for the funnelname
- Funnel nameinitials
- Funnel initialscolor
- Funnel colorsequence
- Funnel sequence orderdefault
- Whether this is the default funnel
dealStages
- Array of deal stages in this funnel, including:id
- Stage IDname
- Stage namesequence
- Stage sequence within the funnel
Categories
Categories
Stream for managing categories used to classify organizations and people.Key Fields:
id
- Unique identifier for the categoryname
- Category name
Sectors
Sectors
Stream for managing business sectors used to classify organizations.Key Fields:
id
- Unique identifier for the sectorname
- Sector name
Products
Products
Stream for managing products and services offered.Key Fields:
id
- Unique identifier for the productname
- Product namecode
- Product codeprice
- Product priceactive
- Whether the product is activecreatedAt
- When the product was created