Hi everyone, hope you’re doing awesome! (If this is not the right channel please point me to the right place) I was tasked with helping out connect to a 3rd party to share product details (basic info with stock and price) via a Scheduled Script, but I’m pretty new to Netsuite and I’m quite lost: • Can anyone point me to some basic examples on pulling product data? I’m able to do a basic

search.create({type: search.Type.INVENTORY_ITEM…})

but what if not all custom fields are part of that type? • Is there a way to visualize the whole DB schema or to find out all the custom fields that were created for this company? (I was not here when these were created). Currently the script is pulling 3 custom fields from _inventory_item_ but two of those are returning simply “1” and “2" instead of their actual value. Plus there are other fields that I cannot for the life of me figure out where I can get them from. I tried exploring by going to Setup > Records Catalog and I did find some of the stuff I need but I do not understand what the Join column really means. • Once I figure out how to get the remaining data, is there an easy way to join together the results if they’re not part of the same search? (sort of like when you do joins in a sql query?) Happy to share code or join a quick call if need be.