IntegrationHub - How to prevent a record from being inserted (ignore = true)

midjoule · ‎06-19-2020

Hello experts,

I've setup an ETL throught IntegrationHub and I'm wondering how I can ignore records with specific attributes.

The support documentation proposes this script, slightly enhanced to match our requirement (in yellow). However, it doesn't work:

 (function(batch, output) { 
                for (var i = 0; i < batch.length; i++) { 
                        var in0 = gs.nil(batch[i].input) ? '' : batch[i].input; 
                        output[i] = in0 + " modified by script”;

//do not import if the value of the field attribute = 'ABC'
if (batch[i].attribute = 'ABC')
   batch[i].ignore = true
 
                    } 
                } 
            })(batch, output);

How could I achieve this ? Is there any additional supporting documentation in regards to scripting within the IntegrationHub ?

midjoule · ‎06-19-2020

Thank you Andrew for the proposal. Unfortunately it didn't resolve the issue.

In fact, we managed it without using any script, which is good. In fact there is a condition builder which supports our requirement:

Click the button Edit Class
In our case, we want to exclude records were both LNX and @@@ vendor_monitor are set (value is not LNX and value is not @@@)
As the else condition remains empty, the class is not set.

Here is the screenshot:

Even if we found the solution, I would still be interested to know more about the methods available in the batch and output variables, and especially on how to ignore a record by script. If anyone has a proposal, please write it here.

Best regards

View solution in original post

Long6 · ‎03-18-2021

Thanks midjoule, but I only have Robust Transform Map coming with the Service Graph Connector for SCCM, Integrationhub ETL is not activated, the only thing I have is to use your proposed script, but it's not working right now.

midjoule · ‎03-18-2021

I would strongly suggest installing the IntegrationHub ETL, because the Service Graph Connector for SCCM is made to work with it. It's quite difficult to understand all the links behind the Robust Transform Maps. IntegrationHub ETL plays the interface role, making it easy to transform the data.

If you can't work with the IntegrationHub ETL, then I would suggest not using Service Graph Connector for SCCM, but better use the previous way to retrieve data from SCCM, through normal Transform Maps. You can find the plugins under this id : com.snc.integration.sccm

Taniya Pal · ‎12-23-2021

We have a similar kind of requirement. We want to ignore a row if a disk is not related with the computer available in system through robust transformer.

kindly let us know if you have the solution

midjoule · ‎12-23-2021

Hi Taniya,

You should be able to perform this throught the "Edit Class", as explained here above.

If not, please send a screenshot of what you tried and I'll have a look.

Best regards

Taniya Pal · ‎12-23-2021

No, conditional class is not working. the requirement is, if there is a CI present with computer class, disk will insert. Otherwise it's not, the row will be ignored.