Service1

Click here for a complete list of operations.

SqlUpdate

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 /Service1.asmx HTTP/1.1
Host: maexws.blokweg.nl
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://www.fitsolutions.nl/ws/1/SqlUpdate"

<?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>
    <SqlUpdate xmlns="http://www.fitsolutions.nl/ws/1/">
      <autorisatie>
        <Login>string</Login>
        <Wachtwoord>string</Wachtwoord>
        <LicentieNr>string</LicentieNr>
      </autorisatie>
      <request>
        <Tabel>string</Tabel>
        <Kolommen>
          <Kolom Volgnummer="positiveInteger">
            <Veldnaam>string</Veldnaam>
            <Waarde>string</Waarde>
          </Kolom>
          <Kolom Volgnummer="positiveInteger">
            <Veldnaam>string</Veldnaam>
            <Waarde>string</Waarde>
          </Kolom>
        </Kolommen>
        <Id>long</Id>
      </request>
    </SqlUpdate>
  </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>
    <SqlUpdateResponse xmlns="http://www.fitsolutions.nl/ws/1/">
      <SqlUpdateResult>
        <Response>
          <Rijen>
            <Rij xsi:nil="true" />
            <Rij xsi:nil="true" />
          </Rijen>
        </Response>
        <Id>string</Id>
        <ResponseValid>boolean</ResponseValid>
        <ErrorCode>string</ErrorCode>
        <ErrorMessage>string</ErrorMessage>
      </SqlUpdateResult>
    </SqlUpdateResponse>
  </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 /Service1.asmx HTTP/1.1
Host: maexws.blokweg.nl
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>
    <SqlUpdate xmlns="http://www.fitsolutions.nl/ws/1/">
      <autorisatie>
        <Login>string</Login>
        <Wachtwoord>string</Wachtwoord>
        <LicentieNr>string</LicentieNr>
      </autorisatie>
      <request>
        <Tabel>string</Tabel>
        <Kolommen>
          <Kolom Volgnummer="positiveInteger">
            <Veldnaam>string</Veldnaam>
            <Waarde>string</Waarde>
          </Kolom>
          <Kolom Volgnummer="positiveInteger">
            <Veldnaam>string</Veldnaam>
            <Waarde>string</Waarde>
          </Kolom>
        </Kolommen>
        <Id>long</Id>
      </request>
    </SqlUpdate>
  </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>
    <SqlUpdateResponse xmlns="http://www.fitsolutions.nl/ws/1/">
      <SqlUpdateResult>
        <Response>
          <Rijen>
            <Rij xsi:nil="true" />
            <Rij xsi:nil="true" />
          </Rijen>
        </Response>
        <Id>string</Id>
        <ResponseValid>boolean</ResponseValid>
        <ErrorCode>string</ErrorCode>
        <ErrorMessage>string</ErrorMessage>
      </SqlUpdateResult>
    </SqlUpdateResponse>
  </soap12:Body>
</soap12:Envelope>