Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

ConnectApi.QuerySqlInput

Represents the input to create an SQL query.
Property Type Description Required or Optional Available Version
adaptiveTimeout Integer Amount of time (in seconds) for the query engine to respond to the request. 0 will return the queryId, status, and metadata, but no data associated with the SQL. The maximum value is 15. Optional 63.0
querySettings Map<String, String> Settings to adjust the query execution behavior:
  • date_style—Order of Year, Month, and Day for parsing date strings, for example MDY and DMY.
  • lc_time—Locale for date literals using ISO language and country code, for example en_US and de_AT.
  • query_timeout—Execution limit in milliseconds before the query is terminated, for example 1800000ms.
Optional 62.0
rowLimit Long Maximum number of rows to include in the response. Fewer rows may be returned. Optional 62.0
sql String SQL expression. Required 62.0
sqlParameters List<ConnectApi.QuerySqlParameterItem> Value and type information about the SQL parameters. Optional 62.0