MailCow Import Multiple Mailbox from CSV File

import.sh

#!/bin/bash

# Set the API endpoint URL and key
ENDPOINT="https://mcow.domain.tld/api/v1/add/mailbox"
API_KEY="XXX-YYY"

# Read the CSV file line by line and create mailbox users
while IFS=',' read -r from_name from_email user_name password; do
    # Extract the domain from the user_name field
    domain=$(echo "$user_name" | awk -F'@' '{print $2}')

    # Extract the local part from the user_name field
    local_part=$(echo "$user_name" | awk -F'@' '{print $1}')

    # Build the API request JSON
    data=$(cat <<EOF
    {
      "active": "1",
      "domain": "$domain",
      "local_part": "$local_part",
      "name": "$from_name",
      "password": "$password",
      "password2": "$password",
      "quota": "0",
      "tls_enforce_in": "1",
      "tls_enforce_out": "1"
    }
EOF
)

    # Make the API request
    response=$(curl -s -H "X-API-Key: $API_KEY" -H "Content-Type: application/json" -d "$data" "$ENDPOINT")

    # Print the response
    echo "Response for $user_name:"
    echo "$response"

done < <(tail -n +2 /root/mailboxes.csv)