GitHub issues to tsv

curl_GitHub_issues_with_jq.sh

OWNER=masaki925
REPO=repo

# ref: https://github.com/settings/tokens
TOKEN=<TOKEN>

# ref: https://docs.github.com/en/rest/issues/issues#list-repository-issues
#
curl \
  -H "Accept: application/vnd.github+json" \
  -H "Authorization: Bearer ${TOKEN}" \
  "https://api.github.com/repos/${OWNER}/${REPO}/issues?per_page=100&labels=Data+Product&state=open" | \
  jq ".[] | {title: .title, url: .html_url}"

json_to_tsv

import json
from pandas import json_normalize

with open('issues.json') as f:
    json_str = f.read()

data = json.loads(json_str)
df = json_normalize(data)

df.to_csv('issues.tsv', sep="\t")