[Initial Page]

TPN Live - SOAP to get a list of consignments

 The SOAP method to extract this data is as follows. Site URL on request.

This gives a list of consignment numbers in the specified date range.

FindConsignmentsToExport

SOAP 1.1

The following is a sample SOAP 1.1 request and response. The placeholders shown need to be replaced with actual values. The date is in DD/MM/YYYY format.

POST /TPNImportExport/Service.asmx HTTP/1.1

Host: poseidon

Content-Type: text/xml; charset=utf-8

Content-Length: length

SOAPAction: "TPNImportExport/FindConsignmentsToExport"

<?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>

    <FindConsignmentsToExport xmlns="TPNImportExport">

      <Username>string</Username>

      <Password>string</Password>

      <DateFrom>string</DateFrom>

      <DateTo>string</DateTo>

      <ReqColDel>integer</ReqColDel>

    </FindConsignmentsToExport>

  </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>

    <FindConsignmentsToExportResponse xmlns="TPNImportExport">

      <FindConsignmentsToExportResult>

        <string>string</string>

        <string>string</string>

      </FindConsignmentsToExportResult>

    </FindConsignmentsToExportResponse>

  </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. The date is in DD/MM/YYYY format.

POST /TPNImportExport/Service.asmx HTTP/1.1

Host: poseidon

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>

    <FindConsignmentsToExport xmlns="TPNImportExport">

      <Username>string</Username>

      <Password>string</Password>

      <DateFrom>string</DateFrom>

      <DateTo>string</DateTo>

     <ReqColDel>integer</ReqColDel>

    </FindConsignmentsToExport>

  </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>

    <FindConsignmentsToExportResponse xmlns="TPNImportExport">

      <FindConsignmentsToExportResult>

        <string>string</string>

        <string>string</string>

      </FindConsignmentsToExportResult>

    </FindConsignmentsToExportResponse>

  </soap12:Body>

</soap12:Envelope>

Example result -

<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 

xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><FindConsignmentsToExportResponse xmlns="TPNImportExport"><FindConsignmentsToExportResult>

<string>1457308</string><string>1457312</string><string>1457316</string><string>1457318</string><string>1457320</string><string>1457322</string>

<string>1457324</string><string>1457326</string><string>1457328</string><string>2613063</string>

</FindConsignmentsToExportResult></FindConsignmentsToExportResponse></soap:Body></soap:Envelope>

Code Example (Windev)

SOAP.Value[1] = username

SOAP.Name[1] = "Username"

SOAP.Type[1] = SOAPStringType

SOAP.Value[2] = password

SOAP.Name[2] = "Password"

SOAP.Type[2] = SOAPStringType

SOAP.Value[3] = DateToString(startdate,"DD/MM/YYYY")

SOAP.Name[3] = "DateFrom"

SOAP.Type[3] = SOAPStringType

SOAP.Value[4] = DateToString(enddate,"DD/MM/YYYY")

SOAP.Name[4]= "DateTo"

SOAP.Type[4]=SOAPStringType

SOAP.Value[5] = exporttype

SOAP.Name[5] = "ReqColDel"

SOAP.Type[5] = SOAPIntegerType

IF SOAPRun(sitetouse, "FindConsignmentsToExport","TPNImportExport","TPNImportExport/FindConsignmentsToExport","utf-8") THEN

mysoapresult = SOAPGetResult(SOAPXMLResult)