Skip Navigation
"Unknown table or column '<name>'" error when using Connect Web Services (CWS)
Answer ID 7214   |   Last Review Date 12/17/2018

I'm trying to use the Connect Web Services' QueryCSV operation but keep getting "Unknown table or column '<name>'" errors.


Connect Web Services ("SOAP API")


Ensure that your query selects specific fields from the object, or objects, you are attempting to query rather than the entire object itself.


The "QueryCSV" operation is designed to return specific fields for an object rather than an entire object. If one uses a query to select one or more objects in their entirety, rather than specific fields that have been defined for that object(s), the web service will return a "RequestErrorFault".

Take the query shown in the following SOAP envelope as an example:

<soapenv:Envelope xmlns:soapenv="">
                  <ns7:ClientInfoHeader xmlns:ns7="" soapenv:mustUnderstand="0">
                           <ns7:AppID>My App</ns7:AppID>
                  <ns7:QueryCSV xmlns:ns7="">
                         <ns7:Query>SELECT Incident From Incident WHERE ID IN (217, 218)</ns7:Query>

Because the query is attempting to retrieve an entire object ("Incident"), the web service will return a response like the following:

<soapenv:Envelope xmlns:soapenv="">
         <faultstring>Unknown table or column 'Incident'</faultstring>
            <n0:RequestErrorFault xmlns:n0="" xmlns:xsi="">
               <n0:exceptionMessage>Unknown table or column 'Incident'</n0:exceptionMessage>

Notify Me
The page will refresh upon submission. Any pending input will be lost.