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
}
...]