BrightofficeAPI

Click here for a complete list of operations.

GetSqlToCopyReport

Test

To test the operation using the HTTP POST protocol, click the 'Invoke' button.

Parameter	Value
companyDatabaseName:
hashCode:
sourceReportName:
destinationReportName:

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 /Webservices/BrightOfficeAPI.asmx HTTP/1.1
Host: www.spdoffice.co.uk
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://tempuri.org/GetSqlToCopyReport"

<?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>
    <GetSqlToCopyReport xmlns="http://tempuri.org/">
      <companyDatabaseName>string</companyDatabaseName>
      <hashCode>string</hashCode>
      <sourceReportName>string</sourceReportName>
      <destinationReportName>string</destinationReportName>
    </GetSqlToCopyReport>
  </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>
    <GetSqlToCopyReportResponse xmlns="http://tempuri.org/">
      <GetSqlToCopyReportResult>
        <EnquiryResult>
          <SuccessCode>SUCCESS or SYSTEMERROR or LOGINERROR or OTHER or MISSINGRECORD or PARAMETERERROR</SuccessCode>
          <Message>string</Message>
          <ExceptionMessage>string</ExceptionMessage>
          <IsSystemError>boolean</IsSystemError>
        </EnquiryResult>
        <Value>string</Value>
      </GetSqlToCopyReportResult>
    </GetSqlToCopyReportResponse>
  </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 /Webservices/BrightOfficeAPI.asmx HTTP/1.1
Host: www.spdoffice.co.uk
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>
    <GetSqlToCopyReport xmlns="http://tempuri.org/">
      <companyDatabaseName>string</companyDatabaseName>
      <hashCode>string</hashCode>
      <sourceReportName>string</sourceReportName>
      <destinationReportName>string</destinationReportName>
    </GetSqlToCopyReport>
  </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>
    <GetSqlToCopyReportResponse xmlns="http://tempuri.org/">
      <GetSqlToCopyReportResult>
        <EnquiryResult>
          <SuccessCode>SUCCESS or SYSTEMERROR or LOGINERROR or OTHER or MISSINGRECORD or PARAMETERERROR</SuccessCode>
          <Message>string</Message>
          <ExceptionMessage>string</ExceptionMessage>
          <IsSystemError>boolean</IsSystemError>
        </EnquiryResult>
        <Value>string</Value>
      </GetSqlToCopyReportResult>
    </GetSqlToCopyReportResponse>
  </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 /Webservices/BrightOfficeAPI.asmx/GetSqlToCopyReport?companyDatabaseName=string&hashCode=string&sourceReportName=string&destinationReportName=string HTTP/1.1
Host: www.spdoffice.co.uk

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

<?xml version="1.0" encoding="utf-8"?>
<StringResult xmlns="http://tempuri.org/">
  <EnquiryResult>
    <SuccessCode>SUCCESS or SYSTEMERROR or LOGINERROR or OTHER or MISSINGRECORD or PARAMETERERROR</SuccessCode>
    <Message>string</Message>
    <ExceptionMessage>string</ExceptionMessage>
    <IsSystemError>boolean</IsSystemError>
  </EnquiryResult>
  <Value>string</Value>
</StringResult>

HTTP POST

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

POST /Webservices/BrightOfficeAPI.asmx/GetSqlToCopyReport HTTP/1.1
Host: www.spdoffice.co.uk
Content-Type: application/x-www-form-urlencoded
Content-Length: length

companyDatabaseName=string&hashCode=string&sourceReportName=string&destinationReportName=string

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

<?xml version="1.0" encoding="utf-8"?>
<StringResult xmlns="http://tempuri.org/">
  <EnquiryResult>
    <SuccessCode>SUCCESS or SYSTEMERROR or LOGINERROR or OTHER or MISSINGRECORD or PARAMETERERROR</SuccessCode>
    <Message>string</Message>
    <ExceptionMessage>string</ExceptionMessage>
    <IsSystemError>boolean</IsSystemError>
  </EnquiryResult>
  <Value>string</Value>
</StringResult>