List user-defined types (UDTs)

Gets information about the user-defined types (UDTs) in a keyspace.

Ready to write code? See the examples for this method to get started. If you are new to the Data API, check out the quickstart.

Result

Returns an unordered list of ListTypeDescriptor objects that describe each user-defined type in the keyspace.

Returns a promise that resolves to an unordered list of TypeDescriptor objects that describe each user-defined type in the keyspace.

The Go client is in preview. For more information, see astra-db-go.

Returns an unordered slice of UDTDescriptor structs that describe each user-defined type in the keyspace.

Returns an unordered list of TableUserDefinedTypeDescriptor objects that describe each user-defined type in the keyspace.

Returns an unordered list of UserDefinedTypeInfo objects that describe each user-defined type in the keyspace.

The status.types field in the response describes each user-defined type.

Example response:

{
  "status": {
    "types": [
      {
        "type": "userDefined",
        "udtName": "address",
        "definition": {
          "fields": {
            "city": {
              "type": "text"
            },
            "country": {
              "type": "text"
            }
          }
        },
        "apiSupport": {
          "createTable": true,
          "insert": true,
          "read": true,
          "filter": false,
          "cqlDefinition": "demo.address"
        }
      }
    ]
  }
}

Parameters

Use the list_types method, which belongs to the astrapy.Database class.

Method signature

list_types(
  *,
  keyspace: str,
  table_admin_timeout_ms: int,
  request_timeout_ms: int,
  timeout_ms: int,
) -> list[ListTypeDescriptor]

Name Type Summary

Name	Type	Summary
`keyspace`	`str`	Optional. The keyspace to inspect. Default: The database’s working keyspace.
`table_admin_timeout_ms`	`int`	A timeout, in milliseconds, for the underlying HTTP request. If not provided, the `Database` setting is used. This parameter is aliased as `request_timeout_ms` and `timeout_ms` for convenience.

keyspace

str

Optional. The keyspace to inspect.

Default: The database’s working keyspace.

table_admin_timeout_ms

int

A timeout, in milliseconds, for the underlying HTTP request. If not provided, the Database setting is used. This parameter is aliased as request_timeout_ms and timeout_ms for convenience.

Use the listTypes method, which belongs to the Db class.

Method signature

async listTypes(
  options?: {
    nameOnly?: false,
    keyspace?: string,
    timeout?: number | TimeoutDescriptor,
  },
): TypeDescriptor[]

Name Type Summary

Name	Type	Summary
`options`	`ListTypesOptions`	Optional. The options for this operation. See Properties of `options` for more details.

options

ListTypesOptions

Optional. The options for this operation. See Properties of options for more details.

Properties of `options`
Name	Type	Summary
`nameOnly`	`false`	Optional. Must be `false` or undefined to return metadata about the user defined types. Otherwise, only the user defined type names are returned.
`keyspace`	`string`	Optional. The keyspace to inspect. Default: The database’s working keyspace.
`timeout`	`number` \| `TimeoutDescriptor`	Optional. A timeout to impose on the underlying API request.

The Go client is in preview. For more information, see astra-db-go.

Use the ListTypes method, which belongs to the Db type.

Method signature

func (d *Db) ListTypes(
  ctx context.Context,
  opts ...options.ListTypesOption
) ([]results.UDTDescriptor, error)

Name Type Summary

Name	Type	Summary
`ctx`	`context.Context`	The context for the operation.
`opts`	`…options.ListTypesOption`	Optional. A builder to generate options for this operation. See Methods of the `ListTypesOption` builder for more details.

ctx

context.Context

The context for the operation.

opts

…options.ListTypesOption

Optional. A builder to generate options for this operation. See Methods of the ListTypesOption builder for more details.

Methods of the `ListTypesOption` builder
Method	Summary
`SetKeyspace(v string)`	Optional. The keyspace to inspect. Default: The database’s working keyspace.
`UpdateAPIOptions(v …APIOption)`	Optional. General API options for this operation, including the timeout.

Use the listTypes method, which belongs to the com.datastax.astra.client.databases.Database class.

Method signature

List<TableUserDefinedTypeDescriptor> listTypes()

List<TableUserDefinedTypeDescriptor> listTypes(ListTypesOptions options)

Name Type Summary

