SQLServices

Click here for a complete list of operations.

LoadQuery

Test

The test form is only available for requests from the local machine.

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values.

POST /_layouts/BPC/PowerWebForms/PWFSQLServices.asmx HTTP/1.1
Host: crm.zarsim.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://bpc-components.com/LoadQuery"

<?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:Body>
    <LoadQuery xmlns="http://bpc-components.com/">
      <queryListUrl>string</queryListUrl>
      <queryListIdOrName>string</queryListIdOrName>
      <queryName>string</queryName>
      <parameters>
        <ListItemValue Name="string" />
        <ListItemValue Name="string" />
      </parameters>
    </LoadQuery>
  </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:Body>
    <LoadQueryResponse xmlns="http://bpc-components.com/">
      <LoadQueryResult>
        <ListItems>
          <ListItem VersionNo="string" CreatedBy="string" CreatedDate="string" ModifiedBy="string" ModifiedDate="string">
            <Values xsi:nil="true" />
          </ListItem>
          <ListItem VersionNo="string" CreatedBy="string" CreatedDate="string" ModifiedBy="string" ModifiedDate="string">
            <Values xsi:nil="true" />
          </ListItem>
        </ListItems>
        <ErrorMessage>string</ErrorMessage>
        <Compressed>
          <ColumnNames>
            <string>string</string>
            <string>string</string>
          </ColumnNames>
          <Values>
            <string>string</string>
            <string>string</string>
          </Values>
        </Compressed>
      </LoadQueryResult>
    </LoadQueryResponse>
  </soap:Body>
</soap:Envelope>

SOAP 1.2

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values.

POST /_layouts/BPC/PowerWebForms/PWFSQLServices.asmx HTTP/1.1
Host: crm.zarsim.com
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <LoadQuery xmlns="http://bpc-components.com/">
      <queryListUrl>string</queryListUrl>
      <queryListIdOrName>string</queryListIdOrName>
      <queryName>string</queryName>
      <parameters>
        <ListItemValue Name="string" />
        <ListItemValue Name="string" />
      </parameters>
    </LoadQuery>
  </soap12:Body>
</soap12:Envelope>

HTTP/1.1 200 OK
Content-Type: application/soap+xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <LoadQueryResponse xmlns="http://bpc-components.com/">
      <LoadQueryResult>
        <ListItems>
          <ListItem VersionNo="string" CreatedBy="string" CreatedDate="string" ModifiedBy="string" ModifiedDate="string">
            <Values xsi:nil="true" />
          </ListItem>
          <ListItem VersionNo="string" CreatedBy="string" CreatedDate="string" ModifiedBy="string" ModifiedDate="string">
            <Values xsi:nil="true" />
          </ListItem>
        </ListItems>
        <ErrorMessage>string</ErrorMessage>
        <Compressed>
          <ColumnNames>
            <string>string</string>
            <string>string</string>
          </ColumnNames>
          <Values>
            <string>string</string>
            <string>string</string>
          </Values>
        </Compressed>
      </LoadQueryResult>
    </LoadQueryResponse>
  </soap12:Body>
</soap12:Envelope>