SelectService


Click here for a complete list of operations.

SelectData

Issue a select statement to your MB database

Test

To test the operation using the HTTP POST protocol, click the 'Invoke' button.
Parameter Value
SelectSQL:
Sourcename:
Password:
StudioID:

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 /0_4/SelectService.asmx HTTP/1.1
Host: clients.mindbodyonline.com/api
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://clients.mindbodyonline.com/API/0_4/SelectData"

<?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>
    <SelectData xmlns="http://clients.mindbodyonline.com/API/0_4">
      <SelectSQL>string</SelectSQL>
      <Sourcename>string</Sourcename>
      <Password>string</Password>
      <StudioID>int</StudioID>
    </SelectData>
  </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>
    <SelectDataResponse xmlns="http://clients.mindbodyonline.com/API/0_4">
      <SelectDataResult>
        <Result>
          <Row>
            <Content />
          </Row>
          <Row>
            <Content />
          </Row>
        </Result>
      </SelectDataResult>
    </SelectDataResponse>
  </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 /0_4/SelectService.asmx HTTP/1.1
Host: clients.mindbodyonline.com/api
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>
    <SelectData xmlns="http://clients.mindbodyonline.com/API/0_4">
      <SelectSQL>string</SelectSQL>
      <Sourcename>string</Sourcename>
      <Password>string</Password>
      <StudioID>int</StudioID>
    </SelectData>
  </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>
    <SelectDataResponse xmlns="http://clients.mindbodyonline.com/API/0_4">
      <SelectDataResult>
        <Result>
          <Row>
            <Content />
          </Row>
          <Row>
            <Content />
          </Row>
        </Result>
      </SelectDataResult>
    </SelectDataResponse>
  </soap12:Body>
</soap12:Envelope>

HTTP GET

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

GET /0_4/SelectService.asmx/SelectData?SelectSQL=string&Sourcename=string&Password=string&StudioID=string HTTP/1.1
Host: clients.mindbodyonline.com/api

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

<?xml version="1.0" encoding="utf-8"?>
<Result_RecordSet xmlns="http://clients.mindbodyonline.com/API/0_4">
  <Result>
    <Row>
      <Content />
    </Row>
    <Row>
      <Content />
    </Row>
  </Result>
</Result_RecordSet>

HTTP POST

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

POST /0_4/SelectService.asmx/SelectData HTTP/1.1
Host: clients.mindbodyonline.com/api
Content-Type: application/x-www-form-urlencoded
Content-Length: length

SelectSQL=string&Sourcename=string&Password=string&StudioID=string
HTTP/1.1 200 OK
Content-Type: text/xml; charset=utf-8
Content-Length: length

<?xml version="1.0" encoding="utf-8"?>
<Result_RecordSet xmlns="http://clients.mindbodyonline.com/API/0_4">
  <Result>
    <Row>
      <Content />
    </Row>
    <Row>
      <Content />
    </Row>
  </Result>
</Result_RecordSet>