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

[midjoule]

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]

1. I'm wondering why the computer CI wouldn't be in the CMDB. 

2. In your data, is there a way to determine if the computer is in the CMDB or not ?

3. If not, I would suggest managing it through a "on Before insert" business rule on the Disk table: if there is no CI related to the disk, then abort the operation. Unfortunately, I'm don't see other option in the IntegrationHub ETL.

[Taniya Pal]

Yes, we have a ID, with that we can glide in table and check what's the class

[midjoule]

Hi Taniya,

Is your issue resolved ? Should it be the case, could you please close it (mark as correct)? Otherwise, please explain where you are stuck.

Best regards

[VaranAwesomenow]

You can implement this in 3 ways

1. Implement on before script

    gliderecordusing key field from source / target -> if found

        //status = 'SKIPPED';

        or

        //ignore = true;

2. Implement on after script

    On after can access target Object, so you can run a set query to check if its a valid record or not and do a delete.

3. Write a post import script on scheduled import that will do the delete