Error: "Invalid number of rows(0) affected by the operation. Expecting (1)" When consuming SDM REST API

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

Error: "Invalid number of rows(0) affected by the operation. Expecting (1)" when trying to change status through REST

Cause

ID being used in the URL is not correct

Environment

Release : 17.2

Component : REST API

Resolution

The id 7076291 (Ticket ID, ref_num) being used is incorrect. In this field, the internal ID must be used, not the ref_num, which is the external ID. To get the correct id you can run:

select id from call_req where ref_num='<external ID>';

Additional Information

REST HTTP Methods