Getting insufficient rights to query records via REST API using admin credential

dariensharif
Kilo Contributor

Using REST need to extract to pieces of data.

1)  Count of VMware Templates in use and I am able to extract this data by the following GET

    {{server}}{{path}}/stats/cmdb_ci_vmware_template?sysparm_count=true

2)  Count of VMware Templates that have credentials and I am unable to extract this data using GET

    {{server}}{{path}}/stats/cmdb_ci_vmware_template?sysparm_query={credential}=true&sysparm_count=true

   Get the JSON message using admin credentials

   {
       "error": {
             "detail": "No permission to read column(s): [{credential}]",
             "message": "Insufficient rights to query records"
        },
        "status": "failure"
    }

Either my query is not right or some parts of CMDB are not accessible via REST, even as admin. I think the issue is former but need confirmation and help. Thanks.