com.glide.processors.soap.SOAPProcessingException: Field(s) present in the query do not have permission to be read
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-03-2021 04:22 AM
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
- Labels:
-
Scripting and Coding
-
Team Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-03-2021 02:05 PM
Hi
This is a prefix use by the tool SOAPUI.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2021 01:43 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-07-2021 08:55 AM
I try to add Personalize, Personalize response s' role noticed in this post
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