GET api/product/{id}/history/purchases

Lists purchase orders and invoices matching query parameters, that have specified product in detail table

Request Information

URI Parameters

NameDescriptionTypeAdditional information
id

Product guid

globally unique identifier

Required

Status

OrderStatus

None.

Take

integer

None.

Skip

integer

None.

SupplierIdentifier

Collection of byte

None.

SupplierIdentifierGuid

globally unique identifier

None.

PLUG_UID

Collection of byte

None.

PluGuid

globally unique identifier

None.

StoreID

Matches against either the ordered for store, or the ordered from store for store transfers

integer

None.

TransfersOnlyStore

When true, StoreID is only matched against the ordered from store for store transfers

boolean

None.

OrdersOnlyStore

When true, StoreID is only matched against the ordered for store

boolean

None.

Search

string

None.

OrderNo

string

None.

DetailSearch

DetailSearchType

None.

OrderType

string

None.

ShowHeader

ShowHeaderType

None.

ExcludeCompleted

boolean

None.

ExcludeStarted

boolean

None.

ExcludeSent

boolean

None.

ExcludeInvoices

boolean

None.

ExcludeCancelled

boolean

None.

CreatedBefore

Local created date filtering before

date

None.

CreatedAfter

Local created date filtering after

date

None.

SentBefore

Local sent date filtering before

date

None.

DueDateBefore

Due date filtering before

date

None.

DueDateAfter

Due date filtering after

date

None.

SentAfter

Local sent date filtering after

date

None.

StockReceivedAfter

Local stock received after

date

None.

StockReceivedBefore

Local stock received after

date

None.

TradingPartner

OrderTradingPartner

None.

TransferInvoiced

boolean

None.

AutoOrder

boolean

None.

SortBy

OrderSortBy

None.

Sort

SortOrder

None.

Relations

boolean

None.

Details

boolean

None.

Body Parameters

None.

Response Information

Resource Description

PageList containing list of purchase history records and count of all matching purchase history

PageListOfPurchaseHistory
NameDescriptionTypeAdditional information
Type

string

None.

List

Collection of PurchaseHistory

None.

Skip

Number of records to skip over

integer

None.

Take

Number of records to take

integer

None.

TotalCount

integer

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

Response Formats

application/json, text/json

Sample:
{
  "type": "PurchaseHistory",
  "list": [
    {
      "$id": "2",
      "invoiceIdentifier": "XPDzm2hPvE29TXspHz1CCg==",
      "invoiceIdentifierGuid": "9bf3f05c-4f68-4dbc-bd4d-7b291f3d420a",
      "invoiceNo": "sample string 1",
      "invoiceDate": "2025-06-14T07:40:11.8636816",
      "invoiceText": "sample string 2",
      "invoiceSupplierIdentifier": "alPeEA4X10O1qTg5z0QlGA==",
      "invoiceSupplierIdentifierGuid": "10de536a-170e-43d7-b5a9-3839cf442518",
      "invoiceSupplierName": "sample string 3",
      "invoiceStatus": 1,
      "completed": "2025-06-14T07:40:11.8636816",
      "invoiceQty": 4.1,
      "invoiceCost": 5.1,
      "invoiceExtCost": 6.1,
      "hasInvoice": true,
      "orderGuid": "33E77C5ZA0q6WkajlF+U7g==",
      "orderIdentifier": "ec3b71df-592e-4a03-ba5a-46a3945f94ee",
      "orderID": 1,
      "sent": "2025-06-14T07:40:11.8636816",
      "sentLocal": "2025-06-14T07:40:11.8636816",
      "sentByUser": "sample string 8",
      "orderDescription": "sample string 9",
      "orderSupplierIdentifier": "3F1YzuG7dUqvFeTy1YQ3fA==",
      "orderSupplierIdentifierGuid": "ce585ddc-bbe1-4a75-af15-e4f2d584377c",
      "orderSupplierName": "sample string 10",
      "orderQty": 11.1,
      "orderCost": 12.1,
      "hasOrder": true
    },
    {
      "$ref": "2"
    }
  ],
  "skip": 1,
  "take": 1,
  "totalCount": 1
}

