> ## Documentation Index
> Fetch the complete documentation index at: https://exsited.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Retrieve the columns of an external database table

> Returns the columns of one table of a database, as a list under `data`.

Pass the database `name` as `db_name` and the table's `table_name`. The response has the same shape as the database listing, with the table's columns under `data`.

> [!NOTE]
>
> The SDK samples get their client from credentials your app registers once when it starts, as shown in [Authentication](https://exsited.mintlify.site/authentication.md#set-up-a-client). To try the call here, click **Try it**, set `host` to your Exsited API host name and paste an access token from [Get an access token](https://exsited.mintlify.site/api-reference/authentication/get-an-access-token.md).


## OpenAPI

````yaml GET /external_databases/{db_name}/tables/{table_name}
openapi: 3.1.0
info:
  title: Exsited API
  version: v4
servers:
  - url: https://{host}/api/v4
    variables:
      host:
        default: your-api-host.example.com
        description: Your Exsited API host name, without https://.
security:
  - bearerAuth: []
tags:
  - name: Authentication
  - name: Accounts
  - name: Account emails
  - name: Account groups
  - name: Communications
  - name: Communication profiles
  - name: Orders
  - name: Quote orders
  - name: Express
  - name: Usages
  - name: Sales reps
  - name: Gift certificates
  - name: Invoices
  - name: Pro-forma invoices
  - name: Payments
  - name: Refunds
  - name: Credit notes
  - name: Credit note applications
  - name: Reconciliations
  - name: Items
  - name: Inventory adjustments
  - name: Units of measurement
  - name: Zones
  - name: Shipping packages
  - name: Shipping rules
  - name: Fulfillment profiles
  - name: Fulfillment terms
  - name: Item fulfillments
  - name: Item receipts
  - name: Bookings
  - name: Rental assets
  - name: Return merchandise authorisations
  - name: Purchase orders
  - name: Purchase invoices
  - name: Purchase payments
  - name: Purchase refunds
  - name: Purchase credit notes
  - name: Purchase credit note applications
  - name: Purchase express
  - name: Return vendor authorizations
  - name: ABA files
  - name: Receive terms
  - name: Labours
  - name: Tasks
  - name: Timesheets
  - name: Milestones
  - name: Employees
  - name: Departments
  - name: Designations
  - name: Teams
  - name: Time periods
  - name: Workflows
  - name: Workflow settings
  - name: Events
  - name: Custom events
  - name: System events
  - name: Approvals
  - name: Approval profiles
  - name: Approval user groups
  - name: Alerts
  - name: Alert responsibility settings
  - name: Alert responsibilities
  - name: Action scripts
  - name: Note groups
  - name: Note attachments
  - name: Instance settings
  - name: Accounting codes
  - name: Additional codes
  - name: Billing periods
  - name: Charging periods
  - name: Pricing periods
  - name: Invoice terms
  - name: Days of the month
  - name: Countries
  - name: Salutations
  - name: Document templates
  - name: Email templates
  - name: Roles
  - name: Operators
  - name: Operator groups
  - name: User settings
  - name: Custom attributes
  - name: Custom components
  - name: Custom features
  - name: Custom fields
  - name: Custom forms
  - name: Attribute attachments
  - name: Portal
  - name: Integration connections
  - name: External databases
  - name: Reports
  - name: Applications
  - name: Organisation
  - name: Child organisations
  - name: Webhooks
paths:
  /external_databases/{db_name}/tables/{table_name}:
    get:
      tags:
        - External databases
      summary: Retrieve the columns of an external database table
      description: >-
        Pass the database `name` as `db_name` and the table's `table_name`. The
        response has the same shape as the database listing, with the table's
        columns under `data`.
      operationId: external_databases_get_external_database_table
      parameters:
        - name: db_name
          in: path
          required: true
          description: >-
            The database's `name`, as given when it is created, such as
            `acmedb`.
          schema:
            type: string
        - name: table_name
          in: path
          required: true
          description: The table's `table_name`, such as `contacts`.
          schema:
            type: string
      responses:
        '200':
          description: The table's columns, under `data`.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ExternalDatabaseList'
      x-codeSamples:
        - lang: bash
          label: cURL
          source: >-
            curl -X GET
            "$EXSITED_BASE_URL/api/v4/external_databases/acmedb/tables/contacts"
            \
              -H "Authorization: Bearer $ACCESS_TOKEN"
        - lang: python
          label: Python
          source: >
            from exsited import build_client


            client = build_client()


            response =
            client.external_databases.get_external_database_table("acmedb",
            "contacts")

            print(response.data)
        - lang: javascript
          label: JavaScript
          source: >
            import {buildClient} from 'exsited';


            const client = await buildClient();


            const response = await
            client.externalDatabases.getExternalDatabaseTable('acmedb',
            'contacts');

            console.log(response.data);
        - lang: php
          label: PHP
          source: >
            use Exsited\Client\ClientRegistry;


            $client = ClientRegistry::buildClient();


            $response =
            $client->externalDatabases->getExternalDatabaseTable('acmedb',
            'contacts');

            print_r($response->data);
        - lang: java
          label: Java
          source: >
            import com.exsited.client.ApiResponse;

            import com.exsited.client.ClientRegistry;

            import com.exsited.client.ExsitedClient;

            import
            com.exsited.resources.external_databases.external_databases_dto.ExternalDatabasesDto;


            ExsitedClient client = ClientRegistry.buildClient();


            ApiResponse<ExternalDatabasesDto.ExternalDatabases> response =
            client.externalDatabases().getExternalDatabaseTable(
                    "acmedb",
                    "contacts");
            System.out.println(response.getMap());
        - lang: csharp
          label: .NET
          source: >
            using Exsited.Client;


            await using var client = ExsitedClient.BuildClient();


            var response = await
            client.ExternalDatabases.GetExternalDatabaseTableAsync("acmedb",
            "contacts");


            Console.WriteLine(response.Json);
        - lang: dart
          label: Dart
          source: >
            import 'package:exsited/exsited.dart';


            final client = buildClient();


            final response = await
            client.externalDatabases.getExternalDatabaseTable(
              'acmedb',
              'contacts',
            );

            print(response.map);
        - lang: go
          label: Go
          source: "import (\n\t\"context\"\n\t\"fmt\"\n\t\"log\"\n\n\texsited \"github.com/exsited/exsited-sdk-go/v4\"\n)\n\nclient, err := exsited.BuildClient(nil)\nif err != nil {\n\tlog.Fatal(err)\n}\ndefer client.Close()\n\nresponse, err := client.ExternalDatabases().GetExternalDatabaseTable(context.Background(), \"acmedb\", \"contacts\", nil, nil)\nif err != nil {\n\tlog.Fatal(err)\n}\nfmt.Println(response.Map)\n"
components:
  schemas:
    ExternalDatabaseList:
      type: object
      properties:
        object:
          type: string
        url:
          type: string
        data:
          type: array
          items:
            type: object
          description: >-
            The entries on this page. In the database listing, each has a
            `name`.
        pagination:
          $ref: '#/components/schemas/ExternalDatabasePagination'
    ExternalDatabasePagination:
      type: object
      properties:
        has_next:
          type: boolean
        has_prev:
          type: boolean
        per_page:
          type:
            - integer
            - 'null'
        next_cursor:
          type:
            - string
            - 'null'
        prev_cursor:
          type:
            - string
            - 'null'
        links:
          $ref: '#/components/schemas/ExternalDatabasePaginationLinks'
    ExternalDatabasePaginationLinks:
      type: object
      properties:
        next:
          type: string
        prev:
          type: string
  securitySchemes:
    bearerAuth:
      type: http
      scheme: bearer
      description: >-
        An access token from `POST /api/v4/oauth2/token`. The SDKs get and renew
        it for you.

````

This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.