kusto-v1-json-to-csv

kusto-v1-json-to-csv

#!/bin/bash

# This is free and unencumbered software released into the public domain.
#
# Anyone is free to copy, modify, publish, use, compile, sell, or
# distribute this software, either in source code form or as a compiled
# binary, for any purpose, commercial or non-commercial, and by any
# means.
#
# In jurisdictions that recognize copyright laws, the author or authors
# of this software dedicate any and all copyright interest in the
# software to the public domain. We make this dedication for the benefit
# of the public at large and to the detriment of our heirs and
# successors. We intend this dedication to be an overt act of
# relinquishment in perpetuity of all present and future rights to this
# software under copyright law.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
# IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR
# OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
# ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR
# OTHER DEALINGS IN THE SOFTWARE.
#
# For more information, please refer to <https://unlicense.org>

# Kusto REST API query/management (/v1/rest/query, /v1/rest/mgmt) response converter from json to csv
# https://docs.microsoft.com/en-us/azure/data-explorer/kusto/api/rest/
# https://docs.microsoft.com/en-us/azure/data-explorer/kusto/api/rest/response

# usage: command-that-prints-kusto-v1-response | ./kusto-v1-json-to-csv
# usage: ./kusto-v1-json-to-csv file-with-kusto-v1-response

if [[ -z "$1" ]] || [[ "$1" == "-" ]]; then
  FILE="/dev/stdin"
else
  FILE="$1"
fi

STDIN=$(<"$FILE")
jq -r '[ .Tables[0].Columns[].ColumnName ] | @csv' <<<"$STDIN"
jq -r '.Tables[0].Rows[] | map(. | @text) | @csv' <<<"$STDIN"

# https://gist.github.com/180254/0341d60b198b06f995d3da91e02c8bc2