In this blog, we will see how to call a stored procedure in Dell Boomi. What is the Stored Procedure? A Stored procedure is a set of SQL Statements which are stored in a relational management system as a group so that it can be reused and shared by multiple programs. The stored procedure accepts […]
In this Blog, we will see how to handle API Pagination in Boomi What is API Pagination? When we make calls to API, there will be a lot of results to return. To avoid that, we paginate the results to make sure responses are easier to handle. Pagination is when a query returns more results […]
Connect with FTP and read files from FTP in OIC What is FTP? 🡺 FTP stands for File Transfer Protocol. FTP (File Transfer Protocol) is a network protocol for transmitting files between computers over Transmission Control Protocol/Internet Protocol (TCP/IP) connections. Within the TCP/IP suite, FTP is considered an application layer protocol. The end user’s computer […]
Consume Salesforce API Using the REST Client Connector What is Rest? An API, or application programming interface, is a set of rules that define how applications or devices can connect to and communicate with each other. A REST API is an API that conforms to the design principles of the REST, or representational state transfer architectural style. For […]
In this blog we will perform sorting of a document based on a particular field, sample input and output documents are given below: Input: Output: Overview of the use case: Steps: Step 1. Go to platform.boomi.com Step 2. Login by giving your valid credentials (Username and Password). Step 3. The home page will be displayed, […]
What is Scheduling? Process execution schedules are standardized schedules that control when a process should run. You can add multiple schedules to a process for different execution requirements. A process must be deployed to an Atom, Molecule, or Atom Cloud to run on a schedule. A schedule starts as soon as you deploy the process […]
Install Jar files for SQL Server In this blog, we will see how to install Jar files for SQL Server and deploy them to the atom. Step 1: Let us begin with the steps. Step 1: Search for SQL jars and choose 2nd option as shown. Step 2: Once we open the link, click on […]
What is Solace queue? A queue acts as both a destination where clients can publish messages to and as an endpoint that clients can bind consumers to and consume messages from. A queue is typically used in a point-to-point (PTP) messaging environment. It’s also possible to add topic subscriptions to a queue so messages published […]
In this blog, let us discuss about how to do a Manual OAuth call with client credentials grant type. To do manual OAuth call in boomi, we have a connector called “HTTP Client” through which we can use the service provided by third party API. Here, we want to access particular employee data from salesforce […]
In this blog, let us discuss how to capture and fetch those fields that are coming in the request profile from a Database table. First, let us see the payload that would be the request: { “requestCount”: 2, “requests”:[ { “studentId”: “abc”, “fields”: [“emailId”,”percentage”,”grade”,”firstName”,”lastName”,”studentId”,”branch”,”YearOfJoining”] }, { “studentId”: […]
