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

# Clickhouse Click Pipe Reverse Private Get List: Inputs,

> List reverse private endpoints. Includes inputs, outputs, pricing notes, Deepline CLI examples, and GTM automation guidance.

## Run in Enrichment Spreadsheet

<Info>
  Use this function as a column step in `deepline enrich`.
</Info>

```bash theme={null}
deepline enrich --input leads.csv --output leads.enriched.csv --with 'result=clickhouse_click_pipe_reverse_private_endpoint_get_list:{"organizationId":"{{organizationId}}","serviceId":"{{serviceId}}"}' --json
```

<Tip>
  Map payload values to spreadsheet columns with `{{column_name}}` placeholders.
</Tip>

## Input Schema

| Name                     | Type     | Required | Default | Description                                               |
| ------------------------ | -------- | -------- | ------- | --------------------------------------------------------- |
| `payload.organizationId` | `string` | Yes      |         | ID of the organization that owns the service.             |
| `payload.serviceId`      | `string` | Yes      |         | ID of the service that owns the Reverse Private Endpoint. |

<details>
  <summary>Show raw input schema</summary>

  ### Input JSON Schema

  ```json theme={null}
  {
    "type": "object",
    "description": "Returns a list of reverse private endpoints for the specified service.",
    "properties": {
      "organizationId": {
        "type": "string",
        "description": "ID of the organization that owns the service.",
        "format": "uuid"
      },
      "serviceId": {
        "type": "string",
        "description": "ID of the service that owns the Reverse Private Endpoint.",
        "format": "uuid"
      }
    },
    "required": [
      "organizationId",
      "serviceId"
    ],
    "additionalProperties": false
  }
  ```
</details>

## Output Schema

| Name          | Type     | Required | Default | Description                                    |
| ------------- | -------- | -------- | ------- | ---------------------------------------------- |
| `result.data` | `object` | Yes      |         | Provider response payload.                     |
| `result.meta` | `object` | No       |         | Additional response metadata (status, paging). |

<details>
  <summary>Show raw output schema</summary>

  ### Output JSON Schema

  ```json theme={null}
  {
    "type": "object",
    "description": "Standard tool result payload.",
    "properties": {
      "data": {
        "type": "object",
        "description": "Provider response payload.",
        "properties": {
          "status": {
            "type": "number",
            "description": "HTTP status code."
          },
          "requestId": {
            "type": "string",
            "description": "Unique id assigned to every request. UUIDv4",
            "format": "uuid"
          },
          "result": {
            "type": "array",
            "items": {
              "properties": {
                "description": {
                  "type": "string",
                  "description": "Reverse private endpoint description. Maximum length is 255 characters."
                },
                "type": {
                  "type": "string",
                  "description": "Reverse private endpoint type.",
                  "enum": [
                    "VPC_ENDPOINT_SERVICE",
                    "VPC_RESOURCE",
                    "MSK_MULTI_VPC",
                    "GCP_PSC_SERVICE_ATTACHMENT"
                  ]
                },
                "vpcEndpointServiceName": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "VPC endpoint service name."
                },
                "vpcResourceConfigurationId": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "VPC resource configuration ID. Required for VPC_RESOURCE type."
                },
                "vpcResourceShareArn": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "VPC resource share ARN. Required for VPC_RESOURCE type."
                },
                "mskClusterArn": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "MSK cluster ARN. Required for MSK_MULTI_VPC type."
                },
                "mskAuthentication": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "MSK cluster authentication type. Required for MSK_MULTI_VPC type.",
                  "enum": [
                    "SASL_IAM",
                    "SASL_SCRAM"
                  ]
                },
                "gcpServiceAttachment": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "Private Preview. GCP PSC service attachment URI. Required for GCP_PSC_SERVICE_ATTACHMENT type. Format: projects/{project}/regions/{region}/serviceAttachments/{name}."
                },
                "customPrivateDnsMappings": {
                  "type": "array",
                  "description": "Optional private DNS names for Reverse Private Endpoint. Can be used as data source destination address. Must be unique across the ClickHouse service. Generally available for Google Private Service Connect (PSC). For AWS PrivateLink (VPC endpoint service and VPC resource), available in Private Preview; contact ClickHouse support to enable it for your service. Not supported for MSK multi-VPC. Supports exact names and leading wildcard names such as *.example.com",
                  "items": {
                    "properties": {
                      "privateDnsName": {
                        "type": "string",
                        "description": "Optional private DNS names for Reverse Private Endpoint. Can be used as data source destination address. Must be unique across the ClickHouse service. Generally available for Google Private Service Connect (PSC). For AWS PrivateLink (VPC endpoint service and VPC resource), available in Private Preview; contact ClickHouse support to enable it for your service. Not supported for MSK multi-VPC. Supports exact names and leading wildcard names such as *.example.com"
                      }
                    },
                    "additionalProperties": false
                  }
                },
                "id": {
                  "type": "string",
                  "description": "Reverse private endpoint ID.",
                  "format": "uuid"
                },
                "serviceId": {
                  "type": "string",
                  "description": "ClickHouse service ID reverse private endpoint is associated with.",
                  "format": "uuid"
                },
                "endpointId": {
                  "type": "string",
                  "description": "Reverse private endpoint endpoint ID."
                },
                "dnsNames": {
                  "type": "array",
                  "description": "Reverse private endpoint internal DNS names.",
                  "items": {
                    "type": "string"
                  }
                },
                "privateDnsNames": {
                  "type": "array",
                  "description": "Reverse private endpoint private DNS names.",
                  "items": {
                    "type": "string"
                  }
                },
                "status": {
                  "type": "string",
                  "description": "Reverse private endpoint status.",
                  "enum": [
                    "Unknown",
                    "Provisioning",
                    "Deleting",
                    "Ready",
                    "Failed",
                    "PendingAcceptance",
                    "Rejected",
                    "Expired"
                  ]
                }
              },
              "additionalProperties": false
            }
          }
        },
        "additionalProperties": false
      },
      "meta": {
        "type": "object",
        "description": "Additional response metadata (status, paging).",
        "additionalProperties": true
      }
    },
    "required": [
      "data"
    ],
    "additionalProperties": false
  }
  ```
</details>

## Advanced: Direct CLI

<Info>
  Use direct execution for single payload debugging.
</Info>

```bash theme={null}
deepline tools execute clickhouse_click_pipe_reverse_private_endpoint_get_list --payload '{
  "organizationId": "string",
  "serviceId": "string"
}' --json
```

### CLI flags

| Flag                        | Description                                         |
| --------------------------- | --------------------------------------------------- |
| `--json`                    | Print machine-readable output.                      |
| `--wait`                    | Wait for terminal provider status when supported.   |
| `--debug`                   | Enable wait mode with additional status/log output. |
| `--wait-timeout SECONDS`    | Max seconds to wait in wait mode.                   |
| `--poll-interval SECONDS`   | Polling interval in seconds during wait mode.       |
| `--timeout SECONDS`         | Request timeout in seconds.                         |
| `--connect-timeout SECONDS` | Connection timeout in seconds.                      |

## Cost

* Pricing model: `fixed` (per call).
* Estimated Deepline credits: `0` per pricing unit.
* Provider-native pricing may still exist outside Deepline credit billing.
* Billing mode: `no_bill`.