Cash Register PriceBook Conexxus 3.5 PULL API

GET /{stationId}/pricebook/files

API endpoint returns PriceBook datasets info on a particular cash register. Data returned in Conexxus 3.5 standard for the following entities:

Merchandise Maintenance (MCT) report
Item Maintenance (ITT) report

Detailed API description is provided by Petrosoft Swagger according to OpenAPI Specification.

Examples of XML Documents returned by API

The examples below are taken from the testing environment with testing data. No association with any real company, product, event, or data is intended or should be inferred.

XML Example with MCT Data


 <?xml version="1.0"?>
  <TransmissionHeader>
    <StoreLocationID>1179</StoreLocationID>
    <VendorName>CStoreOffice</VendorName>
    <VendorModelVersion>NAXML3.4.5</VendorModelVersion>
  </TransmissionHeader>
  <MerchandiseCodeMaintenance>
    <TableAction type="update"/>
    <RecordAction type="modify"/>
    <MCTDetail>
      <MerchandiseCode>1</MerchandiseCode>
      <ActiveFlag value="yes"/>
      <MerchandiseCodeDescription>Tobacco</MerchandiseCodeDescription>
      <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
      <SalesRestriction>
        <MinimumCustomerAge>21</MinimumCustomerAge>
        <TransactionLimit>0.00</TransactionLimit>
        <ProhibitTender>
          <Tender>
            <TenderCode>foodStamps</TenderCode>
          </Tender>
        </ProhibitTender>
      </SalesRestriction>
      <OpenSaleLimits>
        <LowAmount>0.35</LowAmount>
        <HighAmount>75</HighAmount>
      </OpenSaleLimits>
      <NegativeFlag value="no"/>
      <ProhibitOpenSalesFlag value="no"/>
      <Extension>
        <TableName>Departments</TableName>
        <Category>0</Category>
        <SplDiscEligible>1</SplDiscEligible>
        <Taxes>
          <Tax>1</Tax>
        </Taxes>
        <IDCheck>1</IDCheck>
      </Extension>
    </MCTDetail>
    <MCTDetail>
      <MerchandiseCode>2</MerchandiseCode>
      <ActiveFlag value="yes"/>
      <MerchandiseCodeDescription>Juices</MerchandiseCodeDescription>
      <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
      <SalesRestriction>
        <TransactionLimit>0.00</TransactionLimit>
      </SalesRestriction>
      <OpenSaleLimits>
        <LowAmount>0.01</LowAmount>
        <HighAmount>20</HighAmount>
      </OpenSaleLimits>
      <NegativeFlag value="no"/>
      <ProhibitOpenSalesFlag value="no"/>
      <Extension>
        <TableName>Departments</TableName>
        <Category>0</Category>
        <SplDiscEligible>1</SplDiscEligible>
      </Extension>
    </MCTDetail>
    <MCTDetail>
      <MerchandiseCode>6</MerchandiseCode>
      <ActiveFlag value="yes"/>
      <MerchandiseCodeDescription>Groc T</MerchandiseCodeDescription>
      <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
      <SalesRestriction>
        <TransactionLimit>0.00</TransactionLimit>
      </SalesRestriction>
      <OpenSaleLimits>
        <LowAmount>0.01</LowAmount>
        <HighAmount>20</HighAmount>
      </OpenSaleLimits>
      <NegativeFlag value="no"/>
      <ProhibitOpenSalesFlag value="no"/>
      <Extension>
        <TableName>Departments</TableName>
        <Category>0</Category>
        <SplDiscEligible>0</SplDiscEligible>
        <Taxes>
          <Tax>1</Tax>
        </Taxes>
      </Extension>
      <ProhibitOpenSalesFlag value="no"/>
      <Extension>
        <TableName>Departments</TableName>
        <Category>9999</Category>
        <Type>Fuel</Type>
        <SplDiscEligible>0</SplDiscEligible>
      </Extension>
    </MCTDetail>
  </MerchandiseCodeMaintenance>
</NAXML-MaintenanceRequest>

To download the XML example with MCT data, click here.

XML Example with ITT Data


