Ended up opening a case with Commvault suport. I was told there is no endpoint to get the details I was looking for. Instead they provided me with the qcommand to extract the same info. This works perfectly.
qoperation execscript -sn QS_AuxCopyReport
Job details seems to have the same info which I totally overlooked. I plan to use the qcommand for my script