use inventory visibility API to fetch stock for a WMSLocation

(3) Share

Report

Posted on by SunilSharma

I am developing an integration where i need to fetch stock levels for products from particular locations and then transfer this to a 3rd party system.

As i have checked it is not possible to use or /in operator with the api while using getonhand.

as per requirement, i need stock quantities for all WMS locations except one particular location.

In Inventory visibility , i can acheive this with putting filters like below.

I want to know, how can i acheive the same with Inventory visibility API.

i use a logicapp workflow to get data from IV and then send it further to third party.

All responses (2)

Answers (0)

Subhad365 19 User Group Leader on at

Like (1)

Report

use inventory visibility API to fetch stock for a WMSLocation

My Apologies for this delayed response -- just I happened to bump across your post :=)

Just in case you are still looking for an answer, you can also get this done by calling the version 2.0 of the inventory endpoint:

{{IVUrl}}/api/environment/{{environment}}/onhand/indexquery

And then you can keep passing your WMSLocations as array in the JSON body:

{

"filters": {

"OrganizationId": [

"USMF"

],

"ProductId": [

"1000", "10002"

],

"SiteId": [

"1"

],

"LocationId": [

"13", "15", "18"

]

},

"groupByValues": [],

"returnNegative": true

}

Whereby you can get the result as an array response, for all WMSLocations, except the one(s) you are not interested.

Don't forget to set the Version as 2.0 in the header :-)

api-version: 2.0
Kevin Xia Microsoft Employee on at

Like (0)

Report

use inventory visibility API to fetch stock for a WMSLocation

Hi,

You need to use the API to get the inventory quantity of the product from all WMS locations. Once you retrieve the inventory count, you can code out the data for specific locations to exclude in the integration code. Finally, the filtered inventory quantity data is transferred to your third-party system.

Best regards,

Kevin