<?xml version="1.0"?>
<NAXML-MaintenanceRequest xmlns="http://www.naxml.org/POSBO/Vocabulary/2003-10-16" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="3.5" xsi:schemaLocation="http://www.naxml.org/POSBO/Vocabulary/2003-10-16 NAXML-PBIMaintenance.xsd">
  <TransmissionHeader>
    <StoreLocationID>1179</StoreLocationID>
    <VendorName>CStoreOffice</VendorName>
    <VendorModelVersion>NAXML3.4.5</VendorModelVersion>
  </TransmissionHeader>
  <ItemMaintenance>
    <TableAction type="initialize"/>
    <RecordAction type="addchange"/>
    <ITTDetail>
      <RecordAction type="addchange"/>
      <ItemCode>
        <POSCodeFormat format="none"/>
        <POSCode>00000000000178</POSCode>
        <POSCodeModifier>000</POSCodeModifier>
      </ItemCode>
      <ITTData>
        <ActiveFlag value="yes"/>
        <MerchandiseCode>5</MerchandiseCode>
        <RegularSellPrice>1.59000</RegularSellPrice>
        <Description>Single Roll TP</Description>
        <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
        <SalesRestriction>
          <TransactionLimit>0.00</TransactionLimit>
        </SalesRestriction>
        <SellingUnits>1.00000</SellingUnits>
        <PriceRequiredFlag value="yes"/>
      </ITTData>
      <Extension>
        <FeeNumber>0</FeeNumber>
      </Extension>
    </ITTDetail>
    <ITTDetail>
      <RecordAction type="addchange"/>
      <ItemCode>
        <POSCodeFormat format="none"/>
        <POSCode>00000000000208</POSCode>
        <POSCodeModifier>000</POSCodeModifier>
      </ItemCode>
      <ITTData>
        <ActiveFlag value="yes"/>
        <MerchandiseCode>19</MerchandiseCode>
        <RegularSellPrice>1.99000</RegularSellPrice>
        <Description>ICEE 16OZ PL</Description>
        <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
        <SalesRestriction>
          <TransactionLimit>0.00</TransactionLimit>
        </SalesRestriction>
        <SellingUnits>1.00000</SellingUnits>
        <PriceRequiredFlag value="yes"/>
      </ITTData>
      <Extension>
        <FeeNumber>0</FeeNumber>
        <Taxes>
          <Tax>1</Tax>
        </Taxes>
      </Extension>
    </ITTDetail>
    <ITTDetail>
      <RecordAction type="addchange"/>
      <ItemCode>
        <POSCodeFormat format="none"/>
        <POSCode>00000000000253</POSCode>
        <POSCodeModifier>000</POSCodeModifier>
      </ItemCode>
      <ITTData>
        <ActiveFlag value="yes"/>
        <MerchandiseCode>20</MerchandiseCode>
        <RegularSellPrice>1.49000</RegularSellPrice>
        <Description>20 OZ HOT COFFEE</Description>
        <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
        <SalesRestriction>
          <TransactionLimit>0.00</TransactionLimit>
        </SalesRestriction>
        <SellingUnits>1.00000</SellingUnits>
        <PriceRequiredFlag value="yes"/>
      </ITTData>
      <Extension>
        <FeeNumber>0</FeeNumber>
        <Taxes>
          <Tax>1</Tax>
        </Taxes>
      </Extension>
    </ITTDetail>
    <ITTDetail>
      <RecordAction type="addchange"/>
      <ItemCode>
        <POSCodeFormat format="none"/>
        <POSCode>00000000000673</POSCode>
        <POSCodeModifier>000</POSCodeModifier>
      </ItemCode>
      <ITTData>
        <ActiveFlag value="yes"/>
        <MerchandiseCode>5</MerchandiseCode>
        <RegularSellPrice>1.99000</RegularSellPrice>
        <Description>GENOA SALAMI</Description>
        <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
        <SalesRestriction>
          <TransactionLimit>0.00</TransactionLimit>
        </SalesRestriction>
        <SellingUnits>1.00000</SellingUnits>
        <PriceRequiredFlag value="yes"/>
      </ITTData>
      <Extension>
        <FeeNumber>0</FeeNumber>
      </Extension>
    </ITTDetail>
    <ITTDetail>
      <RecordAction type="addchange"/>
      <ItemCode>
        <POSCodeFormat format="none"/>
        <POSCode>00000000001779</POSCode>
        <POSCodeModifier>000</POSCodeModifier>
      </ItemCode>
      <ITTData>
        <ActiveFlag value="yes"/>
        <MerchandiseCode>39</MerchandiseCode>
        <RegularSellPrice>1.99000</RegularSellPrice>
        <Description>ICE 7LB PLU1</Description>
        <PaymentSystemsProductCode>400</PaymentSystemsProductCode>
        <SalesRestriction>
          <TransactionLimit>0.00</TransactionLimit>
        </SalesRestriction>
        <SellingUnits>1.00000</SellingUnits>
        <PriceRequiredFlag value="yes"/>
      </ITTData>
      <Extension>
        <FeeNumber>0</FeeNumber>
      </Extension>
    </ITTDetail>
  </ItemMaintenance>
</NAXML-MaintenanceRequest>

To download the XML example with ITT data, click here.