How to call IRE in integration hub ETL

Mark Wood
Tera Contributor

Hello Experts,

I am trying to import the below data to the target table to avoid duplicates I have configured the identification and reconciliation rule. Now my requirement is to call the IRE rule using the integration hub ETL How can I achieve this please guide me thank you.

2 REPLIES 2

sumanta pal
Kilo Guru

To call the Identification and Reconciliation (IRE) rule using the Integration Hub ETL, you can follow the steps below:

1. **Create a Flow Designer Flow:**
- Navigate to Flow Designer in ServiceNow.
- Click on New -> Flow.
- Give a name to the flow and click on Submit.

2. **Add an Action to the Flow:**
- Click on the '+' icon to add an action.
- Select the 'Run Script' action.
- In the script, you can call the IRE API to execute the rule.

3. **Script to Call IRE API:**
- The script to call the IRE API can be something like this:

javascript
(function run() {
var gr = new GlideRecord('your_table_name');
gr.query();
while (gr.next()) {
var ire = new SNC.IdentificationEngine();
var result = ire.process('your_table_name', gr.sys_id);
}
})();

- Replace 'your_table_name' with the name of your table.
- This script will run the IRE rule for each record in the table.

4. **Configure Integration Hub ETL to Call the Flow:**
- Navigate to Integration Hub ETL.
- Configure the ETL to call the flow you created.
- You can do this by adding a 'Run Flow' action in the ETL and selecting the flow.

5. **Test the ETL:**
- Run the ETL to test if the IRE rule is being called correctly.
- Check the target table to see if duplicates are being avoided.

Please note that you need to have the correct roles to access Flow Designer, Integration Hub ETL, and to run scripts. Also, the IRE API is available starting from the Kingston release of ServiceNow.

For asking ServiceNow-related questions try this :

For a better and more optimistic result, please visit this website. It uses a Chat Generative Pre-Trained Transformer ( GPT ) technology for solving ServiceNow-related issues.

Please visit : https://nowkb.com/home
Our Website :https://nowkb.com/home
Link - https://nowgpt.ai/

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Mark Wood 

 

Might be helpful

 

https://www.youtube.com/watch?v=2tVLhE_OwOE

https://docs.servicenow.com/bundle/vancouver-servicenow-platform/page/product/configuration-manageme...

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
Mark Harper and Robert Geen of GlideFast Consulting give an overview and demo on how to boost CMDB data quality with IntegrationHub (IH) ETL in ServiceNow. Use the IntegrationHub ETL store app to create and manage ETL transform maps, which integrate third-party data into the CMDB without ...