This issue occurs on the module_data, with the "orderitems" resource. It also occurs on the "orders" resource with the subresource "products".
If all the field options listed in the module_data app (using either method listed above), the "items" property comes back as an empty array. However, the "totalItemsCount" property still reports the correct number of products.
This seems to be caused by the inclusion of the "variation" field in the data call.
For instance, both of these calls will get the correct products:
{module_data resource="orderitems" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order" skip="0" limit="10" where="{'orderId':''}" order="productId" collection="myData"}
{module_data resource="orders" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order" subresource="products" resourceId="" skip="0" limit="10" order="productId" collection="myData"}
However, both of these will return an empty "items" array (but correct "totalItemsCount" value):
{module_data resource="orderitems" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order,variation" skip="0" limit="10" where="{'orderId':''}" order="productId" collection="myData"}
{module_data resource="orders" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order,variation" subresource="products" resourceId="" skip="0" limit="10" order="productId" collection="myData"}
Cheers,
Ben
This issue occurs on the module_data, with the "orderitems" resource. It also occurs on the "orders" resource with the subresource "products".
If all the field options listed in the module_data app (using either method listed above), the "items" property comes back as an empty array. However, the "totalItemsCount" property still reports the correct number of products.
This seems to be caused by the inclusion of the "variation" field in the data call.
For instance, both of these calls will get the correct products:
{module_data resource="orderitems" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order" skip="0" limit="10" where="{'orderId':''}" order="productId" collection="myData"}
{module_data resource="orders" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order" subresource="products" resourceId="" skip="0" limit="10" order="productId" collection="myData"}
However, both of these will return an empty "items" array (but correct "totalItemsCount" value):
{module_data resource="orderitems" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order,variation" skip="0" limit="10" where="{'orderId':''}" order="productId" collection="myData"}
{module_data resource="orders" version="v3" fields="itemId,orderId,productId,siteId,variationId,catalogueId,units,unitPrice,unitTaxRate,totalPrice,description,createDate,lastUpdateDate,attributeExtras,deletedByTaskOrAdmin,product,order,variation" subresource="products" resourceId="" skip="0" limit="10" order="productId" collection="myData"}
Cheers,
Ben