NodeJS: trackDependency does not store "data" field

[philippreissing]

I'm trying to use the method trackDependency() to track custom dependencies in a NodeJS backend.
I create a custom object and save it like this:

    const message = {
      name: 'query',
      resultCode: error ? error.response.sqlState ?? 'error' : 0,
      data: 'test', //sql.toString().trim(),
      dependencyTypeName: 'Databricks',
      duration: duration,
      success: !error,
    };
    console.log(message);
    appInsights.defaultClient.trackDependency(message); 

Here's how the message looks like (data is hardcoded for testing):

{
  name: 'query',
  resultCode: 0,
  data: 'test',
  dependencyTypeName: 'Databricks',
  duration: 1455.913166999817,
  success: true
}

The event gets saved in log analytics, but the data field always stays empty.

I'm using Node JS 18.15.0 with applicationinsights 3.1.0

[philippreissing]

Ok, I found the problem. The library checks if the depency is of SQL type and only then stores the data field.

ApplicationInsights-node.js/src/shared/util/util.ts

Line 100 in 6e0b8d3

dependencyType.indexOf("SQL") > -1 ||

That feels a bit limiting - why should I not be able to also use the data field in other dependencies?

Anyway, I could solve this by renaming my dependency type to Databricks SQL instead.

[JacksonWeber]

@philippreissing The logic here is to check for the dependency type being a database call in which case we would collect the data field in an auto-collection scenario as well. Is there a requirement on your side to specifically collect the data field here?