Name	Type	Summary
`options`	`ListTypesOptions`	Optional. The options for this operation, including the keyspace and timeouts.

options

ListTypesOptions

Optional. The options for this operation, including the keyspace and timeouts.

Use the ListTypesAsync method, which belongs to the Database class. You can also use ListTypes, which is the synchronous version of the method.

Method signature

public Task<List<UserDefinedTypeInfo>> ListTypesAsync(
  ListTypesOptions options = null
);

Name Type Summary

Name	Type	Summary
`options`	`ListTypesOptions`	Optional. General API options for this operation, including the keyspace and timeout. For more information and examples, see Customize API interaction.

options

ListTypesOptions

Optional. General API options for this operation, including the keyspace and timeout. For more information and examples, see Customize API interaction.

Use the listTypes command.

Command signature

curl -sS -L -X POST "API_ENDPOINT/api/json/v1/KEYSPACE_NAME" \
--header "Token: APPLICATION_TOKEN" \
--header "Content-Type: application/json" \
--data '{
  "listTypes": {
    "options": {
      "explain": true
    }
  }
}'

Name Type Summary

Name	Type	Summary
`options.explain`	`true`	Must be `true` to return metadata about the user-defined types. Otherwise, only the names of the user-defined types are returned.

options.explain

true

Must be true to return metadata about the user-defined types. Otherwise, only the names of the user-defined types are returned.

Examples

The following examples demonstrate how to get metadata about user-defined types in a keyspace.

from astrapy import DataAPIClient

# Get a database
client = DataAPIClient()
database = client.get_database(
    "API_ENDPOINT", token="APPLICATION_TOKEN"
)

# List type metadata
result = database.list_types()
print(result)

import { DataAPIClient } from "@datastax/astra-db-ts";

// Get a database
const client = new DataAPIClient();
const database = client.db("API_ENDPOINT", {
  token: "APPLICATION_TOKEN",
});

// List type metadata
(async function () {
  const result = await database.listTypes({ nameOnly: false });

  console.log(result);
})();

The Go client is in preview. For more information, see astra-db-go.

package main

import (
	"context"
	"encoding/json"
	"fmt"
	"log"

	"github.com/datastax/astra-db-go/v2/astra"
	"github.com/datastax/astra-db-go/v2/astra/options"
)

func main() {
	ctx := context.Background()

	// Get a database
	client := astra.NewClient()

	database := client.Database(
		"API_ENDPOINT",
		options.API().SetToken("APPLICATION_TOKEN"),
	)

	// List type metadata
	types, err := database.ListTypes(ctx)

	if err != nil {
		log.Fatal(err)
	}

	output, err := json.Marshal(types)
	if err != nil {
		log.Fatal(err)
	}
	fmt.Println(string(output))
}

import com.datastax.astra.client.DataAPIClient;
import com.datastax.astra.client.databases.Database;
import com.datastax.astra.client.tables.definition.types.TableUserDefinedTypeDescriptor;
import java.util.List;

public class Example {

  public static void main(String[] args) {
    // Get a database
    Database database = new DataAPIClient("APPLICATION_TOKEN").getDatabase("API_ENDPOINT");

    // List type metadata
    List<TableUserDefinedTypeDescriptor> result = database.listTypes();

    System.out.println(result);
  }
}

using System.Text.Json;
using DataStax.AstraDB.DataApi;

namespace Examples;

public class Program
{
  static async Task Main()
  {
    // Get an existing table
    var client = new DataAPIClient();
    var database = client.GetDatabase(
      "API_ENDPOINT",
      "APPLICATION_TOKEN"
    );

    // List types
    var types = await database.ListTypesAsync();

    Console.WriteLine(JsonSerializer.Serialize(types));
  }
}

curl -sS -L -X POST "API_ENDPOINT/api/json/v1/KEYSPACE_NAME" \
  --header "Token: APPLICATION_TOKEN" \
  --header "Content-Type: application/json" \
  --data '{
  "listTypes": {
    "options": {
      "explain": true
    }
  }
}'

Client reference

For more information, see the client reference.

The Go client is in preview. For more information, see astra-db-go.

For more information, see the client reference.

Client reference documentation is not applicable for HTTP.

List user-defined types (UDTs)

Result

Parameters

Examples

Client reference

Was this helpful?

Give Feedback