POST api/department/import

Request Information

URI Parameters

None.

Body Parameters

Collection of Department
NameDescriptionTypeAdditional information
ID

integer

None.
Name

string

Required

String length: inclusive between 0 and 60
Code

string

Required

String length: inclusive between 0 and 20
SortOrder

integer

None.
IsLiquor

boolean

Deprecated. Use only IsTobacco field.

IsTobacco

boolean

None.
ExcludeTalker

boolean

None.
ExternalSales

boolean

None.
SaleGLCode

string

String length: inclusive between 0 and 50
COGSGLCode

string

String length: inclusive between 0 and 50
AccountingCategoryID

integer

None.
MaximumMarkdownPercentage

Maximum markdown amount for products with in this department, i.e. This percent each time

 decimal number

None.
AccountingOnly

Excludes department from reporting

 boolean

None.
GenerateExternalID

integer

None.
UseNonReportableTaxCode

When set to true, the MyOB accounting integration will use the non reportable tax code when exporting sales for this department.

 boolean

None.
MinPLU

integer

None.
MaxPLU

integer

None.
ScaleLocation

Default Location for new Scale PLUs in this Department, can be overridden at Product level

 ScaleLocation

Relation. This field may not always be loaded or used for updates.
SubDepartments

Collection of SubDepartment

Relation. This field may not always be loaded or used for updates.
Stores

Collection of integer

Relation. This field may not always be loaded or used for updates.
InvestmentBuyOverride

Store size configuration has been overridden for this department

 boolean

Relation. This field may not always be loaded or used for updates.
Updated

date

None.
SalesMode

SalesMode

None.
GSTPercent

integer

None.
CostGSTPercent

integer

None.
EarnLoyaltyPoints

boolean

None.
QuantityOverride

boolean

None.
QuantityRequired

boolean

None.
AllowDiscounts

boolean

None.
DiscountDiscounts

boolean

None.
ItemRecalled

boolean

None.
NoRefund

boolean

None.
Active

boolean

None.
AllowMarkdown

boolean

None.
DefaultGP

decimal number

None.
LabelShelfDefault

integer

None.
LabelTalkerDefault

integer

None.
LabelSmall

boolean

None.
Tags

string

None.
UnitMeasureKind

integer

None.
FuelItem

boolean

None.
TrackSerial

boolean

None.
WarrantyPeriod

integer

None.
CostCalcMethod

CostCalcMethod

None.
ProviderName

string

None.
OverrideHostMargin

boolean

None.
KeepDescription

when false, changes to HostDescription should flow to receipt Name. (OverrideHostDescription)

 boolean

None.
MSCCommodity

string

None.
AllowAutoOrder

boolean

None.
ExcludeFromWebUpdate

boolean

None.
WebPriceBasedOn

boolean

None.
LabelFormat

string

None.
SendToScale

boolean

None.
LabelPageLayoutG_UID

Collection of byte

None.
LabelPageLayoutGuid

globally unique identifier

None.
MinimumAge

Only a default on the Department table

 integer

Relation. This field may not always be loaded or used for updates.
CountryOfOrigin

string

Relation. This field may not always be loaded or used for updates.
ServiceFeeID

Only a default on the Department table

 integer

None.
EftCode

Only a default on the Department and SubDepartment table

 integer

None.
DefaultPrinter

Only a default on the Department and SubDepartment table

 string

String length: inclusive between 0 and 60
DefaultPrinterGroup

Only a default on the Department and SubDepartment table

 string

String length: inclusive between 0 and 60
BuyingLimit

Buying Limit for Department. Below are possible values NULL=Dept/SubDept Limit will be used 0=Unlimited - Regardless of Dept/SubDept limits +ve integer

 integer

None.
BuyingLimitIndependent

This indicates if buying limit is independent from other limits like Product/PriceGroup. If yes, limit does not count towards other limits like Product/PriceGroup limit. For example, if toilet paper has BuyingLimit=1 and Grocery Dept has BuyingLimit=2 - if true, transaction may have 1xTP and 2xGrocery - if false, 1xTP and 1xGrocery

 boolean

None.
BuyingLimitType

It indicates whether limit applies to category or item

 BuyingLimitType

None.
IncludeInDistinctLimit

It indicates whether this limit includes in distinct store level limit

 boolean

None.
DefaultsEmpty

boolean

None.
MSCCat

MSCCategory

