Generate a CSV dump of project information from GitLab

gitlab-to-csv.sh

#!/bin/bash
#
# This script can be used as a starting point for generating a spreadsheet of
# GitLab projects, with their properties, from an existing GitLab instance
#
# You must set a GitLab access token via the GITLAB_TOKEN env variable
#
# Invoke with ./gitlab-to-csv.sh <gitlab hostname>


FILENAME=projects.csv

echo "path,archived,namespace_kind" > ${FILENAME}

for i in $(seq 1 100); do
    echo ">> Fetching page ${i}.."
    curl --silent --fail \
        -o - \
        -H "Content-Type: application/json" \
        -H "Authorization: Bearer ${GITLAB_TOKEN}" \
        "https://${1}/api/v4/projects?per_page=100&page=${i}" \
            |  jq -e -r ".[] | [.path_with_namespace, .archived, .namespace.kind] | @csv" \
            >> ${FILENAME}

    if [ $? -ne 0 ]; then
        echo ">> Exiting after $i pages, $(wc -l $FILENAME) written to ${FILENAME}";
        exit;
    fi;
done;