How to test 'Integration' after adding new field into staging table & Target table

[Obito]

Hi All,

We have one import set table which creates record in Catalog Item table, We are planning to change source from where the data is being sent to 'staging table'. Also added new 'ID' field which is not mandatory.

--Before replying to my question please consider below points.

1) Even after changing the source, fields name we have kept same. 

2) Primary fields are also same.

So, how can we test newly created catalog item other than by creating request manually.

Thanks,

[Rajdeep Ganguly · Accepted solution]

Sure, you can test the newly created catalog item in several ways other than manually creating a request. Here are some steps you can follow:

1. **Automated Testing Framework (ATF)**: ServiceNow provides an Automated Testing Framework that you can use to create and run automated test cases for your applications and configurations on your ServiceNow instance. You can create a test case for the new catalog item and run it to ensure it's working as expected.

2. **Direct Table Entry**: You can directly create a record in the Catalog Item table (sc_cat_item) using the new ID field. This can be done either through the ServiceNow UI or through a script.

3. **REST API**: ServiceNow provides REST APIs that you can use to create, read, update, and delete records. You can use the Table API to create a new catalog item and then retrieve it to ensure it was created successfully.

4. **Import Set**: Since you're already using an import set, you can create a test import set with a few records that use the new ID field. Run the import and then check the Catalog Item table to ensure the records were created successfully.

5. **Scripting**: You can write a script to create a new catalog item and then retrieve it. This can be done in a background script, a script include, or a business rule.

Remember to test in a sub-production instance first before moving to production.

nowKB.com

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.
Link - https://nowgpt.ai/

For the ServiceNow Certified System Administrator exams try this :
https://www.udemy.com/course/servicenow-csa-admin-certification-exam-2023/?couponCode=NOW-DEVELOPER