Relation. This field may not always be loaded or used for updates.
MSCCom

MSCCommodity

Relation. This field may not always be loaded or used for updates.
MSCDep

MSCDepartment

Relation. This field may not always be loaded or used for updates.
MSCSubCom

MSCSubCommodity

Relation. This field may not always be loaded or used for updates.

Request Formats

application/json, text/json

Sample: 
[
  {
    "$id": "1",
    "id": 1,
    "name": "sample string 2",
    "code": "sample string 3",
    "sortOrder": 4,
    "isLiquor": true,
    "isTobacco": true,
    "excludeTalker": true,
    "externalSales": true,
    "saleGLCode": "sample string 9",
    "cogsglCode": "sample string 10",
    "accountingCategoryID": 11,
    "maximumMarkdownPercentage": 12.0,
    "accountingOnly": true,
    "generateExternalID": 1,
    "useNonReportableTaxCode": true,
    "minPLU": 15,
    "maxPLU": 16,
    "scaleLocation": {
      "$id": "2",
      "id": 1,
      "deptNo": 1,
      "deptCode": "sample string 2",
      "name": "sample string 3",
      "enabled": true,
      "updated": "2025-08-02T23:12:59.9628666",
      "department": {
        "$ref": "1"
      }
    },
    "subDepartments": [
      {
        "$id": "3",
        "id": 1,
        "departmentID": 2,
        "name": "sample string 3",
        "code": "sample string 4",
        "departmentCode": "sample string 5",
        "externalSales": true,
        "minorDepartments": [
          {
            "$id": "4",
            "id": 1,
            "subDepartmentID": 2,
            "departmentID": 3,
            "name": "sample string 4",
            "subDepartmentCode": "sample string 5",
            "departmentCode": "sample string 6",
            "code": "sample string 7",
            "lesserDepartments": [
              {
                "$id": "5",
                "id": 1,
                "departmentID": 2,
                "subDepartmentID": 3,
                "minorDepartmentID": 4,
                "name": "sample string 5",
                "code": "sample string 6",
                "departmentCode": "sample string 7",
                "subDepartmentCode": "sample string 8",
                "minorDepartmentCode": "sample string 9",
                "updated": "2025-08-02T23:12:59.9628666",
                "salesMode": 1,
                "gstPercent": 1,
                "costGSTPercent": 1,
                "earnLoyaltyPoints": true,
                "quantityOverride": true,
                "quantityRequired": true,
                "allowDiscounts": true,
                "discountDiscounts": true,
                "itemRecalled": true,
                "noRefund": true,
                "active": true,
                "allowMarkdown": true,
                "defaultGP": 1.1,
                "labelShelfDefault": 1,
                "labelTalkerDefault": 1,
                "labelSmall": true,
                "tags": "sample string 11",
                "unitMeasureKind": 1,
                "fuelItem": true,
                "trackSerial": true,
                "warrantyPeriod": 1,
                "costCalcMethod": 1,
                "providerName": "sample string 12",
                "overrideHostMargin": true,
                "keepDescription": true,
                "mscCommodity": "sample string 15",
                "allowAutoOrder": true,
                "excludeFromWebUpdate": true,
                "webPriceBasedOn": true,
                "labelFormat": "sample string 16",
                "sendToScale": true,
                "labelPageLayoutG_UID": "OZMxuBdCNk2O5YDD94Aedg==",
                "labelPageLayoutGuid": "b8319339-4217-4d36-8ee5-80c3f7801e76",
                "minimumAge": 17,
                "countryOfOrigin": "sample string 18",
                "serviceFeeID": 1,
                "eftCode": 19,
                "defaultPrinter": "sample string 20",
                "defaultPrinterGroup": "sample string 21",
                "buyingLimit": 1,
                "buyingLimitIndependent": true,
                "buyingLimitType": 0,
                "includeInDistinctLimit": true,
                "defaultsEmpty": false,
                "mscCat": {
                  "$id": "6",
                  "dept": 1,
                  "category": 2,
                  "name": "sample string 3",
                  "active": true,
                  "mscCommodities": [
                    {
                      "$id": "7",
                      "dept": 1,
                      "category": 2,
                      "commodity": 3,
                      "name": "sample string 4",
                      "active": true,
                      "mscSubCommodities": [
                        {
                          "$id": "8",
                          "dept": 1,
                          "category": 2,
                          "commodity": 3,
                          "subCommodity": 4,
                          "name": "sample string 5",
                          "active": true,
                          "subCommodityCode": "sample string 7"
                        },
                        {
                          "$ref": "8"
                        }
                      ],
                      "commodityCode": "sample string 6"
                    },
                    {
                      "$ref": "7"
                    }
                  ],
                  "categoryCode": "sample string 5"
                },
                "mscCom": {
                  "$ref": "7"
                },
                "mscDep": {
                  "$id": "9",
                  "dept": 1,
                  "name": "sample string 2",
                  "active": true,
                  "mscCategories": [
                    {
                      "$ref": "6"
                    },
                    {
                      "$ref": "6"
                    }
                  ],
                  "deptCode": "sample string 4"
                },
                "mscSubCom": {
                  "$ref": "8"
                }
              },
              {
                "$ref": "5"
              }
            ],
            "updated": "2025-08-02T23:12:59.9628666",
            "salesMode": 1,
            "gstPercent": 1,
            "costGSTPercent": 1,
            "earnLoyaltyPoints": true,
            "quantityOverride": true,
            "quantityRequired": true,
            "allowDiscounts": true,
            "discountDiscounts": true,
            "itemRecalled": true,
            "noRefund": true,
            "active": true,
            "allowMarkdown": true,
            "defaultGP": 1.1,
            "labelShelfDefault": 1,
            "labelTalkerDefault": 1,
            "labelSmall": true,
            "tags": "sample string 9",
            "unitMeasureKind": 1,
            "fuelItem": true,
            "trackSerial": true,
            "warrantyPeriod": 1,
            "costCalcMethod": 1,
            "providerName": "sample string 10",
            "overrideHostMargin": true,
            "keepDescription": true,
            "mscCommodity": "sample string 13",
            "allowAutoOrder": true,
            "excludeFromWebUpdate": true,
            "webPriceBasedOn": true,
            "labelFormat": "sample string 14",
            "sendToScale": true,
            "labelPageLayoutG_UID": "EW3ARoAWrkOZna1jcTuegA==",
            "labelPageLayoutGuid": "46c06d11-1680-43ae-999d-ad63713b9e80",
            "minimumAge": 15,
            "countryOfOrigin": "sample string 16",
            "serviceFeeID": 1,
            "eftCode": 17,
            "defaultPrinter": "sample string 18",
            "defaultPrinterGroup": "sample string 19",
            "buyingLimit": 1,
            "buyingLimitIndependent": true,
            "buyingLimitType": 0,
            "includeInDistinctLimit": true,
            "defaultsEmpty": false,
            "mscCat": {
              "$ref": "6"
            },
            "mscCom": {
              "$ref": "7"
            },
            "mscDep": {
              "$ref": "9"
            },
            "mscSubCom": {
              "$ref": "8"
            }
          },
          {
            "$ref": "4"
          }
        ],
        "investmentBuyOverride": true,
        "updated": "2025-08-02T23:12:59.9628666",
        "salesMode": 1,
        "gstPercent": 1,
        "costGSTPercent": 1,
        "earnLoyaltyPoints": true,
        "quantityOverride": true,
        "quantityRequired": true,
        "allowDiscounts": true,
        "discountDiscounts": true,
        "itemRecalled": true,
        "noRefund": true,
        "active": true,
        "allowMarkdown": true,
        "defaultGP": 1.1,
        "labelShelfDefault": 1,
        "labelTalkerDefault": 1,
        "labelSmall": true,
        "tags": "sample string 9",
        "unitMeasureKind": 1,
        "fuelItem": true,
        "trackSerial": true,
        "warrantyPeriod": 1,
        "costCalcMethod": 1,
        "providerName": "sample string 10",
        "overrideHostMargin": true,
        "keepDescription": true,
        "mscCommodity": "sample string 13",
        "allowAutoOrder": true,
        "excludeFromWebUpdate": true,
        "webPriceBasedOn": true,
        "labelFormat": "sample string 14",
        "sendToScale": true,
        "labelPageLayoutG_UID": "dNE3L+8Nr02NKFVf8lQwEA==",
        "labelPageLayoutGuid": "2f37d174-0def-4daf-8d28-555ff2543010",
        "minimumAge": 15,
        "countryOfOrigin": "sample string 16",
        "serviceFeeID": 1,
        "eftCode": 17,
        "defaultPrinter": "sample string 18",
        "defaultPrinterGroup": "sample string 19",
        "buyingLimit": 1,
        "buyingLimitIndependent": true,
        "buyingLimitType": 0,
        "includeInDistinctLimit": true,
        "defaultsEmpty": false,
        "mscCat": {
          "$ref": "6"
        },
        "mscCom": {
          "$ref": "7"
        },
        "mscDep": {
          "$ref": "9"
        },
        "mscSubCom": {
          "$ref": "8"
        }
      },
      {
        "$ref": "3"
      }
    ],
    "stores": [
      1,
      2
    ],
    "investmentBuyOverride": true,
    "updated": "2025-08-02T23:12:59.9784634",
    "salesMode": 1,
    "gstPercent": 1,
    "costGSTPercent": 1,
    "earnLoyaltyPoints": true,
    "quantityOverride": true,
    "quantityRequired": true,
    "allowDiscounts": true,
    "discountDiscounts": true,
    "itemRecalled": true,
    "noRefund": true,
    "active": true,
    "allowMarkdown": true,
    "defaultGP": 1.1,
    "labelShelfDefault": 1,
    "labelTalkerDefault": 1,
    "labelSmall": true,
    "tags": "sample string 19",
    "unitMeasureKind": 1,
    "fuelItem": true,
    "trackSerial": true,
    "warrantyPeriod": 1,
    "costCalcMethod": 1,
    "providerName": "sample string 20",
    "overrideHostMargin": true,
    "keepDescription": true,
    "mscCommodity": "sample string 23",
    "allowAutoOrder": true,
    "excludeFromWebUpdate": true,
    "webPriceBasedOn": true,
    "labelFormat": "sample string 24",
    "sendToScale": true,
    "labelPageLayoutG_UID": "Z2CDS2Yi80+3EhRDkbGShQ==",
    "labelPageLayoutGuid": "4b836067-2266-4ff3-b712-144391b19285",
    "minimumAge": 25,
    "countryOfOrigin": "sample string 26",
    "serviceFeeID": 1,
    "eftCode": 27,
    "defaultPrinter": "sample string 28",
    "defaultPrinterGroup": "sample string 29",
    "buyingLimit": 1,
    "buyingLimitIndependent": true,
    "buyingLimitType": 0,
    "includeInDistinctLimit": true,
    "defaultsEmpty": false,
    "mscCat": {
      "$ref": "6"
    },
    "mscCom": {
      "$ref": "7"
    },
    "mscDep": {
      "$ref": "9"
    },
    "mscSubCom": {
      "$ref": "8"
    }
  },
  {
    "$ref": "1"
  }
]

