Dell Boomi API Management-Configure Rest Based API for form Based Jason Response

Dell Boomi API Management

Most of you are familiar with Dell Boomi API management feature. APIs are implemented as deployable API components. There are two types: API Service and API Proxy. Using API components enables you to consolidate API design into a single, explicit location.

In API Service, we can define an endpoint using a Rest or Soap.

Configure API:

First we have to configure an API.Give your API a title and then a base path.As Shown in screen shot below.

Then go on Rest Tab and it will automatically configure path for you then click on Add End Point button.Configure you end point. Configure your input type and output type and create a process that will handle your request.As shown in screen shot.

Create Listener Process

Now create a process that will listen all the request send to API. In my example i am configuring a process that will get two inputs as API parameter and on the bases of those inputs insert data into salesforce.

Starting connector will be WebService Server Connector with Listen action. Create its operation with 

Operation Type = Get

Object= will be your resource path you configure during end point creation

Expected Input Type = Single Data

Response Output Type = Single Data

Result Content Type = text/plain

Then you have to use this groovy script so parameter values can be assigned to your variables.Below groovy script will be used.

import java.util.Properties;

import java.io.InputStream;

import org.apache.http.NameValuePair;

import org.apache.http.client.utils.URLEncodedUtils;

import java.nio.charset.StandardCharsets;

for( int i = 0; i < dataContext.getDataCount(); i++ ) {

    InputStream is = dataContext.getStream(i);

    Properties props = dataContext.getProperties(i);

    def input = is.text;

    def data = URLEncodedUtils.parse(input, StandardCharsets.UTF_8) as List<NameValuePair>;

    

    for ( NameValuePair arg: data ) {

        props.setProperty("document.dynamic.userdefined." + arg.name, arg.value);

    }

    

    dataContext.storeStream(is, props);

}

Now we have to use dynamic properties to get values from endpoints. Will create two dynamic process properties to get Account Id and Account Key. Dynamic process property name = AccountId and AccountKey. It will get value from our endpoint. Our endpoint is 

Http:Demo//ws/rest/Test/Lim?AID=123456&Key=444 

Dynamic Process Property Name = AccountId

Parameter = Dynamic document property with name = AID

Dynamic Process Property Name = AccountKey

Parameter = Dynamic document property with name = Key

Note: One thing to note here is that my dynamic process property names are same as my url parameter name. This is the key point to set variables. The bold words in my url are my parameters placeholder i have given the same name to my dynamic process property. This is how you can set values.

In my case we will use another dynamic process property to check that the account id and key combination is in salesforce or not.In the decision box will check if salesforce do not have this combination we will send an email alert if this combination exists we will insert data in salesforce.

Salesforce Connector

Configuring salesforce connector or mapping data is easy tasks and can be found in below links.

https://help.boomi.com/bundle/connectors/page/r-atm-Salesforce_Connector_6ff3c702-e986-41a1-be5b-a00e76ded0a5.html

Dell Boomi: Update Flat File/CSV data using groovy script

Update data of CSV file using Groovy

In this blog i am trying to share my experience of updating csv data using groovy scripts. I had an explicit requirement that i have to remove leading zeros from a integrer data field before passing it to my map.

As you all work on Dell Boomi so you know that in Boomi there are so many built in Strings function which can do this task very easily or you can use a simple javascript code to achieve this functionality.

Javascript code:

Output = Input.replace(/^0+/, '') ;

I have to do this by groovy because in the data process you can only use groovy script and i have to remove leading zeros before passing it to map function.

Sample file:

test-trstevens113@msn.com,Test User,0000100098,8797784047620,trstevenstest@msn.com,,,0,2016-01-18 11:36:32.847,0000123652

test-tstevens@lves.washk12.org,Test2 User,0000100098,87976289823652,tstevens222@lves.washk12.org,,,0,2016-01-18 11:35:45.327,000012352

Note:

I have to remove leading zeros from column 3 that is "0000100098" but in code below i use 2 as this is indexed with zero.

Code of Groovy:

import java.util.Properties;

import java.io.InputStream;

import java.io.BufferedReader;

String DELIMITER = ",";

for( int i = 0; i < dataContext.getDataCount(); i++ ) {

   InputStream is = dataContext.getStream(i);

   Properties props = dataContext.getProperties(i);

   BufferedReader reader = new BufferedReader(new InputStreamReader(is));

   StringBuffer outData = new StringBuffer();

   int lineNum = 0;

      

   while ((line = reader.readLine()) != null) {

// Parse the line into separate columns splitting on the delimiter defined above

String[] columns = line.split(DELIMITER);

         // Obtain a column's value by its known position on the line (zero-indexed)

String someColumnValue = columns[2];

columns[2] = someColumnValue.replaceFirst("^0+(?!\$)", "");

for(int k = 0; k < columns.length; k++){

outData = outData.append(columns[k]+DELIMITER);

//outData.append('\n');

}

    

      lineNum++;

   }

   

   // Convert the output StringBuffer to an InputStream and store in the dataContext

   is = new ByteArrayInputStream(outData.toString().getBytes("UTF-8"));

   dataContext.storeStream(is, props);

   

}

Hope this helps you. Happy Coding !!!