Service Graph Connector - Avoid empty lookup items in the IRE payload

[Palani Chockali]

If the record being processed is partial and if it has an empty lookup, then IRE will not de-duplicate the empty lookups and will continue to accumulate them until the payload size becomes too large to hold in memory safely and could lead to potential IRE issues. As a result, the integration may not function correctly due to this issue.

IRE team has fixed this empty item lookup payload issue in SD and it is also in the process of back-porting to Rome. Also, note that IH-ETL (mapping tool) does not show this conditional check as visible during mapping which is also being fixed. To avoid empty lookup items in the payload, follow this workaround until the IRE fix is in place:

Note:
We will be modifying the Serial Number lookup done within ‘SG-Intune Devices’ data source as an example. But the steps will be similar for lookups in other SG Connectors as well.

1. Type ‘Intune’ on the nav and choose ‘Data Sources’
2. Click on the SG-Intune Devices data source
3. Click on the ‘Robust Transformer’ tab
4. Click on the ‘SG-Intune Devices’ Transformer definition
5. Click on the ‘RTE Entity Mappings’ tab
6. Click on the ‘tempToSerialNumber_1’ Temp entity mapping
7. Check the ‘IsConditional’
8. Add the following code to the ‘Condition Script’

   (function() {
    if (((input.temp.u_serialnumber))) {
        return true;
    }
    return false;
})();

9.  Add the column ‘Encoded Query’ if it is not shown on the form
10. Add the following encoded query
      u_serialnumberISNOTEMPTY

11. Update/Save the record 

References:

Please see this blog post which is specific to Jamf where the printer information comes in empty and getting in to partial payloads table and how to resolve it
https://community.servicenow.com/community?id=community_article&sys_id=bfbba5c9db9845d03dd13ca8f4961...