Part Transactions

GET Part Transactions

Retrieve part transaction records for reporting and history lookup.

GET /ODataApi/v1/GetPartTransactions

Endpoint

https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions

Replace {sitename} with your MVP One site name.

Transaction type endpoints

Use the $filter query parameter with TransactionType to return a specific transaction type.

Transaction typeEndpoint example
Adjusthttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'adjust'
Check Outhttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'check out'
Cycle Counthttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'cycle count'
Movehttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'move'
Purchase Receivehttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'purchase receive'
Purchase Returnhttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'purchase return'
Quick Receivehttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'quick receive'
Returnhttps://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'return'

Examples

Get adjust transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'adjust'

Get check-out transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'check out'

Get cycle-count transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'cycle count'

Get move transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'move'

Get purchase-receive transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'purchase receive'

Get purchase-return transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'purchase return'

Get quick-receive transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'quick receive'

Get return transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'return'

Optional query examples

Return selected fields

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$select=PartID,TransactionType,Quantity,TransactionDate

Return the first 10 adjust transactions

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'adjust'&$top=10

Sort check-out transactions by date

GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'check out'&$orderby=TransactionDate desc

Notes

  • Use TransactionType to filter part transaction records.
  • Use single quotes around transaction type values.
  • OData filter values are case-sensitive.
  • Encode spaces if your client does not encode URLs automatically. For example, check out can be sent as check%20out.