(Excel) MYOB: Update a Category

Sends a PUT to update a category.

For more information, see https://accountrightapi.myob.cloud/?version=latest#c4d0013b-79c4-40ff-af0f-0d9c4b192a71

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' Implements the following CURL command:

' curl --request PUT "https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/{{category_id}}" \
'   --header "Authorization: Bearer ACCESS_TOKEN" \
'   --header "x-myobapi-key: This is your API Key" \
'   --header "x-myobapi-version: v2" \
'   --header "Accept-Encoding: gzip,deflate" \
'   --data "{
'             \"UID\": \"20b483b2-9a89-4793-b8c3-2da1a6284e1f\",
'             \"DisplayID\": \"Postman001\",
'             \"Name\": \"Postman sample\",
'             \"Description\": \"This has been updated via Postman\",
'             \"IsActive\": true,
'             \"RowVersion\": \"-8858580467037765632\"
'         }"

' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON

' The following JSON is sent in the request body.

' {
'   "UID": "20b483b2-9a89-4793-b8c3-2da1a6284e1f",
'   "DisplayID": "Postman001",
'   "Name": "Postman sample",
'   "Description": "This has been updated via Postman",
'   "IsActive": true,
'   "RowVersion": "-8858580467037765632"
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.UpdateString("UID","20b483b2-9a89-4793-b8c3-2da1a6284e1f")
success = json.UpdateString("DisplayID","Postman001")
success = json.UpdateString("Name","Postman sample")
success = json.UpdateString("Description","This has been updated via Postman")
success = json.UpdateBool("IsActive",True)
success = json.UpdateString("RowVersion","-8858580467037765632")

http.SetRequestHeader "Authorization","Bearer ACCESS_TOKEN"
http.SetRequestHeader "x-myobapi-key","This is your API Key"
http.SetRequestHeader "Accept-Encoding","gzip,deflate"
http.SetRequestHeader "x-myobapi-version","v2"

Dim sbRequestBody As Chilkat.StringBuilder
Set sbRequestBody = Chilkat.NewStringBuilder
success = json.EmitSb(sbRequestBody)


Set resp = http.PTextSb("PUT","https://ar1.api.myob.com/accountright/c06778dd-4371-4a83-975f-522df65d7574/GeneralLedger/Category/{{category_id}}",sbRequestBody,"utf-8","application/json",False,False)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = "; respStatusCode
If (respStatusCode <> 200) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Response Body:"
    Debug.Print resp.BodyStr
    Debug.Print "Failed."

    Exit Sub
End If

Debug.Print "Success."