Planify converter from JSON backup file to markdown

planify-json-export.jq

.projects as $p 
| .sections as $s 
| .items 
| map(select(.completed_at == ""))
| group_by(.project_id)
| map([
    "# \(.[0].project_id as $id | $p | map(select(.id == $id))[0].name)",
    (group_by(.section_id) |
        map(
            [
                "## \(.[0].section_id as $id | $s | (map(select($id == .id))[0] // {name: "No Section"}).name)", 
                (map("### \(.content)\n\(.description)\n\n[due::\(.due | fromjson | .date)]") | join("\n\n"))
            ] | join("\n")
        ) | join("\n\n")
    )] | join("\n")
    ) | join("\n\n")

planify-json-export.sh

#!/usr/bin/env bash
set -euxo pipefail

jq -rf ./planify-json-export.jq "$1" | nvim +'set ft=markdown buftype=nofile'