API for Creating Business Application to CMDB_CI Relationship

[andrewwade]

I am working with access to the WebServices REST/SOAP api for our Service Now platform.

Currently, I am creating CI's and now want to be able to link them to a Business Application (BAPPxxx).

The mapping is similar to the following:

u_cmdb_ci_business_app   -> Business Application (predefined)

u_cmdb_ci_business_enviro -> Business Application Enviornment (Prod, QA, Dev, etc.)

u_enviro_rel_instance   -> Maps the Business Application Environment to the cmdb_ci_appl

u_cmdb_ci_appl -> the CI Application   (ex.   Linux Red Hat@servername)

u_cmdb_ci_linux/windows -> the CI for linux or windows.

Now, in terms of the API, I'm not seeing the ability to do inserts

a)   into the u_cmdb_ci_appl   table to create the CI Application

b)   into the u_enviro_rel_instance to create the link between that CI Application and a predefined u_cmdb_ci_business_enviro

Also, I'm not seeing a getRecords query that returns all the associations (the parent/child) in the u_enviro_rel_instance and u_cmdb_ci_business_enviro   tables when I query a specific sys_id for the table.

Is it possible to do this query through the API?     Also, is it possible to update the tables via the API to create new parent child relationships?

[joshua_bice]

Have you set up import tables and transform maps for these tables?

[andrewwade]

Currently, we don't have any import tables or transfom maps set up for those tables.

I have requested them for some other tables and understand how they work.   I just wanted to make sure conceptually, that if I requested my admins to create those import tables and transform maps that I could update those tables with the proper entries through the API exposed fields rather than have to use Glide.

[joshua_bice]

Someone else like Know Your Expert | Pradeep Sharma could probably give better insight to this, but my understanding is that you can't change tables with SOAP or REST unless they're specifically an import table.

[tony_barratt]

Hi Joshua,

It could be best practice, in some cases, to use an import set to change or create data in tables, whilst using REST or SOAP.

But you can use REST to carry out create, read, update, and delete operations on existing tables.

Table API - ServiceNow Wiki

or SOAP

Direct Web Services - ServiceNow Wiki

Best Regards

Tony