Filtering resources

• The required JSON is {"lastUpdatedDate":["2015-11-19T20:09:57Z",null]}.  
• Base 64 encoding that is
  eyJsYXN0VXBkYXRlZERhdGUiOlsiMjAxNS0xMS0xOVQyMDowOTo1N1oiLG51bGxdfQ
• The full URL to query for products changed since the lastUpdateDate:
  https://app.finaleinventory.com/YOURACCOUNTNAME/api/product/?filter=eyJsYXN0VXBkYXRlZERhdGUiOlsiMjAxNS0xMS0xOVQyMDowOTo1N1oiLG51bGxdfQ

To filter for committed sales orders:

• The required JSON is {orderTypeId:['SALES_ORDER','SALES_ORDER'],statusId:['ORDER_LOCKED','ORDER_LOCKED']}
• Base 64 encoding that is iseyJvcmRlclR5cGVJZCI6WyJTQUxFU19PUkRFUiIsIlNBTEVTX09SREVSIl0sInN0YXR1c0lkIjpbIk9SREVSX0xPQ0tFRCIsIk9SREVSX0xPQ0tFRCJdfQ==
• The full URL to query for orders is:
  https://app.finaleinventory.com/YOURACCOUNTNAME/api/order/?filter=eyJvcmRlclR5cGVJZCI6WyJTQUxFU19PUkRFUiIsIlNBTEVTX09SREVSIl0sInN0YXR1c0lkIjpbIk9SREVSX0xPQ0tFRCIsIk9SREVSX0xPQ0tFRCJdfQ==

Similar filters can be applied to any value that is a scalar type at the top level of the object (for example, the order orderId, the order origin location, the customer name, or the facility name). Therefore you can't filter on products in an order/shipment, or user defined fields.

The system is optimized for filtering by lastUpdatedDate. If you are encountering performance problems requesting large collections, then you should cache your collections and only fetch updates using the lastUpdatedDate filter. Typically the system performs well for collections with up to 10,000 entries, but if you have more then you should consider adding caching in your code.

 The collection APIs can respond quicker when you limit the number of entries. Add a limit parameter to the url with an integer value.

- The full URL to query for the first 1000 products ordered by their lastUpdatedDate:
https://app.finaleinventory.com/YOURACCOUNTNAME/api/product/?limit=1000
- To continue iteration, you can take the last entry in the lastUpdatedDate list and use that as the starting point for your next request. The filters are inclusive so there would be overlap between requests.
- The full URL to query for the next 1000 products changed since the lastUpdateDate:
https://app.finaleinventory.com/YOURACCOUNTNAME/api/product/?limit=1000&filter=eyJsYXN0VXBkYXRlZERhdGUiOlsiMjAxNS0xMS0xOVQyMDowOTo1N1oiLG51bGxdfQ

To filter for all product lookups for a specific product by productUrl:

- The required JSON is {productUrl:['/demo/api/product/10000','/demo/api/product/10000']}
- Base 64 encoding that is eyJwcm9kdWN0VXJsIjpbIi9kZW1vL2FwaS9wcm9kdWN0LzEwMDAwIiwiL2RlbW8vYXBpL3Byb2R1Y3QvMTAwMDAiXX0=
- The full URL to query for that product's product lookups is https://app.finaleinventory.com/YOURACCOUNTNAME/api/scanlookup/?filter=eyJwcm9kdWN0VXJsIjpbIi9kZW1vL2FwaS9wcm9kdWN0LzEwMDAwIiwiL2RlbW8vYXBpL3Byb2R1Y3QvMTAwMDAiXX0=

To filter for a regular product lookup by scan key:

- The required JSON is {scanKey:['10000','10000'],scanTypeId:['UNSPECIFIED_TEXT','UNSPECIFIED_TEXT']}
- Base 64 encoding that is eyJzY2FuS2V5IjpbIjEwMDAwIiwiMTAwMDAiXSwic2NhblR5cGVJZCI6WyJVTlNQRUNJRklFRF9URVhUIiwiVU5TUEVDSUZJRURfVEVYVCJdfQ==
- The full URL to query for that product's product lookups is https://app.finaleinventory.com/YOURACCOUNTNAME/api/scanlookup/?filter=eyJzY2FuS2V5IjpbIjEwMDAwIiwiMTAwMDAiXSwic2NhblR5cGVJZCI6WyJVTlNQRUNJRklFRF9URVhUIiwiVU5TUEVDSUZJRURfVEVYVCJdfQ==

To filter for a range of Finale short codes by scan key:

- The required JSON is {scanKey:['200001000100','200001000200'],scanTypeId:['INVENTORY_SHORT_CODE','INVENTORY_SHORT_CODE']}
- Base 64 encoding that is eyJzY2FuS2V5IjpbIjIwMDAwMTAwMDEwMCIsIjIwMDAwMTAwMDIwMCJdLCJzY2FuVHlwZUlkIjpbIklOVkVOVE9SWV9TSE9SVF9DT0RFIiwiSU5WRU5UT1JZX1NIT1JUX0NPREUiXX0=
- The full URL to query for that product's product lookups is https://app.finaleinventory.com/YOURACCOUNTNAME/api/scanlookup/?filter=eyJzY2FuS2V5IjpbIjIwMDAwMTAwMDEwMCIsIjIwMDAwMTAwMDIwMCJdLCJzY2FuVHlwZUlkIjpbIklOVkVOVE9SWV9TSE9SVF9DT0RFIiwiSU5WRU5UT1JZX1NIT1JUX0NPREUiXX0=