--- schema_version: "1" id: 4b81e41cfdd659496825f121ec2622da55f459e15004a7710c0df1abae13444e title: ConnectApi.QuerySqlInput collection: legacydeveloper version: current locale: en-us portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/apexref/apex_connectapi_input_query_sql.md canonical_url: https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_connectapi_input_query_sql.htm source_site: developer.salesforce.com content_type: documentation content_hash: fba631e97380126bd7c9bc4de148fa272479b85cb59f8031bf3e74b9be2ae96a description: Represents the input to create an SQL query. --- # 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
#### See Also - [querySql(input)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySql_1 "Submit an SQL query request for execution and retrieve the first chunk of data.") - [querySql(input, dataspace)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySql_2 "Submit an SQL query request for execution and specify the data space.") - [querySql(input, workloadName, dataspace)](https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_ConnectAPI_CdpQuery_static_methods.htm#apex_ConnectAPI_CdpQuery_querySql_3 "Submit an SQL query request for execution and specify the workload name and data space.")