In Dell Boomi, properties play a crucial role in handling values that may change during the execution of an integration process. Among the different types of properties, Dynamic Process Properties and Dynamic Document Properties are often confused because both can be set and modified at runtime. However, they serve different purposes and scopes within an… Continue reading Difference Between Dynamic Process Property and Dynamic Document Property in Boomi Integrations
Author: Christo Johns
Adding a Custom HTML Button Near a Body Field in NetSuite Using UserEvent Script
This article will guide you through the process of adding a custom HTML button near a body field in NetSuite using a UserEvent script. This technique is useful for adding custom functionality to NetSuite forms without modifying the core UI. Understanding the Use Case In NetSuite development, you may often need to add custom buttons… Continue reading Adding a Custom HTML Button Near a Body Field in NetSuite Using UserEvent Script
Sample SQL QUERY to fetch Custom Price levels from a customer record
Use this query to fetch the custom price levels from a customer record: QUERY: SELECT internalid, customername, customeremail, itemID, displayname, currency, unitprice, FROM ( SELECT item.id AS internalid, c.altname AS customername, c.email AS customeremail, … Continue reading Sample SQL QUERY to fetch Custom Price levels from a customer record
Generating SFTP GUID and Host Key using a NetSuite Suitelet
Overview When integrating NetSuite with external systems over SFTP (Secure File Transfer Protocol), it is often necessary to store or retrieve authentication credentials such as GUIDs (Globally Unique Identifiers) and Host Keys. These credentials are essential for NetSuite’s SFTP connection objects to validate secure transfers. In this article, we’ll walk through a Suitelet script that… Continue reading Generating SFTP GUID and Host Key using a NetSuite Suitelet
How to Create a Web Listener in Boomi Integration
A Web Listener in Boomi is an essential component when building real-time integrations, especially for handling inbound HTTP requests from external systems (e.g., webhooks, APIs, or other applications). It acts as a server endpoint that listens for incoming HTTP requests and triggers a Boomi process. In this article, we’ll walk through step-by-step instructions to create… Continue reading How to Create a Web Listener in Boomi Integration
How to fetch a suitelet date field without the time and timezone.
Use : record.getText({ fieldId: ‘custpage_jj_date’ }); to get only the date. use newDate() to get the corresponding date object.
How to test an SQL code in NetSuite using SuiteQL Query Tool
Go to Customization -> SuiteBuilder-> Search and Install Bundles Select and Install SuiteQL Query Tool from the bundles: After Installing the bundle go to SuiteQL-> SuiteLet : In the suitlet page paste the code and click Run Query:
Sample query to fetch custom price levels in customer record
SELECT netprice, internalid, base_price FROM ( SELECT cip.price AS netprice, cip.item AS internalid, ip.price AS base_price, ROW_NUMBER() OVER (PARTITION BY cip.item ORDER BY ip.priceLevel ASC)… Continue reading Sample query to fetch custom price levels in customer record
Sample Query to fetch Pricing per Customer with itemtype and Customer ID as filter
SELECT BUILTIN_RESULT.TYPE_INTEGER(pricingWithCustomers.internalid) AS internalid, BUILTIN_RESULT.TYPE_PERCENT(priceLevel.discountpct) AS discountpct, BUILTIN_RESULT.TYPE_CURRENCY(pricingWithCustomers.unitprice, BUILTIN.CURRENCY(pricingWithCustomers.unitprice)) AS netprice FROM pricingWithCustomers LEFT JOIN item ON pricingWithCustomers.item = item.ID LEFT JOIN priceLevel ON pricingWithCustomers.pricelevel = priceLevel.ID LEFT JOIN Customer ON pricingWithCustomers.customer = Customer.ID WHERE (… Continue reading Sample Query to fetch Pricing per Customer with itemtype and Customer ID as filter
How to Share OAuth 2.0 Integration Credentials in NetSuite Without Granting Account Access
When setting up OAuth 2.0 integrations in NetSuite, there may be scenarios where you need to share the integration credentials with someone who does not have direct access to the NetSuite account. To securely enable this, NetSuite provides an OAuth 2.0 Consent Policy during the creation of the integration record. By selecting the appropriate consent… Continue reading How to Share OAuth 2.0 Integration Credentials in NetSuite Without Granting Account Access