Load a workbook to suitelet script

Using N/query module in the suitelet for load the workbook to the script. Create data set and workbook in NetSuite and export the code similar as saved search and apply to the script.

      /* Query */
            const itemQueryDBHK = query.create({
                type: query.Type.ITEM,
            });

            /* Joins */
            const itemvendorJoinCZFK = itemQueryDBHK.autoJoin({
                fieldId: 'itemvendor',
            });

            const vendorJoinSYTK = itemvendorJoinCZFK.autoJoin({
                fieldId: 'vendor',
            });

            const subsidiaryJoinDECZ = itemvendorJoinCZFK.autoJoin({
                fieldId: 'subsidiary',
            });

            /* Conditions */
          
            const itemQueryDBHKConditionTLSS = itemvendorJoinCZFK.createCondition({
                fieldId: 'preferredvendor',
                operator: query.Operator.IS,
                values: [
                    true,
                ],
            });

            const itemQueryDBHKConditionSYLP = subsidiaryJoinDECZ.createCondition({
                fieldId: 'id',
                operator: query.Operator.ANY_OF,
                values: projectSubsidiary,
            });

            const itemQueryDBHKConditionIHCT = itemQueryDBHK.createCondition({
                fieldId: 'id',
                operator: query.Operator.ANY_OF,
                values: removeDuplicate,
            });

            itemQueryDBHK.condition = itemQueryDBHK.and(
                itemQueryDBHKConditionIHCT,
                itemQueryDBHKConditionSYLP,
                itemQueryDBHKConditionTLSS,
            );

            /* Columns */
            const itemQueryDBHKColumnGWFJ = itemQueryDBHK.createColumn({
                fieldId: 'id',
                groupBy: false,
                context: {
                    name: 'RAW',
                },
                // label: 'Item Id',
                alias: 'GWFJ',
            });

            const itemQueryDBHKColumnJJIY = itemQueryDBHK.createColumn({
                fieldId: 'itemid',
                groupBy: false,
                context: {
                    name: 'RAW',
                },
                // label: 'Item Name/Number',
                alias: 'JJIY',
            });

            const itemQueryDBHKColumnSWGR = vendorJoinSYTK.createColumn({
                fieldId: 'id',
                groupBy: false,
                context: {
                    name: 'RAW',
                },
                // label: 'Vendor ID',
                alias: 'SWGR',
            });

            const itemQueryDBHKColumnDKCP = itemvendorJoinCZFK.createColumn({
                fieldId: 'vendor',
                groupBy: false,
                context: {
                    name: 'DISPLAY',
                },
                // label: 'Vendor',
                alias: 'DKCP',
            });

            const itemQueryDBHKColumnUFFQ = subsidiaryJoinDECZ.createColumn({
                fieldId: 'id',
                groupBy: false,
                context: {
                    name: 'RAW',
                },
                // label: 'Subsidiary ID',
                alias: 'UFFQ',
            });

            const itemQueryDBHKColumnWQXZ = itemvendorJoinCZFK.createColumn({
                fieldId: 'subsidiary',
                groupBy: false,
                context: {
                    name: 'DISPLAY',
                },
                // label: 'Subsidiary',
                alias: 'WQXZ',
            });

            itemQueryDBHK.columns = [
                itemQueryDBHKColumnGWFJ,
                itemQueryDBHKColumnSWGR,
                itemQueryDBHKColumnUFFQ
            ];

/* Results */
            itemQueryDBHK.run().results.forEach(result => {
                log.debug("Query result testFunctin", result);
             
            });
            
}