application/xml, text/xml

Sample:
<PageListOfPurchaseHistoryyDisaqof xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/EziManager.Models.Common">
  <Skip>1</Skip>
  <Take>1</Take>
  <TotalCount>1</TotalCount>
  <List xmlns:d2p1="http://schemas.datacontract.org/2004/07/EziManager.Models.EMC.Orders">
    <d2p1:PurchaseHistory>
      <d2p1:Completed>2025-06-14T07:40:11.8636816+00:00</d2p1:Completed>
      <d2p1:HasInvoice>true</d2p1:HasInvoice>
      <d2p1:HasOrder>true</d2p1:HasOrder>
      <d2p1:InvoiceCost>5.1</d2p1:InvoiceCost>
      <d2p1:InvoiceDate>2025-06-14T07:40:11.8636816+00:00</d2p1:InvoiceDate>
      <d2p1:InvoiceExtCost>6.1</d2p1:InvoiceExtCost>
      <d2p1:InvoiceIdentifier>XPDzm2hPvE29TXspHz1CCg==</d2p1:InvoiceIdentifier>
      <d2p1:InvoiceIdentifierGuid>9bf3f05c-4f68-4dbc-bd4d-7b291f3d420a</d2p1:InvoiceIdentifierGuid>
      <d2p1:InvoiceNo>sample string 1</d2p1:InvoiceNo>
      <d2p1:InvoiceQty>4.1</d2p1:InvoiceQty>
      <d2p1:InvoiceStatus>1</d2p1:InvoiceStatus>
      <d2p1:InvoiceSupplierIdentifier>alPeEA4X10O1qTg5z0QlGA==</d2p1:InvoiceSupplierIdentifier>
      <d2p1:InvoiceSupplierIdentifierGuid>10de536a-170e-43d7-b5a9-3839cf442518</d2p1:InvoiceSupplierIdentifierGuid>
      <d2p1:InvoiceSupplierName>sample string 3</d2p1:InvoiceSupplierName>
      <d2p1:InvoiceText>sample string 2</d2p1:InvoiceText>
      <d2p1:OrderCost>12.1</d2p1:OrderCost>
      <d2p1:OrderDescription>sample string 9</d2p1:OrderDescription>
      <d2p1:OrderGuid>33E77C5ZA0q6WkajlF+U7g==</d2p1:OrderGuid>
      <d2p1:OrderID>1</d2p1:OrderID>
      <d2p1:OrderIdentifier>ec3b71df-592e-4a03-ba5a-46a3945f94ee</d2p1:OrderIdentifier>
      <d2p1:OrderQty>11.1</d2p1:OrderQty>
      <d2p1:OrderSupplierIdentifier>3F1YzuG7dUqvFeTy1YQ3fA==</d2p1:OrderSupplierIdentifier>
      <d2p1:OrderSupplierIdentifierGuid>ce585ddc-bbe1-4a75-af15-e4f2d584377c</d2p1:OrderSupplierIdentifierGuid>
      <d2p1:OrderSupplierName>sample string 10</d2p1:OrderSupplierName>
      <d2p1:Sent>2025-06-14T07:40:11.8636816+00:00</d2p1:Sent>
      <d2p1:SentByUser>sample string 8</d2p1:SentByUser>
      <d2p1:SentLocal>2025-06-14T07:40:11.8636816+00:00</d2p1:SentLocal>
    </d2p1:PurchaseHistory>
    <d2p1:PurchaseHistory>
      <d2p1:Completed>2025-06-14T07:40:11.8636816+00:00</d2p1:Completed>
      <d2p1:HasInvoice>true</d2p1:HasInvoice>
      <d2p1:HasOrder>true</d2p1:HasOrder>
      <d2p1:InvoiceCost>5.1</d2p1:InvoiceCost>
      <d2p1:InvoiceDate>2025-06-14T07:40:11.8636816+00:00</d2p1:InvoiceDate>
      <d2p1:InvoiceExtCost>6.1</d2p1:InvoiceExtCost>
      <d2p1:InvoiceIdentifier>XPDzm2hPvE29TXspHz1CCg==</d2p1:InvoiceIdentifier>
      <d2p1:InvoiceIdentifierGuid>9bf3f05c-4f68-4dbc-bd4d-7b291f3d420a</d2p1:InvoiceIdentifierGuid>
      <d2p1:InvoiceNo>sample string 1</d2p1:InvoiceNo>
      <d2p1:InvoiceQty>4.1</d2p1:InvoiceQty>
      <d2p1:InvoiceStatus>1</d2p1:InvoiceStatus>
      <d2p1:InvoiceSupplierIdentifier>alPeEA4X10O1qTg5z0QlGA==</d2p1:InvoiceSupplierIdentifier>
      <d2p1:InvoiceSupplierIdentifierGuid>10de536a-170e-43d7-b5a9-3839cf442518</d2p1:InvoiceSupplierIdentifierGuid>
      <d2p1:InvoiceSupplierName>sample string 3</d2p1:InvoiceSupplierName>
      <d2p1:InvoiceText>sample string 2</d2p1:InvoiceText>
      <d2p1:OrderCost>12.1</d2p1:OrderCost>
      <d2p1:OrderDescription>sample string 9</d2p1:OrderDescription>
      <d2p1:OrderGuid>33E77C5ZA0q6WkajlF+U7g==</d2p1:OrderGuid>
      <d2p1:OrderID>1</d2p1:OrderID>
      <d2p1:OrderIdentifier>ec3b71df-592e-4a03-ba5a-46a3945f94ee</d2p1:OrderIdentifier>
      <d2p1:OrderQty>11.1</d2p1:OrderQty>
      <d2p1:OrderSupplierIdentifier>3F1YzuG7dUqvFeTy1YQ3fA==</d2p1:OrderSupplierIdentifier>
      <d2p1:OrderSupplierIdentifierGuid>ce585ddc-bbe1-4a75-af15-e4f2d584377c</d2p1:OrderSupplierIdentifierGuid>
      <d2p1:OrderSupplierName>sample string 10</d2p1:OrderSupplierName>
      <d2p1:Sent>2025-06-14T07:40:11.8636816+00:00</d2p1:Sent>
      <d2p1:SentByUser>sample string 8</d2p1:SentByUser>
      <d2p1:SentLocal>2025-06-14T07:40:11.8636816+00:00</d2p1:SentLocal>
    </d2p1:PurchaseHistory>
  </List>
