# GetDataSetEx

### Description

Gets a data set in XML format that meets the criteria specified in the filter.

Note that to call this function, you must:

* Set the AdminEncryptionKey

```csharp
void GetDataSetEx (string webServiceUrl, string table, string filter, 
                   ref string dataSet, out string response)
```

### Parameters

| Parameter     | Type   | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| ------------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| webServiceUrl | string | URL to the QLM License Server.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| table         | string | <p>specify the table to query. The possible values are:<br><br>qryLicenseInfo: the main view where all license keys are recorded.<br>qryActivationAttempts: the view containing the activation attempts.<br>qryActivationLog: the view containing the activation log for multiple activations keys.<br>qryAnalyticsInstalls: the view containing Analytics.<br>qryCustomerInfo: the view containing customer information<br>qryIllegalComputers: the view containing the illegal computers.<br>qryLicenseHistoryInfo: the view containing historical keys.<br><br>AuditTrail: table containing AuditTrail data.</p> |
| filter        | string | SQL filter to determine which records to return. Use a where clause sql syntax, example: ActivationKey='AAAA'. Note that if the filter contains an Activation Key or a Computer Key, you must strip out the dashes in the license key. License keys in the database are stored without dashes.                                                                                                                                                                                                                                                                                                                      |
| dataSet       | string | returned dataset containing license key records that match criteria                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| response      | string | XML fragment containing the result of the call.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |

### Response XML format

```xml
<?xml version='1.0' encoding='UTF-8'?>
<QuickLicenseManager>
<result>Successfully executed query using filter...</result>
</QuickLicenseManager>
```

### Example error response

```xml
<?xml version='1.0' encoding='UTF-8'?>
<QuickLicenseManager>
<error>Details about the error</error>
</QuickLicenseManager>
```

## Remarks

Use [ParseResults ](https://docs.soraco.co/docs/api-reference/.net-api/iqlmcustomerinfo/methods/parseresults)to interpret the results of the call and load the returned data into an [ILicenseInfo ](https://docs.soraco.co/docs/api-reference/.net-api/ilicenseinfo)object.

```csharp
ILicenseInfo li = new LicenseInfo();
string message = string.Empty;
if (lv.QlmLicenseObject.ParseResults(response, ref li, ref message))
{
  // The operation  was successful	
}
else
{
  // The operation failed
}
```