Command to export all grafana 2 dashboard to JSON using curl

grafana-dashboard-exporter

KEY=XXXXXXXXXXXX
HOST="https://metrics.crisidev.org"

mkdir -p dashboards && for dash in $(curl -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']' '\n' |cut -d "," -f 5 |grep slug |cut -d\" -f 4); do 
  curl -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/db/$dash > dashboards/$dash.json 
done

Thanks, was looking for something simple like this 👍

thanks for this script,saved me a bunch of time
perhaps you should mention that API key should be created for each org

another thing is , i found it useful to save the JSONs in human readable format by piping them through |python -m json.tool

Here is an upgraded version for the latest version of grafana :

KEY=XXXXXXXXXXXXXXXXXXXXXXXXXXXX
HOST="https://my.super.duper.grafana.com"

if [ !-d dashboards ] ; then
    mkdir -p dashboards
fi

for dash in $(curl -sSL -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq '.' |grep -i uri|awk -F '"uri": "' '{ print $2 }'|awk -F '"' '{print $1 }'); do
  curl -sSL -k -H "Authorization: Bearer ${KEY}" "${HOST}/api/dashboards/${dash}" > dashboards/$(echo ${dash}|sed 's,db/,,g').json
done

I hope you don't mind that I've used your scripts for my repo: https://github.com/hagen1778/grafana-import-export

Thanks all for the precious scripts, the export was working but then the import script is always rejected the dashboards for me in Grafana 3.1.1.
The fix was setting the id to null and adding the overwrite flag to true to be able either to create the dashboard from scratch or replace it if existing.
If you want to block the importation if already existing, you can simply set the overwrite flag to false.

Here is the code in the export script so the import script can run smoothly.
This code does not need the jq framework.

KEY=XXXX
HOST="http://XXXX:3000"

if [ !-d dashboards ] ; then
    mkdir -p dashboards
fi

for dash in $(curl -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']' '\n' |cut -d "," -f 5 | grep db |cut -d\" -f 4 |cut -d\/ -f2); do 
  curl -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/db/$dash | sed 's/"id":[0-9]\+,/"id":null,/' | sed 's/\(.*\)}/\1,"overwrite": true}/' > dashboards/$dash.json 
done

I found that the previous script did not capture the first dashboard. This version fixes the problem:

SCRIPT_DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
KEY=$(<~/.grafanakey)
HOST="http://localhost:3000"


if [ ! -d $SCRIPT_DIR/dashboards ] ; then
    mkdir -p $SCRIPT_DIR/dashboards
fi

for dash in $(curl -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |sed 's/{"id"/\\\n{"id"/g' |cut -d "," -f 3 | grep db |cut -d\" -f 4 |cut -d\/ -f2); do
  curl -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/db/$dash | sed 's/"id":[0-9]\+,/"id":null,/' | sed 's/\(.*\)}/\1,"overwrite": true}/' > $SCRIPT_DIR/dashboards/$dash.json
done

Can anyone please let me what's KEY and HOST here in the script ?

@shashanks93
KEY is Grafana authorisation token. it is described well here http://docs.grafana.org/http_api/auth/
HOST is node on which your grafana instance is running. Basically, host of UI.
i

Was able to achieve this by this script

#!/usr/bin/env bash
SCRIPT_DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
KEY=$(<~/.grafanakey)
HOST="https://mdmdev.cloudtrust.rocks"


if [ ! -d $SCRIPT_DIR/dashboards ] ; then
    mkdir -p $SCRIPT_DIR/dashboards
fi

for dash in $(curl -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq -r '.[] | .uri'); do
  curl -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/$dash | sed 's/"id":[0-9]\+,/"id":null,/' | sed 's/\(.*\)}/\1,"overwrite": true}/' > dashboards/$(echo ${dash} |cut -d\" -f 4 |cut -d\/ -f2).json
done

#!/bin/bash -x
#
# http://linux-notes.org/
#
#Vitaliy Natarov
#Set some colors for status OK, FAIL and titles
SETCOLOR_SUCCESS="echo -en \\033[1;32m"
SETCOLOR_FAILURE="echo -en \\033[1;31m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"

SETCOLOR_TITLE="echo -en \\033[1;36m" #Fuscia
SETCOLOR_TITLE_GREEN="echo -en \\033[0;32m" #green
SETCOLOR_TITLE_PURPLE="echo -en \\033[0;35m" #purple 
SETCOLOR_NUMBERS="echo -en \\033[0;34m" #BLUE

KEY="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
HOST="http://graffana_url"
DASH_DIR="~/Grafana/dashboards"

if [ ! -d "$DASH_DIR" ]; then
	 mkdir -p dashboards 
else
	 $SETCOLOR_TITLE_PURPLE
	 echo "|-------------------------------------------------------------------------------|";
	 echo "| A $DASH_DIR directory is already exist! |";
	 echo "|-------------------------------------------------------------------------------|";
	 $SETCOLOR_NORMAL
fi
  
#curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']{' '\n'| cut -d ':' -f4| cut -d ',' -f1| cut -d '"' -f2 | grep -Ev "(^$|\[)"| cut -c 4-

for dash in $(curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']{' '\n'| cut -d ':' -f4| cut -d ',' -f1| cut -d '"' -f2 | grep -Ev "(^$|\[)"| cut -c 4-); do
	curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/db/$dash > dashboards/$dash.json
	$SETCOLOR_TITLE_GREEN
	echo "The [ $dash ] dashboard has been exported"  
	$SETCOLOR_NORMAL
done

$SETCOLOR_TITLE
echo "|-------------------------------------------------------------------------------|";
echo "|----------------------------------FINISHED-------------------------------------|";
echo "|-------------------------------------------------------------------------------|";
$SETCOLOR_NORMAL

@SebastianUA, can you please share the restore script as well which can be used to restore dashboards backup taken by your script.
Thanks in Advance !

how did you create a new dashboard with exported json file?
I try this but got the error. However, when I manually insert the json file through UI, it works.

curl -k -H "Content-Type: application/json" -H "Authorization: Bearer $KEY" -X POST -d dashboards/$DASHBOARD.json $HOST:$PORT/api/dashboards/db

[{"classification":"DeserializationError","message":"invalid character 'd' looking for beginning of value"},{"fieldNames":["Dashboard"],"classification":"RequiredError","message":"Required"}]

@timeforce

Please add the following to the end of json file.
I could.

  },
  "overwrite": true
}

Thank you for creating.
I improved visibility of json file.

#!/usr/bin/env bash
SCRIPT_DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
KEY=$(<~/.grafanakey)
HOST="https://mdmdev.cloudtrust.rocks"


if [ ! -d $SCRIPT_DIR/dashboards ] ; then
    mkdir -p $SCRIPT_DIR/dashboards
fi

for dash in $(curl -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq -r '.[] | .uri'); do
  curl -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/$dash | sed 's/"id":[0-9]\+,/"id":null,/' | sed 's/\(.*\)}/\1,"overwrite": true}/' | jq . > dashboards/$(echo ${dash} |cut -d\" -f 4 |cut -d\/ -f2).json
done

Updating on @SebastianUA's solution to work with grafana 5.0 (access dashboards by uid)

#!/bin/bash -x
#
# http://linux-notes.org/
#
#Vitaliy Natarov
#Set some colors for status OK, FAIL and titles
SETCOLOR_SUCCESS="echo -en \\033[1;32m"
SETCOLOR_FAILURE="echo -en \\033[1;31m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"

SETCOLOR_TITLE="echo -en \\033[1;36m" #Fuscia
SETCOLOR_TITLE_GREEN="echo -en \\033[0;32m" #green
SETCOLOR_TITLE_PURPLE="echo -en \\033[0;35m" #purple 
SETCOLOR_NUMBERS="echo -en \\033[0;34m" #BLUE

KEY="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
HOST="http://graffana_url"
DASH_DIR="~/Grafana/dashboards"

if [ ! -d "$DASH_DIR" ]; then
	 mkdir -p dashboards 
else
	 $SETCOLOR_TITLE_PURPLE
	 echo "|-------------------------------------------------------------------------------|";
	 echo "| A $DASH_DIR directory is already exist! |";
	 echo "|-------------------------------------------------------------------------------|";
	 $SETCOLOR_NORMAL
fi
  
#curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']{' '\n'| cut -d ':' -f3| cut -d ',' -f1| cut -d '"' -f2 | grep -Ev "(^$|\[)"| cut -c 4-

for dash in $(curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']{' '\n'| cut -d ':' -f3| cut -d ',' -f1| cut -d '"' -f2 | grep -Ev "(^$|\[)"| cut -c 4-); do
	curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/dashboards/uid/$dash > dashboards/$dash.json
	$SETCOLOR_TITLE_GREEN
	echo "The [ $dash ] dashboard has been exported"  
	$SETCOLOR_NORMAL
done

$SETCOLOR_TITLE
echo "|-------------------------------------------------------------------------------|";
echo "|----------------------------------FINISHED-------------------------------------|";
echo "|-------------------------------------------------------------------------------|";
$SETCOLOR_NORMAL

I played with a couple of these scripts and I did get dashboards. But I noticed that all my templated dashboards do not have their variables. Which is most of our dashboards. Has anyone had experience pulling a dashboard with template variables?

I've lost track of this gist. It is awesome to see such engagement and improvements!

For Grafana 5.0.0 I had to remove the cut -c 4-.

#!/bin/bash
#
# Vitaliy Natarov
# see https://gist.github.com/crisidev/bd52bdcc7f029be2f295
#
# add the "-x" option to the shebang line if you want a more verbose output
#
# set some colors for status OK, FAIL and titles
SETCOLOR_SUCCESS="echo -en \\033[1;32m"
SETCOLOR_FAILURE="echo -en \\033[1;31m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"

SETCOLOR_TITLE="echo -en \\033[1;36m" # fuchsia
SETCOLOR_TITLE_GREEN="echo -en \\033[0;32m" # green
SETCOLOR_TITLE_PURPLE="echo -en \\033[0;35m" # purple 
SETCOLOR_NUMBERS="echo -en \\033[0;34m" # blue

KEY="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
HOST="http://grafana_url:grafana_port"
DASH_DIR="${HOME}/Documents/Grafana/dashboards" # adapt to your needs!

if [ ! -d "${DASH_DIR}" ]; then
	 mkdir -p "${DASH_DIR}" 
else
	 ${SETCOLOR_TITLE_PURPLE}
	 echo "|-------------------------------------------------------------------------------|";
	 echo "| A $DASH_DIR directory already exists! |";
	 echo "|-------------------------------------------------------------------------------|";
	 ${SETCOLOR_NORMAL}
fi
  
#curl -sS -k -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& |tr ']{' '\n'| cut -d ':' -f3| cut -d ',' -f1| cut -d '"' -f2 | grep -Ev "(^$|\[)"
#exit 0

for dash in $(curl -sS -k -H "Authorization: Bearer ${KEY}" ${HOST}/api/search\?query\=\& |tr ']{' '\n'| cut -d ':' -f3| cut -d ',' -f1| cut -d '"' -f2 | grep -Ev "(^$|\[)"); do
	curl -sS -k -H "Authorization: Bearer ${KEY}" "${HOST}/api/dashboards/uid/${dash}" -o "${DASH_DIR}/${dash}.json"
	${SETCOLOR_TITLE_GREEN}
	echo "The [ ${dash} ] dashboard has been exported as ${DASH_DIR}/${dash}.json"  
	${SETCOLOR_NORMAL}
done

$SETCOLOR_TITLE
echo "|-------------------------------------------------------------------------------|";
echo "|----------------------------------FINISHED-------------------------------------|";
echo "|-------------------------------------------------------------------------------|";
$SETCOLOR_NORMAL

Made a few updates:

• Makes $HOST and $KEY as command line arguments.
• Updates JSON parsing to use jq.
• Filters out the folders from the search query so only dashboards are saved.
• Saves dashboard using dashboard title instead of uid.
• Gets the folder name and preserves the folder organization when saving dashboards. Really useful if you have a ton of dashboards and folders
• Some refactoring to include an init function and common log functions with timestamps.

#!/bin/bash
#
# Anugrah Vijay
# add the "-x" option to the shebang line if you want a more verbose output
#
# set some colors for status OK, FAIL and titles
SETCOLOR_SUCCESS="echo -en \\033[0;32m"
SETCOLOR_FAILURE="echo -en \\033[1;31m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"
SETCOLOR_TITLE_PURPLE="echo -en \\033[0;35m" # purple 

# usage log "string to log" "color option"
function log_success() {
	if [ $# -lt 1 ]; then
	    ${SETCOLOR_FAILURE}
	    echo "Not enough arguments for log function! Expecting 1 argument got $#"
	    exit 1
	fi

	timestamp=$(date "+%Y-%m-%d %H:%M:%S %Z")

	${SETCOLOR_SUCCESS}
	printf "[${timestamp}] $1\n"
	${SETCOLOR_NORMAL}
}

function log_failure() {
	if [ $# -lt 1 ]; then
	    ${SETCOLOR_FAILURE}
	    echo "Not enough arguments for log function! Expecting 1 argument got $#"
	    exit 1
	fi

	timestamp=$(date "+%Y-%m-%d %H:%M:%S %Z")

	${SETCOLOR_FAILURE}
	printf "[${timestamp}] $1\n"
	${SETCOLOR_NORMAL}
}

function log_title() {
	if [ $# -lt 1 ]; then
	    ${SETCOLOR_FAILURE}
	    log_failure "Not enough arguments for log function! Expecting 1 argument got $#"
	    exit 1
	fi

	${SETCOLOR_TITLE_PURPLE}
	printf "|-------------------------------------------------------------------------|\n"
	printf "|$1|\n";
	printf "|-------------------------------------------------------------------------|\n"
	${SETCOLOR_NORMAL}
}

function init() {
	# Check if hostname and key are provided 
	if [ $1 -lt 2 ]; then
	    ${SETCOLOR_FAILURE}
	    log_failure "Not enough command line arguments! Expecting two: \$HOSTNAME and \$KEY. Recieved only $1."
	    exit 1
	fi

	DASH_DIR=$(echo $HOST | awk -F[/:] '{print $4}')

	if [ ! -d "${DASH_DIR}" ]; then
		 mkdir "${DASH_DIR}" 
	else
		log_title "----------------- A $DASH_DIR directory already exists! -----------------"
	fi
}


HOST=$1
KEY=$2
init $# $HOST $KEY

for dashboard_uid in $(curl -sS -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq -r '.[] | select( .type | contains("dash-db")) | .uid'); do 

	dashboard_json="$(curl -sS -H "Authorization: Bearer $KEY" $HOST/api/dashboards/uid/$dashboard_uid)"
	dashboard_title="$(echo $dashboard_json | jq -r '.dashboard | .title')"
	folder_title="$(echo $dashboard_json | jq -r '.meta | .folderTitle')"

	mkdir -p "$DASH_DIR/$folder_title"
	echo $dashboard_json > "$DASH_DIR/$folder_title/$dashboard_title.json"

	log_success "Dashboard has been saved\t\t title=\"${dashboard_title}\", uid=\"${dashboard_uid}\", path=\"${DASH_DIR}/$folder_title/${dashboard_title}.json\"." 
done

log_title "------------------------------ FINISHED ---------------------------------";

@van

Made a a couple tweaks:

• counter of saved dashboards
• replace some special symbols if they exist in a title
• version of saved dashboard in its filename

#!/bin/bash
#
# add the "-x" option to the shebang line if you want a more verbose output
#
# set some colors for status OK, FAIL and titles
SETCOLOR_SUCCESS="echo -en \\033[0;32m"
SETCOLOR_FAILURE="echo -en \\033[1;31m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"
SETCOLOR_TITLE_PURPLE="echo -en \\033[0;35m" # purple 

# usage log "string to log" "color option"
function log_success() {
   if [ $# -lt 1 ]; then
       ${SETCOLOR_FAILURE}
       echo "Not enough arguments for log function! Expecting 1 argument got $#"
       exit 1
   fi

   timestamp=$(date "+%Y-%m-%d %H:%M:%S %Z")

   ${SETCOLOR_SUCCESS}
   printf "[${timestamp}] $1\n"
   ${SETCOLOR_NORMAL}
}

function log_failure() {
   if [ $# -lt 1 ]; then
       ${SETCOLOR_FAILURE}
       echo "Not enough arguments for log function! Expecting 1 argument got $#"
       exit 1
   fi

   timestamp=$(date "+%Y-%m-%d %H:%M:%S %Z")

   ${SETCOLOR_FAILURE}
   printf "[${timestamp}] $1\n"
   ${SETCOLOR_NORMAL}
}

function log_title() {
   if [ $# -lt 1 ]; then
       ${SETCOLOR_FAILURE}
       log_failure "Not enough arguments for log function! Expecting 1 argument got $#"
       exit 1
   fi

   ${SETCOLOR_TITLE_PURPLE}
   printf "|-------------------------------------------------------------------------|\n"
   printf "|$1|\n";
   printf "|-------------------------------------------------------------------------|\n"
   ${SETCOLOR_NORMAL}
}

function init() {
   # Check if hostname and key are provided 
   if [ $1 -lt 2 ]; then
       ${SETCOLOR_FAILURE}
       log_failure "Not enough command line arguments! Expecting two: \$HOSTNAME and \$KEY. Recieved only $1."
       exit 1
   fi

   DASH_DIR=$(echo $HOST | awk -F[/:] '{print $4}')

   if [ ! -d "${DASH_DIR}" ]; then
   	 mkdir "${DASH_DIR}" 
   else
   	log_title "----------------- A $DASH_DIR directory already exists! -----------------"
   fi
}


HOST=$1
KEY=$2
init $# $HOST $KEY

counter=0

for dashboard_uid in $(curl -sS -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq -r '.[] | select( .type | contains("dash-db")) | .uid'); do 

   counter=$((counter + 1))
   dashboard_json="$(curl -sS -H "Authorization: Bearer $KEY" $HOST/api/dashboards/uid/$dashboard_uid)"
   dashboard_title="$(echo $dashboard_json | jq -r '.dashboard | .title' | sed -r 's/[ \/]+/_/g' )"
   dashboard_version="$(echo $dashboard_json | jq -r '.dashboard | .version')"
   folder_title="$(echo $dashboard_json | jq -r '.meta | .folderTitle')"

   mkdir -p "$DASH_DIR/$folder_title"
   echo $dashboard_json > "$DASH_DIR/$folder_title/${dashboard_title}_v${dashboard_version}.json"

   log_success "Dashboard has been saved\t\t title=\"${dashboard_title}\", uid=\"${dashboard_uid}\", path=\"${DASH_DIR}/$folder_title/${dashboard_title}_v${dashboard_version}.json\"." 
done

log_title "${counter} dashboards were saved";

log_title "------------------------------ FINISHED ---------------------------------";

Hi, seems need to add special key to disable ssl verification which add --insecure key to curl.

Made a change to ease the life of Windows users!

#/bin/bash
#
# add the "-x" option to the shebang line if you want a more verbose output
#
# set some colors for status OK, FAIL and titles
SETCOLOR_SUCCESS="echo -en \\033[0;32m"
SETCOLOR_FAILURE="echo -en \\033[1;31m"
SETCOLOR_NORMAL="echo -en \\033[0;39m"
SETCOLOR_TITLE_PURPLE="echo -en \\033[0;35m" # purple 

# usage log "string to log" "color option"
function log_success() {
   if [ $# -lt 1 ]; then
       ${SETCOLOR_FAILURE}
       echo "Not enough arguments for log function! Expecting 1 argument got $#"
       exit 1
   fi

   timestamp=$(date "+%Y-%m-%d %H:%M:%S %Z")

   ${SETCOLOR_SUCCESS}
   printf "[${timestamp}] $1\n"
   ${SETCOLOR_NORMAL}
}

function log_failure() {
   if [ $# -lt 1 ]; then
       ${SETCOLOR_FAILURE}
       echo "Not enough arguments for log function! Expecting 1 argument got $#"
       exit 1
   fi

   timestamp=$(date "+%Y-%m-%d %H:%M:%S %Z")

   ${SETCOLOR_FAILURE}
   printf "[${timestamp}] $1\n"
   ${SETCOLOR_NORMAL}
}

function log_title() {
   if [ $# -lt 1 ]; then
       ${SETCOLOR_FAILURE}
       log_failure "Not enough arguments for log function! Expecting 1 argument got $#"
       exit 1
   fi

   ${SETCOLOR_TITLE_PURPLE}
   printf "|-------------------------------------------------------------------------|\n"
   printf "|$1|\n";
   printf "|-------------------------------------------------------------------------|\n"
   ${SETCOLOR_NORMAL}
}

function init() {
   # Check if hostname and key are provided 
   if [ $1 -lt 2 ]; then
       ${SETCOLOR_FAILURE}
       log_failure "Not enough command line arguments! Expecting two: \$HOSTNAME and \$KEY. Recieved only $1."
       exit 1
   fi

   DASH_DIR=$(echo $HOST | awk -F[/:] '{print $4}')

   if [ ! -d "${DASH_DIR}" ]; then
   	 mkdir "${DASH_DIR}" 
   else
   	log_title "----------------- A $DASH_DIR directory already exists! -----------------"
   fi
}


HOST=$1
KEY=$2
init $# $HOST $KEY

counter=0

for dashboard_uid in $(curl -sS -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq -r '.[] | select( .type | contains("dash-db")) | .uid'); do 

   counter=$((counter + 1))
   url=`echo $HOST/api/dashboards/uid/$dashboard_uid | tr -d '\r'`
   dashboard_json=$(curl -sS -H "Authorization: Bearer $KEY" $url)
   dashboard_title=$(echo $dashboard_json | jq -r '.dashboard | .title' | sed -r 's/[ \/]+/_/g' )
   dashboard_version=$(echo $dashboard_json | jq -r '.dashboard | .version')
   folder_title=$(echo $dashboard_json | jq -r '.meta | .folderTitle')

   mkdir -p "$DASH_DIR/$folder_title"
   echo $dashboard_json > "$DASH_DIR/$folder_title/${dashboard_title}_v${dashboard_version}.json"

   log_success "Dashboard has been saved\t\t title=\"${dashboard_title}\", uid=\"${dashboard_uid}\", path=\"${DASH_DIR}/$folder_title/${dashboard_title}_v${dashboard_version}.json\"." 
done

log_title "${counter} dashboards were saved";

log_title "------------------------------ FINISHED ---------------------------------";```

Another tool to export dashboards, now with PHP -> https://github.com/wnasich/grafana_dd

It's possible that I was doing something wrong, but just in case, I'm adding to this discussion to save others the hassle that I've just been through.

Whilst this explains a way of exporting the JSON from the dashboards, the format it comes out in will not directly import back in.

After playing around, I found that the simply piping out to:

jq .

Created a JSON file that was one level too high. When I attempted to import the resulting file back into Grafana, it created the dashboard completely empty. Instead, if we do:

jq .dashboard

Then you get a JSON file in the format that Grafana wants. I have tested this by creating several dashboards, using the script to export them (with the above fix), deleting them and then re-importing them. All now works fine.

If running on a Mac, the antiquated BSD version of sed included with OSX does not support extended regex. Therefore, you first need to install brew and gnu-sed, then change sed to gsed in the line below.

dashboard_title=$(echo $dashboard_json | jq -r '.dashboard | .title' | sed -r 's/[ \/]+/_/g' )

becomes

dashboard_title=$(echo $dashboard_json | jq -r '.dashboard | .title' | gsed -r 's/[ \/]+/_/g' )

Also, if you're looking for a batch import dashboard script to go along with this (perhaps you're migrating Grafana servers like I am), I've written a gist based on this one to batch import JSON dashboard files.

Grafana Import Dashboard Gist: https://gist.github.com/thedoc31/628beeee934f9c84648c108d4ad89f05

Wow!!! I was not expecting this kind of engagement from this ;)

Just want to give my two cents on this. I have multiple orgs in Grafana (hence multiple api keys) so I did the following modifications to the scripts above to backup dashboards for each org.

# Declare a list with the api keys using as a prefix the organization name plus "_" character
declare -a StringArray=("MAIN_<api-key>" "OtherOrg_<api-key>" "YetOnAnother_<api-key>")

# Iterate through api keys:
for API_KEY in "${StringArray[@]}"; do
    ORG=$(echo $API_KEY | cut -d "_" -f1) # Name of the organization based on the prefix
    KEY=$(echo $API_KEY | cut -d "_" -f2) # API Key for that organization after removing the prefix

    # Iterate through dashboards using the current API Key
    for dashboard_uid in $(curl -sS -H "Authorization: Bearer $KEY" $HOST/api/search\?query\=\& | jq -r '.[] | select( .type | contains("dash-db")) | .uid'); do

        url=`echo $HOST/api/dashboards/uid/$dashboard_uid | tr -d '\r'`
        dashboard_json=$(curl -sS -H "Authorization: Bearer $KEY" $url)
        dashboard_title=$(echo $dashboard_json | jq -r '.dashboard | .title' | sed -r 's/[ \/]+/_/g' )
        dashboard_version=$(echo $dashboard_json | jq -r '.dashboard | .version')

        # You can export the files like this to keep them organized by organization:
        mkdir -p "$DASH_DIR/dashboards_$ORG"
        echo $dashboard_json > "$DASH_DIR}/dashboards_$ORG/${dashboard_title}_v${dashboard_version}.json"
    done
done

Simple modification of the original script that works with Grafana 6.2.5 (and needs jq):

KEY=
HOST=

mkdir -p dashboards && for dash in $(curl -k -H "Authorization: Bearer $KEY" "$HOST/api/search?query=&" | jq -r '.[] | select(.type == "dash-db") | .uid'); do 
	curl -k -H "Authorization: Bearer $KEY" "$HOST/api/dashboards/uid/$dash" > dashboards/"$dash".json 
done

Improved version which stores the dashboards as pretty JSON (easier to review diffs in git) and renames the files to uid-slug.json so make them easier to identify.

#!/bin/bash

set -o errexit
set -o pipefail

HOST=https://your.host.name

[ -n "$KEY" ] || ( echo "No API key found. Get one from $HOST/org/apikeys and run 'KEY=<API key> $0'"; exit 1)

set -o nounset

echo "Exporting Grafana dashboards from $HOST"
rm -rf dashboards
mkdir -p dashboards
for dash in $(curl -s -H "Authorization: Bearer $KEY" "$HOST/api/search?query=&" | jq -r '.[] | select(.type == "dash-db") | .uid'); do
	curl -s -H "Authorization: Bearer $KEY" "$HOST/api/dashboards/uid/$dash" | jq -r > dashboards/${dash}.json
	slug=$(cat dashboards/${dash}.json | jq -r '.meta.slug')
	mv dashboards/${dash}.json dashboards/${dash}-${slug}.json
done

cut -c 4-

thanks. Working.

mmmm... which script to use :D

hi, I tried the one from @magiconair (this one) which is working pretty well so far,
but I have some issues...

on importing it to another grafana instance (like copypaste content of the exportet .json file on import via GUI)

• all variables are gone
• cant select datasource(s) on import (cause __requires section is missing and )
• and even the title seems to be away on import
  (even though the name is on the bottom of the .json - as title! )

    "timezone": "",
    "title": "My Fancy Dashboard",
    "uid": "tH3uId",
    "variables": {
      "list": []

any suggestions, how to export all dashboards (at once) formatted like the ones you get by clicking "Download JSON" on https://grafana.com/grafana/dashboards ? =P

thanks in advance & best regards :)

fwiw some versions of jq have a "feature" that breaks pipes. If you;re having trouble, make sure you use jq . -r when piping.

Yet another iteration of this idea:

#!/bin/bash

# Usage:
#
# export_grafana_dashboards.sh https://admin:REDACTED@grafana.dedevsecops.com

create_slug () {
  echo "$1" | iconv -t ascii//TRANSLIT | sed -r s/[^a-zA-Z0-9]+/-/g | sed -r s/^-+\|-+$//g | tr A-Z a-z
}

full_url=$1
username=$(echo "${full_url}" | cut -d/ -f 3 | cut -d: -f 1)
base_url=$(echo "${full_url}" | cut -d@ -f 2)
folder=$(create_slug "${username}-${base_url}")

mkdir "${folder}" 
for db_uid in $(curl -s "${full_url}/api/search" | jq -r .[].uid); do
  db_json=$(curl -s "${full_url}/api/dashboards/uid/${db_uid}")
  db_slug=$(echo "${db_json}" | jq -r .meta.slug)
  db_title=$(echo "${db_json}" | jq -r .dashboard.title)
  filename="${folder}/${db_slug}.json"
  echo "Exporting \"${db_title}\" to \"${filename}\"..." 
  echo "${db_json}" | jq -r . > "${filename}"
done
echo "Done"

Can someone patch grafana-cli to export dashboards to a single (as a most simple task) JSON ? :)

Used @magiconair script with a slight modification to use username/password and a fix to the second 'jq' call.
Worked fine with Grafana 6.7.2.
To import the dashboard (one by one) use the import tool from Grafana. Paste everything under the "dashboard" object and delete properties "version" and "uid".

Here's the modified script and a container I ran this into.

#!/bin/bash

set -o errexit
set -o pipefail

HOST="grafana.tools.connected.dyson.cloud"
FULLURL="https://<username>:<password>@$HOST"

set -o nounset

echo "Exporting Grafana dashboards from $HOST"
rm -rf dashboards
mkdir -p dashboards
for dash in $(curl -s "$FULLURL/api/search?query=&" | jq -r '.[] | select(.type == "dash-db") | .uid'); do
        curl -s "$FULLURL/api/dashboards/uid/$dash" | jq -r . > dashboards/${dash}.json
        slug=$(cat dashboards/${dash}.json | jq -r '.meta.slug')
        mv dashboards/${dash}.json dashboards/${dash}-${slug}.json
done

docker run -it -v $(pwd):/myfolder -w "/myfolder" --rm bitnami/minideb bash
install_packages curl ca-certificates jq
chmod +x exportGrafana.sh
./exportGrafana.sh