CMDB data integration using Integration HUB ETL through import set API

LaxmiPrasanna P
Tera Contributor

‎02-28-2024 08:19 AM

Hello Everyone,

We are working on integrating CMDB Data from third-party application to Service Now via Import Set API. We used Integration HUB ETL UI to generate Robust Transformer for this data transfer. When we try to load the data from third-party application to Service Now using Import Set API (https://xxxxxxxxxx.service-now.com/api/now/import/u_staging_table), Robust transformer is able to insert/update the data into CMDB, instead we are getting below the response.

 

"import_set": "ISET0129529",
    "staging_table": "u_cbo_terraform",
    "result": [
        {
            "transform_map": "",
            "status": "error",
            "error_message": "Invalid table ",
            "status_message": "{\"cmdb_ci_service_technical\":{\"unchanged\":1},\"cmdb_ci_win_server\":{\"inserted\":1},\"cmdb_rel_ci\":{\"inserted\":2},\"cmdb_ci_service_auto\":{\"unchanged\":1}}"
        }
    ]
}


Can any one of you help why the error message displays as "Invalid table" though it's a valid table and data is being transformed to CMDB table. Really appreciate all your help with this.

 
Thank you!
Preview file
148 KB
0 Helpfuls
  • 563 Views
1 REPLY 1

AJ-TechTrek
Giga Sage
Giga Sage

‎02-29-2024 06:37 AM

Hi @LaxmiPrasanna P ,

 

Did you run the transform map ?

Are your fields mapped properly (check for field types)

Is the file getting attached to the data source before the transform begins. Can you check the import set table whether the data is loaded into this table worked or not ?

Make sure the loaded file header contains right info as needed ?

 

Also there are couple of solved articles available, refer those.

 

https://www.servicenow.com/community/itsm-forum/quot-import-set-not-created-invalid-target-table-quo...

 

https://www.servicenow.com/community/developer-forum/quot-import-set-not-created-invalid-target-tabl...

 

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

 

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

0 Helpfuls