Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / use inventory visibili...
Supply chain | Supply Chain Management, Commerce
Unanswered

use inventory visibility API to fetch stock for a WMSLocation

(3) ShareShare
ReportReport
Posted on by SunilSharma 96
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.
  • Subhad365 Profile Picture
    Subhad365 17 User Group Leader on at
    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 Profile Picture
    Kevin Xia Microsoft Employee on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans