Salesforce full reference

This connector is optimized for AI agents. For the data replication connector, see Salesforce.

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, Context Store Search
Contacts	List, Get, API Search, Context Store Search
Leads	List, Get, API Search, Context Store Search
Opportunities	List, Get, API Search, Context Store Search
Tasks	List, Get, API Search, Context Store 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
Reports	List, Get
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/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "sobjects",
    "action": "list"
}'

Response Schema

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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)" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Accounts Context Store 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.context_store_search(
    query={"filter": {"eq": {"Id": "<str>"}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "accounts",
    "action": "context_store_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 meta.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

Response Schema

Field Name	Type	Description
data	array	List of matching records
meta	object	Pagination metadata
meta.has_more	boolean	Whether additional pages are available
meta.cursor	string | null	Cursor for next page of results
meta.took_ms	number | null	Query execution time in milliseconds
data[].Id	string	Unique identifier for the account record
data[].Name	string	Name of the account or company
data[].AccountSource	string	Source of the account record (e.g., Web, Referral)
data[].BillingAddress	object	Complete billing address as a compound field
data[].BillingCity	string	City portion of the billing address
data[].BillingCountry	string	Country portion of the billing address
data[].BillingPostalCode	string	Postal code portion of the billing address
data[].BillingState	string	State or province portion of the billing address
data[].BillingStreet	string	Street address portion of the billing address
data[].CreatedById	string	ID of the user who created this account
data[].CreatedDate	string	Date and time when the account was created
data[].Description	string	Text description of the account
data[].Industry	string	Primary business industry of the account
data[].IsDeleted	boolean	Whether the account has been moved to the Recycle Bin
data[].LastActivityDate	string	Date of the last activity associated with this account
data[].LastModifiedById	string	ID of the user who last modified this account
data[].LastModifiedDate	string	Date and time when the account was last modified
data[].NumberOfEmployees	integer	Number of employees at the account
data[].OwnerId	string	ID of the user who owns this account
data[].ParentId	string	ID of the parent account, if this is a subsidiary
data[].Phone	string	Primary phone number for the account
data[].ShippingAddress	object	Complete shipping address as a compound field
data[].ShippingCity	string	City portion of the shipping address
data[].ShippingCountry	string	Country portion of the shipping address
data[].ShippingPostalCode	string	Postal code portion of the shipping address
data[].ShippingState	string	State or province portion of the shipping address
data[].ShippingStreet	string	Street address portion of the shipping address
data[].Type	string	Type of account (e.g., Customer, Partner, Competitor)
data[].Website	string	Website URL for the account
data[].SystemModstamp	string	System timestamp when the record was last modified

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Contacts Context Store 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.context_store_search(
    query={"filter": {"eq": {"Id": "<str>"}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "contacts",
    "action": "context_store_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 meta.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

Response Schema

Field Name	Type	Description
data	array	List of matching records
meta	object	Pagination metadata
meta.has_more	boolean	Whether additional pages are available
meta.cursor	string | null	Cursor for next page of results
meta.took_ms	number | null	Query execution time in milliseconds
data[].Id	string	Unique identifier for the contact record
data[].AccountId	string	ID of the account this contact is associated with
data[].CreatedById	string	ID of the user who created this contact
data[].CreatedDate	string	Date and time when the contact was created
data[].Department	string	Department within the account where the contact works
data[].Email	string	Email address of the contact
data[].FirstName	string	First name of the contact
data[].IsDeleted	boolean	Whether the contact has been moved to the Recycle Bin
data[].LastActivityDate	string	Date of the last activity associated with this contact
data[].LastModifiedById	string	ID of the user who last modified this contact
data[].LastModifiedDate	string	Date and time when the contact was last modified
data[].LastName	string	Last name of the contact
data[].LeadSource	string	Source from which this contact originated
data[].MailingAddress	object	Complete mailing address as a compound field
data[].MailingCity	string	City portion of the mailing address
data[].MailingCountry	string	Country portion of the mailing address
data[].MailingPostalCode	string	Postal code portion of the mailing address
data[].MailingState	string	State or province portion of the mailing address
data[].MailingStreet	string	Street address portion of the mailing address
data[].MobilePhone	string	Mobile phone number of the contact
data[].Name	string	Full name of the contact (read-only, concatenation of first and last name)
data[].OwnerId	string	ID of the user who owns this contact
data[].Phone	string	Business phone number of the contact
data[].ReportsToId	string	ID of the contact this contact reports to
data[].Title	string	Job title of the contact
data[].SystemModstamp	string	System timestamp when the record was last modified

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Leads Context Store 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.context_store_search(
    query={"filter": {"eq": {"Id": "<str>"}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "leads",
    "action": "context_store_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 meta.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

Response Schema

Field Name	Type	Description
data	array	List of matching records
meta	object	Pagination metadata
meta.has_more	boolean	Whether additional pages are available
meta.cursor	string | null	Cursor for next page of results
meta.took_ms	number | null	Query execution time in milliseconds
data[].Id	string	Unique identifier for the lead record
data[].Address	object	Complete address as a compound field
data[].City	string	City portion of the address
data[].Company	string	Company or organization the lead works for
data[].ConvertedAccountId	string	ID of the account created when lead was converted
data[].ConvertedContactId	string	ID of the contact created when lead was converted
data[].ConvertedDate	string	Date when the lead was converted
data[].ConvertedOpportunityId	string	ID of the opportunity created when lead was converted
data[].Country	string	Country portion of the address
data[].CreatedById	string	ID of the user who created this lead
data[].CreatedDate	string	Date and time when the lead was created
data[].Email	string	Email address of the lead
data[].FirstName	string	First name of the lead
data[].Industry	string	Industry the lead's company operates in
data[].IsConverted	boolean	Whether the lead has been converted to an account, contact, and opportunity
data[].IsDeleted	boolean	Whether the lead has been moved to the Recycle Bin
data[].LastActivityDate	string	Date of the last activity associated with this lead
data[].LastModifiedById	string	ID of the user who last modified this lead
data[].LastModifiedDate	string	Date and time when the lead was last modified
data[].LastName	string	Last name of the lead
data[].LeadSource	string	Source from which this lead originated
data[].MobilePhone	string	Mobile phone number of the lead
data[].Name	string	Full name of the lead (read-only, concatenation of first and last name)
data[].NumberOfEmployees	integer	Number of employees at the lead's company
data[].OwnerId	string	ID of the user who owns this lead
data[].Phone	string	Phone number of the lead
data[].PostalCode	string	Postal code portion of the address
data[].Rating	string	Rating of the lead (e.g., Hot, Warm, Cold)
data[].State	string	State or province portion of the address
data[].Status	string	Current status of the lead in the sales process
data[].Street	string	Street address portion of the address
data[].Title	string	Job title of the lead
data[].Website	string	Website URL for the lead's company
data[].SystemModstamp	string	System timestamp when the record was last modified

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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"

Response Schema

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/integrations/connectors/{your_connector_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" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Opportunities Context Store 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.context_store_search(
    query={"filter": {"eq": {"Id": "<str>"}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "opportunities",
    "action": "context_store_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 meta.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	boolean	Whether the opportunity is closed
IsDeleted	boolean	Whether the opportunity has been moved to the Recycle Bin
IsWon	boolean	Whether the opportunity was won
LastActivityDate	string	Date of the last activity associated with this opportunity
LastModifiedById	string	ID of the user who last modified this opportunity
LastModifiedDate	string	Date and time when the opportunity was last modified
LeadSource	string	Source from which this opportunity originated
Name	string	Name of the opportunity
NextStep	string	Description of the next step in closing the opportunity
OwnerId	string	ID of the user who owns this opportunity
Probability	number	Likelihood of closing the opportunity (percentage)
StageName	string	Current stage of the opportunity in the sales process
Type	string	Type of opportunity (e.g., New Business, Existing Business)
SystemModstamp	string	System timestamp when the record was last modified

Response Schema

Field Name	Type	Description
data	array	List of matching records
meta	object	Pagination metadata
meta.has_more	boolean	Whether additional pages are available
meta.cursor	string | null	Cursor for next page of results
meta.took_ms	number | null	Query execution time in milliseconds
data[].Id	string	Unique identifier for the opportunity record
data[].AccountId	string	ID of the account associated with this opportunity
data[].Amount	number	Estimated total sale amount
data[].CampaignId	string	ID of the campaign that generated this opportunity
data[].CloseDate	string	Expected close date for the opportunity
data[].ContactId	string	ID of the primary contact for this opportunity
data[].CreatedById	string	ID of the user who created this opportunity
data[].CreatedDate	string	Date and time when the opportunity was created
data[].Description	string	Text description of the opportunity
data[].ExpectedRevenue	number	Expected revenue based on amount and probability
data[].ForecastCategory	string	Forecast category for this opportunity
data[].ForecastCategoryName	string	Name of the forecast category
data[].IsClosed	boolean	Whether the opportunity is closed
data[].IsDeleted	boolean	Whether the opportunity has been moved to the Recycle Bin
data[].IsWon	boolean	Whether the opportunity was won
data[].LastActivityDate	string	Date of the last activity associated with this opportunity
data[].LastModifiedById	string	ID of the user who last modified this opportunity
data[].LastModifiedDate	string	Date and time when the opportunity was last modified
data[].LeadSource	string	Source from which this opportunity originated
data[].Name	string	Name of the opportunity
data[].NextStep	string	Description of the next step in closing the opportunity
data[].OwnerId	string	ID of the user who owns this opportunity
data[].Probability	number	Likelihood of closing the opportunity (percentage)
data[].StageName	string	Current stage of the opportunity in the sales process
data[].Type	string	Type of opportunity (e.g., New Business, Existing Business)
data[].SystemModstamp	string	System timestamp when the record was last modified

Tasks

Tasks List

Returns a list of tasks 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.tasks.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tasks",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for tasks. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT FIELDS(STANDARD) FROM Task WHERE Status = 'Not Started' LIMIT 100"

Response Schema

Records

Field Name	Type	Description
Id	string
Subject	string
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Tasks Get

Get a single task by ID. Returns all accessible fields by default. Use the fields parameter to retrieve only specific fields for better performance.

Python SDK

await salesforce.tasks.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tasks",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Task ID (18-character ID starting with '00T')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,Subject,Status,Priority,ActivityDate,WhoId,WhatId"

Response Schema

Records

Field Name	Type	Description
Id	string
Subject	string
attributes	object

Tasks API Search

Search for tasks using SOSL (Salesforce Object Search Language). SOSL is optimized for text-based searches across multiple fields.

Python SDK

await salesforce.tasks.api_search(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tasks",
    "action": "api_search",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOSL search query. Format: FIND {searchTerm} RETURNING Task(fields) [LIMIT n]
Examples:

• "FIND {follow up} IN ALL FIELDS RETURNING Task(Id,Subject,Status,Priority)"
• "FIND {call} IN NAME FIELDS RETURNING Task(Id,Subject,ActivityDate) LIMIT 50" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Tasks Context Store Search

Search and filter tasks 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.tasks.context_store_search(
    query={"filter": {"eq": {"Id": "<str>"}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tasks",
    "action": "context_store_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 meta.cursor
fields	array	No	Field paths to include in results

Searchable Fields

Field Name	Type	Description
Id	string	Unique identifier for the task record
AccountId	string	ID of the account associated with this task
ActivityDate	string	Due date for the task
CallDisposition	string	Result of the call, if this task represents a call
CallDurationInSeconds	integer	Duration of the call in seconds
CallType	string	Type of call (Inbound, Outbound, Internal)
CompletedDateTime	string	Date and time when the task was completed
CreatedById	string	ID of the user who created this task
CreatedDate	string	Date and time when the task was created
Description	string	Text description or notes about the task
IsClosed	boolean	Whether the task has been completed
IsDeleted	boolean	Whether the task has been moved to the Recycle Bin
IsHighPriority	boolean	Whether the task is marked as high priority
LastModifiedById	string	ID of the user who last modified this task
LastModifiedDate	string	Date and time when the task was last modified
OwnerId	string	ID of the user who owns this task
Priority	string	Priority level of the task (High, Normal, Low)
Status	string	Current status of the task
Subject	string	Subject or title of the task
TaskSubtype	string	Subtype of the task (e.g., Call, Email, Task)
Type	string	Type of task
WhatId	string	ID of the related object (Account, Opportunity, etc.)
WhoId	string	ID of the related person (Contact or Lead)
SystemModstamp	string	System timestamp when the record was last modified

Response Schema

Field Name	Type	Description
data	array	List of matching records
meta	object	Pagination metadata
meta.has_more	boolean	Whether additional pages are available
meta.cursor	string | null	Cursor for next page of results
meta.took_ms	number | null	Query execution time in milliseconds
data[].Id	string	Unique identifier for the task record
data[].AccountId	string	ID of the account associated with this task
data[].ActivityDate	string	Due date for the task
data[].CallDisposition	string	Result of the call, if this task represents a call
data[].CallDurationInSeconds	integer	Duration of the call in seconds
data[].CallType	string	Type of call (Inbound, Outbound, Internal)
data[].CompletedDateTime	string	Date and time when the task was completed
data[].CreatedById	string	ID of the user who created this task
data[].CreatedDate	string	Date and time when the task was created
data[].Description	string	Text description or notes about the task
data[].IsClosed	boolean	Whether the task has been completed
data[].IsDeleted	boolean	Whether the task has been moved to the Recycle Bin
data[].IsHighPriority	boolean	Whether the task is marked as high priority
data[].LastModifiedById	string	ID of the user who last modified this task
data[].LastModifiedDate	string	Date and time when the task was last modified
data[].OwnerId	string	ID of the user who owns this task
data[].Priority	string	Priority level of the task (High, Normal, Low)
data[].Status	string	Current status of the task
data[].Subject	string	Subject or title of the task
data[].TaskSubtype	string	Subtype of the task (e.g., Call, Email, Task)
data[].Type	string	Type of task
data[].WhatId	string	ID of the related object (Account, Opportunity, etc.)
data[].WhoId	string	ID of the related person (Contact or Lead)
data[].SystemModstamp	string	System timestamp when the record was last modified

Events

Events List

Returns a list of events 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.events.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "events",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for events. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT FIELDS(STANDARD) FROM Event WHERE StartDateTime > TODAY LIMIT 50"

Response Schema

Records

Field Name	Type	Description
Id	string
Subject	string
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Events Get

Get a single event by ID. Returns all accessible fields by default. Use the fields parameter to retrieve only specific fields for better performance.

Python SDK

await salesforce.events.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "events",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Event ID (18-character ID starting with '00U')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,Subject,StartDateTime,EndDateTime,Location,WhoId,WhatId"

Response Schema

Records

Field Name	Type	Description
Id	string
Subject	string
attributes	object

Events API Search

Search for events using SOSL (Salesforce Object Search Language). SOSL is optimized for text-based searches across multiple fields.

Python SDK

await salesforce.events.api_search(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "events",
    "action": "api_search",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOSL search query. Format: FIND {searchTerm} RETURNING Event(fields) [LIMIT n]
Examples:

• "FIND {meeting} IN ALL FIELDS RETURNING Event(Id,Subject,StartDateTime,Location)"
• "FIND {demo} IN NAME FIELDS RETURNING Event(Id,Subject,EndDateTime) LIMIT 25" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Campaigns

Campaigns List

Returns a list of campaigns 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.campaigns.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "campaigns",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for campaigns. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT FIELDS(STANDARD) FROM Campaign WHERE IsActive = true LIMIT 50"

Response Schema

Records

Field Name	Type	Description
Id	string
Name	string
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Campaigns Get

Get a single campaign by ID. Returns all accessible fields by default. Use the fields parameter to retrieve only specific fields for better performance.

Python SDK

await salesforce.campaigns.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "campaigns",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Campaign ID (18-character ID starting with '701')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,Name,Type,Status,StartDate,EndDate,IsActive"

Response Schema

Records

Field Name	Type	Description
Id	string
Name	string
attributes	object

Campaigns API Search

Search for campaigns using SOSL (Salesforce Object Search Language). SOSL is optimized for text-based searches across multiple fields.

Python SDK

await salesforce.campaigns.api_search(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "campaigns",
    "action": "api_search",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOSL search query. Format: FIND {searchTerm} RETURNING Campaign(fields) [LIMIT n]
Examples:

• "FIND {webinar} IN ALL FIELDS RETURNING Campaign(Id,Name,Type,Status)"
• "FIND {2024} IN NAME FIELDS RETURNING Campaign(Id,Name,StartDate,IsActive) LIMIT 50" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Cases

Cases List

Returns a list of cases 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.cases.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "cases",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for cases. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT FIELDS(STANDARD) FROM Case WHERE Status = 'New' LIMIT 100"

Response Schema

Records

Field Name	Type	Description
Id	string
CaseNumber	string
Subject	string
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Cases Get

Get a single case by ID. Returns all accessible fields by default. Use the fields parameter to retrieve only specific fields for better performance.

Python SDK

await salesforce.cases.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "cases",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Case ID (18-character ID starting with '500')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,CaseNumber,Subject,Status,Priority,ContactId,AccountId"

Response Schema

Records

Field Name	Type	Description
Id	string
CaseNumber	string
Subject	string
attributes	object

Cases API Search

Search for cases using SOSL (Salesforce Object Search Language). SOSL is optimized for text-based searches across multiple fields.

Python SDK

await salesforce.cases.api_search(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "cases",
    "action": "api_search",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOSL search query. Format: FIND {searchTerm} RETURNING Case(fields) [LIMIT n]
Examples:

• "FIND {login issue} IN ALL FIELDS RETURNING Case(Id,CaseNumber,Subject,Status)"
• "FIND {urgent} IN NAME FIELDS RETURNING Case(Id,Subject,Priority) LIMIT 25" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Notes

Notes List

Returns a list of notes 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.notes.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "notes",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for notes. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT FIELDS(STANDARD) FROM Note WHERE ParentId = '001xx...' LIMIT 50"

Response Schema

Records

Field Name	Type	Description
Id	string
Title	string
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Notes Get

Get a single note by ID. Returns all accessible fields by default. Use the fields parameter to retrieve only specific fields for better performance.

Python SDK

await salesforce.notes.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "notes",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Note ID (18-character ID starting with '002')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,Title,Body,ParentId,OwnerId"

Response Schema

Records

Field Name	Type	Description
Id	string
Title	string
attributes	object

Notes API Search

Search for notes using SOSL (Salesforce Object Search Language). SOSL is optimized for text-based searches across multiple fields.

Python SDK

await salesforce.notes.api_search(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "notes",
    "action": "api_search",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOSL search query. Format: FIND {searchTerm} RETURNING Note(fields) [LIMIT n]
Examples:

• "FIND {important} IN ALL FIELDS RETURNING Note(Id,Title,ParentId)"
• "FIND {action items} IN NAME FIELDS RETURNING Note(Id,Title,Body) LIMIT 50" |

Response Schema

Records

Field Name	Type	Description
searchRecords	array<object>

Content Versions

Content Versions List

Returns a list of content versions (file metadata) 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. Note: ContentVersion does not support FIELDS(STANDARD), so specific fields must be listed.

Python SDK

await salesforce.content_versions.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "content_versions",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for content versions. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT Id, Title, FileExtension, ContentSize FROM ContentVersion WHERE IsLatest = true LIMIT 50"

Response Schema

Records

Field Name	Type	Description
Id	string
Title	string
FileExtension	string
ContentSize	integer
ContentDocumentId	string
VersionNumber	string
IsLatest	boolean
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Content Versions Get

Get a single content version's metadata by ID. Returns file metadata, not the file content. Use the download action to retrieve the actual file binary.

Python SDK

await salesforce.content_versions.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "content_versions",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce ContentVersion ID (18-character ID starting with '068')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,Title,FileExtension,ContentSize,ContentDocumentId,IsLatest"

Response Schema

Records

Field Name	Type	Description
Id	string
Title	string
FileExtension	string
ContentSize	integer
ContentDocumentId	string
VersionNumber	string
IsLatest	boolean
attributes	object

Content Versions Download

Downloads the binary file content of a content version. First use the list or get action to retrieve the ContentVersion ID and file metadata (size, type, etc.), then use this action to download the actual file content. The response is the raw binary file data.

Python SDK

async for chunk in salesforce.content_versions.download(    id="<str>"):# Process each chunk (e.g., write to file)
    file.write(chunk)

Note: Download operations return an async iterator of bytes chunks for memory-efficient streaming. Use async for to process chunks as they arrive.

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "content_versions",
    "action": "download",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce ContentVersion ID (18-character ID starting with '068').
Obtain this ID from the list or get action.
range_header	string	No	Optional Range header for partial downloads (e.g., 'bytes=0-99')

Attachments

Attachments List

Returns a list of attachments (legacy) 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. Note: Attachments are a legacy feature; consider using ContentVersion (Salesforce Files) for new implementations.

Python SDK

await salesforce.attachments.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "attachments",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query for attachments. Default returns up to 200 records.
To change the limit, provide your own query with a LIMIT clause.
Example: "SELECT Id, Name, ContentType, BodyLength, ParentId FROM Attachment WHERE ParentId = '001xx...' LIMIT 50"

Response Schema

Records

Field Name	Type	Description
Id	string
Name	string
ContentType	string
BodyLength	integer
ParentId	string
attributes	object

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string

Attachments Get

Get a single attachment's metadata by ID. Returns file metadata, not the file content. Use the download action to retrieve the actual file binary. Note: Attachments are a legacy feature; consider using ContentVersion for new implementations.

Python SDK

await salesforce.attachments.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "attachments",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Attachment ID (18-character ID starting with '00P')
fields	string	No	Comma-separated list of fields to retrieve. If omitted, returns all accessible fields.
Example: "Id,Name,ContentType,BodyLength,ParentId"

Response Schema

Records

Field Name	Type	Description
Id	string
Name	string
ContentType	string
BodyLength	integer
ParentId	string
attributes	object

Attachments Download

Downloads the binary file content of an attachment (legacy). First use the list or get action to retrieve the Attachment ID and file metadata, then use this action to download the actual file content. Note: Attachments are a legacy feature; consider using ContentVersion for new implementations.

Python SDK

async for chunk in salesforce.attachments.download(    id="<str>"):# Process each chunk (e.g., write to file)
    file.write(chunk)

Note: Download operations return an async iterator of bytes chunks for memory-efficient streaming. Use async for to process chunks as they arrive.

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "attachments",
    "action": "download",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Attachment ID (18-character ID starting with '00P').
Obtain this ID from the list or get action.
range_header	string	No	Optional Range header for partial downloads (e.g., 'bytes=0-99')

Reports

Reports List

Returns a list of reports available in the Salesforce org. Each report includes metadata such as Id, Name, Format, Description, and URL. This uses the Analytics REST API, not SOQL.

Python SDK

await salesforce.reports.list()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "reports",
    "action": "list"
}'

Response Schema

Records

Field Name	Type	Description
id	string
name	null | string
url	null | string
describeUrl	null | string
instancesUrl	null | string

Reports Get

Executes a report synchronously and returns the report data results. Returns both metadata and the executed data including fact maps, aggregates, and detail rows. First use the list action to find available reports, then use this action to run a report and get its data. Note: Large reports may be truncated. For reports with more than 2,000 detail rows, consider using async report runs.

Python SDK

await salesforce.reports.get(
    id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "reports",
    "action": "get",
    "params": {
        "id": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
id	string	Yes	Salesforce Report ID (18-character ID starting with '00O').
Obtain this ID from the list action.
includeDetails	boolean	No	Whether to include detail rows in the report results. Defaults to true.
Set to false to get only summary/aggregate data.

Response Schema

Records

Field Name	Type	Description
attributes	null | object
reportMetadata	null | object
reportExtendedMetadata	null | object
factMap	null | object
groupingsDown	null | object
groupingsAcross	null | object
hasDetailRows	null | boolean
allData	null | boolean

Query

Query List

Execute a custom SOQL query and return results. Use this for querying any Salesforce object. For pagination, check the response: if done is false, use nextRecordsUrl to fetch the next page.

Python SDK

await salesforce.query.list(
    q="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "query",
    "action": "list",
    "params": {
        "q": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
q	string	Yes	SOQL query string. Include LIMIT clause to control the number of records returned.
Examples:

• "SELECT Id, Name FROM Account LIMIT 100"
• "SELECT FIELDS(STANDARD) FROM Contact WHERE AccountId = '001xx...' LIMIT 50"
• "SELECT Id, Subject, Status FROM Case WHERE CreatedDate = TODAY" |

Response Schema

Meta

Field Name	Type	Description
done	boolean
nextRecordsUrl	string