com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read

Atchaang
Tera Contributor

I am using SOAPUI to query servicenow data table.
Data are returned for most of tables (cmdb_ci,incident etc...) but for sys_choice table, when I try the method getRecords, an error is raised :
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sys="http://www.service-now.com/sys_choice">
<soapenv:Header/>
<soapenv:Body>
<sys:getRecords>
<!--Optional:-->
<sys:element>state</sys:element>
<sys:language>en</sys:language>
<!--Optional:-->
<sys:name>incident</sys:name>
</sys:getRecords>
</soapenv:Body>
</soapenv:Envelope>

Error is raised (only for this table sys_choice)
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header/>
<SOAP-ENV:Body>
<SOAP-ENV:Fault>
<faultcode>SOAP-ENV:Server</faultcode>
<faultstring>com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read</faultstring>
<detail>com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read</detail>
</SOAP-ENV:Fault>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Any idea about this error ?

Thanks & regards

 

7 REPLIES 7

Hi 

This is a prefix use by the tool SOAPUI.
Regards

 

 

 

Atchaang
Tera Contributor

Hi 

My API has given the Personalize_choice role, and now the error is not raised, I can acces all fields (table,element,language,label,hint,inactive,sequence) and their value except the field value (empty is displayed with the command sys_choice.list for this field ???).
For ACL, all are correct (sys_choice.* is setted).
With Admin role, all fields (include value field) are displayed with their value.
Why value field of sys_choice table is displayed always empty ?
Any idea please, which role to use to give my API account to acces value of value field of sys_choice table ?

Regards

 

 

 

Atchaang
Tera Contributor

I try to add Personalize, Personalize response s' role noticed in this post  

https://community.servicenow.com/community?id=community_question&sys_id=50004feddb58dbc01dcaf3231f96...

without successful 😞
Why this field Value is not provided by sys_choice.list or soap API call ?

I cannot get Admin role for my API to get this missing field value
this makes me crazy !

Regards