</PageListOfPurchaseHistoryyDisaqof>

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Sample:
PK=�Z�꠪�5xl/workbook.xml �(�����0��&�C��ŠR8q���{��m�?ik��H�yۙ��v�d��v@=�P��]EH�$hNց�w�z��,��X!T���L$gJ���ȣ�&H�^i������ �W�����x@�-�
���llu�5D~S,������j���1J�q����<�iv�B�e�e4/��������PK=�Z����	�[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
=�Z�1�''_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="R092ee897928f418a" /></Relationships>PK=�Z�0H�xl/worksheets/sheet1.xml �(���]o�0�������K"��T�]Ջ����l'���J�u�
��9~},�ۗ�gi��}I�!�}�+�rxr���٠ͳm�t��ݚ6��ٲ����>���jm:���9 ]ת�;]�:�;D1���V8��m��©ۿ�G#E"t�Ԫ��EV)�}L��sxG�{
*��Rr��`<���Ǐ�Uq`�
~�?P�Z�Z���R�ĂS�ֆ'��8::�ރ�\3rO���71��K��:����oM&��:]���a�q����x����D$���e�d�������㒈�4M(����UMS#�	'����P���՝_�p1~�����:��L|_䒸_�ح���د�d!���d�����a���	�)�q�\�/j��))�0���I�<h�	w����+PK=�ZJ�5�Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞خ�P�nذ-�������nK�Ƃ#q�"A*�`��h~OO��|�Xoߦ��(��;
������pL�A�v��ш)O�~�#�+.j�S�9���	c�gr�c}�0�4t|Fs���J���%n�l��?Do�`�ɛ�D.��g�'J��:J~J�_�,2�s�a'dE�mU)�(��wS��2R����2�be����-���L��ڗ�N��Bͼ"�Q�Qh�J�W5~��/PK=�ZЃ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=�Z�����xl/sharedStrings.xml �(�ePMK�0�+!w��T��ʪ���$�!}�a����*�_oV�{��)w���H�"Vr�
)m��|��.� 6�*�I��K"يTɑy�Қ����`V�b
�3L��)��i����(�u0��qF��3���?�\]r�-���R�/w�����Mk�3�o������0';�ۜ�rR�CPM�,�H�BrV��n��_�5hH��=xR��Q����U����O��PK-=�Z�꠪�5xl/workbook.xmlPK-=�Z����	�[Content_Types].xmlPK-
=�Z�1�''V_rels/.relsPK-=�Z�0H��xl/worksheets/sheet1.xmlPK-=�ZJ�5�P�xl/_rels/workbook.xml.relsPK-=�ZЃc'2E
�xl/styles.xmlPK-=�Z�����ixl/sharedStrings.xmlPK��	

