We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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