# REST Resource: customers.crmBasedUserListQueries

- [Resource: CrmBasedUserListQuery](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries#CrmBasedUserListQuery)
  - [JSON representation](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries#CrmBasedUserListQuery.SCHEMA_REPRESENTATION)
- [Methods](https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries#METHODS_SUMMARY)

## Resource: CrmBasedUserListQuery

Defines a CRM based user list query that can be executed within Ads Data Hub.

| JSON representation |
|---|
| ``` { "name": string, "title": string, "queryText": string, "queryState": enum (`https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/QueryState`), "updateTime": string, "updateEmail": string, "createTime": string, "createEmail": string, "queryShare": [ { object (`https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/QueryShare`) } ], "userList": string } ``` |

| Fields ||
|---|---|
| `name` | `string` Output only. Immutable. Name that uniquely identifies a query. It has the form: customers/\[customerId\]/crmBasedUserListQueries/\[resource_id\], e.g. 'customers/123/crmBasedUserListQueries/abcd1234'. The resource ID is generated by the server. |
| `title` | `string` Query title, which is unique within a single Ads Data Hub customer and query type. |
| `queryText` | `string` Query text written in Standard SQL. See <https://cloud.google.com/bigquery/docs/reference/standard-sql/>. |
| `queryState` | ``enum (`https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/QueryState`)`` Query state. |
| `updateTime` | ``string (`https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#google.protobuf.Timestamp` format)`` Output only. Time the query was last updated. A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: `"2014-10-02T15:01:23Z"` and `"2014-10-02T15:01:23.045123456Z"`. |
| `updateEmail` | `string` Output only. Email address of user who last updated the query. |
| `createTime` | ``string (`https://developers.google.com/protocol-buffers/docs/reference/google.protobuf#google.protobuf.Timestamp` format)`` Output only. Immutable. Time the query was created. A timestamp in RFC3339 UTC "Zulu" format, with nanosecond resolution and up to nine fractional digits. Examples: `"2014-10-02T15:01:23Z"` and `"2014-10-02T15:01:23.045123456Z"`. |
| `createEmail` | `string` Output only. Immutable. Email address of user who created the query. |
| `queryShare[]` | ``object (`https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/QueryShare`)`` Indicates ways that a query may be shared beyond the owning Ads Data Hub customer. |
| `userList` | `string` Output only. The Ads Data Hub user list resource that can be populated by this CRM based user list query. The resource name has the form: customers/\[customerId\]/userLists/\[userListId\] |

| ## Methods ||
|---|---|
| ### `https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries/create` | Creates a CRM based user list query for later execution. |
| ### `https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries/delete` | Deletes a CRM based user list query. |
| ### `https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries/get` | Retrieves the requested CRM based user list query. |
| ### `https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries/list` | Lists the CRM based user list queries owned by the specified customer. |
| ### `https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries/patch` | Updates an existing CRM based user list query. |
| ### `https://developers.google.com/ads-data-hub/marketers/reference/rest/v1/customers.crmBasedUserListQueries/validate` | Performs static validation checks on the provided CRM based user list query to ensure valid output schema. |