NOTE: This is an article for the legacy API. To access updated information on this endpoint, please reference the HTML guide attached to the bottom of the REST API Access document
Description: Gets turns results from Inventory > Turns screen, By Item-Site tab
Resource: ItemSiteTurnsDetailOverTime/
Verb: GET
Query String Options:
-
interval (required):
- 2 = Weekly
- 4 = Monthly
- 8 = Quarterly
- 32 = Yearly
- startDate (optional): first date to filter by, e.g. 1/1/2020
Returns: JSON Array of objects
Example Response JSON:
[
{
"ItemSiteId": 1423,
"ItemId": 740,
"SiteId": 3,
"ItemCode": "0406031",
"ShipperId": 4,
"SiteCode": "271",
"ItemDescription": "Contoso Digital Cameras Lightweight Tripod E316 Silver",
"ItemSiteCategory1Name": "Cameras and camcorders ",
"ItemSiteCategory2Name": "Cameras & Camcorders Accessories",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"PeriodDate": "2022/09/01",
"StartDate": "2022/09/01",
"EndDate": "2022/09/30",
"QuantitySold": 76.00000,
"Cogs": 1824.62000,
"OnHandQuantity": -317.00000,
"AverageOnHandQuantity": -374.1333333333333333,
"TargetOnHandQuantity": 32.0000000,
"OnHandBalance": -4552.120000000,
"AverageOnHandBalance": -5372.5546666666666666,
"TargetOnHandBalance": 459.52000000,
"MeasurementPeriodLength": 30,
"CurrentTurns": 0.0,
"AverageTurns": 0.0,
"TargetTurns": 48.310287546425255338904363975,
"CurrVsTargetTurns": -48.310287546425255338904363975,
"AvgVsTargetTurns": -48.310287546425255338904363975,
"CurrentUnitTurns": 0.0,
"AverageUnitTurns": 0.0,
"TargetUnitTurns": 28.895833333333333333333333334,
"CurrVsTargetUnitTurns": -28.895833333333333333333333334,
"AvgVsTargetUnitTurns": -28.895833333333333333333333334
},
{
"ItemSiteId": 1423,
"ItemId": 740,
"SiteId": 3,
"ItemCode": "0406031",
"ShipperId": 4,
"SiteCode": "271",
"ItemDescription": "Contoso Digital Cameras Lightweight Tripod E316 Silver",
"ItemSiteCategory1Name": "Cameras and camcorders ",
"ItemSiteCategory2Name": "Cameras & Camcorders Accessories",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"PeriodDate": "2022/10/01",
"StartDate": "2022/10/01",
"EndDate": "2022/10/31",
"QuantitySold": 118.00000,
"Cogs": 2856.70000,
"OnHandQuantity": -384.00000,
"AverageOnHandQuantity": -389.8387096774193548,
"TargetOnHandQuantity": 34.0000000,
"OnHandBalance": -5514.240000000,
"AverageOnHandBalance": -5654.2812903225806451,
"TargetOnHandBalance": 488.24000000,
"MeasurementPeriodLength": 31,
"CurrentTurns": 0.0,
"AverageTurns": 0.0,
"TargetTurns": 68.890993588557716194573795013,
"CurrVsTargetTurns": -68.890993588557716194573795013,
"AvgVsTargetTurns": -68.890993588557716194573795013,
"CurrentUnitTurns": 0.0,
"AverageUnitTurns": 0.0,
"TargetUnitTurns": 40.863377609108159392789373815,
"CurrVsTargetUnitTurns": -40.863377609108159392789373815,
"AvgVsTargetUnitTurns": -40.863377609108159392789373815
}
...]