get-alerts-list-1day.sh

#!/bin/bash

MACKEREL_APIKEY=<YOUR_MACKEREL_APIKEY>
LIMIT=100
DATE_FROM=$(date -d '1 day ago' +%s)

# 一回目
JSON_FIRST=$(
  curl -GsS \
     -X GET \
     -H 'X-Api-Key: '${MACKEREL_APIKEY} \
     -H 'Content-Type: application/json' \
     -d withClosed=true \
     -d limit=${LIMIT} \
     https://api.mackerelio.com/api/v0/alerts
)
TSV_FIRST=$(
  echo "$JSON_FIRST" |
  /usr/bin/jq -r ' .alerts[]|[
    .id,
    .status,
    .monitorId,
    .type,
    .hostId,
    .value,
    .message,
    .reason,
    .openedAt,
    .closedAt
  ] | @tsv'
)
NEXT_ID=$(
echo "$JSON_FIRST" | /usr/bin/jq -r '.nextId'
)

while read LINE
do
  for OPEN_AT in $(echo "$LINE" | cut -f 9);do
    if [[ $DATE_FROM -le $OPEN_AT ]]; then
      echo -e "$(echo "$LINE" | cut -f 1-7)\t$(date -d @$OPEN_AT +"%Y-%m-%d %H:%M:%S")\t$(date -d @$(echo "$LINE" | cut -f 10) +"%Y-%m-%d %H:%M:%S")"
    elif [[ $DATE_FROM -gt $OPEN_AT ]]; then
      exit
    fi
  done
done <<END
$TSV_FIRST
END

# 二回目以降
while :
do
  if [ -z $NEXT_ID ]; then
    break
  fi
  JSON_NEXT=$(
    curl -GsS \
      -X GET \
      -H 'X-Api-Key: '${MACKEREL_APIKEY} \
      -H 'Content-Type: application/json' \
      -d withClosed=true \
      -d limit=${LIMIT} \
      -d nextId=${NEXT_ID} \
      https://api.mackerelio.com/api/v0/alerts
  )
  TSV_NEXT=$(
    echo "$JSON_NEXT" |
    /usr/bin/jq -r ' .alerts[]|[
      .id,
      .status,
      .monitorId,
      .type,
      .hostId,
      .value,
      .message,
      .reason,
      .openedAt,
      .closedAt
    ] | @tsv'
  )
  NEXT_ID=$(
  echo "$JSON_NEXT" | /usr/bin/jq -r '.nextId'
  )
  while read LINE
  do
    for OPEN_AT in $(echo "$LINE" | cut -f 9);do
      if [[ $DATE_FROM -le $OPEN_AT ]]; then
        echo -e "$(echo "$LINE" | cut -f 1-7)\t$(date -d @$OPEN_AT +"%Y-%m-%d %H:%M:%S")\t$(date -d @$(echo "$LINE" | cut -f 10) +"%Y-%m-%d %H:%M:%S")"
      elif [[ $DATE_FROM -gt $OPEN_AT ]]; then
        exit
      fi
    done
  done <<END
  $TSV_NEXT
END
done