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. |
|
InventoryAverageWeeklySales | 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": "vSyXqwwl6k+EJF/079PRqA==", "pluGuid": "ab972cbd-250c-4fea-8424-5ff4efd3d1a8", "inventoryGuid": "Sl9TVgPo1UeHbOuVTKIkcQ==", "inventoryIdentifier": "56535f4a-e803-47d5-876c-eb954ca22471", "averageWeeklySales": 1.0, "inventoryAverageWeeklySales": 1.0, "onHand": 1, "onHandPacks": 1, "onOrder": 1, "onOrderPacks": 1, "accuracy": 1, "lastOrdered": "2025-08-02T23:17:51.6453137", "lastOrderQuantity": 1.1, "lastReceived": "2025-08-02T23:17:51.6453137", "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>Sl9TVgPo1UeHbOuVTKIkcQ==</InventoryGuid> <InventoryIdentifier>56535f4a-e803-47d5-876c-eb954ca22471</InventoryIdentifier> <LastInvoiceStatus>1</LastInvoiceStatus> <LastOrderQuantity>1.1</LastOrderQuantity> <LastOrdered>2025-08-02T23:17:51.6453137+00:00</LastOrdered> <LastReceived>2025-08-02T23:17:51.6453137+00:00</LastReceived> <LastReceivedQuantity>1.1</LastReceivedQuantity> <OnHand>1</OnHand> <OnHandPacks>1</OnHandPacks> <OnOrder>1</OnOrder> <OnOrderPacks>1</OnOrderPacks> <PLUG_UID>vSyXqwwl6k+EJF/079PRqA==</PLUG_UID> <PluGuid>ab972cbd-250c-4fea-8424-5ff4efd3d1a8</PluGuid> </OrderDetailLookup>
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Sample:
PK 9�[K�1<� 5 xl/workbook.xml � (� ����0D�&�C��"�N\�z4Ж�5��B $��ξ>Z�=���G����mC��-j�;��v�: a��Ŭ�J`m�[� �t<��aAY�[5x���a��!4�E�_P���~G��=�>��X��&aK���x�mQKZC J�skJ�P� 5 ��#f��<�L\S��7g���PK 9�[���� � [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 9�[m�P�' ' _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="R79dda43bb9dc4b5b" /></Relationships>PK 9�[z���� � xl/worksheets/sheet1.xml � (� ��Yo�0�� �}���JR�Mӽ��a�I��p���C �EЙ���~��\]1����ΧN���S�::^�u�O�}��!����`��4�:s,��� �lw�y�*Б��ӱ�mL��}L�=�ل+=7�}����r/�[?�[�A�Kݣ�w��]��uq�h{���0vg�uh���;��L�+t�Į��&�+ԇ�l��o�ǘ���a=ua�zxQl�L�����m���u�d�I�Ь�6-~�(�[�:��U��u��N)� %\g�O3�.˕�Q�K=>� � *!�B��a=)��|%9Pp)���RO��%@�3J�T�4�g����+�(gX ��lX�K=?� Jq���Y�a�(��W Q��N�:ٸ7� #�gX15�W�^��V����@�Q�P)q8E��mOL�)�ȝ�*t�N� �nf��5q�b��r'� �A�}6�P��=C=TgC{��sHa�9r�� �Ӈ8���`�`����(&�����$1')��?_]�eZ�;:R;�>gp�}�ڒ���I�t �$�]�4��.A�ĢK�&q�%x����I<t �$��jO=k5��iu��i���i���i5vكԝ�ldN��unpW�j�u���˼i��m��ds1P����j������y�2)�R��l�aZF��7z4Z�����l���G'c2�S��96�PK 9�[��N�� P xl/_rels/workbook.xml.rels � (� ��An� E��f_c��Q�l��6�&x�����ٺ�z��Tj��n�B���f�|���ަ����5 Y����`��Q?T��n�4bL7B?����ctk�iYG&u���T��;T'�/��~[&;\��h�=Zu���?����S�"���b?Q�ף��S����J"I�JKU`�nj!^F �^��L�֨IhQ�ڥԢ��L�����Ӧ�N�x>�EYKQ�Q.�j��_l� PK 9�[Ѓ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 9�[Td�W � xl/sharedStrings.xml � (� ��QO�0������16fA�HB��c̥����ö#��[ b2&>5=�~�''�GE�PiQʄt;qP���I���F��$�����5qFi��q,*uB���\W�-�;��u�R`�Um\�W\oM�������$++i��!q*)�+�9 v�Hc�.f���jz�&��/��դ�)O��)U}ќr{�L�j��m��g�]^/!G��#����m�]] ۵ s��C�Vd�X���M}�|Sx�d=T`k0��#2�v�ǻ�ۚJ�pi�Tg���6Xt�k�/�M�Á�֜���h�!�(�fY���.DM&쇽0�b��h0�!�}Fq=����ko� PK- 9�[K�1<� 5 xl/workbook.xmlPK- 9�[���� � � [Content_Types].xmlPK- 9�[m�P�' ' U _rels/.relsPK- 9�[z���� � � xl/worksheets/sheet1.xmlPK- 9�[��N�� P � xl/_rels/workbook.xml.relsPK- 9�[Ѓc'2 E xl/styles.xmlPK- 9�[Td�W � � xl/sharedStrings.xmlPK � 6
application/vnd.ms-excel
Sample:
PK 9�[�E�� 5 xl/workbook.xml � (� ����0��&�C��@Q��x��}��4П�5��$���~;�d��3���/\E�l��=*�'cQ�]g���{1�uR`c�[�,K�s8B�F�^ZOW�?,o����A�+J�Դ>)�f��_d4���I�b��r���"V�� �,��YєW�8ܯ۔�9$"�;�ѝ��J����PK 9�[���� � [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 9�[>+�' ' _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="Re4b4bd57c5394019" /></Relationships>PK 9�[z���� � xl/worksheets/sheet1.xml � (� ��Yo�0�� �}���JR�Mӽ��a�I��p���C �EЙ���~��\]1����ΧN���S�::^�u�O�}��!����`��4�:s,��� �lw�y�*Б��ӱ�mL��}L�=�ل+=7�}����r/�[?�[�A�Kݣ�w��]��uq�h{���0vg�uh���;��L�+t�Į��&�+ԇ�l��o�ǘ���a=ua�zxQl�L�����m���u�d�I�Ь�6-~�(�[�:��U��u��N)� %\g�O3�.˕�Q�K=>� � *!�B��a=)��|%9Pp)���RO��%@�3J�T�4�g����+�(gX ��lX�K=?� Jq���Y�a�(��W Q��N�:ٸ7� #�gX15�W�^��V����@�Q�P)q8E��mOL�)�ȝ�*t�N� �nf��5q�b��r'� �A�}6�P��=C=TgC{��sHa�9r�� �Ӈ8���`�`����(&�����$1')��?_]�eZ�;:R;�>gp�}�ڒ���I�t �$�]�4��.A�ĢK�&q�%x����I<t �$��jO=k5��iu��i���i���i5vكԝ�ldN��unpW�j�u���˼i��m��ds1P����j������y�2)�R��l�aZF��7z4Z�����l���G'c2�S��96�PK 9�[%�b� P xl/_rels/workbook.xml.rels � (� ��KN�0@�b͞8q�&EM�a�m��=��&vd����G� XEWb�������4����M#9���TE �tj�}��Z�n�{EL�s iņL��#�A�D(܌6u��)�=��<�)+�%�9n��p��?D�� ���ӄ6�����A�@��;�)z U��@v��}S�KU/jQJ�ùл��x1�z}癌f�]r�b��8 qW#<���ӥs������E#�U�5�W5z��/PK 9�[Ѓ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 9�[Td�W � xl/sharedStrings.xml � (� ��QO�0������16fA�HB��c̥����ö#��[ b2&>5=�~�''�GE�PiQʄt;qP���I���F��$�����5qFi��q,*uB���\W�-�;��u�R`�Um\�W\oM�������$++i��!q*)�+�9 v�Hc�.f���jz�&��/��դ�)O��)U}ќr{�L�j��m��g�]^/!G��#����m�]] ۵ s��C�Vd�X���M}�|Sx�d=T`k0��#2�v�ǻ�ۚJ�pi�Tg���6Xt�k�/�M�Á�֜���h�!�(�fY���.DM&쇽0�b��h0�!�}Fq=����ko� PK- 9�[�E�� 5 xl/workbook.xmlPK- 9�[���� � � [Content_Types].xmlPK- 9�[>+�' ' U _rels/.relsPK- 9�[z���� � � xl/worksheets/sheet1.xmlPK- 9�[%�b� P � xl/_rels/workbook.xml.relsPK- 9�[Ѓc'2 E xl/styles.xmlPK- 9�[Td�W � � xl/sharedStrings.xmlPK � 5