Answer
Check two things for the service account specifically: that the SQL_TRACE system parameter is turned on, and that the DEBUGGER system privilege is granted to that service account — trace output for odata-debug=json depends on both, and a service/integration account commonly doesn't have DEBUGGER granted by default the way an administrator's interactive account might, which silently suppresses the detailed trace even though the call itself succeeds or fails normally.