Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

https://docs.microsoft.com/en-us/dynamics-nav/using-filter-expressions-in-odata-uris

Call example

https://api.ghi.asamco.cloud/EPOAPI/odata/_as_epo_vwItemOnWarehouse?%24top=1&%24filter=((bAllowToSellFrom+eq+true)+and+(WHStockLink+eq+4))+and+(id+eq+2)

Example responses:

 {

            "linkId"112274,
            "id"2,
            "whStockLink"4,
            "name""Johannesburg",
            "code""010-JHB",
            "knownAs""",
            "address""5 Voyager Street \rLinbro Business Park \rLinbro Park \r2054",
            "defaultWhse"true,
            "bAllowToBuyInto"true,
            "bAllowToSellFrom"true,
            "bAllowMultiBinLocations"true,
            "tti"1,
            "ttc"1,
            "ttr"1,
            "ttg"1,
            "qtyOnHand"0.0,
            "qtyReserved"0.0,
            "qtyOnPo"0.0,
            "qtyOnSo"0.0,
            "qtyToDeliver"0.0,
            "averageCost"0.0,
            "latestCost"0.0,
            "lowestCost"0.0,
            "highestCost"0.0,
            "manualCost"0.0,
            "lastGrvCost"0.0,
            "whseLink"2,
            "branchID"0

...