hetzner invoices

import.sh

#!/usr/bin/env bash

# Put all your Hetzner invoices in a 'pdf' directory and keep the original name.

for filename in pdf/*.pdf; do
  date="$(date -d "$(sed 's,.*_\(.*\)_.*,\1,' <<< "${filename})")" '+%s000000000')"
  value="$(pdftotext "${filename}" - | grep -A 2 Brutto | tail -n 1 | sed "s;\([0-9]*\),\([0-9]*\).*€;\1.\2;")"
  payload="invoice value=${value} ${date}"
  curl -i -XPOST 'http://127.0.0.1:8086/write?db=hetzner' --data-binary "${payload}"
done