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 […]
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”: […]
In this blog, We will see how to expose an API in Workato and based on the request schema how will we get the data from Salesforce. What is an API? API stands for Application Programming Interface. In the context of APIs, the word Application refers to any software with a distinct function. Interface can […]