The CreatorCon Call for Content is officially open! Get started here.

Extracting catalog via Rest API

Lane8
Kilo Contributor

I am extracting the catalog items from SNOW using the rest API to query the sc_cat_item table. I also want to be able to extract the catalog categories that these sit within.  I have extracted the sc_category table, but I cannot find a way of linking the two tables. 

 

There is no reference to a category on the sc_cat_item table. There is a table called sc_cat_item_category but this only contains a sys_id and sys_class_name fields that don't link back to those tables. 

 

Any suggestions please?

0 REPLIES 0