> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Connections: List all (Javascript)

> This script lists all connections in alphabetically order by name.

This script lists all connections in alphabetical order by name.

Refer to the [Sigma REST API Recipes](https://quickstarts.sigmacomputing.com/guide/developers_api_code_samples/index.html?index=../..index#0) QuickStart for step-by-step instructions.

## Example script

```javascript JavaScript
// This script lists all connections in alphabetically order by name

// Load environment variables from a specific .env file for configuration
require('dotenv').config({ path: 'sigma-api-recipes/.env' });

// Import the function to obtain a bearer token from the authenticate-bearer module
const getBearerToken = require('../get-access-token');

// Import Axios for making HTTP requests
const axios = require('axios');

// Load use-case specific variables from environment variables
const baseURL = process.env.baseURL; // Your base URL

// Define an asynchronous function to fetch and sort connections
async function listConnections() {
    const accessToken = await getBearerToken();
    if (!accessToken) {
        console.error('Failed to obtain Bearer token.');
        return;
    }

    try {
        const endpoint = `${baseURL}/connections?includeArchived=false`;
        console.log(`Fetching connections from: ${endpoint}`);

        // API request to fetch connections
        const response = await axios.get(endpoint, {
            headers: { 'Authorization': `Bearer ${accessToken}`, 'Accept': 'application/json' },
        });

        const connections = response.data.entries; // Access 'entries' field in response

        console.log('Raw Response:', response.data); // Debugging log to confirm data structure

        if (connections && connections.length > 0) {
            // Sort connections alphabetically by name
            const sortedConnections = connections.sort((a, b) =>
                a.name.localeCompare(b.name)
            );

            // Display sorted connections
            sortedConnections.forEach((connection, index) => {
                console.log(`#${index + 1}: Name: ${connection.name}, ID: ${connection.connectionId}, Type: ${connection.type}`);
            });
        } else {
            console.log('No connections found.');
        }
    } catch (error) {
        console.error('Error fetching connections:', error.message);
        if (error.response) {
            console.error('Response Data:', error.response.data);
        }
    }
}

// Execute the function to list connections if this script is run directly
if (require.main === module) {
    listConnections();
}

// Export the listConnections function for reuse in other modules
module.exports = listConnections;
```

```json Response Example
#1: Name: Sigma Sample Database, ID: 10eed7b7-4a10-4c40-802b-xxxxxxxxxx, Type: snowflake
```

## Endpoints used

1. Get authentication token: `getBearerToken` function
2. List connections