Unable to update the incident State to "Closed" or "Resolved" from any previous State

[SN_2023]

Hi,

I am able to "GET" the incident from servicenow to Excel 2019 VBA through REST API. But I am facing some difficulties in doing vice-versa i.e. Update the servicenow incident using REST API's "PATCH" method. I was able to update the "state" of the INCIDENT from "New " (1) to "In Progress" (2) or "On Hold" (3). Also I was able to update other fields such as "Work Notes", "Resolution Code", "Close notes", etc. But was not able to update the "state" of the "Incident" to "Resolved" (4) or "Closed" (5). When I tried to update the "State" to "Resolved" (4) or "Closed" (5), I filled the following fields:

"Work Notes", "Resolution Code", "Close notes", "Closed by", "Closed At"

Did I miss something? Please help me to resolve the issue.

Most Important:

Also I would like to update the servicenow incidents from excel VBA.

Any help would be highly appreciated?

OS: MS Windows 64 bit

Browser: Bravo

Thank you

[SN_2023]

Now I am able to do update even from excel 2019 VBA directly using REST API.