application/vnd.ms-excel

Sample:
PK=�Z��胶5xl/workbook.xml �(�����0��&�C���H")��x�པ�4П�5���H�yۙ��v�l��3�����\��lE��(�OƂ�;a�b!J�"Fɡ5��@���%q0� ������X�:`���V�bR��x@�.͞f�d4�����"�)�`�ERH35nY`%���8��U2�.��
ʢ�^x�	�;{�Q��n�PK=�Z����	�[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
=�Z�Mf�''_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="Rae399a584c564430" /></Relationships>PK=�Z�0H�xl/worksheets/sheet1.xml �(���]o�0�������K"��T�]Ջ����l'���J�u�
��9~},�ۗ�gi��}I�!�}�+�rxr���٠ͳm�t��ݚ6��ٲ����>���jm:���9 ]ת�;]�:�;D1���V8��m��©ۿ�G#E"t�Ԫ��EV)�}L��sxG�{
*��Rr��`<���Ǐ�Uq`�
~�?P�Z�Z���R�ĂS�ֆ'��8::�ރ�\3rO���71��K��:����oM&��:]���a�q����x����D$���e�d�������㒈�4M(����UMS#�	'����P���՝_�p1~�����:��L|_䒸_�ح���د�d!���d�����a���	�)�q�\�/j��))�0���I�<h�	w����+PK=�Z�q9�Pxl/_rels/workbook.xml.rels �(���KN�0@�b͞8�m��ݰa[z��Q;�]�gc���V� �X��j4��'�|�l�o�H^Ї���,�V:5ؾ�s�k��EL�s iņL��� 
N"dnF�:��IĔ���B�D���sN���Lr�����z����yB��W�O� F G�{�-����"KT O��CWJ� g��$+4�wS�2b����2M����+��j֭�+c�G�}���iY^��R��)y�8cR������PK=�ZЃ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=�Z�����xl/sharedStrings.xml �(�ePMK�0�+!w��T��ʪ���$�!}�a����*�_oV�{��)w���H�"Vr�
)m��|��.� 6�*�I��K"يTɑy�Қ����`V�b
�3L��)��i����(�u0��qF��3���?�\]r�-���R�/w�����Mk�3�o������0';�ۜ�rR�CPM�,�H�BrV��n��_�5hH��=xR��Q����U����O��PK-=�Z��胶5xl/workbook.xmlPK-=�Z����	��[Content_Types].xmlPK-
=�Z�Mf�''U_rels/.relsPK-=�Z�0H��xl/worksheets/sheet1.xmlPK-=�Z�q9�P�xl/_rels/workbook.xml.relsPK-=�ZЃc'2E
�xl/styles.xmlPK-=�Z�����kxl/sharedStrings.xmlPK��