Queries and returns url for the last created WI

getLastOpenWI.sh

#!/bin/bash

# Execute the SOQL query
QUERY_RESULT=$(sf data query -o carvago-prod --query "SELECT Id FROM sf_devops__Work_Item__c ORDER BY CreatedDate DESC LIMIT 1" --result-format csv)

# Get the record ID from the result. We select the second line (actual data) and then cut by ',' to get the ID.
RECORD_ID=$(echo "$QUERY_RESULT" | awk 'NR==2' | cut -d',' -f2)

# Form the URL
URL="https://carvago.lightning.force.com/sf_devops/DevOpsCenter.app?workItemId=$RECORD_ID"
echo $URL