products api

[CraigReardon]

We have a client who off IT courses to the public

These courses (in this case a product) can then be in 2 different catalogs - a location (eg. Melbourne) and a supplier (eg. Microsoft)

They would like to be able to display all products in Melbourne for example and then sub categorise by supplier, is this possible?

I have started playing with {module_data resource="catalogproducts" version="v3" fields="productUrl,product,catalogue" skip="0" limit="10" where="\{'catalogue.name':'Melbourne'\}" order="catalogueId" collection="myData"}

but it only brings back the catalog id associated with Melbourne and not the supplier (given the where clause)

I even tried to add a supplier name to the where condition using the API discovery tool but it did not add to the code.

Ant thoughts much appreciated.

[TheBCMan]

I had this exact same problem, it only gives the ID back and nothing else. I ended up scraping that and just using a custom field of the product to define the category (which you could do a where filter with). It's not a great solution but it's better than pounding the server X many times to get the data for the ID.