This blog will cover how we can perform SQL JOINS in Boomi. Prerequisites: We have to create two tables in the database named Employee_Blog and Department_Blog having columns Id, Name, Dept ID and Dept ID, Dept name respectively. Figure 1: Employee_Blog Figure 2: Department_Blog Step 1: Log on to the Boomi platform (https://platform.boomi.com/) with a […]
Expose SOAP API in OIC What is SOAP? SOAP stands for Simple Object Access Protocol. SOAP is the XML-based message protocol that enables the distributed elements of an application to communicate. SOAP can be carried over various standard protocols, including the web-related Hypertext Transfer Protocol (HTTP). SOAP is a lightweight protocol used to create web […]
Google Sheet Module (MuleSoft) Prerequisites: We need to have an active Google account and we need to make use of Google APIs to leverage the Google Sheet module provided by MuleSoft. To do so we need to follow the following steps: First we need to go to the Google API console using the URL https://console.cloud.google.com/apis/library. […]
Introduction It is possible to generate documents directly from data processing shapes in Boomi by storing the data in a streaming store and producing the document. In this discussion, we will explore how to achieve this using both Groovy and JavaScript. Groovy code breakdown Let’s explore the code in detail: import java.util.Properties; import java.io.InputStream; import […]
What is IMAP: IMAP stands for Internet Message Access Protocol It is an application layer protocol and is the most commonly used protocol for retrieving emails It was designed by Mark Crispin in 1986 The current version of IMAP is IMAP4 This term is also known as Internet mail access protocol, Interactive mail access protocol, […]
Introduction: GraphQL is a query language for API’s and a runtime for executing those queries against our requested data. GraphQL provides a more efficient, powerful, and flexible alternative to the traditional REST API. Advantages: With GraphQL, we can request only the data that we need, and nothing more. This helps in reducing over-fetching or under-fetching […]
Parse Template is the Mule component to use for processing a template and obtaining a result. A template is defined as text with embedded Mule expressions that are evaluated and replaced with their result. There are some scenarios where we need to use a parse template in the flow. Some of the scenarios are: When […]
API Service Component: Routing Headers: When we have two or more REST APIs with same endpoint, the Routing header will help us to route to specific API or webservice (i.e., linked subprocess) based on specified header value. Steps to expose an API using a web service server connector Step 1.1: Log onto the Boomi platform […]
In this blog, we will develop a synchronous soap API. In this Use case, We will expose soap which takes employee id as request. We will retrieve employee data from database using employee id. Then, we will send employee data as response. Let us begin with the steps. Step 1: Log on to Boomi platform […]
HOW TO SEND AND RECEIVE TO/FROM AMAZON SQS. In this blog, we will see how to send and receive to/from Amazon SQS. What is Amazon SQS? Amazon Simple Queue Service (SQS) is a message queue service offered by Amazon Web Services. It is used by distributed applications to exchange messages through a polling model. The […]