GET Part Transactions
Retrieve part transaction records for reporting and history lookup.
GET /ODataApi/v1/GetPartTransactionsEndpoint
https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactionsReplace {sitename} with your MVP One site name.
Transaction type endpoints
Use the $filter query parameter with TransactionType to return a specific transaction type.
| Transaction type | Endpoint example |
|---|---|
| Adjust | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'adjust' |
| Check Out | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'check out' |
| Cycle Count | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'cycle count' |
| Move | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'move' |
| Purchase Receive | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'purchase receive' |
| Purchase Return | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'purchase return' |
| Quick Receive | https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'quick receive' |
| Return | https://{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,TransactionDateReturn the first 10 adjust transactions
GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'adjust'&$top=10Sort check-out transactions by date
GET https://{sitename}.mvpplant.com/ODataApi/v1/GetPartTransactions?$filter=TransactionType eq 'check out'&$orderby=TransactionDate descNotes
- Use
TransactionTypeto 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 outcan be sent ascheck%20out.
