How to send the API body in a MSXML2.XMLHTTP60 patch call

[steveotis]

All,
I've successfully used the code below to place some GET API calls to my companies contracted CMS platform.
I'm now trying to do the same for a patch call. See images below, the patch call requires a "BODY" that a GET call does not.
I'm not sure how to put this in my VBA code. I expect it's something like "req.Open(body)" where BODY is some concated string of my body values
but I can't find a solid example to work off of:

This is my POSTMAN call and it works fine:

This is what I normally send for a GET request (except "PATCH" is "GET") and it works fine. I now need to know how to put the above body into the code below.
The URL is normally very simple for a get request but I guess the body details cannot be added to the end of the URL.

 

[John_w]

The Send method has an optional argument for the request body:

req.Send ("{""properties"":{...the rest of the request body ...")

Note the use of 2 consecutive double quotes to get 1 double quote within the body string.

 

[steveotis]

Great thank you. This is what I wound up doing and I also seemed to need this line req.setRequestHeader "content-Type", "application/json" or I was getting an error.