GET api/product/{id}/orderLookup
Order History information
Request Information
URI Parameters
Name | Description | Type | Additional information |
---|---|---|---|
id |
Product identifier |
globally unique identifier |
Required |
Body Parameters
None.
Response Information
Resource Description
Order detail and history information
OrderDetailLookupName | Description | Type | Additional information |
---|---|---|---|
PLUG_UID | Collection of byte |
None. |
|
PluGuid | globally unique identifier |
None. |
|
InventoryGuid | Collection of byte |
None. |
|
InventoryIdentifier | globally unique identifier |
None. |
|
AverageWeeklySales | decimal number |
None. |
|
PromotionalAverageWeeklySales | decimal number |
None. |
|
InventoryAverageWeeklySales | decimal number |
None. |
|
InventoryPromotionalAverageWeeklySales | decimal number |
None. |
|
OnHand | integer |
None. |
|
OnHandPacks | integer |
None. |
|
OnOrder | integer |
None. |
|
OnOrderPacks | integer |
None. |
|
Accuracy | integer |
None. |
|
LastOrdered | date |
None. |
|
LastOrderQuantity | decimal number |
None. |
|
LastReceived | date |
None. |
|
LastReceivedQuantity | decimal number |
None. |
|
LastInvoiceStatus | ProductStatus |
None. |
Response Formats
application/json, text/json
Sample:
{ "pluG_UID": "MVQu3/MuMUO/ipKtWK9Kdg==", "pluGuid": "df2e5431-2ef3-4331-bf8a-92ad58af4a76", "inventoryGuid": "95vvrink2kact/TyKeAyQg==", "inventoryIdentifier": "aeef9bf7-e429-46da-9cb7-f4f229e03242", "averageWeeklySales": 1.0, "promotionalAverageWeeklySales": 1.0, "inventoryAverageWeeklySales": 1.0, "inventoryPromotionalAverageWeeklySales": 1.0, "onHand": 1, "onHandPacks": 1, "onOrder": 1, "onOrderPacks": 1, "accuracy": 1, "lastOrdered": "2025-10-04T23:59:27.4400305", "lastOrderQuantity": 1.1, "lastReceived": "2025-10-04T23:59:27.4400305", "lastReceivedQuantity": 1.1, "lastInvoiceStatus": 1 }
application/xml, text/xml
Sample:
<OrderDetailLookup xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.Orders"> <Accuracy>1</Accuracy> <AverageWeeklySales>1</AverageWeeklySales> <InventoryAverageWeeklySales>1</InventoryAverageWeeklySales> <InventoryGuid>95vvrink2kact/TyKeAyQg==</InventoryGuid> <InventoryIdentifier>aeef9bf7-e429-46da-9cb7-f4f229e03242</InventoryIdentifier> <InventoryPromotionalAverageWeeklySales>1</InventoryPromotionalAverageWeeklySales> <LastInvoiceStatus>1</LastInvoiceStatus> <LastOrderQuantity>1.1</LastOrderQuantity> <LastOrdered>2025-10-04T23:59:27.4400305+00:00</LastOrdered> <LastReceived>2025-10-04T23:59:27.4400305+00:00</LastReceived> <LastReceivedQuantity>1.1</LastReceivedQuantity> <OnHand>1</OnHand> <OnHandPacks>1</OnHandPacks> <OnOrder>1</OnOrder> <OnOrderPacks>1</OnOrderPacks> <PLUG_UID>MVQu3/MuMUO/ipKtWK9Kdg==</PLUG_UID> <PluGuid>df2e5431-2ef3-4331-bf8a-92ad58af4a76</PluGuid> <PromotionalAverageWeeklySales>1</PromotionalAverageWeeklySales> </OrderDetailLookup>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK m�D[<q迶 5 xl/workbook.xml � (� ����@�{��r��䠢���_a��O�����O ��ۙ��v�h\�4�g5h���w!���)�'cIO��8�a���meM��ߊt�$�2p4`�F�NZ�W�?,oa�;����Pj^����C��9[��d���7%�~�(�QQ�+���ܚ�ǜ�\N�=N)����5M�Q���l��/PK m�D[���� � [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 m�D[��;' ' _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="R90d6ae1cc56e48e1" /></Relationships>PK m�D[Eyx� � xl/worksheets/sheet1.xml � (� ��Is�0�������ڕRIY&+���Dpc�vB~�c���\@���k��J0:��6ΧN�0ގ]����"^�۷����~H�|2���{��:s�Mϒ��βݙ溜���ԋwzkj�8���<&o~�Z�=���f>F�����i���]�ݾ��,�-D��U�[w2Z����{'ѫ�{gs�:�d�ÿB�Okk��&����p��(g�<˛�$�R���M6���:|[gfH,�,�M�:Qx��D�W����ڬ��8�R�@(�:��4���E�t9�q��'=0B%%�BbjדBO���� ��R!�zZ�i�?bS)��@�]� =��+�Qΰ\I%���?�(A �A�^zq�c�)�� !0��e��U�W�@c���U�W'��"��*���A�0bN +6�Nу�]����(N�@�8��R�m�L�KJ <pnP��������"l���A-{�s"(2�����=��Z��9E��>�0�:�2�P%��)��`�`����"�o�i��Q�$/����,���3�Wj.�� ��mA\v hW]7�i� M�K�&1��I�t �$n��hw]B6��.���Ϟ����Ѓ������ԃ���܃��҃�&�ڃ�F;�A���&x���*}�+j���i��j�e�Ep�H�K�'�3K��R����,�{K���`�=ZjO�e�P���8&@e}n�x�����^�F���s��n����Yg:�����_PK m�D[ �d� P xl/_rels/workbook.xml.rels � (� ��Mn� F��f_���(N6�t��ۊ Hۜ���W(j��H]t��o��i������m��:?�C�1 ����z8����v�Ǚ�xÏ��$>Ѿ�1��ԋ�3cQǎ2n�!�n�����5ԥ�e�����F�I��u�L_�;�1 9p7`��'���ȳH�${��59�vuQ1� �wS��2����։�۲æ)U%e}W��;����M�Ni���U�*K�u�:���Ϳ�~PK m�D[Ѓc'2 E 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 m�D[{z�d ^ xl/sharedStrings.xml � (� ��kK�0��J���[Vw���u x��"r��l�6�����(:�+�����yxONHv�V������l����R�U����E��H(���5�YtTd�SP�s�&�&�k����Mp�uP8�U�7A�5"Ue���QR�6,�6�3>`Qm�k��;!D�"���jqe Y�}�e}Qkٖgf���k~5g2�Zit��0X��K�̡D��le)�ʿ�w��(�W����ӭހx� ��ܿ��܉Q;M[�O��5��nk��N��m7���Ƈ�Y-pN@�^���V�����mJ�� b�j�ð[� �S�`*��� ��.�8ƔO�t$C�X�c�*Χ���0I� �;PK- m�D[<q迶 5 xl/workbook.xmlPK- m�D[���� � � [Content_Types].xmlPK- m�D[��;' ' U _rels/.relsPK- m�D[Eyx� � � xl/worksheets/sheet1.xmlPK- m�D[ �d� P xl/_rels/workbook.xml.relsPK- m�D[Ѓc'2 E G xl/styles.xmlPK- m�D[{z�d ^ � xl/sharedStrings.xmlPK � r
application/vnd.ms-excel
Sample:
PK m�D[m�˶� 5 xl/workbook.xml � (� ����0D�&�C���(R8q���{�Eh�ik��-H�yۙ�};bB7<�ѣ�+i�-�MZ�Z0qס�2D�^�N5Pc��`;'I��2(4�W�ӕ��[��=@���RZ����C�����l���oJ,��bQ�H %�e��,έ-)��*�,�y�r�d�撤q��w�`���PK m�D[���� � [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 m�D[���' ' _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="Ra9f6146d2d2b434a" /></Relationships>PK m�D[Eyx� � xl/worksheets/sheet1.xml � (� ��Is�0�������ڕRIY&+���Dpc�vB~�c���\@���k��J0:��6ΧN�0ގ]����"^�۷����~H�|2���{��:s�Mϒ��βݙ溜���ԋwzkj�8���<&o~�Z�=���f>F�����i���]�ݾ��,�-D��U�[w2Z����{'ѫ�{gs�:�d�ÿB�Okk��&����p��(g�<˛�$�R���M6���:|[gfH,�,�M�:Qx��D�W����ڬ��8�R�@(�:��4���E�t9�q��'=0B%%�BbjדBO���� ��R!�zZ�i�?bS)��@�]� =��+�Qΰ\I%���?�(A �A�^zq�c�)�� !0��e��U�W�@c���U�W'��"��*���A�0bN +6�Nу�]����(N�@�8��R�m�L�KJ <pnP��������"l���A-{�s"(2�����=��Z��9E��>�0�:�2�P%��)��`�`����"�o�i��Q�$/����,���3�Wj.�� ��mA\v hW]7�i� M�K�&1��I�t �$n��hw]B6��.���Ϟ����Ѓ������ԃ���܃��҃�&�ڃ�F;�A���&x���*}�+j���i��j�e�Ep�H�K�'�3K��R����,�{K���`�=ZjO�e�P���8&@e}n�x�����^�F���s��n����Yg:�����_PK m�D[S�\� P xl/_rels/workbook.xml.rels � (� ��Kn�0@�b;��LB*�n�.0u�IDbG�i�l]�H�B�"�F�V��==i���c�=O#{%g�� FV�v�]�hV�ݬw4bL���Ҋ �1Ώ��ӄ�p3��1�OS�;>�>bG|!D�}[&;\f��3hzr�4��������E`��~J�Y$*�綁]Uײm��R+QJ`�nj!^F �^�<�)�~)uE5��������G�.�;��LMJ��HY)�R�����|PK m�D[Ѓc'2 E 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 m�D[{z�d ^ xl/sharedStrings.xml � (� ��kK�0��J���[Vw���u x��"r��l�6�����(:�+�����yxONHv�V������l����R�U����E��H(���5�YtTd�SP�s�&�&�k����Mp�uP8�U�7A�5"Ue���QR�6,�6�3>`Qm�k��;!D�"���jqe Y�}�e}Qkٖgf���k~5g2�Zit��0X��K�̡D��le)�ʿ�w��(�W����ӭހx� ��ܿ��܉Q;M[�O��5��nk��N��m7���Ƈ�Y-pN@�^���V�����mJ�� b�j�ð[� �S�`*��� ��.�8ƔO�t$C�X�c�*Χ���0I� �;PK- m�D[m�˶� 5 xl/workbook.xmlPK- m�D[���� � [Content_Types].xmlPK- m�D[���' ' V _rels/.relsPK- m�D[Eyx� � � xl/worksheets/sheet1.xmlPK- m�D[S�\� P xl/_rels/workbook.xml.relsPK- m�D[Ѓc'2 E G xl/styles.xmlPK- m�D[{z�d ^ � xl/sharedStrings.xmlPK � r