Is there a way to set custom property values from your groovy script in your datasource?

Yeah, that creates a string. In your working example, you create a map, not a string. Remove the single quotes from around the headers when you define it.

Don’t beat yourself up. Your mind was obviously working on the more difficult problems that you’ve still to surmount.

FWIW: I just had a similar boneheaded moment with LM Support. I had an LM Logs pipeline alert setup, but it wasn’t triggering the alert because I had left it disabled.

Aaaaanyway, the body would simply be the stuff you want to update. Doing a PATCH to:

{{url}}/device/devices/:deviceid/devicedatasources/:hdsid/instances/:instanceid?opType=replace

With a body like this:

{
    "customProperties": [{"name": "test.property", "value": "testvalue"}]
}

I was able to patch my instance. If you wanted multiple properties patched:

{
    "customProperties": [
        {"name": "test.property", "value": "testvalue"},
        {"name": "test.property2", "value": "testvalue2"}
    ]
}

These are obviously the JSON equivalents of the Groovy map you might be using to construct the json.

I can’t remember what type of object should be passed in with the patch, but it seems like it wants a map. Try not converting it to json first.

Well, your payload needs adjusting. Needs to be a list of maps:

def payload = [[name:"description", value:"New York"]]

This is what the .patch() method got as its arguments:

(org.codehaus.groovy.runtime.GStringImpl, groovy.json.internal.LazyMap, java.util.LinkedHashMap)

It would seem that the second argument (which is your payload?) is a LazyMap but needs to be json. The error message gives a ton of useless information, but doesn’t get far enough to tell you what type of object needs to be passed in as the payload. I’m guessing string. Here’s how you convert an array/map to json:

import groovy.json.*
payload = [["name": "description", "value": "New York"]]
jsonPayload = JsonOutput.toJson(payload)
println(jsonPayload.getClass())

Remember, the http client object is part of the santaba library (LM code), so IMO should be supported by LM. I’d push them in chat for help getting it working.

If your experience with the chat queue is like mine, you’ll have an hour or so to get it working while you’re waiting. How else would I have the time to be on the community as much as I am? 

import javax.crypto.Mac
import javax.crypto.spec.SecretKeySpec
import org.apache.commons.codec.binary.Hex

def generate_headers(id, key, path, data, verb) {
  // Create encryption signature for authorization request
  // data should be a json string (not a map)
  try {
    Long epoch_time = System.currentTimeMillis()
    Mac hmac = Mac.getInstance("HmacSHA256")
    hmac.init(new SecretKeySpec(key.getBytes(), "HmacSHA256"))
    signature = Hex.encodeHexString(hmac.doFinal("${verb}${epoch_time}${data}${path}".getBytes())).bytes.encodeBase64()
    return ["Authorization": "LMv1 $id:$signature:$epoch_time", "Content-Type": "application/json"]
  } catch (Exception err) {println("ERROR: Unable to establish encryption for $path.\n${err.message}")}
}

I think this works. When I tested it with the wrong verb, i got a 401 (auth fail). When i tested it with the right verb, i got a 403 (permission denied) (because the api creds i used are RO). I think that means i did get authenticated, but my creds don’t have permission. I did finally find this, which would probably work too; but do me a favor and see if the function above works.

I got hit with an auth failure as well.  I made sure its pulling the proper id and key.  I tried seeing if anything was amiss myself but im coming up blank  

Also I made sure data was in json string format and not a map or object or anything else.  

As a brief follow up.  I made a clone of the datasource to see if that one would show up with this get

{{url}}/device/devices/{id}/devicedatasources/

Turns out with device “A” I did fine my clone in the list

however device “B” does not show it. 

I verified both devices had the datasource in question by checking my resources tab in the UI

Be careful with that. Postman corrects errors like encoding spaces and quote marks. In groovy, you’ll need to escape the double quotes.

/device/devices/{deviceId}/devicedatasources?filter=dataSourceName:\”Microsoft_SQLServer_GlobalPerformance\”&fields=id,dataSourceName

When all else fails, output your URL after creating it in groovy to make sure it looks right.

Now I’m getting an authentication failed when i add in the filter elements.  Why is groovy so mean to me? LOL

It’s in Groovy’s nature. It’s why it’s not a very popular language outside very specific circles.