Twilio full reference

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

This is the full reference documentation for the Twilio agent connector.

Supported entities and actions

The Twilio connector supports the following entities and actions.

Entity	Actions
Accounts	List, Get, Context Store Search, Context Store SQL Query
Calls	List, Create, Get, Context Store Search, Context Store SQL Query
Messages	List, Create, Get, Context Store Search, Context Store SQL Query, Semantic Search
Incoming Phone Numbers	List, Create, Get, Context Store Search, Context Store SQL Query
Recordings	List, Get, Context Store Search, Context Store SQL Query
Conferences	List, Get, Context Store Search, Context Store SQL Query
Usage Records	List, Context Store Search, Context Store SQL Query
Addresses	List, Get, Context Store Search, Context Store SQL Query
Queues	List, Get, Context Store Search, Context Store SQL Query
Transcriptions	List, Get, Context Store Search, Context Store SQL Query
Outgoing Caller Ids	List, Get, Context Store Search, Context Store SQL Query

Accounts

Accounts List

Returns a list of accounts associated with the authenticated account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "accounts",
  "action": "list"
}'

Python SDK

await twilio.accounts.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": "accounts",
    "action": "list"
}'

Parameters

Parameter Name	Type	Required	Description
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
auth_token	null | string
date_created	null | string
date_updated	null | string
friendly_name	null | string
owner_account_sid	null | string
sid	null | string
status	null | string
subresource_uris	null | object
type	null | string
uri	null | string

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Accounts Get

Get a single account by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "accounts",
  "action": "get",
  "params": {
    "sid": "<str>"
  }
}'

Python SDK

