Hey all, we’re trying to pull list of items from NetSuite and we’re using SuiteQL. It looks like getting all the custom fields and custom segment values requires quite a few many joins. Just wondering if we’re approaching it the wrong way. Would just doing a REST integration be better? In that case, would we be able to get the custom item fields directly?

You can use the BUILTIN.DF(fieldname) to get the direct field value, will avoid all of the joins: