Updating and Deleting Locations in cmn_location Table

[boomsfib]

Good Afternoon everyone.

I'm running into an issue where I am unable to use the configuration_item module to update or delete Locations in the cmn_location table. I am able to create them. And in fact, I'm able to create multiple with same name (though that's neither here nor there)

However when trying to update a Location, i get a failed message that no cmdb_ci records match the sys_id that I provided.

Error Message
Failed: localhost No cmdb_ci records match the {'sys_id': '960a308edb7ae150dec34a6c1396193b', 'sysparm_exclude_reference_link': 'true', 'sysparm_limit': 1000} query.

Playbook

- name: Check ServiceNow
  servicenow.itsm.configuration_item_info:
    instance:
      host: "{{ tbservicenow.sn_instance }}"
      username: "{{ tbservicenow.sn_username }}"
      password: "{{ tbservicenow.sn_password }}"
    name: "{{ data['name'] }}"
    sys_class_name: cmn_location
  register: snow_site_results

- name: ServiceNow Retire Location
  servicenow.itsm.configuration_item:
    instance:
      host: "{{ tbservicenow.sn_instance }}"
      username: "{{ tbservicenow.sn_username }}"
      password: "{{ tbservicenow.sn_password }}"
    sys_class_name: cmn_location
    name: "{{ data['name'] }}"
    sys_id: "{{ snow_site_results['records'][0]['sys_id'] }}"
    other:
      u_operational_status: "{{ data['status']['value'] | snow_location_status_filter }}"
  delegate_to: localhost

Results of the first task to Check ServiceNow for Location

---                                                                                                                                                                                                                              
duration: 2.11524                                                                                                                                                                                                                
end: '2023-05-15T19:31:18.209339'                                                                                                                                                                                                
event_loop: null                                                                                                                                                                                                                 
host: localhost                                                                                                                                                                                                                  
play: Network Inventory Management                                                                                                                                                                                     
play_pattern: localhost                                                                                                                                                                                                          
playbook: inventory_mgmt.yml                                                                                                                                                          ▒
remote_addr: 127.0.0.1                                                                                                                                                                                                           
res:                                                                                                                                                                                                                             
  _ansible_no_log: null                                                                                                                                                                                                          
  changed: false                                                                                                                                                                                                                 
  invocation:                                                                                                                                                                                                                    
    module_args:                                                                                                                                                                                                                 
      configuration_item_mapping: null                                                                                                                                                                                           
      instance:                                                                                                                                                                                                                  
        client_id: null                                                                                                                                                                                                          
        client_secret: null                                                                                                                                                                                                       
        grant_type: password                                                                                                                                                                                                      
        host: <host>                                                                                                                                                                                
        password: VALUE_SPECIFIED_IN_NO_LOG_PARAMETER                                                                                                                                                                             
        refresh_token: null                                                                                                                                                                                                       
        timeout: null                                                                                                                                                                                                             
        username: ansible_api                                                                                                                                                                                                     
      name: Test                                                                                                                                                                                                           
      query: null                                                                                                                                                                                                                 
      sys_class_name: cmn_location                                                                                                                                                                                                
      sys_id: null                                                                                                                                                                                                                
      sysparm_display_value: 'false'                                                                                                                                                                                              
      sysparm_query: null                                                                                                                                                                                                                           
  records:                                                                                                                                                                                                                       
  - attachments: []                                                                                                                                                                                                              
    city: <city>                                                                                                                                                                                                            
    cmn_location_source: ''                                                                                                                                                                                                      
    cmn_location_type: ''                                                                                                                                                                                                        
    company: ''                                                                                                                                                                                                                  
    contact: ''                                                                                                                                                                                                                  
    coordinates_retrieved_on: ''                                                                                                                                                                                                 
    country: USA                                                                                                                                                                                                                 
    duplicate: 'false'                                                                                                                                                                                                           
    fax_phone: ''
    full_name: Test                                                                                                                                                                                                        
    lat_long_error: ''                                                                                                                                                                                                            
    latitude: ''                                                                                                                                                                                                         
    life_cycle_stage: ''                                                                                                                                                                                                          
    life_cycle_stage_status: ''                                                                                                                                                                                                   
    longitude: ''                                                                                                                                                                                                       
    managed_by_group: ''                                                                                                                                                                                                          
    name: Test                                                                                                                                                                                                             
    parent: ''                                                                                                                                                                                                                    
    phone: ''                                                                                                                                                                                                                     
    phone_territory: ''                                                                                                                                                                                                           
    primary_location: ''                                                                                                                                                                                                          
    state: ''                                                                                                                                                                                                                     
    stock_room: 'false'                                                                                                                                                                                                           
    street: ''                                                                                                                                                                                                         
    sys_created_by: ansible_api                                                                                                                                                                                                   
    sys_created_on: '2023-05-15 14:19:27'                                                                                                                                                                                         
    sys_id: 960a308edb7ae150dec34a6c1396193b                                                                                                                                                                                      
    sys_mod_count: '0'                                                                                                                                                                                                           
    sys_tags: ''                                                                                                                                                                                                                 
    sys_updated_by: ansible_api                                                                                                                                                                                                  
    sys_updated_on: '2023-05-15 14:19:27'                                                                                                                                                                                        
    time_zone: ''                                                                                                                                                                                                                
    u_branch_number: ''                                                                                                                                                                                                          
    u_email: ''                                                                                                                                                                                                                  
    u_operational_status: '1'                                                                                                                                                                                                    
    u_passport: 'false'                                                                                                                                                                                                          
    zip: ''                                                                                                                                                                                                                 
resolved_action: servicenow.itsm.configuration_item_info

I'm able to work around this by using Ansible's builtin URI module, but thought that I should be able to use configuration_item module considering I was able to create the location and that documentation states it works with all cmdb tables.

Has anyone else tried working with cmn_locations? Is it in fact supported and could this be a bug?

Thanks everyone!