application/xml

Sample:

Sample not available.

text/xml

Sample:

Sample not available.

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

Collection of boolean

Response Formats

application/json, text/json

Sample: 
[
  true,
  true
]

application/xml, text/xml

Sample: 
<ArrayOfboolean xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
  <boolean>true</boolean>
  <boolean>true</boolean>
</ArrayOfboolean>

text/csv

Sample:

Sample not available.

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Sample: 
PK��[/�w^�5xl/workbook.xml �(�����0��&�C��� F��x��}-�4П�5��$޼���~;�d��4f 5j_���!؂1/zT�OƢ���8!J�b���ƈ�BX�y���Ѿ��ӕ��[���1�qE)����!���!q��Vw6	[C�7U.��bQD�Š6��Ź�M(q���=��ʓ�,8ϲ�C{��l�]PK��[����	�[Content_Types].xml �(����J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
��[���x''_rels/.rels �(�<?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="R3b087e5fdee44f44" /></Relationships>PK��[ˇ]e'xl/worksheets/sheet1.xml �(��Q�n� ~�}%��j��T��j�M;lg�85����?�H]��`��c�r{u��@�}%�U&�[�O��{x�ۺ�0�� �p7���h�(N������4qN
��6��ft�IY�VzMl��\�����M%�~�r�zY��e��z���.��
)T]&�)��b��x�����Yª_�C2��N�=}��
�d���8
�1���ytR8}M�d[2�|Y�ٺ`t3FB��\��BO^{M�.N"�gV���1UȦGn�R祺�\^�q�N�'G�y*�"AHU�>��PK��[>%6�Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞�N����vÆm�F�8��ؑ�=�����ĂMW��==i���c��F�B>�6 3��v�`���<�a��hĘ&B?́��c�7��ӄ!s3��1�OS�;>�>aG<��~ɀ[&;^f��3hzt�<�������E`G��~J�_���S��A����K-�R�
�񻩅x)�z}�������R�(�tW�=��ѧK/�����\�
�b�+��U�����PK��[Ѓc'2E
xl/styles.xml �(��S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v�F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}���LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK��[�/���xl/sharedStrings.xml �(�5�A� �B�nA�h&�@@ڵ����������d2;}Ҧ�X9frp(�9/�V���p��i�[&t�E5��YTO��r՚���R7�\���u�\*����M��9��#��s#qЧ��������~PK-��[/�w^�5xl/workbook.xmlPK-��[����	�[Content_Types].xmlPK-
��[���x''V_rels/.relsPK-��[ˇ]e'�xl/worksheets/sheet1.xmlPK-��[>%6�P;xl/_rels/workbook.xml.relsPK-��[Ѓc'2E
�xl/styles.xmlPK-��[�/����xl/sharedStrings.xmlPK��

application/vnd.ms-excel

Sample: 
PK��[���W�5xl/workbook.xml �(���;�0D{$�`�8�"rR������kld�㓏��ngv�����W���|��R�s5cIh��N>��v�Gy��ɼRF`��ۢˬ,��E �6!ѕ�+�� �F�vXQ����@��=�i���՝M���M��_,�8���2P�87��3%�6�p�@)){!EU^q�;{�q��n�PK��[����	�[Content_Types].xml �(����J�0�_��*M�D��V�*��d�
�d�k��<�H���V���=
��|�o��|����������+�����7l���e۶~=E�"�zlXO�@Ճ��C�3]HNR~���R��uU�<���������a��36��b7םQ
�1Z�$�8z�R��3
tP��-c�� g����_M��Of���~O�s�T���� ����P<�D��e=1Z��a2�b
��%#H'�2}���e�B)��~j/F�t��PK
��[qc��''_rels/.rels �(�<?xml version="1.0" encoding="utf-8"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml" Id="Ra78c537cf78e4896" /></Relationships>PK��[ˇ]e'xl/worksheets/sheet1.xml �(��Q�n� ~�}%��j��T��j�M;lg�85����?�H]��`��c�r{u��@�}%�U&�[�O��{x�ۺ�0�� �p7���h�(N������4qN
��6��ft�IY�VzMl��\�����M%�~�r�zY��e��z���.��
)T]&�)��b��x�����Yª_�C2��N�=}��
�d���8
�1���ytR8}M�d[2�|Y�ٺ`t3FB��\��BO^{M�.N"�gV���1UȦGn�R祺�\^�q�N�'G�y*�"AHU�>��PK��[�q�[�Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞���4U�nذ-���g���m�.г��H\�H�J,�t5��ӓf>�?6��yb/��hMy&��QV�����n��f���i"�,�����[sԀ��uhR���eL�﹓�({�5�K\3����?DK4*|��4�������0 F`�{�����<KT`���}-��~VZ�E%T	��L-�����;_��V�f�H���ʦ��� =��ӥ�N��B-���l놊\VD�Ư�b�PK��[Ѓc'2E
xl/styles.xml �(��S�j�0��&0���0�^�]v��:��d;��H��Kj�vG�Mz�zOHr�iB8v�F��WEG�?s�Oh�lff�uZМ���ށh�R���6�'��2��������ɳ�UŦ`<Қo���x���8��K�6BC ^�کĖ��B���n��f8����9� ����CUk��#��U�ub��WUB;��k���&�
AR>��� ��im��ΑF���YO��%�}���LJ\in�,���9oy}��y.�$��6��ųNJ�c��T��rĘ)փBR淶�E3ʟ�\��q��PK��[�/���xl/sharedStrings.xml �(�5�A� �B�nA�h&�@@ڵ����������d2;}Ҧ�X9frp(�9/�V���p��i�[&t�E5��YTO��r՚���R7�\���u�\*����M��9��#��s#qЧ��������~PK-��[���W�5xl/workbook.xmlPK-��[����	��[Content_Types].xmlPK-
��[qc��''T_rels/.relsPK-��[ˇ]e'�xl/worksheets/sheet1.xmlPK-��[�q�[�P9xl/_rels/workbook.xml.relsPK-��[Ѓc'2E
xl/styles.xmlPK-��[�/����xl/sharedStrings.xmlPK��