inventory item list check

[JuiceyBrucey]

Hi, I am integrating JIWA into a custom shopping system and need to run a query on a list of inventory items all in one query and find out the status of each item so the system can alert the shopper that the item is not available. I need to be able to specify the products concerned.
Is there a plugin for this?
Thank you.
Cheers

[DannyC]

Assuming you're using the REST API, sounds like you'll need a custom route.

[Scott.Pearce]

You could use an AutoQuery like:

https://api.jiwa.com.au/Queries/IN_Main ... tNo,Status

Status
-------
<blank>, 0, <no status tag returned> = Active
1 = Discontinued
2 = Deleted
3 = Slow
3 = Obsolete

Don't forget to authenticate first:

https://api.jiwa.com.au/auth?username=a ... d=password

To design your own AutoQueries go to:

https://api.jiwa.com.au/ss_admin/autoquery/

and search for IN_MainQuery using the filter on the left (give it a few seconds to load - there are a lot of tables).

[Mike.Sheen]

You could use an AutoQuery like:

https://api.jiwa.com.au/Queries/IN_Main ... tNo,Status

/Queries/InventoryItemList has more than just the main table - joins in classification, categories and even stock level - so might be a better fit... it all depends.

If you don't know about AutoQuery conventions, then you should look at the official docs, but to give you the one minute summary:

• Provides a route per table or view
• Provides pagination via skip, take and orderby, orderbydesc parameters
• All fields are filterable via simple conventions - eg: ?NameStartsWith=Mi will filter the column Name, returning only those starting with the letters 'Mi', NameContainsWith=Mi will return only those containing the letters 'Mi'.

[SBarnes]

There is also the option of being notified as to when a product gets updated using web hooks, the documentation to this can be found here

As for the auto query be aware that each call by default will only give you 100 result so you need to tell the api to include the total results via Include="Total" and then use skip in each call and once you work out the fields you want you can specify the fields as a comma separated list as in Fields=

[JuiceyBrucey]

Thank you very much for all of these replies.
I am working my way through it now and will let you know how I go.
Thanks again.
Cheers

[JuiceyBrucey]

Hi Scott, thank you for this solution.
I tried it out but did not have any success. It looks like the simplest solution for what I am trying to achieve, but I only had limited luck with it. If I could get it to work, it would be the perfect solution.
I tried it using the URL directly to the local server with just one InventoryID and that worked. It returned one item. Although it did not return the Status field.
http://localhost:8020/Queries/IN_Main?I ... tNo,Status

But when I added two more InventoryIDs, I got nothing.
http://localhost:8020/Queries/IN_Main?I ... tNo,Status

I then called both of these URLS using CURL and again it worked with one InventoryID, but got nothing when I put more than one.
Any ideas?
Thank you.

You could use an AutoQuery like:

https://api.jiwa.com.au/Queries/IN_Main ... tNo,Status

Status
-------
<blank>, 0, <no status tag returned> = Active
1 = Discontinued
2 = Deleted
3 = Slow
3 = Obsolete

Don't forget to authenticate first:

https://api.jiwa.com.au/auth?username=a ... d=password

To design your own AutoQueries go to:

https://api.jiwa.com.au/ss_admin/autoquery/

and search for IN_MainQuery using the filter on the left (give it a few seconds to load - there are a lot of tables).

[SBarnes]

That's because you should use InventoryIDIn for multiple Ids, my suggestion is you have a look at the swagger ui as in https://api.jiwa.com.au/swagger-ui, on localhost it will work as well, just give it a minute to come up and use try it out once you expand the sections it will show you the equivalent in curl and obviously from there you can work it out, you need to login using the get call under auth first though with a user name and password to make it work.

If you use https://api.jiwa.com.au/swagger-ui the credentials are admin and password.

[JuiceyBrucey]

Hi Mike,
I am checking out this method as well.
Queries/InventoryItemList
Thank you.

You could use an AutoQuery like:

https://api.jiwa.com.au/Queries/IN_Main ... tNo,Status

/Queries/InventoryItemList has more than just the main table - joins in classification, categories and even stock level - so might be a better fit... it all depends.

If you don't know about AutoQuery conventions, then you should look at the official docs, but to give you the one minute summary:

• Provides a route per table or view
• Provides pagination via skip, take and orderby, orderbydesc parameters
• All fields are filterable via simple conventions - eg: ?NameStartsWith=Mi will filter the column Name, returning only those starting with the letters 'Mi', NameContainsWith=Mi will return only those containing the letters 'Mi'.

[JuiceyBrucey]

That worked! Tried it with three items.
Excellent. The only issue now is that the Status field is not showing up.
How do I sort that out?
**** UPDATE ****
Field is not returned if value is zero. No problem, I can work with that.
Thanks again.

That's because you should use InventoryIDIn for multiple Ids, my suggestion is you have a look at the swagger ui as in https://api.jiwa.com.au/swagger-ui, on localhost it will work as well, just give it a minute to come up and use try it out once you expand the sections it will show you the equivalent in curl and obviously from there you can work it out, you need to login using the get call under auth first though with a user name and password to make it work.

If you use https://api.jiwa.com.au/swagger-ui the credentials are admin and password.