Product Categories using ContentConnector

[MichaelSlupina]

At our company we use an instance of the 1WorldSync ContentConnector (java application).

I am wondering if there is any way to receive the product category as show in the DataSource Product Catalog:

https://datasource.cs.1worldsync.com/techspecs.aspx?skuid=e70dcfb5-9144-4e8a-aa26-31acf0736b87&tab=M...

For the Mfg part number 5PS0L37713 for example I can here find the Category "Systems - System Service & Support".

Could someone please assist to write an SQL-Snippet to retreive this information from the database?

Thank you in advance!

[iM_23]

Hi @MichaelSlupina Thank you for getting in touch and for your continued involvement in the community! I have moved your post to the DataSource Questions Board, where a team member will respond to your question shortly.

-1WS

[Modzilla · Accepted solution]

Hi @MichaelSlupina 

That's a great question, if I am not mistaken you can find a couple of sample queries in the following post:

https://community.1worldsync.com/t5/DS-User-Guides/Sample-Queries/ta-p/8915

If this doesn't help, I can ask our technical team if we can provide a sample query for the categorisation

If you have any questions please let me know

[MichaelSlupina]

Thank you @Modzilla, that link was of great help!

All the Best

Michael