This is the third post in a four part series of posts that explain how users can integrate with and extend Salesforce using itDuzzit. Previously, we looked at using pre-built Salesforce duzzits. Now we’ll look at how you can create custom Salesforce integrations using pre-built Salesforce duzzits.

In this post, let’s create a duzzit that retrieves leads created today, and inserts lead data into a google spreadsheet. To get started, we’ll click “Create a Duzzit”:

We’ll just create a blank duzzit, so click “Next”:

Let’s name the duzzit “Salesforce Lead to Google Spreadsheet”, and create it:

Now we’ll edit the new duzzit. In the first step, we’ll click on “(add a do)”, which allows us to choose from a large selection of possible actions:

Since we want to get Salesforce leads, we’ll click on Salesforce, and then scroll down to choose “Salesforce Lookup Leads”. This is the same lead lookup duzzit that we ran directly in the previous post, but in this case, we’re having our custom duzzit run it. Now we need to configure how it will be run:

For the purposes of this example, we only care about leads that have been created today. As you may recall, the “Salesforce Lookup Leads” duzzit takes a date string formatted as yyyy-mm-dd (e.g. 2011-10-24). For convenience, we can click on “select value” next to the “created after” input, and use the value picker to select an appropriate date value:

There are a lot of date value choices, so we’ll have to scroll down a fairly far to get to the formatted date section:

We’ll select the appropriate format. The “created after” input now is set:

Now we’ll save the configuration by clicking on “accept”. The outputs from the “Salesforce Lookup Leads” duzzit are now displayed as inputs on the left”:

In the next few steps, we’ll be using duzzits that create and insert data into a Google spreadsheet. In order to do this, you’ll need to have a Google account and will need to add authentication to Google spreadsheets for your itDuzzit account. First, let’s call a duzzit to create a spreadsheet. We’ll do this by dropping a “Do” into the step, clicking on “Google”, and choosing the “Create New Spreadsheet” duzzit:

Here we’ve named the new spreadsheet “Leads”, and have indicated the columns that will be created in the spreadsheet.

Next, we’ll add a Loop step (dragging a loop from the “more…” menu):

We’ll loop through leads. To configure this, drag the “leads” input (under SalesforceLeads on the left) onto (select value). Now the loop looks like this:

Within the loop, we’ll add a step (drag a step into the loop), and add a “Do” within the step. For this “Do”, we’ll select the “Google Spreadsheets – Add Row” duzzit:

In this example, we’ve filled in the name of the spreadsheet, the key for the spreadsheet (which was returned when the spreadsheet was created), and column names / values for first name, last name, and title.

Now let’s run the duzzit. (From the edit screen, clicking on “Do It” brings up the duzzit run screen, and here you can click on “Do It Now”). If everything has been configured correctly, you should now have a Google spreadsheet named leads that looks something like this:

This example just scratches the surface of what can be done to quickly connect Salesforce with virtually any other application that provides web service APIs.

In the next post, we’ll look at how to create connectors for Salesforce objects (which you’ll need to do if you want to work with custom objects), and how to use SOQL within itDuzzit.

This is the second post in a four part series of posts that explain how users can integrate with and extend Salesforce using itDuzzit. In this post, we’ll look at how you can use pre-built Salesforce duzzits.

Previously, we looked at connecting itDuzzit to a Salesforce organization. Once you’ve connected to a Salesforce organization, you can run pre-built Salesforce duzzits from the Duzzit library.

When you click on “Duzzit Library”, you’ll see a number of applications for which we provide pre-built duzzit connectors and solutions:

To see Salesforce duzzits, click on “Salesforce”. All pre-built duzzits related to Salesforce are listed:

If you’ve had a chance to explore through the system, you’ll know that there are often a number of different ways to call duzzits. Right now, we’ll simply run one directly. In this example, we’ll add a lead to Salesforce using the “Salesforce Create Lead” duzzit. When we select this duzzit by clicking on it, the duzzit run form appears:

There are a number of fields on this duzzit, each corresponding to an attribute on a Salesforce lead. In this example, we’ll make the following entries:

Next, clicking on the “Do It Now” button at the bottom of the form (you’ll probably need to scroll down to see it) will push this data to Salesforce. If successful, you’ll see this:

We can also lookup the new lead using the “Salesforce Lookup Leads” duzzit. You can find this in the library, in the same listing where you found the “Salesforce Create Lead” duzzit. Let’s click on it, and search using the name “Smith”:

After clicking “Do It Now”, we’ll get the results of the lookup:

Now that we’ve seen how Salesforce duzzits can be used to push information into Salesforce and query information from Salesforce, we’re ready to use these duzzits to a cross-application solution. In the next post, we’ll show how to create custom Salesforce integrations using pre-build duzzits.

This is the first post in a four part series of posts that explain how users can integrate with and extend Salesforce using itDuzzit. In this post, we’ll look at how to connect itDuzzit to Salesforce.

First, once you’re logged into itDuzzit, go to the “Connection” tab:

In this example, the account we’re using doesn’t have any connections yet. Scrolling down, we can get to where the Salesforce connector is listed:

Clicking on “Add Connection” brings you to a screen specific to Salesforce:

itDuzzit authenticates to Salesforce via the OAuth mechanism. To support OAuth, Salesforce requires that a package be installed within the Salesforce organization you’re connecting to. If you haven’t already installed the itDuzzit package, you can do so by clicking on one of the installation links. If you’re connecting to a development or production organization, click on “Click here to install itDuzzit into a Salesforce production environment”. If you’re connecting to a sandbox organization, click on “Click here to install itDuzzit into a Salesforce sandbox (test) environment”. Note that you’ll need to have sufficient authority within Salesforce to install the itDuzzit package.

Once a package has been installed, you’ll be able to authorize itDuzzit to connect to Salesforce on your behalf. If you’re setting up a connection to a production or development environment, choose “Production” as the environment type; otherwise choose “Sandbox”, and then click on “Go to Salesforce to authorize”. If you’re already logged into the Salesforce organization you’re connecting to, itDuzzit will be authorized to connect to that organization. If you’re not logged in to Salesforce, you’ll then be shown a Salesforce login screen:

When you enter your Salesforce credentials and click on “Login”, Salesforce will authenticate you, and provide itDuzzit with an authentication token for your itDuzzit account.

Now, returning to the connections page, you’ll see Salesforce listed as one of your connections.

In the next post, we cover using pre-built Salesforce duzzits.