# ExecuteQuery

Required Frends version: 5.5+

Required .NET version: 6.0

Compatible Agents: Crossplatform

Source code: <https://github.com/FrendsPlatform/Frends.CassandraDB>

{% tabs %}
{% tab title="Parameter: Input" %}

| Name                                            | Description                                                                                                                                                                                                                                                                                                                                                                                         |
| ----------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| AuthenticationMethods : `AuthenticationMethods` | <p>Authentication method.</p><p>Possible values:</p><ul><li><code>None</code>:</li></ul><p>Authentication method.</p><ul><li><code>PlainTextAuthProvider</code>:</li></ul><p>Authentication method.</p><ul><li><code>DsePlainTextAuthProvider</code>:</li></ul><p>Authentication method.</p><p><br>Default: <code>1</code><br>Example: <code>AuthenticationMethods.PlainTextAuthProvider</code></p> |
| UseSsl : `Boolean`                              | <p>Use Ssl.</p><p><br>Default: <code>False</code><br>Example: <code>false</code></p>                                                                                                                                                                                                                                                                                                                |
| X509CertificateFilePath : `String`              | <p>X509 certificate location.</p><p><br>Default: <code>-</code><br>Example: <code>c:\temp</code></p>                                                                                                                                                                                                                                                                                                |
| 🗝X509CertificatePassword : `String`            | <p>X509 certificate's password.</p><p><br>Default: <code>-</code><br>Example: <code>FooBar</code></p>                                                                                                                                                                                                                                                                                               |
| Username : `String`                             | <p>Username.</p><p><br>Default: <code>-</code><br>Example: <code>Foo</code></p>                                                                                                                                                                                                                                                                                                                     |
| Password : `String`                             | <p>Password.</p><p><br>Default: <code>-</code><br>Example: <code>Bar</code></p>                                                                                                                                                                                                                                                                                                                     |
| AsUser : `String`                               | <p>Connect with 'Input.Username' credentials, but will act as 'Input.AsUser'.</p><p><br>Default: <code>-</code><br>Example: <code>Foo2</code></p>                                                                                                                                                                                                                                                   |
| ContactPoints : `ContactPoint[]`                | <p>Contact point(s).</p><p><br>Default: <code>-</code><br>Example: <code>Object{127.0.0.1}</code></p>                                                                                                                                                                                                                                                                                               |
| Port : `Int32`                                  | <p>Port.</p><p><br>Default: <code>9042</code><br>Example: <code>9042</code></p>                                                                                                                                                                                                                                                                                                                     |
| Keyspace : `String`                             | <p>Keyspace (Case-sensitive).</p><p><br>Default: <code>-</code><br>Example: <code>foo</code></p>                                                                                                                                                                                                                                                                                                    |
| Query : `String`                                | <p>Query to execute.</p><p><br>Default: <code>-</code><br>Example: <code>SELECT bar FROM foo</code></p>                                                                                                                                                                                                                                                                                             |
| {% endtab %}                                    |                                                                                                                                                                                                                                                                                                                                                                                                     |

{% tab title="Result: Result" %}

| Name                      | Description                                                                                                                                                                                                                         |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Success : `Boolean`       | <p>True if query ran successfully.<br>Example: <code>true</code></p>                                                                                                                                                                |
| QueryResults : `JToken`   | <p>Query results. Only SELECT query contain values.<br>Example: <code>JToken</code></p>                                                                                                                                             |
| Warnings : `List<String>` | <p>Returns the server-side warnings for this query. This feature is only available for Cassandra 2.2 or above; with lower versions, this property always returns null.<br>Example: <code>List { "warning1", "warning2" }</code></p> |
| {% endtab %}              |                                                                                                                                                                                                                                     |

{% tab title="Changelog" %}

## Changelog

### \[1.0.0] - 2023-10-30

#### Added

* Initial implementation
  {% endtab %}
  {% endtabs %}