ermrefdata-get

#!/usr/bin/bash
auth 2>/dev/null || authn 2>/dev/null
tenant=$(cat tenant)
okapi_url=$(cat okapi.url)
okapi_token=$(cat okapi.token)

echo "------------- Agreements Supplementary Properties -------------"
apicall=$(curl -s -w '\n' -X GET -H "Accept: application/json" -H "X-Okapi-Tenant: ${tenant}" -H "x-okapi-token: ${okapi_token}" "${okapi_url}/erm/custprops?max=1000")
echo "${apicall}" | jq -r '.[] |[.name, ([ .category.desc, .category.values[]?.value ] |join(";") ) ] | @tsv' 
echo

echo "------------- Agreements Picklist Values -------------"
apicall=$(curl -s -w '\n' -X GET -H "Accept: application/json" -H "X-Okapi-Tenant: ${tenant}" -H "x-okapi-token: ${okapi_token}" "${okapi_url}/erm/refdata?sort=asc&max=1000")
echo "${apicall}" | jq -r '.[] | [.desc, ([.values[]?.value ] |join(";")) ] |@tsv'
echo 

echo "------------- License Terms -------------"
apicall=$(curl -s -w '\n' -X GET -H "Accept: application/json" -H "X-Okapi-Tenant: ${tenant}" -H "x-okapi-token: ${okapi_token}" "${okapi_url}/licenses/custprops")
echo "${apicall}" | jq -r '.[] |[.name, .description, ([ .category.values[]?.value ] |join(";") ) ] | @tsv' 
echo

echo "------------- License Picklist Values -------------"
apicall=$(curl -s -w '\n' -X GET -H "Accept: application/json" -H "X-Okapi-Tenant: ${tenant}" -H "x-okapi-token: ${okapi_token}" ${okapi_url}/licenses/refdata&max=1000)
echo "$apicall" | jq -r '.[] |[.desc, ([(.values[] | .value)] | join(";"))] | @tsv'