GetQuery Provides a means of retrieving single or multiple data records and returns either the specific columns (pruning the number of elements is governed by how the netforum facade object was constructed, for example, the one-to-many relationships cannot be rendered in a flat-view - in these cases, no value will be returned for the impacted elements) or the complete Facade object record (returning all the fields associated with a netForum Facade object can be done by passing a "*" as the sole value for the szColumnList value).
SOAP 1.1
The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.
HTTP GET
The following is a sample HTTP GET request and response. The placeholders shown need to be replaced with actual values.
HTTP POST
The following is a sample HTTP POST request and response. The placeholders shown need to be replaced with actual values.
POST /xweb/secure/netforumxml.asmx HTTP/1.1
Host: www.sslnacwa.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.avectra.com/2005/GetQuery"
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>string</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetQuery xmlns="http://www.avectra.com/2005/">
<szObjectName>string</szObjectName>
<szColumnList>string</szColumnList>
<szWhereClause>string</szWhereClause>
<szOrderBy>string</szOrderBy>
</GetQuery>
</soap:Body>
</soap:Envelope>HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header>
<AuthorizationToken xmlns="http://www.avectra.com/2005/">
<Token>string</Token>
</AuthorizationToken>
</soap:Header>
<soap:Body>
<GetQueryResponse xmlns="http://www.avectra.com/2005/">
<GetQueryResult>xml</GetQueryResult>
</GetQueryResponse>
</soap:Body>
</soap:Envelope>GET /xweb/secure/netforumxml.asmx/GetQuery?szObjectName=string&szColumnList=string&szWhereClause=string&szOrderBy=string HTTP/1.1
Host: www.sslnacwa.com
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0"?>
xmlPOST /xweb/secure/netforumxml.asmx/GetQuery HTTP/1.1
Host: www.sslnacwa.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length
szObjectName=string&szColumnList=string&szWhereClause=string&szOrderBy=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length
<?xml version="1.0"?>
xml