Order_Retrieve

Retrieves details for an Order including details, products and payments. Use EntityID to retrieve owner Contact/Company information for order.

Warning: This API endpoint will eventually be deprecated (existing implementations will still continue to work). We strongly advise to use the new Order v3 REST API endpoints. Here is an example on how to get the details for a specific order using the new endpoints.

Request

  • Method: SOAP
  • Server: https://[app key here]-[site_ID here]-apps.worldsecuresystems.com. Take a look at the Authorize your API calls document for more info on how this URL is formed.
  • Path: /catalystwebservice/catalystcrmwebservice.asmx
  • The username and password fields:You can make SOAP API calls can be authorized either by using the actual username or password of an Admin username or, if you are making the calls from an app leave the username field empty and use the authorization token as the password.

Parameters

  • siteId - ID of the site (integer)
  • username - email address of user account, leave empty if using site token (string)
  • password - password of user account, or site authentication token for specified site (string)
  • orderId - (integer)

To use a site token instead of username/password, send an empty username field and the site token as the password. See example below.

Response

A Order_RetrieveResponse object with the following properties:

  • Order_RetrieveResult - (object)
    • OrderDetails - (object)
      • entityId - (integer)
      • orderId - (integer)
      • orderName - (string)
      • workflowId - (integer)
      • statusTypeId - (integer)
      • countryCode - (string)
      • orderType - (integer)
      • invoiceNumber - (integer)
      • invoiceDate - (dateTime) - e.g. 2014-09-9T10:24:00
      • userID_AssignedTo - (integer)
      • shippingAmount - (double)
      • shippingTaxRate - (double)
      • shippingAttention - (string)
      • shippingInstructions - (string)
      • shippingOptionId - (integer)
      • discountCodeId - (integer)
      • discountRate - (double)
      • totalOrderAmount - (double)
      • directDebitTypeId - (integer)
      • directDebitDays - (integer)
      • isRecur - (boolean)
      • nextInvoiceDate - (dateTime) - e.g. 2014-09-9T10:24:00
      • endRecurDate - (dateTime) - e.g. 2014-09-9T10:24:00
      • cycleTypeID - (integer)
      • createDate - (dateTime) - e.g. 2014-09-9T10:24:00
      • lastUpdateDate - (dateTime) - e.g. 2014-09-9T10:24:00
      • deleted - (boolean)
      • products - (object)
        • Product - (object)
          • productId - (integer)
          • productCode - (string)
          • productDescription - (string)
          • units - (integer)
          • unitPrice - (double)
          • unitTaxRate - (double)
          • totalProductPrice - (double)
          • productName - (string)
          • variationId - (integer)
      • payments - (object)
        • Payment - (object)
          • paymentMethodTypeID - (integer)
          • amount - (double)
          • paymentStatusID - (integer)
          • transactionNumber - (string)
          • transactionAuthCode - (string)
          • Description - (string)
          • paymentDate - (dateTime) - e.g. 2014-09-9T10:24:00
      • addresses - (object)
        • Address - (object)
          • addressTypeID - (integer)
          • addressLine1 - (string)
          • addressLine2 - (string)
          • city - (string)
          • zipcode - (string)
          • state - (string)
          • countryCode - (string)
      • crmForms - (object)
        • CrmForms - (object)
          • formId - (integer)
          • formName - (string)
          • crmFormFields - (array)

Examples

Accepts and returns XML as Content-Type.

The following is a sample SOAP 1.2 request and response. The placeholders shown need to be replaced with actual values, please note the data in the request and response is only for explanatory purposes.

Request:

POST /catalystwebservice/catalystcrmwebservice.asmx HTTP/1.1
Host: worldsecuresystems.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>
    <Order_Retrieve xmlns="http://tempuri.org/CatalystDeveloperService/CatalystCRMWebservice">
      <username>jdoe@yourdomain.com</username>
      <password>Y0urP@ssw0rdH3re</password>
      <siteId>12345</siteId>
      <orderId>12345</orderId>
    </Order_Retrieve>
  </soap12:Body>
</soap12:Envelope>

