Megaventory API v2017a

Examples:

GET examples (JSON)

The following calls the ProductGet endpoint. All the products will be returned.

https://api.megaventory.com/v2017a/json/reply/ProductGet?APIKEY=YOUR_API_KEY_HERE

The following call uses the Filters attribute to call the ProductGet endpoint by quering the ProductSKU fieldname with a SearchValue of AT1FX01W15. The product that equals 'AT1FX01W15' will be returned.

https://api.megaventory.com/v2017a/json/reply/ProductGet?APIKEY=YOUR_API_KEY_HERE&Filters={FieldName:ProductSKU,SearchValue:AT1FX01W15}

The following call uses the Filters attribute to call the ProductGet endpoint by quering the ProductSKU fieldname with a SearchOperator of Contains and a SearchValue of FX01W. The products that contain 'FX01W' will be returned.

https://api.megaventory.com/v2017a/json/reply/ProductGet?APIKEY=YOUR_API_KEY_HERE&Filters={FieldName:ProductSKU,SearchOperator:Contains,SearchValue:FX01W}

The following call uses the Filters attribute with multiple filters to call the CurrencyGet endpoint by quering the CurrencyDescription fieldname with a SearchOperator of Contains and a SearchValue of EUR. Another subsequent filter uses the CurrencyCode fieldname with a SearchOperator of Equals and a SearchValue of USD with the AndOr operator set to Or. The currencies that contain 'EUR' in the currency description or equal 'USD' in the currency code fields will be returned.

https://api.megaventory.com/v2017a/json/reply/CurrencyGet?APIKEY=YOUR_API_KEY_HERE&Filters=[{FieldName:CurrencyDescription,SearchOperator:Contains,SearchValue:EUR},{AndOr:Or,FieldName:CurrencyDescription,SearchOperator:Equals,SearchValue:USD},{AndOr:Or,FieldName:CurrencyCode,SearchOperator:Equals,SearchValue:USD}]

The following call uses the Filters attribute with a Group property to call the ProductClientGet endpoint by quering the ProductClientID fieldname with a SearchOperator of Equals and a SearchValue of 16. Then, a Group starts with the property StartGroup and three products are searched with Or operators. The query searches for ProductID = 102 Or 114 Or 116. Finally the Group ends with the property EndGroup

https://api.megaventory.com/v2017a/json/reply/ProductClientGet?APIKEY=YOUR_API_KEY_HERE&Filters=[{"AndOr": "And","FieldName": "ProductClientID","SearchOperator": "Equals","SearchValue": "16"},{"Group": "StartGroup","AndOr": "And","FieldName": "ProductID","SearchOperator": "Equals","SearchValue": "102"},{"AndOr": "Or","FieldName": "ProductID","SearchOperator": "Equals","SearchValue": "114"},{"Group": "EndGroup","AndOr": "Or","FieldName": "ProductID","SearchOperator": "Equals","SearchValue": "116"}]