WebServiceDB Web Service

WebServiceDB

Click here for a complete list of operations.

Get_the_Number_of_Rows

for view only

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 /WebServiceDB.asmx HTTP/1.1
Host: webservice.alamer-market.com
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://alamerwebservices.com/Get_the_Number_of_Rows"

<?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>
    <Get_the_Number_of_Rows xmlns="http://alamerwebservices.com/">
      <User>
        <userName>string</userName>
        <password>string</password>
      </User>
      <dbConnect>
        <IP>string</IP>
        <DbName>string</DbName>
        <Username>string</Username>
        <Password>string</Password>
        <Connect>string</Connect>
      </dbConnect>
    </Get_the_Number_of_Rows>
  </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>
    <Get_the_Number_of_RowsResponse xmlns="http://alamerwebservices.com/">
      <Get_the_Number_of_RowsResult>
        <Name>string</Name>
        <En_Name>string</En_Name>
        <Price>string</Price>
        <NetPrice>string</NetPrice>
        <Unit>string</Unit>
        <UnitDescreption>string</UnitDescreption>
        <barcode>string</barcode>
        <Message>string</Message>
        <FromDate>string</FromDate>
        <ToDate>string</ToDate>
        <SpecialPrice>string</SpecialPrice>
        <UseSpecialPrice>int</UseSpecialPrice>
        <ItemID>string</ItemID>
        <QuantityPerUnit>float</QuantityPerUnit>
        <Tax>float</Tax>
        <ctnPrice>string</ctnPrice>
        <ctnDisc>string</ctnDisc>
        <totalRow>string</totalRow>
        <username>string</username>
        <UserID>int</UserID>
        <IsAdded>int</IsAdded>
        <Company_Id>int</Company_Id>
        <Location>string</Location>
        <Note>string</Note>
        <Description>string</Description>
        <Path_Id>int</Path_Id>
        <Section_Id>int</Section_Id>
        <Location_Id>int</Location_Id>
        <dataSet>
          <xsd:schema>schema</xsd:schema>xml</dataSet>
        <dataTable>xmlxml</dataTable>
        <IsCustomer>boolean</IsCustomer>
      </Get_the_Number_of_RowsResult>
    </Get_the_Number_of_RowsResponse>
  </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 /WebServiceDB.asmx HTTP/1.1
Host: webservice.alamer-market.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>
    <Get_the_Number_of_Rows xmlns="http://alamerwebservices.com/">
      <User>
        <userName>string</userName>
        <password>string</password>
      </User>
      <dbConnect>
        <IP>string</IP>
        <DbName>string</DbName>
        <Username>string</Username>
        <Password>string</Password>
        <Connect>string</Connect>
      </dbConnect>
    </Get_the_Number_of_Rows>
  </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>
    <Get_the_Number_of_RowsResponse xmlns="http://alamerwebservices.com/">
      <Get_the_Number_of_RowsResult>
        <Name>string</Name>
        <En_Name>string</En_Name>
        <Price>string</Price>
        <NetPrice>string</NetPrice>
        <Unit>string</Unit>
        <UnitDescreption>string</UnitDescreption>
        <barcode>string</barcode>
        <Message>string</Message>
        <FromDate>string</FromDate>
        <ToDate>string</ToDate>
        <SpecialPrice>string</SpecialPrice>
        <UseSpecialPrice>int</UseSpecialPrice>
        <ItemID>string</ItemID>
        <QuantityPerUnit>float</QuantityPerUnit>
        <Tax>float</Tax>
        <ctnPrice>string</ctnPrice>
        <ctnDisc>string</ctnDisc>
        <totalRow>string</totalRow>
        <username>string</username>
        <UserID>int</UserID>
        <IsAdded>int</IsAdded>
        <Company_Id>int</Company_Id>
        <Location>string</Location>
        <Note>string</Note>
        <Description>string</Description>
        <Path_Id>int</Path_Id>
        <Section_Id>int</Section_Id>
        <Location_Id>int</Location_Id>
        <dataSet>
          <xsd:schema>schema</xsd:schema>xml</dataSet>
        <dataTable>xmlxml</dataTable>
        <IsCustomer>boolean</IsCustomer>
      </Get_the_Number_of_RowsResult>
    </Get_the_Number_of_RowsResponse>
  </soap12:Body>
</soap12:Envelope>