question

Jonathan Ryan Grice avatar image
Jonathan Ryan Grice asked ·

Filter categories not equals

How do I list all items and filter out items found in categories that their name or id equals example?
I know the proper usage for listing all items is

/v3/merchants/%s/items

how can I filter out certain categories and still list remaining products?

such as

/v3/merchants/%s/items?filter=categories!%3Dshoes&filter=categories!%3Djewelry
SandboxREST APIsemi-integrationsInventory
4 comments
10 |2000 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Update: I've tried filtering using example

/v3/merchants/%s/items?filter=categories.name!=shoes

and

/v3/merchants/%s/items?filter=categories.id!=T70G4BMTFBF12

and also get 500 Internal Server Error

0 Likes 0 · ·
I still haven't sorted this issue out. I'm still receiving a "500 Internal Server Error" on filtering out items in certain categories either by categories.name or categories.id.

Any ideas would be greatly appreciated.
0 Likes 0 · ·

Are you still getting the 500 error?

Also we do have an endpoint to grab all the items of a single category.

GET /v3/merchants/{mId}/categories/{catId}/items
0 Likes 0 · ·
I am still getting to 500 Internet Server Error when trying to filter=category.name or filter= category.id. I'm paging from the items endpoint so it's not straining the server, but I want to filter out items from categories that can't be sold online.
0 Likes 0 · ·

1 Answer

zgreathouse avatar image
zgreathouse answered ·
The reason why you are getting a 500 error is because the categories themselves are nested in an array. (You cannot filter on nested items, you can only filter on top level fields in the JSON object)

What I would recommend is the following:

1. Create a separate category for "Available Online" (An item can belong to multiple categories)
2. Associate items available online to this category
3. Then you can use the "GET /v3/merchants/{mId}/categories/{catId}/items" endpoint to grab all the items available online.
Share
10 |2000 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Welcome to the
Clover Developer Community