QXXML Examples

Use the following examples to get familiar with the structure of QXXML.

JobSetupAdd: Add one JobSetup

<?xml version="1.0" ?>
<QXXML>
  <QXXMLMsgsRq onError="stopOnError" loginuser="Admin" loginpassword="AdminPassword" database="C:\Program Files\QXpress\The Service Company.mde" ApplicationName="Test Program - Do NOT Trust" ApplicationAccessPassword="430806">
    <JobSetupAddRq responseData="includeNone" RequestID="123">
      <JobSetupAdd>
        <CustomerRef>
          <CustomerName>Crenshaw, Bob</CustomerName>
        </CustomerRef>
        <ChargeDescriptionRef>
          <ChargeDescriptionDescription>Regular Service Call</ChargeDescriptionDescription>
        </ChargeDescriptionRef>
        <JobSetupExportTag>UniqueID-12345</JobSetupExportTag>
        <JobSetupType>OneTime</JobSetupType>
      </JobSetupAdd>
    </JobSetupAddRq>
  </QXXMLMsgsRq>
</QXXML>

JobSetupAdd: Add two JobSetups

<?xml version="1.0" ?>
<QXXML>
  <QXXMLMsgsRq onError="stopOnError" loginuser="Admin" loginpassword="Admin" database="C:\Program Files\QXpress\The Service Company.mde" ApplicationName="Test Program - Do NOT Trust" ApplicationAccessPassword="430806">
    <JobSetupAddRq responseData="includeNone" RequestID="123">
      <JobSetupAdd>
        <CustomerRef>
          <CustomerName>Crenshaw, Bob</CustomerName>
        </CustomerRef>
        <ChargeDescriptionRef>
          <ChargeDescriptionDescription>Regular Service Call</ChargeDescriptionDescription>
        </ChargeDescriptionRef>
        <JobSetupExportTag>UniqueID-12345</JobSetupExportTag>
        <JobSetupType>OneTime</JobSetupType>
      </JobSetupAdd>
      <JobSetupAdd>
        <CustomerRef>
          <CustomerName>Crider, Craig</CustomerName>
        </CustomerRef>
        <ChargeDescriptionRef>
          <ChargeDescriptionDescription>Weekly Service</ChargeDescriptionDescription>
        </ChargeDescriptionRef>
        <JobSetupExportTag>UniqueID-12346</JobSetupExportTag>
        <JobSetupType>Recurring</JobSetupType>
      </JobSetupAdd>
    </JobSetupAddRq>
  </QXXMLMsgsRq>
</QXXML>

JobSetupQuery: Request all fields of a specific JobSetup

JobSetupQuery: Request specific fields of a specific JobSetup (faster)

Multiple Query requests: Request JobSetupQuery,CrewQuery and CustomerQuery

<?xml version="1.0" ?>
<QXXML>
  <QXXMLMsgsRq onError="stopOnError" loginuser="Admin" loginpassword="AdminPassword" database="C:\Program Files\QXpress\The Service Company.mde" ApplicationName="Test Program - Do NOT Trust" ApplicationAccessPassword="430806">
    <JobSetupQueryRq RequestID="123">
      <JobSetupExportTagFilter>UniqueID-12345</JobSetupExportTagFilter>
      <JobSetupSelectFieldsFilter>CustomerName,JobSetupAmount,JobSetupRefID,JobSetupStatus,JobSetupType</JobSetupSelectFieldsFilter>
    </JobSetupQueryRq>
    <CrewQueryRq RequestID="124">
    </CrewQueryRq>
    <CustomerQueryRq RequestID="125">
      <CustomerSelectFieldsFilter>CustomerName,CustomerBillToLine1,CustomerBillToLine2,CustomerBillToLine3</CustomerSelectFieldsFilter>
    </CustomerQueryRq>
  </QXXMLMsgsRq>
</QXXML>

JobComponentQuery: Request specific services in My Calendar

<?xml version="1.0" ?>
<QXXML>
  <QXXMLMsgsRq onError="stopOnError" loginuser="Admin" loginpassword="AdminPassword" database="C:\Program Files\QXpress\The Service Company.mde" ApplicationName="Test Program - Do NOT Trust" ApplicationAccessPassword="430806">
    <JobComponentQueryRq RequestID="123">
      <JobComponentCrewFilter>=001</JobComponentCrewFilter>
      <JobComponentDateFromFilter>2004-05-13</JobComponentDateFromFilter>
      <JobComponentDateToFilter>2004-05-14</JobComponentDateToFilter>
      <JobComponentIsOnMyCalendar>=YES</JobComponentIsOnMyCalendar>
    </JobComponentQueryRq>
  </QXXMLMsgsRq>
</QXXML>