Response:

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>
    <Order_RetrieveResponse xmlns="http://tempuri.org/CatalystDeveloperService/CatalystCRMWebservice">
      <Order_RetrieveResult>
        <entityId>1234</entityId>
        <orderId>12345</orderId>
        <orderName>Order Name</orderName>
        <workflowId>12345</workflowId>
        <statusTypeId>52866</statusTypeId>
        <countryCode>GB</countryCode>
        <orderType>2</orderType>
        <invoiceNumber>12345</invoiceNumber>
        <invoiceDate>2014-02-02T10:20:00</invoiceDate>
        <userID_AssignedTo>12345</userID_AssignedTo>
        <shippingAmount>double</shippingAmount>
        <shippingTaxRate>double</shippingTaxRate>
        <shippingAttention>string</shippingAttention>
        <shippingInstructions>string</shippingInstructions>
        <shippingOptionId>0</shippingOptionId>
        <discountcodeId>1234</discountcodeId>
        <discountRate>0</discountRate>
        <totalOrderAmount>120</totalOrderAmount>
        <directDebitTypeId>0</directDebitTypeId>
        <directDebitDays>0</directDebitDays>
        <isRecur>true</isRecur>
        <nextInvoiceDate>2014-07-07T9:27:00</nextInvoiceDate>
        <endRecurDate>2014-07-07T9:27:00</endRecurDate>
        <cycleTypeID>1</cycleTypeID>
        <createDate>2010-08-08T12:22:00</createDate>
        <lastUpdateDate>2012-08-08T12:22:00</lastUpdateDate>
        <deleted>false</deleted>
        <products>
        <Product>
           <productId>4735640</productId>
           <productCode>JBWMC0KLZA</productCode>
           <productDescription/>
           <units>1</units>
           <unitPrice>120</unitPrice>
           <unitTaxRate>0</unitTaxRate>
           <totalProductPrice>120</totalProductPrice>
           <productName>Product name 1</productName>
        </Product>
        <Product>
           <productId>4735641</productId>
           <productCode>JBWMC0KLZB</productCode>
           <productDescription/>
           <units>2</units>
           <unitPrice>121</unitPrice>
           <unitTaxRate>0</unitTaxRate>
           <totalProductPrice>121</totalProductPrice>
           <productName>Product name 2</productName>
        </Product>
        </products>
        <payments>
          <Payment>
            <paymentMethodTypeID>int</paymentMethodTypeID>
            <amount>double</amount>
            <paymentStatusID>int</paymentStatusID>
            <transactionNumber>string</transactionNumber>
            <transactionAuthCode>string</transactionAuthCode>
            <Description>string</Description>
            <paymentDate>2014-07-07T9:27:00</paymentDate>
          </Payment>
          <Payment>
            <paymentMethodTypeID>int</paymentMethodTypeID>
            <amount>double</amount>
            <paymentStatusID>int</paymentStatusID>
            <transactionNumber>string</transactionNumber>
            <transactionAuthCode>string</transactionAuthCode>
            <Description>string</Description>
            <paymentDate>2014-07-07T9:27:00</paymentDate>
          </Payment>
        </payments>
        <addresses>
          <Address>
             <addressTypeID>1</addressTypeID>
             <addressLine1>Home Address</addressLine1>
             <city>Home City</city>
             <zipcode>HOME ZIP</zipcode>
             <state>home state</state>
             <countryCode>RO</countryCode>
          </Address>
          <Address>
             <addressTypeID>1</addressTypeID>
             <addressLine1>Home Address</addressLine1>
             <city>Home City</city>
             <zipcode>HOME ZIP</zipcode>
             <state>home state</state>
             <countryCode>RO</countryCode>
          </Address>
        </addresses>
        <crmForms>
          <CrmForms>
            <formId>12345</formId>
            <formName>Webform name here</formName>
            <crmFormFields xsi:nil="true" />
          </CrmForms>
          <CrmForms>
            <formId>12345</formId>
            <formName>Webform name here</formName>
            <crmFormFields xsi:nil="true" />
          </CrmForms>
        </crmForms>
      </Order_RetrieveResult>
    </Order_RetrieveResponse>
  </soap12:Body>
</soap12:Envelope>