Author: Christo Johns

Connecting Power BI or Excel to NetSuite Using ODBC Connector

Integrating NetSuite SuiteAnalytics Connect with Power BI allows you to visualize and analyze NetSuite data seamlessly. This guide walks you through the setup process using the 64-bit MySQL ODBC connector. ? Prerequisites NetSuite account with SuiteAnalytics Connect enabled Power BI Desktop installed 64-bit MySQL ODBC Connector (download from MySQL official site) Administrative access to configure… Continue reading Connecting Power BI or Excel to NetSuite Using ODBC Connector

Boomi SFTP GET Operation: Get and Delete

The SFTP GET operation in Boomi is used to retrieve files from a remote SFTP server. One of the most commonly used actions is “Get and Delete”, which not only downloads the file but also removes it from the remote directory after successful retrieval. This is useful for workflows where files should not remain on… Continue reading Boomi SFTP GET Operation: Get and Delete

Difference Between Dynamic Process Property and Dynamic Document Property in Boomi Integrations

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

Published
Categorized as Boomi Tagged ,

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

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