Ignore records with Null username coming through JAMF connector

Prashant62 · ‎05-25-2026

We have an existing implementation of ServiceGraph connector for JAMF in our environment and we are trying to restrict the jamf records that are coming with empty Username values.
As the ServiceGraph uses robust transform, I am looking for a way to achieve this.
Any help on this is highly appreciated.

Yogesh11bhatt · ‎05-25-2026

Hi @Prashant62 ,

The best practice for Service Graph Connectors is to handle this using the built-in conditional logic in IntegrationHub ETL—no scripting required.

Navigate to IntegrationHub ETL in your ServiceNow instance.
Open your Service Graph Connector for JAMF ETL definition.
Go to Step 3: CMDB Classes to Map.
Locate the specific CI Class you want to prevent from being created (e.g., the User or Computer class).
Click the Condition icon (it looks like a funnel/filter) next to that class.
Set the condition to only run if the username is present. For example:
- [Username] is not empty
Save and activate your ETL definition.

By doing this, the Robust Transform Engine will process the incoming JAMF payload but will simply skip creating or updating that specific record if the username value is missing.

The Low-Code Alternative: RTE Script Operation

If your requirement is strictly to drop the entire row of data before it even reaches the mapping phase, you can flag it in the preparation stage:

In IntegrationHub ETL, go to Step 2: Preview and Prepare Data.
Click Add Operation and select Script Operation.
Pass your incoming JAMF Username column as the input variable (e.g., jamf_user).

Write a simple return script:

JavaScript

if (jamf_user === '' || jamf_user === null || jamf_user === undefined) {
    return false; 
}
return true;

Map the output of this script to a new custom column called Has_Username.
Go to Step 3: CMDB Classes to Map, click the filter icon on your main classes, and set the condition to: [Has_Username] is true.

Bottom Line: Discard the legacy onBefore script you found online. Use IntegrationHub ETL conditions to filter out the empty values safely and correctly.

Please mark this response as helpful if it guided you in the right direction.

Regards,

View solution in original post

Prashant62 · ‎05-28-2026

I have edited the conditional logic from the RTE entity mapping and it worked.