Salesforce full reference
This is the full reference documentation for the Salesforce agent connector.
Supported entities and actions
The Salesforce connector supports the following entities and actions.
| Entity |
Actions |
| Sobjects |
List |
| Accounts |
List, Get, API Search, Search |
| Contacts |
List, Get, API Search, Search |
| Leads |
List, Get, API Search, Search |
| Opportunities |
List, Get, API Search, Search |
| Tasks |
List, Get, API Search, Search |
| Events |
List, Get, API Search |
| Campaigns |
List, Get, API Search |
| Cases |
List, Get, API Search |
| Notes |
List, Get, API Search |
| Content Versions |
List, Get, Download |
| Attachments |
List, Get, Download |
| Query |
List |
Sobjects
Sobjects List
Returns a list of all available Salesforce objects (sObjects) in the organization.
This endpoint is used for health checks to verify authentication and connectivity.
Python SDK
await salesforce.sobjects.list()
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "sobjects",
"action": "list"
}'
Records
| Field Name |
Type |
Description |
name |
string |
|
label |
null | string |
|
labelPlural |
null | string |
|
keyPrefix |
null | string |
|
custom |
null | boolean |
|
queryable |
null | boolean |
|
searchable |
null | boolean |
|
createable |
null | boolean |
|
updateable |
null | boolean |
|
deletable |
null | boolean |
|
urls |
null | object |
|
Accounts
Accounts List
Returns a list of accounts via SOQL query. Default returns up to 200 records.
For pagination, check the response: if done is false, use nextRecordsUrl to fetch the next page.
Python SDK
await salesforce.accounts.list(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "accounts",
"action": "list",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOQL query for accounts. Default returns up to 200 records. |
| To change the limit, provide your own query with a LIMIT clause. |
|
|
|
| Example: "SELECT FIELDS(STANDARD) FROM Account ORDER BY LastModifiedDate DESC LIMIT 50" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Meta
| Field Name |
Type |
Description |
done |
boolean |
|
nextRecordsUrl |
string |
|
Accounts Get
Get a single account by ID. Returns all accessible fields by default.
Use the fields parameter to retrieve only specific fields for better performance.
Python SDK
await salesforce.accounts.get(
id="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "accounts",
"action": "get",
"params": {
"id": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
id |
string |
Yes |
Salesforce Account ID (18-character ID starting with '001') |
fields |
string |
No |
Comma-separated list of fields to retrieve. If omitted, returns all accessible fields. |
| Example: "Id,Name,Industry,AnnualRevenue,Website" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Accounts API Search
Search for accounts using SOSL (Salesforce Object Search Language).
SOSL is optimized for text-based searches across multiple fields and objects.
Use SOQL (list action) for structured queries with specific field conditions.
Python SDK
await salesforce.accounts.api_search(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "accounts",
"action": "api_search",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOSL search query. Format: FIND {searchTerm} IN scope RETURNING Object(fields) [LIMIT n] |
| Examples: |
|
|
|
- "FIND {Acme} IN ALL FIELDS RETURNING Account(Id,Name)"
- "FIND {tech*} IN NAME FIELDS RETURNING Account(Id,Name,Industry) LIMIT 50"
- "FIND {"exact phrase"} RETURNING Account(Id,Name,Website)"
|
Records
| Field Name |
Type |
Description |
searchRecords |
array<object> |
|
Accounts Search
Search and filter accounts records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.
Python SDK
await salesforce.accounts.search(
query={"filter": {"eq": {"Id": "<str>"}}}
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "accounts",
"action": "search",
"params": {
"query": {"filter": {"eq": {"Id": "<str>"}}}
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
query |
object |
Yes |
Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or |
query.filter |
object |
No |
Filter conditions |
query.sort |
array |
No |
Sort conditions |
limit |
integer |
No |
Maximum results to return (default 1000) |
cursor |
string |
No |
Pagination cursor from previous response's next_cursor |
fields |
array |
No |
Field paths to include in results |
Searchable Fields
| Field Name |
Type |
Description |
Id |
string |
Unique identifier for the account record |
Name |
string |
Name of the account or company |
AccountSource |
string |
Source of the account record (e.g., Web, Referral) |
BillingAddress |
object |
Complete billing address as a compound field |
BillingCity |
string |
City portion of the billing address |
BillingCountry |
string |
Country portion of the billing address |
BillingPostalCode |
string |
Postal code portion of the billing address |
BillingState |
string |
State or province portion of the billing address |
BillingStreet |
string |
Street address portion of the billing address |
CreatedById |
string |
ID of the user who created this account |
CreatedDate |
string |
Date and time when the account was created |
Description |
string |
Text description of the account |
Industry |
string |
Primary business industry of the account |
IsDeleted |
boolean |
Whether the account has been moved to the Recycle Bin |
LastActivityDate |
string |
Date of the last activity associated with this account |
LastModifiedById |
string |
ID of the user who last modified this account |
LastModifiedDate |
string |
Date and time when the account was last modified |
NumberOfEmployees |
integer |
Number of employees at the account |
OwnerId |
string |
ID of the user who owns this account |
ParentId |
string |
ID of the parent account, if this is a subsidiary |
Phone |
string |
Primary phone number for the account |
ShippingAddress |
object |
Complete shipping address as a compound field |
ShippingCity |
string |
City portion of the shipping address |
ShippingCountry |
string |
Country portion of the shipping address |
ShippingPostalCode |
string |
Postal code portion of the shipping address |
ShippingState |
string |
State or province portion of the shipping address |
ShippingStreet |
string |
Street address portion of the shipping address |
Type |
string |
Type of account (e.g., Customer, Partner, Competitor) |
Website |
string |
Website URL for the account |
SystemModstamp |
string |
System timestamp when the record was last modified |
| Field Name |
Type |
Description |
hits |
array |
List of matching records |
hits[].id |
string |
Record identifier |
hits[].score |
number |
Relevance score |
hits[].data |
object |
Record data containing the searchable fields listed above |
hits[].data.Id |
string |
Unique identifier for the account record |
hits[].data.Name |
string |
Name of the account or company |
hits[].data.AccountSource |
string |
Source of the account record (e.g., Web, Referral) |
hits[].data.BillingAddress |
object |
Complete billing address as a compound field |
hits[].data.BillingCity |
string |
City portion of the billing address |
hits[].data.BillingCountry |
string |
Country portion of the billing address |
hits[].data.BillingPostalCode |
string |
Postal code portion of the billing address |
hits[].data.BillingState |
string |
State or province portion of the billing address |
hits[].data.BillingStreet |
string |
Street address portion of the billing address |
hits[].data.CreatedById |
string |
ID of the user who created this account |
hits[].data.CreatedDate |
string |
Date and time when the account was created |
hits[].data.Description |
string |
Text description of the account |
hits[].data.Industry |
string |
Primary business industry of the account |
hits[].data.IsDeleted |
boolean |
Whether the account has been moved to the Recycle Bin |
hits[].data.LastActivityDate |
string |
Date of the last activity associated with this account |
hits[].data.LastModifiedById |
string |
ID of the user who last modified this account |
hits[].data.LastModifiedDate |
string |
Date and time when the account was last modified |
hits[].data.NumberOfEmployees |
integer |
Number of employees at the account |
hits[].data.OwnerId |
string |
ID of the user who owns this account |
hits[].data.ParentId |
string |
ID of the parent account, if this is a subsidiary |
hits[].data.Phone |
string |
Primary phone number for the account |
hits[].data.ShippingAddress |
object |
Complete shipping address as a compound field |
hits[].data.ShippingCity |
string |
City portion of the shipping address |
hits[].data.ShippingCountry |
string |
Country portion of the shipping address |
hits[].data.ShippingPostalCode |
string |
Postal code portion of the shipping address |
hits[].data.ShippingState |
string |
State or province portion of the shipping address |
hits[].data.ShippingStreet |
string |
Street address portion of the shipping address |
hits[].data.Type |
string |
Type of account (e.g., Customer, Partner, Competitor) |
hits[].data.Website |
string |
Website URL for the account |
hits[].data.SystemModstamp |
string |
System timestamp when the record was last modified |
next_cursor |
string | null |
Cursor for next page of results |
took_ms |
number |
Query execution time in milliseconds |
Contacts
Contacts List
Returns a list of contacts via SOQL query. Default returns up to 200 records.
For pagination, check the response: if done is false, use nextRecordsUrl to fetch the next page.
Python SDK
await salesforce.contacts.list(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "contacts",
"action": "list",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOQL query for contacts. Default returns up to 200 records. |
| To change the limit, provide your own query with a LIMIT clause. |
|
|
|
| Example: "SELECT FIELDS(STANDARD) FROM Contact WHERE AccountId = '001xx...' LIMIT 50" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Meta
| Field Name |
Type |
Description |
done |
boolean |
|
nextRecordsUrl |
string |
|
Contacts Get
Get a single contact by ID. Returns all accessible fields by default.
Use the fields parameter to retrieve only specific fields for better performance.
Python SDK
await salesforce.contacts.get(
id="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "contacts",
"action": "get",
"params": {
"id": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
id |
string |
Yes |
Salesforce Contact ID (18-character ID starting with '003') |
fields |
string |
No |
Comma-separated list of fields to retrieve. If omitted, returns all accessible fields. |
| Example: "Id,FirstName,LastName,Email,Phone,AccountId" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Contacts API Search
Search for contacts using SOSL (Salesforce Object Search Language).
SOSL is optimized for text-based searches across multiple fields.
Python SDK
await salesforce.contacts.api_search(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "contacts",
"action": "api_search",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOSL search query. Format: FIND {searchTerm} RETURNING Contact(fields) [LIMIT n] |
| Examples: |
|
|
|
- "FIND {John} IN NAME FIELDS RETURNING Contact(Id,FirstName,LastName,Email)"
- "FIND {*@example.com} IN EMAIL FIELDS RETURNING Contact(Id,Name,Email) LIMIT 25"
|
Records
| Field Name |
Type |
Description |
searchRecords |
array<object> |
|
Contacts Search
Search and filter contacts records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.
Python SDK
await salesforce.contacts.search(
query={"filter": {"eq": {"Id": "<str>"}}}
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "contacts",
"action": "search",
"params": {
"query": {"filter": {"eq": {"Id": "<str>"}}}
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
query |
object |
Yes |
Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or |
query.filter |
object |
No |
Filter conditions |
query.sort |
array |
No |
Sort conditions |
limit |
integer |
No |
Maximum results to return (default 1000) |
cursor |
string |
No |
Pagination cursor from previous response's next_cursor |
fields |
array |
No |
Field paths to include in results |
Searchable Fields
| Field Name |
Type |
Description |
Id |
string |
Unique identifier for the contact record |
AccountId |
string |
ID of the account this contact is associated with |
CreatedById |
string |
ID of the user who created this contact |
CreatedDate |
string |
Date and time when the contact was created |
Department |
string |
Department within the account where the contact works |
Email |
string |
Email address of the contact |
FirstName |
string |
First name of the contact |
IsDeleted |
boolean |
Whether the contact has been moved to the Recycle Bin |
LastActivityDate |
string |
Date of the last activity associated with this contact |
LastModifiedById |
string |
ID of the user who last modified this contact |
LastModifiedDate |
string |
Date and time when the contact was last modified |
LastName |
string |
Last name of the contact |
LeadSource |
string |
Source from which this contact originated |
MailingAddress |
object |
Complete mailing address as a compound field |
MailingCity |
string |
City portion of the mailing address |
MailingCountry |
string |
Country portion of the mailing address |
MailingPostalCode |
string |
Postal code portion of the mailing address |
MailingState |
string |
State or province portion of the mailing address |
MailingStreet |
string |
Street address portion of the mailing address |
MobilePhone |
string |
Mobile phone number of the contact |
Name |
string |
Full name of the contact (read-only, concatenation of first and last name) |
OwnerId |
string |
ID of the user who owns this contact |
Phone |
string |
Business phone number of the contact |
ReportsToId |
string |
ID of the contact this contact reports to |
Title |
string |
Job title of the contact |
SystemModstamp |
string |
System timestamp when the record was last modified |
| Field Name |
Type |
Description |
hits |
array |
List of matching records |
hits[].id |
string |
Record identifier |
hits[].score |
number |
Relevance score |
hits[].data |
object |
Record data containing the searchable fields listed above |
hits[].data.Id |
string |
Unique identifier for the contact record |
hits[].data.AccountId |
string |
ID of the account this contact is associated with |
hits[].data.CreatedById |
string |
ID of the user who created this contact |
hits[].data.CreatedDate |
string |
Date and time when the contact was created |
hits[].data.Department |
string |
Department within the account where the contact works |
hits[].data.Email |
string |
Email address of the contact |
hits[].data.FirstName |
string |
First name of the contact |
hits[].data.IsDeleted |
boolean |
Whether the contact has been moved to the Recycle Bin |
hits[].data.LastActivityDate |
string |
Date of the last activity associated with this contact |
hits[].data.LastModifiedById |
string |
ID of the user who last modified this contact |
hits[].data.LastModifiedDate |
string |
Date and time when the contact was last modified |
hits[].data.LastName |
string |
Last name of the contact |
hits[].data.LeadSource |
string |
Source from which this contact originated |
hits[].data.MailingAddress |
object |
Complete mailing address as a compound field |
hits[].data.MailingCity |
string |
City portion of the mailing address |
hits[].data.MailingCountry |
string |
Country portion of the mailing address |
hits[].data.MailingPostalCode |
string |
Postal code portion of the mailing address |
hits[].data.MailingState |
string |
State or province portion of the mailing address |
hits[].data.MailingStreet |
string |
Street address portion of the mailing address |
hits[].data.MobilePhone |
string |
Mobile phone number of the contact |
hits[].data.Name |
string |
Full name of the contact (read-only, concatenation of first and last name) |
hits[].data.OwnerId |
string |
ID of the user who owns this contact |
hits[].data.Phone |
string |
Business phone number of the contact |
hits[].data.ReportsToId |
string |
ID of the contact this contact reports to |
hits[].data.Title |
string |
Job title of the contact |
hits[].data.SystemModstamp |
string |
System timestamp when the record was last modified |
next_cursor |
string | null |
Cursor for next page of results |
took_ms |
number |
Query execution time in milliseconds |
Leads
Leads List
Returns a list of leads via SOQL query. Default returns up to 200 records.
For pagination, check the response: if done is false, use nextRecordsUrl to fetch the next page.
Python SDK
await salesforce.leads.list(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "leads",
"action": "list",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOQL query for leads. Default returns up to 200 records. |
| To change the limit, provide your own query with a LIMIT clause. |
|
|
|
| Example: "SELECT FIELDS(STANDARD) FROM Lead WHERE Status = 'Open' LIMIT 100" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Meta
| Field Name |
Type |
Description |
done |
boolean |
|
nextRecordsUrl |
string |
|
Leads Get
Get a single lead by ID. Returns all accessible fields by default.
Use the fields parameter to retrieve only specific fields for better performance.
Python SDK
await salesforce.leads.get(
id="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "leads",
"action": "get",
"params": {
"id": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
id |
string |
Yes |
Salesforce Lead ID (18-character ID starting with '00Q') |
fields |
string |
No |
Comma-separated list of fields to retrieve. If omitted, returns all accessible fields. |
| Example: "Id,FirstName,LastName,Email,Company,Status,LeadSource" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Leads API Search
Search for leads using SOSL (Salesforce Object Search Language).
SOSL is optimized for text-based searches across multiple fields.
Python SDK
await salesforce.leads.api_search(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "leads",
"action": "api_search",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOSL search query. Format: FIND {searchTerm} RETURNING Lead(fields) [LIMIT n] |
| Examples: |
|
|
|
- "FIND {Smith} IN NAME FIELDS RETURNING Lead(Id,FirstName,LastName,Company,Status)"
- "FIND {marketing} IN ALL FIELDS RETURNING Lead(Id,Name,LeadSource) LIMIT 50"
|
Records
| Field Name |
Type |
Description |
searchRecords |
array<object> |
|
Leads Search
Search and filter leads records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.
Python SDK
await salesforce.leads.search(
query={"filter": {"eq": {"Id": "<str>"}}}
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "leads",
"action": "search",
"params": {
"query": {"filter": {"eq": {"Id": "<str>"}}}
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
query |
object |
Yes |
Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or |
query.filter |
object |
No |
Filter conditions |
query.sort |
array |
No |
Sort conditions |
limit |
integer |
No |
Maximum results to return (default 1000) |
cursor |
string |
No |
Pagination cursor from previous response's next_cursor |
fields |
array |
No |
Field paths to include in results |
Searchable Fields
| Field Name |
Type |
Description |
Id |
string |
Unique identifier for the lead record |
Address |
object |
Complete address as a compound field |
City |
string |
City portion of the address |
Company |
string |
Company or organization the lead works for |
ConvertedAccountId |
string |
ID of the account created when lead was converted |
ConvertedContactId |
string |
ID of the contact created when lead was converted |
ConvertedDate |
string |
Date when the lead was converted |
ConvertedOpportunityId |
string |
ID of the opportunity created when lead was converted |
Country |
string |
Country portion of the address |
CreatedById |
string |
ID of the user who created this lead |
CreatedDate |
string |
Date and time when the lead was created |
Email |
string |
Email address of the lead |
FirstName |
string |
First name of the lead |
Industry |
string |
Industry the lead's company operates in |
IsConverted |
boolean |
Whether the lead has been converted to an account, contact, and opportunity |
IsDeleted |
boolean |
Whether the lead has been moved to the Recycle Bin |
LastActivityDate |
string |
Date of the last activity associated with this lead |
LastModifiedById |
string |
ID of the user who last modified this lead |
LastModifiedDate |
string |
Date and time when the lead was last modified |
LastName |
string |
Last name of the lead |
LeadSource |
string |
Source from which this lead originated |
MobilePhone |
string |
Mobile phone number of the lead |
Name |
string |
Full name of the lead (read-only, concatenation of first and last name) |
NumberOfEmployees |
integer |
Number of employees at the lead's company |
OwnerId |
string |
ID of the user who owns this lead |
Phone |
string |
Phone number of the lead |
PostalCode |
string |
Postal code portion of the address |
Rating |
string |
Rating of the lead (e.g., Hot, Warm, Cold) |
State |
string |
State or province portion of the address |
Status |
string |
Current status of the lead in the sales process |
Street |
string |
Street address portion of the address |
Title |
string |
Job title of the lead |
Website |
string |
Website URL for the lead's company |
SystemModstamp |
string |
System timestamp when the record was last modified |
| Field Name |
Type |
Description |
hits |
array |
List of matching records |
hits[].id |
string |
Record identifier |
hits[].score |
number |
Relevance score |
hits[].data |
object |
Record data containing the searchable fields listed above |
hits[].data.Id |
string |
Unique identifier for the lead record |
hits[].data.Address |
object |
Complete address as a compound field |
hits[].data.City |
string |
City portion of the address |
hits[].data.Company |
string |
Company or organization the lead works for |
hits[].data.ConvertedAccountId |
string |
ID of the account created when lead was converted |
hits[].data.ConvertedContactId |
string |
ID of the contact created when lead was converted |
hits[].data.ConvertedDate |
string |
Date when the lead was converted |
hits[].data.ConvertedOpportunityId |
string |
ID of the opportunity created when lead was converted |
hits[].data.Country |
string |
Country portion of the address |
hits[].data.CreatedById |
string |
ID of the user who created this lead |
hits[].data.CreatedDate |
string |
Date and time when the lead was created |
hits[].data.Email |
string |
Email address of the lead |
hits[].data.FirstName |
string |
First name of the lead |
hits[].data.Industry |
string |
Industry the lead's company operates in |
hits[].data.IsConverted |
boolean |
Whether the lead has been converted to an account, contact, and opportunity |
hits[].data.IsDeleted |
boolean |
Whether the lead has been moved to the Recycle Bin |
hits[].data.LastActivityDate |
string |
Date of the last activity associated with this lead |
hits[].data.LastModifiedById |
string |
ID of the user who last modified this lead |
hits[].data.LastModifiedDate |
string |
Date and time when the lead was last modified |
hits[].data.LastName |
string |
Last name of the lead |
hits[].data.LeadSource |
string |
Source from which this lead originated |
hits[].data.MobilePhone |
string |
Mobile phone number of the lead |
hits[].data.Name |
string |
Full name of the lead (read-only, concatenation of first and last name) |
hits[].data.NumberOfEmployees |
integer |
Number of employees at the lead's company |
hits[].data.OwnerId |
string |
ID of the user who owns this lead |
hits[].data.Phone |
string |
Phone number of the lead |
hits[].data.PostalCode |
string |
Postal code portion of the address |
hits[].data.Rating |
string |
Rating of the lead (e.g., Hot, Warm, Cold) |
hits[].data.State |
string |
State or province portion of the address |
hits[].data.Status |
string |
Current status of the lead in the sales process |
hits[].data.Street |
string |
Street address portion of the address |
hits[].data.Title |
string |
Job title of the lead |
hits[].data.Website |
string |
Website URL for the lead's company |
hits[].data.SystemModstamp |
string |
System timestamp when the record was last modified |
next_cursor |
string | null |
Cursor for next page of results |
took_ms |
number |
Query execution time in milliseconds |
Opportunities
Opportunities List
Returns a list of opportunities via SOQL query. Default returns up to 200 records.
For pagination, check the response: if done is false, use nextRecordsUrl to fetch the next page.
Python SDK
await salesforce.opportunities.list(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "opportunities",
"action": "list",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOQL query for opportunities. Default returns up to 200 records. |
| To change the limit, provide your own query with a LIMIT clause. |
|
|
|
| Example: "SELECT FIELDS(STANDARD) FROM Opportunity WHERE StageName = 'Closed Won' LIMIT 50" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Meta
| Field Name |
Type |
Description |
done |
boolean |
|
nextRecordsUrl |
string |
|
Opportunities Get
Get a single opportunity by ID. Returns all accessible fields by default.
Use the fields parameter to retrieve only specific fields for better performance.
Python SDK
await salesforce.opportunities.get(
id="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "opportunities",
"action": "get",
"params": {
"id": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
id |
string |
Yes |
Salesforce Opportunity ID (18-character ID starting with '006') |
fields |
string |
No |
Comma-separated list of fields to retrieve. If omitted, returns all accessible fields. |
| Example: "Id,Name,Amount,StageName,CloseDate,AccountId" |
|
|
|
|
|
|
|
Records
| Field Name |
Type |
Description |
Id |
string |
|
Name |
string |
|
attributes |
object |
|
Opportunities API Search
Search for opportunities using SOSL (Salesforce Object Search Language).
SOSL is optimized for text-based searches across multiple fields.
Python SDK
await salesforce.opportunities.api_search(
q="<str>"
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "opportunities",
"action": "api_search",
"params": {
"q": "<str>"
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
q |
string |
Yes |
SOSL search query. Format: FIND {searchTerm} RETURNING Opportunity(fields) [LIMIT n] |
| Examples: |
|
|
|
- "FIND {Enterprise} IN NAME FIELDS RETURNING Opportunity(Id,Name,Amount,StageName)"
- "FIND {renewal} IN ALL FIELDS RETURNING Opportunity(Id,Name,CloseDate) LIMIT 25"
|
Records
| Field Name |
Type |
Description |
searchRecords |
array<object> |
|
Opportunities Search
Search and filter opportunities records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.
Python SDK
await salesforce.opportunities.search(
query={"filter": {"eq": {"Id": "<str>"}}}
)
API
curl --location 'https://api.airbyte.ai/api/v1/connectors/sources/{your_source_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
"entity": "opportunities",
"action": "search",
"params": {
"query": {"filter": {"eq": {"Id": "<str>"}}}
}
}'
Parameters
| Parameter Name |
Type |
Required |
Description |
query |
object |
Yes |
Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or |
query.filter |
object |
No |
Filter conditions |
query.sort |
array |
No |
Sort conditions |
limit |
integer |
No |
Maximum results to return (default 1000) |
cursor |
string |
No |
Pagination cursor from previous response's next_cursor |
fields |
array |
No |
Field paths to include in results |
Searchable Fields
| Field Name |
Type |
Description |
Id |
string |
Unique identifier for the opportunity record |
AccountId |
string |
ID of the account associated with this opportunity |
Amount |
number |
Estimated total sale amount |
CampaignId |
string |
ID of the campaign that generated this opportunity |
CloseDate |
string |
Expected close date for the opportunity |
ContactId |
string |
ID of the primary contact for this opportunity |
CreatedById |
string |
ID of the user who created this opportunity |
CreatedDate |
string |
Date and time when the opportunity was created |
Description |
string |
Text description of the opportunity |
ExpectedRevenue |
number |
Expected revenue based on amount and probability |
ForecastCategory |
string |
Forecast category for this opportunity |
ForecastCategoryName |
string |
Name of the forecast category |
IsClosed |
`boo |
|
…(truncated)