await twilio.accounts.get(
    sid="<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": {
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sid	string	Yes	Account SID

Response Schema

Records

Field Name	Type	Description
auth_token	null | string
date_created	null | string
date_updated	null | string
friendly_name	null | string
owner_account_sid	null | string
sid	null | string
status	null | string
subresource_uris	null | object
type	null | string
uri	null | string

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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "accounts",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.accounts.context_store_search(
    query={"filter": {"eq": {"sid": "<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": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier for the account
friendly_name	string	A user-defined friendly name for the account
status	string	The current status of the account
type	string	The type of the account
owner_account_sid	string	The SID of the owner account
date_created	string	The timestamp when the account was created
date_updated	string	The timestamp when the account was last updated
uri	string	The URI for accessing the account resource

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[].sid	string	The unique identifier for the account
data[].friendly_name	string	A user-defined friendly name for the account
data[].status	string	The current status of the account
data[].type	string	The type of the account
data[].owner_account_sid	string	The SID of the owner account
data[].date_created	string	The timestamp when the account was created
data[].date_updated	string	The timestamp when the account was last updated
data[].uri	string	The URI for accessing the account resource

Accounts Context Store SQL Query

Run a SQL query against accounts records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "accounts",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.accounts.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Calls

Calls List

Returns a list of calls made to and from an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "calls",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.calls.list(
    account_sid="<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": "calls",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
sid	null | string
date_created	null | string
date_updated	null | string
parent_call_sid	null | string
account_sid	null | string
to	null | string
to_formatted	null | string
from	null | string
from_formatted	null | string
phone_number_sid	null | string
status	null | string
start_time	null | string
end_time	null | string
duration	null | string
price	null | string
price_unit	null | string
direction	null | string
answered_by	null | string
annotation	null | string
api_version	null | string
forwarded_from	null | string
group_sid	null | string
caller_name	null | string
queue_time	null | string
trunk_sid	null | string
uri	null | string
subresource_uris	null | object

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Calls Create

Initiate an outbound phone call. Requires a recipient (To), a caller ID (From), and call instructions via a TwiML URL, TwiML content, or ApplicationSid. The call will be queued and placed at the account's CPS rate.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "calls",
  "action": "create",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.calls.create(
    account_sid="<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": "calls",
    "action": "create",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	The Account SID that will create the call

Response Schema

Records

Field Name	Type	Description
sid	null | string
date_created	null | string
date_updated	null | string
parent_call_sid	null | string
account_sid	null | string
to	null | string
to_formatted	null | string
from	null | string
from_formatted	null | string
phone_number_sid	null | string
status	null | string
start_time	null | string
end_time	null | string
duration	null | string
price	null | string
price_unit	null | string
direction	null | string
answered_by	null | string
annotation	null | string
api_version	null | string
forwarded_from	null | string
group_sid	null | string
caller_name	null | string
queue_time	null | string
trunk_sid	null | string
uri	null | string
subresource_uris	null | object

Calls Get

Get a single call by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "calls",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.calls.get(
    account_sid="<str>",
    sid="<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": "calls",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Call SID

Response Schema

Records

Field Name	Type	Description
sid	null | string
date_created	null | string
date_updated	null | string
parent_call_sid	null | string
account_sid	null | string
to	null | string
to_formatted	null | string
from	null | string
from_formatted	null | string
phone_number_sid	null | string
status	null | string
start_time	null | string
end_time	null | string
duration	null | string
price	null | string
price_unit	null | string
direction	null | string
answered_by	null | string
annotation	null | string
api_version	null | string
forwarded_from	null | string
group_sid	null | string
caller_name	null | string
queue_time	null | string
trunk_sid	null | string
uri	null | string
subresource_uris	null | object

Calls Context Store Search

Search and filter calls 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "calls",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.calls.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "calls",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier for the call
account_sid	string	The unique identifier for the account associated with the call
to	string	The phone number that received the call
from	string	The phone number that made the call
status	string	The current status of the call
direction	string	The direction of the call (inbound or outbound)
duration	string	The duration of the call in seconds
price	string	The cost of the call
price_unit	string	The currency unit of the call cost
start_time	string	The date and time when the call started
end_time	string	The date and time when the call ended
date_created	string	The date and time when the call record was created
date_updated	string	The date and time when the call record was last updated

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[].sid	string	The unique identifier for the call
data[].account_sid	string	The unique identifier for the account associated with the call
data[].to	string	The phone number that received the call
data[].from	string	The phone number that made the call
data[].status	string	The current status of the call
data[].direction	string	The direction of the call (inbound or outbound)
data[].duration	string	The duration of the call in seconds
data[].price	string	The cost of the call
data[].price_unit	string	The currency unit of the call cost
data[].start_time	string	The date and time when the call started
data[].end_time	string	The date and time when the call ended
data[].date_created	string	The date and time when the call record was created
data[].date_updated	string	The date and time when the call record was last updated

Calls Context Store SQL Query

Run a SQL query against calls records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "calls",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.calls.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "calls",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Messages

Messages List

Returns a list of messages associated with an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "messages",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.messages.list(
    account_sid="<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": "messages",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
body	null | string
date_created	null | string
date_sent	null | string
date_updated	null | string
direction	null | string
error_code	null | string
error_message	null | string
from	null | string
messaging_service_sid	null | string
num_media	null | string
num_segments	null | string
price	null | string
price_unit	null | string
sid	null | string
status	null | string
subresource_uris	null | object
to	null | string
uri	null | string

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Messages Create

Send an outbound SMS, MMS, or WhatsApp message. Requires a recipient (To), a sender (From or MessagingServiceSid), and content (Body, MediaUrl, or ContentSid). Twilio uses application/x-www-form-urlencoded encoding for request bodies.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "messages",
  "action": "create",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.messages.create(
    account_sid="<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": "messages",
    "action": "create",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	The Account SID that will create the message

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
body	null | string
date_created	null | string
date_sent	null | string
date_updated	null | string
direction	null | string
error_code	null | string
error_message	null | string
from	null | string
messaging_service_sid	null | string
num_media	null | string
num_segments	null | string
price	null | string
price_unit	null | string
sid	null | string
status	null | string
subresource_uris	null | object
to	null | string
uri	null | string

Messages Get

Get a single message by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "messages",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.messages.get(
    account_sid="<str>",
    sid="<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": "messages",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Message SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
body	null | string
date_created	null | string
date_sent	null | string
date_updated	null | string
direction	null | string
error_code	null | string
error_message	null | string
from	null | string
messaging_service_sid	null | string
num_media	null | string
num_segments	null | string
price	null | string
price_unit	null | string
sid	null | string
status	null | string
subresource_uris	null | object
to	null | string
uri	null | string

Messages Context Store Search

Search and filter messages 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "messages",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.messages.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "messages",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier for this message
account_sid	string	The unique identifier for the account associated with this message
to	string	The phone number or recipient ID the message was sent to
from	string	The phone number or sender ID that sent the message
body	string	The text body of the message
status	string	The status of the message
direction	string	The direction of the message
price	string	The cost of the message
price_unit	string	The currency unit used for pricing
date_created	string	The date and time when the message was created
date_sent	string	The date and time when the message was sent
error_code	string	The error code associated with the message if any
error_message	string	The error message description if the message failed
num_segments	string	The number of message segments
num_media	string	The number of media files included in the message

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[].sid	string	The unique identifier for this message
data[].account_sid	string	The unique identifier for the account associated with this message
data[].to	string	The phone number or recipient ID the message was sent to
data[].from	string	The phone number or sender ID that sent the message
data[].body	string	The text body of the message
data[].status	string	The status of the message
data[].direction	string	The direction of the message
data[].price	string	The cost of the message
data[].price_unit	string	The currency unit used for pricing
data[].date_created	string	The date and time when the message was created
data[].date_sent	string	The date and time when the message was sent
data[].error_code	string	The error code associated with the message if any
data[].error_message	string	The error message description if the message failed
data[].num_segments	string	The number of message segments
data[].num_media	string	The number of media files included in the message

Messages Context Store SQL Query

Run a SQL query against messages records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "messages",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.messages.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "messages",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Messages Semantic Search

Search messages records by meaning rather than by exact or fuzzy field values. Semantic search embeds a natural-language prompt and returns the most similar passages, ranked by relevance. Pass semantic={field, prompt, filter?, context_size?, min_similarity?, dedup?} to context_store_search instead of query. Only available in hosted mode.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "messages",
  "action": "context_store_search",
  "params": {
    "semantic": {"field": "body", "prompt": "<your natural-language query>"}
  }
}'

Python SDK

Semantic search is passed through the generic execute method — the typed messages.context_store_search helper only accepts query.

await twilio.execute(
    "messages",
    "context_store_search",
    {"semantic": {"field": "body", "prompt": "<your natural-language query>"}},
)

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": "messages",
    "action": "context_store_search",
    "params": {
        "semantic": {"field": "body", "prompt": "<your natural-language query>"}
    }
}'

Semantic Parameters

Parameter Name	Type	Required	Description
semantic.field	string	Yes	Field to search semantically. Mutually exclusive with query.
semantic.prompt	string	Yes	Natural-language query that is embedded and compared against stored passages.
semantic.filter	object	No	Filter conditions (same shape/operators as query.filter). sort is not supported — results are ranked by similarity.
semantic.context_size	integer	No	Characters of surrounding context to return per hit, up to the field's configured window. Omit to return the full configured window.
semantic.min_similarity	number	No	Minimum similarity score in [-1.0, 1.0]. Omit for 0.25; scores below the threshold are discarded before deduplication and top-k selection. Use -1.0 to disable the cutoff.
semantic.dedup	string	No	max (default) returns the single best-scoring passage per record; none returns multiple passages per record, still ranked by similarity and capped by limit.
fields	array	No	Field paths to include in results (dot notation for nested fields). Applied to each hit's entity.
limit	integer	No	Maximum results to return (default 10, maximum 100).

Semantically Searchable Fields

Field Name	Max Context (chars)	Description
body	2048	The text body of the message

Response Schema

Field Name	Type	Description
data	array	List of matching passages
data[].entity	object	The matched source record
data[].entity.sid	string	Source record field
data[].entity.date_sent	string	Source record field
data[].entity.date_created	string	Source record field
data[].entity.direction	string	Source record field
data[].entity.status	string	Source record field
data[].entity.from	string	Source record field
data[].entity.to	string	Source record field
data[].entity.error_code	string	Source record field
data[].entity.error_message	string	Source record field
data[].metadata	object	Match metadata
data[].metadata.score	number	Similarity score
data[].metadata.context	string	The matched passage text
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

Incoming Phone Numbers

Incoming Phone Numbers List

Returns a list of incoming phone numbers for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "incoming_phone_numbers",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.incoming_phone_numbers.list(
    account_sid="<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": "incoming_phone_numbers",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
sid	null | string
account_sid	null | string
friendly_name	null | string
phone_number	null | string
voice_url	null | string
voice_method	null | string
voice_fallback_url	null | string
voice_fallback_method	null | string
voice_caller_id_lookup	null | boolean
date_created	null | string
date_updated	null | string
sms_url	null | string
sms_method	null | string
sms_fallback_url	null | string
sms_fallback_method	null | string
address_requirements	null | string
beta	null | boolean
capabilities	null | object
voice_receive_mode	null | string
status_callback	null | string
status_callback_method	null | string
api_version	null | string
voice_application_sid	null | string
sms_application_sid	null | string
origin	null | string
trunk_sid	null | string
emergency_status	null | string
emergency_address_sid	null | string
emergency_address_status	null | string
address_sid	null | string
identity_sid	null | string
bundle_sid	null | string
uri	null | string
status	null | string
type	null | string
subresource_uris	null | object

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Incoming Phone Numbers Create

Purchase and provision a new Twilio phone number. You must provide either a specific PhoneNumber in E.164 format or an AreaCode (US/Canada only). The number will be added to your account and can be configured for voice and SMS.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "incoming_phone_numbers",
  "action": "create",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.incoming_phone_numbers.create(
    account_sid="<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": "incoming_phone_numbers",
    "action": "create",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	The Account SID that will own the phone number

Response Schema

Records

Field Name	Type	Description
sid	null | string
account_sid	null | string
friendly_name	null | string
phone_number	null | string
voice_url	null | string
voice_method	null | string
voice_fallback_url	null | string
voice_fallback_method	null | string
voice_caller_id_lookup	null | boolean
date_created	null | string
date_updated	null | string
sms_url	null | string
sms_method	null | string
sms_fallback_url	null | string
sms_fallback_method	null | string
address_requirements	null | string
beta	null | boolean
capabilities	null | object
voice_receive_mode	null | string
status_callback	null | string
status_callback_method	null | string
api_version	null | string
voice_application_sid	null | string
sms_application_sid	null | string
origin	null | string
trunk_sid	null | string
emergency_status	null | string
emergency_address_sid	null | string
emergency_address_status	null | string
address_sid	null | string
identity_sid	null | string
bundle_sid	null | string
uri	null | string
status	null | string
type	null | string
subresource_uris	null | object

Incoming Phone Numbers Get

Get a single incoming phone number by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "incoming_phone_numbers",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.incoming_phone_numbers.get(
    account_sid="<str>",
    sid="<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": "incoming_phone_numbers",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Incoming phone number SID

Response Schema

Records

Field Name	Type	Description
sid	null | string
account_sid	null | string
friendly_name	null | string
phone_number	null | string
voice_url	null | string
voice_method	null | string
voice_fallback_url	null | string
voice_fallback_method	null | string
voice_caller_id_lookup	null | boolean
date_created	null | string
date_updated	null | string
sms_url	null | string
sms_method	null | string
sms_fallback_url	null | string
sms_fallback_method	null | string
address_requirements	null | string
beta	null | boolean
capabilities	null | object
voice_receive_mode	null | string
status_callback	null | string
status_callback_method	null | string
api_version	null | string
voice_application_sid	null | string
sms_application_sid	null | string
origin	null | string
trunk_sid	null | string
emergency_status	null | string
emergency_address_sid	null | string
emergency_address_status	null | string
address_sid	null | string
identity_sid	null | string
bundle_sid	null | string
uri	null | string
status	null | string
type	null | string
subresource_uris	null | object

Incoming Phone Numbers Context Store Search

Search and filter incoming phone numbers 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "incoming_phone_numbers",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.incoming_phone_numbers.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "incoming_phone_numbers",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The SID of this phone number
account_sid	string	The SID of the account that owns this phone number
phone_number	string	The phone number in E.164 format
friendly_name	string	A user-assigned friendly name for this phone number
status	string	Status of the phone number
capabilities	object	Capabilities of this phone number
date_created	string	When the phone number was created
date_updated	string	When the phone number was last updated

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[].sid	string	The SID of this phone number
data[].account_sid	string	The SID of the account that owns this phone number
data[].phone_number	string	The phone number in E.164 format
data[].friendly_name	string	A user-assigned friendly name for this phone number
data[].status	string	Status of the phone number
data[].capabilities	object	Capabilities of this phone number
data[].date_created	string	When the phone number was created
data[].date_updated	string	When the phone number was last updated

Incoming Phone Numbers Context Store SQL Query

Run a SQL query against incoming phone numbers records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "incoming_phone_numbers",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.incoming_phone_numbers.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "incoming_phone_numbers",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Recordings

Recordings List

Returns a list of recordings for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "recordings",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.recordings.list(
    account_sid="<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": "recordings",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
call_sid	null | string
conference_sid	null | string
date_created	null | string
date_updated	null | string
start_time	null | string
duration	null | string
sid	null | string
price	null | string
price_unit	null | string
status	null | string
channels	null | integer
source	null | string
error_code	null | string
media_url	null | string
uri	null | string
encryption_details	null | object
subresource_uris	null | object

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Recordings Get

Get a single recording by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "recordings",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.recordings.get(
    account_sid="<str>",
    sid="<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": "recordings",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Recording SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
call_sid	null | string
conference_sid	null | string
date_created	null | string
date_updated	null | string
start_time	null | string
duration	null | string
sid	null | string
price	null | string
price_unit	null | string
status	null | string
channels	null | integer
source	null | string
error_code	null | string
media_url	null | string
uri	null | string
encryption_details	null | object
subresource_uris	null | object

Recordings Context Store Search

Search and filter recordings 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "recordings",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.recordings.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "recordings",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier of the recording
account_sid	string	The account SID that owns the recording
call_sid	string	The SID of the associated call
duration	string	Duration in seconds
status	string	The status of the recording
channels	integer	Number of audio channels
price	string	The cost of storing the recording
price_unit	string	The currency unit
date_created	string	When the recording was created
start_time	string	When the recording started

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[].sid	string	The unique identifier of the recording
data[].account_sid	string	The account SID that owns the recording
data[].call_sid	string	The SID of the associated call
data[].duration	string	Duration in seconds
data[].status	string	The status of the recording
data[].channels	integer	Number of audio channels
data[].price	string	The cost of storing the recording
data[].price_unit	string	The currency unit
data[].date_created	string	When the recording was created
data[].start_time	string	When the recording started

Recordings Context Store SQL Query

Run a SQL query against recordings records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "recordings",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.recordings.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "recordings",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Conferences

Conferences List

Returns a list of conferences for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "conferences",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.conferences.list(
    account_sid="<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": "conferences",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
date_created	null | string
date_updated	null | string
api_version	null | string
friendly_name	null | string
region	null | string
sid	null | string
status	null | string
uri	null | string
reason_conference_ended	null | string
call_sid_ending_conference	null | string
subresource_uris	null | object

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Conferences Get

Get a single conference by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "conferences",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.conferences.get(
    account_sid="<str>",
    sid="<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": "conferences",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Conference SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
date_created	null | string
date_updated	null | string
api_version	null | string
friendly_name	null | string
region	null | string
sid	null | string
status	null | string
uri	null | string
reason_conference_ended	null | string
call_sid_ending_conference	null | string
subresource_uris	null | object

Conferences Context Store Search

Search and filter conferences 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "conferences",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.conferences.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "conferences",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier of the conference
account_sid	string	The account SID associated with the conference
friendly_name	string	A friendly name for the conference
status	string	The current status of the conference
region	string	The region where the conference is hosted
date_created	string	When the conference was created
date_updated	string	When the conference was last updated

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[].sid	string	The unique identifier of the conference
data[].account_sid	string	The account SID associated with the conference
data[].friendly_name	string	A friendly name for the conference
data[].status	string	The current status of the conference
data[].region	string	The region where the conference is hosted
data[].date_created	string	When the conference was created
data[].date_updated	string	When the conference was last updated

Conferences Context Store SQL Query

Run a SQL query against conferences records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "conferences",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.conferences.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "conferences",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Usage Records

Usage Records List

Returns a list of usage records for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "usage_records",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.usage_records.list(
    account_sid="<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": "usage_records",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
as_of	null | string
category	null | string
count	null | string
count_unit	null | string
description	null | string
end_date	null | string
price	null | string
price_unit	null | string
start_date	null | string
subresource_uris	null | object
usage	null | string
usage_unit	null | string
uri	null | string

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Usage Records Context Store Search

Search and filter usage records 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "usage_records",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "account_sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.usage_records.context_store_search(
    query={"filter": {"eq": {"account_sid": "<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": "usage_records",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"account_sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
account_sid	string	The account SID associated with this usage record
category	string	The usage category (calls, SMS, recordings, etc.)
description	string	A description of the usage record
usage	string	The total usage value
usage_unit	string	The unit of measurement for usage
count	string	The number of units consumed
count_unit	string	The unit of measurement for count
price	string	The total price for consumed units
price_unit	string	The currency unit
start_date	string	The start date of the usage period
end_date	string	The end date of the usage period

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[].account_sid	string	The account SID associated with this usage record
data[].category	string	The usage category (calls, SMS, recordings, etc.)
data[].description	string	A description of the usage record
data[].usage	string	The total usage value
data[].usage_unit	string	The unit of measurement for usage
data[].count	string	The number of units consumed
data[].count_unit	string	The unit of measurement for count
data[].price	string	The total price for consumed units
data[].price_unit	string	The currency unit
data[].start_date	string	The start date of the usage period
data[].end_date	string	The end date of the usage period

Usage Records Context Store SQL Query

Run a SQL query against usage records records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "usage_records",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.usage_records.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "usage_records",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Addresses

Addresses List

Returns a list of addresses for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "addresses",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.addresses.list(
    account_sid="<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": "addresses",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
city	null | string
customer_name	null | string
date_created	null | string
date_updated	null | string
emergency_enabled	null | boolean
friendly_name	null | string
iso_country	null | string
postal_code	null | string
region	null | string
sid	null | string
street	null | string
street_secondary	null | string
validated	null | boolean
verified	null | boolean
uri	null | string

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Addresses Get

Get a single address by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "addresses",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.addresses.get(
    account_sid="<str>",
    sid="<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": "addresses",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Address SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
city	null | string
customer_name	null | string
date_created	null | string
date_updated	null | string
emergency_enabled	null | boolean
friendly_name	null | string
iso_country	null | string
postal_code	null | string
region	null | string
sid	null | string
street	null | string
street_secondary	null | string
validated	null | boolean
verified	null | boolean
uri	null | string

Addresses Context Store Search

Search and filter addresses 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "addresses",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.addresses.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "addresses",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier of the address
account_sid	string	The account SID associated with this address
customer_name	string	The customer name associated with this address
friendly_name	string	A friendly name for the address
street	string	The street address
city	string	The city of the address
region	string	The region or state
postal_code	string	The postal code
iso_country	string	The ISO 3166-1 alpha-2 country code
validated	boolean	Whether the address has been validated
verified	boolean	Whether the address has been verified

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[].sid	string	The unique identifier of the address
data[].account_sid	string	The account SID associated with this address
data[].customer_name	string	The customer name associated with this address
data[].friendly_name	string	A friendly name for the address
data[].street	string	The street address
data[].city	string	The city of the address
data[].region	string	The region or state
data[].postal_code	string	The postal code
data[].iso_country	string	The ISO 3166-1 alpha-2 country code
data[].validated	boolean	Whether the address has been validated
data[].verified	boolean	Whether the address has been verified

Addresses Context Store SQL Query

Run a SQL query against addresses records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "addresses",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.addresses.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "addresses",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Queues

Queues List

Returns a list of queues for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "queues",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.queues.list(
    account_sid="<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": "queues",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
average_wait_time	null | integer
current_size	null | integer
date_created	null | string
date_updated	null | string
friendly_name	null | string
max_size	null | integer
sid	null | string
uri	null | string
subresource_uris	null | object

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Queues Get

Get a single queue by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "queues",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.queues.get(
    account_sid="<str>",
    sid="<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": "queues",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Queue SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
average_wait_time	null | integer
current_size	null | integer
date_created	null | string
date_updated	null | string
friendly_name	null | string
max_size	null | integer
sid	null | string
uri	null | string
subresource_uris	null | object

Queues Context Store Search

Search and filter queues 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "queues",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.queues.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "queues",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier for the queue
account_sid	string	The account SID that owns this queue
friendly_name	string	A friendly name for the queue
current_size	integer	Current number of callers waiting
max_size	integer	Maximum number of callers allowed
average_wait_time	integer	Average wait time in seconds
date_created	string	When the queue was created
date_updated	string	When the queue was last updated

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[].sid	string	The unique identifier for the queue
data[].account_sid	string	The account SID that owns this queue
data[].friendly_name	string	A friendly name for the queue
data[].current_size	integer	Current number of callers waiting
data[].max_size	integer	Maximum number of callers allowed
data[].average_wait_time	integer	Average wait time in seconds
data[].date_created	string	When the queue was created
data[].date_updated	string	When the queue was last updated

Queues Context Store SQL Query

Run a SQL query against queues records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "queues",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.queues.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "queues",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Transcriptions

Transcriptions List

Returns a list of transcriptions for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "transcriptions",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.transcriptions.list(
    account_sid="<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": "transcriptions",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
date_created	null | string
date_updated	null | string
duration	null | string
price	null | string
price_unit	null | string
recording_sid	null | string
sid	null | string
status	null | string
transcription_text	null | string
type	null | string
uri	null | string

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Transcriptions Get

Get a single transcription by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "transcriptions",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.transcriptions.get(
    account_sid="<str>",
    sid="<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": "transcriptions",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Transcription SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
api_version	null | string
date_created	null | string
date_updated	null | string
duration	null | string
price	null | string
price_unit	null | string
recording_sid	null | string
sid	null | string
status	null | string
transcription_text	null | string
type	null | string
uri	null | string

Transcriptions Context Store Search

Search and filter transcriptions 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "transcriptions",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.transcriptions.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "transcriptions",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier for the transcription
account_sid	string	The account SID
recording_sid	string	The SID of the associated recording
status	string	The status of the transcription
duration	string	Duration of the audio recording in seconds
price	string	The cost of the transcription
price_unit	string	The currency unit
date_created	string	When the transcription was created
date_updated	string	When the transcription was last updated

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[].sid	string	The unique identifier for the transcription
data[].account_sid	string	The account SID
data[].recording_sid	string	The SID of the associated recording
data[].status	string	The status of the transcription
data[].duration	string	Duration of the audio recording in seconds
data[].price	string	The cost of the transcription
data[].price_unit	string	The currency unit
data[].date_created	string	When the transcription was created
data[].date_updated	string	When the transcription was last updated

Transcriptions Context Store SQL Query

Run a SQL query against transcriptions records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "transcriptions",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.transcriptions.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "transcriptions",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds

Outgoing Caller Ids

Outgoing Caller Ids List

Returns a list of outgoing caller IDs for an account

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "outgoing_caller_ids",
  "action": "list",
  "params": {
    "AccountSid": "<str>"
  }
}'

Python SDK

await twilio.outgoing_caller_ids.list(
    account_sid="<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": "outgoing_caller_ids",
    "action": "list",
    "params": {
        "AccountSid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
PageSize	integer	No	Number of items to return per page

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
date_created	null | string
date_updated	null | string
friendly_name	null | string
phone_number	null | string
sid	null | string
uri	null | string

Meta

Field Name	Type	Description
next_page_uri	null | string
first_page_uri	null | string
page	null | integer
page_size	null | integer

Outgoing Caller Ids Get

Get a single outgoing caller ID by SID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "outgoing_caller_ids",
  "action": "get",
  "params": {
    "AccountSid": "<str>",
    "sid": "<str>"
  }
}'

Python SDK

await twilio.outgoing_caller_ids.get(
    account_sid="<str>",
    sid="<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": "outgoing_caller_ids",
    "action": "get",
    "params": {
        "AccountSid": "<str>",
        "sid": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
AccountSid	string	Yes	Account SID
sid	string	Yes	Outgoing caller ID SID

Response Schema

Records

Field Name	Type	Description
account_sid	null | string
date_created	null | string
date_updated	null | string
friendly_name	null | string
phone_number	null | string
sid	null | string
uri	null | string

Outgoing Caller Ids Context Store Search

Search and filter outgoing caller ids 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.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "outgoing_caller_ids",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "sid": "<str>"
        }
      }
    }
  }
}'

Python SDK

await twilio.outgoing_caller_ids.context_store_search(
    query={"filter": {"eq": {"sid": "<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": "outgoing_caller_ids",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"sid": "<str>"}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
query	object	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, startswith, endswith, contains, array_contains, 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
sid	string	The unique identifier
account_sid	string	The account SID
phone_number	string	The phone number
friendly_name	string	A friendly name
date_created	string	When the outgoing caller ID was created
date_updated	string	When the outgoing caller ID was last updated

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[].sid	string	The unique identifier
data[].account_sid	string	The account SID
data[].phone_number	string	The phone number
data[].friendly_name	string	A friendly name
data[].date_created	string	When the outgoing caller ID was created
data[].date_updated	string	When the outgoing caller ID was last updated

Outgoing Caller Ids Context Store SQL Query

Run a SQL query against outgoing caller ids records in the Airbyte Context Store. SQL projections may return any set of columns, so each result row is a dictionary matching the query's selected fields. Only available in hosted mode.

Use the hosted server documentation to find the qualified Context Store table name and SQL guidance.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "twilio",
  "entity": "outgoing_caller_ids",
  "action": "context_store_sql_query",
  "params": {
    "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
  }
}'

Python SDK

await twilio.outgoing_caller_ids.context_store_sql_query(
    sql="SELECT * FROM <qualified_context_store_table> LIMIT 100"
)

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": "outgoing_caller_ids",
    "action": "context_store_sql_query",
    "params": {
        "sql": "SELECT * FROM <qualified_context_store_table> LIMIT 100"
    }
}'

Parameters

Parameter Name	Type	Required	Description
sql	string	Yes	SQL query to execute against this entity's Context Store data
limit	integer	No	Maximum results to return

Response Schema

Field Name	Type	Description
data	array	Projected rows, with dictionary keys matching the selected columns
meta	object	Query metadata
meta.has_more	boolean	Whether the result was limited and more rows are available
meta.cursor	null	SQL query results do not use cursor pagination
meta.took_ms	number | null	Query execution time in milliseconds