I am trying to get a list of bins using an API in power BI to see basically the Parts>Lists>List by Bin screen. However trying both /goapis/api/v1/bin/list and goapis/api/v1/parts/list_by_bin are giving me only ~45 parts instead of all of the inventory. Is this the wrong API for this? We mostly are trying to see an inventory list that includes expiration dates.
I also tried Get a List by Inventory but that seems to be broken.
I have no filters on it. Please help.
Hi kristina,
We recently battled thius issue.
It turns out that if you send the ROWS=500 parameter along whith your other parameterrs this will at least give you 500 results.
I know the parameter is not listed in the API description but none the less it still works.
Now that was sufficient for us so we did not have to battle any pagination problems that might arrive if you have more that 500 results.
Hopefully this will take you over the hump
//H
example:
goapis/api/v1/parts/list_by_bin?prcpart=snc&location_code=SB&rows=500
Also the list by inv is broken and has been a topic before
//H