49
StockAdjustments API
StockAdjustments is the main transaction table holding inventory movement information. You can add and view StockAdjustments only, never edit or delete them. StockAdjustments are Stock Movements that have happened.
There are three methods available for StockAdjustments :
- List all StockAdjustments
- Return stock level figures for a Product
- Add a StockAdjustment
List all StockAdjustments
End Point: https://api.myposconnect.com/api/v2/stockadjustments
Verb: GET
Example Call 1: https://api.myposconnect.com/api/v2/stockadjustments?liPage=1&liPageSize=99999&sSortKey=LastEditDateUTCDESC&filt_LastEditDateUTC_dt_min=2000-oct-01%2009%3a00&filt_LastEditDateUTC_dt_max=2022-dec-31%2009%3a00
Return Codes: 200 for success, with the body containing the JSON for the sale items. For other possible (more general) return codes please see API Build Basics
Return stock level figures for a Product
End Point: https://api.myposconnect.com/api/v2/stockadjustments/getstocklevels
Verb: GET
Example Call 1: https://api.myposconnect.com/api/v2/stockadjustments/getstocklevels?productId=7347523d-fe86-4cab-bec1-dc79bfa2d6f2
Example Call 2: https://api.myposconnect.com/api/v2/stockadjustments/getstocklevels?StoreId=8EDC467C-6256-49A6-AB9E-0D4B5D05FE71&ProductActive=true
Return Codes: 200 for success, with the body containing the JSON for the sale items. For other possible (more general) return codes please see API Build Basics
Important: getstocklevels works with either a productid for a single product, or with storeid for all products within a store
Add a StockAdjustment
End Point: https://api.myposconnect.com/api/v2/stockadjustments
Verb: GET
Return Codes: For other possible (more general) return codes please see API Build Basics
Troubleshooting Ideas
As with all API connections, you will need to have acquired a bearer token and the user that acquired the token will need to be assigned access permission to this table. If you are not receiving any results send the full endpoint together with any filters and the API user to us from a valid email address and we can advise if permissions have been authorised. You might be able to see data with one table and not another if specific permissions are not applied. Check your filter dates if collecting all rows.
If you are adding StockAdjustments then ask us for a sample
