Import 3rd party data into CMDB via Flow Designer and IRE

Kenneth3
Tera Guru

Hi,

I want to import hardware data from a 3rd party and import that into the CMDB (cmdb_ci_computer) table of ServiceNow. For this I am using IntegrationHub in Flow Designer. I have created a REST call to the 3rd party application and used the JSON parser to parse the incoming data. The challenge for me now is to really import and transform the data to the target table (cmdb_ci_computer). I have read that the best approach is to use the IRE (Identification and Reconciliation) module. Does anyone have done this already or give me some best practices how to do this within Flow Designer?

find_real_file.png

Thanks in advance.

7 REPLIES 7

Hi @Chris

I think you can use the "Name/Values" input type available in the "Action Input" [screenshot for reference]

Sails_0-1667822287826.png

 

Sails
ServiceNow Consultant
United Kingdom

Nishu Saini
Kilo Guru
Kilo Guru
Hi, I believe it can be done using transform map in flow designer. Refer to the below thread it may help you. https://community.servicenow.com/community?id=community_question&sys_id=655c86b9db10d0501cd8a345ca9619ed

Shreya Shah
ServiceNow Employee
ServiceNow Employee

You can use "Create Record" or "Update Record" and select "Computer [cmdb_ci_computer]" and fields accordingly. Flow Designer allows transform functions if you want to do it via Flow Designer.

You can check out Integration Hub Import - https://docs.servicenow.com/bundle/rome-servicenow-platform/page/administer/integrationhub/concept/integrationhub-imports.html to run ETL.