topic Re: Product Categories using ContentConnector in Ask A Question for DataSource

Product Categories using ContentConnector

MichaelSlupina — Fri, 13 Jun 2025 13:10:59 GMT

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=MainSpecsTab

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!

Re: Product Categories using ContentConnector

iM_23 — Fri, 13 Jun 2025 14:19:02 GMT

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

Re: Product Categories using ContentConnector

Modzilla — Fri, 13 Jun 2025 14:28:20 GMT

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

Re: Product Categories using ContentConnector

MichaelSlupina — Fri, 13 Jun 2025 14:47:10 GMT

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

All the Best

Michael