Welcome!

Adobe Flex Authors: Matthew Lobas, PR.com Newswire, Shelly Palmer, Kevin Benedict

Related Topics: Adobe Flex, ColdFusion

Adobe Flex: Article

Using the Adobe Flex Toolkit for Salesforce.com

New integration opportunities

In April 2007 Adobe and Salesforce.com announced the availability of the Flex toolkit for Apex, Salesforce.com's on-demand programming language and API for interaction with their hosted CRM solution. This toolkit makes it simple to build Flex applications that interact with your Salesforce.com database.

The benefits of using Flex are numerous: create far more effective and efficient dashboards for your sales team, build "mashup" user interfaces that bring data together from Salesforce and your enterprise systems, and improve the overall usability of Salesforce.com with tools you're already comfortable with.

The API itself is rather simple. Using the toolkit you can execute query operations (create, update, delete), run full-text searches, pull back metadata on your Salesforce environment (tabs, controls, layout information), send e-mail messages, and work with the workflow engine. The most useful aspect of the API is the query operations, so we'll focus on that in the following sample application "sfQuery."

Getting Started
The toolkit is surprisingly easy to get started with. Simply download it from http://www.salesforce.com/developer, unzip the swc file to a convenient location, and add it to your Flex application's build path (see Figure 1).

Add a reference to the Salesforce namespace to your mx:Application tag as indicated below:

<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"
xmlns:salesforce="com.salesforce.*" layout="absolute" >

To create a connection to the Salesforce.com servers, add this line of code to your application:

<salesforce:Connection id="apex"/>

That's the extent of the configuration of your application. We can now use the connection (referenced as "apex") to interact with the Apex platform.

SOQL: The Salesforce Object Query Language
While this isn't necessarily directly related to the toolkit, it's important to understand some of the peculiarities of SOQL. SOQL is very much like SQL, but with a few key differences. For example, wildcards aren't permitted in your field list in a select statement. Aggregate expressions are basically not supported except for count(), but even that's limited. The biggest difference to be forewarned about is how SOQL handles what we traditionally think of as "join" statements. Instead of returning a table of data, SOQL returns nested result sets from the child tables in a join statement. They refer to this approach as "SOQL relationships." Outer join capability is expected to be included in the Spring 2007 release of Apex. I recommend that you read www.salesforce.com/us/developer/docs/api/index.htm to understand just what you can (and can't) do in SOQL in more detail. It's not difficult to make up the difference in ActionScript, but it sure feels weird knowing you're doing something in code that you could do much easier in SQL!
Anyway, back to the demo:

Doing Stuff
Our demo application will be a simple SOQL query testing application so we can learn the SOQL syntax. You've already created your connection object, so to activate it we have to log in. Prepare a LoginRequest object by populating the username and password fields. Notice that we're defining a callback function (loginResult) that will be fired off when the login response from the Salesforce.com servers is received.

private function login():void
      {
var lr:LoginRequest = new LoginRequest;
// username/password used when logging in interactively
lr.username = username.text;
lr.password = pwd.text;
// server_url and session_id used when deployed in the salesforce environment
// lr.server_url = Application.application.parameters.server_url;
// lr.session_id = Application.application.parameters.session_id;
lr.callback = new AsyncResponder(loginResult);
apex.login(lr);
}

Our callback function is rather simple in this example - all we're doing is changing states. Now that we're logged in let's enter a quick SOQL query:

SELECT Account.Name,
(SELECT Contact.FirstName, Contact.LastName FROM Account.Contacts)
FROM Account

This query will retrieve all contacts for each account in our Salesforce database when the "Execute Query" button is clicked.

   private function executeQuery():void
   {
      apex.query(txtQuery.text,
        new AsyncResponder(function (qr:QueryResult):void
        {
txtQueryOutput.text = ObjectUtil.toString(qr.records);
        })
);
   }

The query() function takes an SOQL statement as the first argument and a callback function as its second. We'll pass the query off to the "apex" connection object and wait for a response. Stylistic comment: rather than define the callback in another function as I did with the loginResult function, I opted to define it inline as an anonymous function. Either method works; the decision as to which way you do this is purely personal.

Once we get the data back we'll use the ObjectUtil class to dump out the returned object as a string in the larger text area. If the query failed, we'd get an error and no results would render. Just like that we now have a quick SOQL statement tester that can help us build our future Flex/Apex applications.


More Stories By Stephen Rittler

Stephen Rittler is the president of Countermarch Systems LLC, a company dedicated to improving alumni relations in higher education through the proper application of CRM tools, social networking and process improvement through technology. His company has developed effective solutions for clients in education, government, publishing and manufacturing. He is a Certified Advanced ColdFusion MX developer and has contributed to the CF community through his writing, leadership of the Philadelphia ColdFusion User Group and presentations on a variety of topics. Steve is a musician at heart but has yet to figure out how to play his saxophone and code at the same time. You can read his blog at http://www.countermarch.com/blog.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
Nordstrom is transforming the way that they do business and the cloud is the key to enabling speed and hyper personalized customer experiences. In his session at 21st Cloud Expo, Ken Schow, VP of Engineering at Nordstrom, will discuss some of the key learnings and common pitfalls of large enterprises moving to the cloud. This includes strategies around choosing a cloud provider(s), architecture, and lessons learned. In addition, he’ll go over some of the best practices for structured team migrat...
SYS-CON Events announced today that Taica will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Taica manufacturers Alpha-GEL brand silicone components and materials, which maintain outstanding performance over a wide temperature range -40C to +200C. For more information, visit http://www.taica.co.jp/english/.
SYS-CON Events announced today that MIRAI Inc. will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. MIRAI Inc. are IT consultants from the public sector whose mission is to solve social issues by technology and innovation and to create a meaningful future for people.
Recently, REAN Cloud built a digital concierge for a North Carolina hospital that had observed that most patient call button questions were repetitive. In addition, the paper-based process used to measure patient health metrics was laborious, not in real-time and sometimes error-prone. In their session at 21st Cloud Expo, Sean Finnerty, Executive Director, Practice Lead, Health Care & Life Science at REAN Cloud, and Dr. S.P.T. Krishnan, Principal Architect at REAN Cloud, will discuss how they bu...
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicate or sell. In their Day 3 Keynote at 21st Cloud Expo, Greg Chambers, Global Group Director, Digital Innovation, Coca-Cola, and Vidya Nagarajan, a Senior Product Manager at Google, will discuss how from store operations...
As hybrid cloud becomes the de-facto standard mode of operation for most enterprises, new challenges arise on how to efficiently and economically share data across environments. In his session at 21st Cloud Expo, Dr. Allon Cohen, VP of Product at Elastifile, will explore new techniques and best practices that help enterprise IT benefit from the advantages of hybrid cloud environments by enabling data availability for both legacy enterprise and cloud-native mission critical applications. By rev...
Join IBM November 1 at 21st Cloud Expo at the Santa Clara Convention Center in Santa Clara, CA, and learn how IBM Watson can bring cognitive services and AI to intelligent, unmanned systems. Cognitive analysis impacts today’s systems with unparalleled ability that were previously available only to manned, back-end operations. Thanks to cloud processing, IBM Watson can bring cognitive services and AI to intelligent, unmanned systems. Imagine a robot vacuum that becomes your personal assistant tha...
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
SYS-CON Events announced today that Datera will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Datera offers a radically new approach to data management, where innovative software makes data infrastructure invisible, elastic and able to perform at the highest level. It eliminates hardware lock-in and gives IT organizations the choice to source x86 server nodes, with business model option...
Infoblox delivers Actionable Network Intelligence to enterprise, government, and service provider customers around the world. They are the industry leader in DNS, DHCP, and IP address management, the category known as DDI. We empower thousands of organizations to control and secure their networks from the core-enabling them to increase efficiency and visibility, improve customer service, and meet compliance requirements.
Digital transformation is changing the face of business. The IDC predicts that enterprises will commit to a massive new scale of digital transformation, to stake out leadership positions in the "digital transformation economy." Accordingly, attendees at the upcoming Cloud Expo | @ThingsExpo at the Santa Clara Convention Center in Santa Clara, CA, Oct 31-Nov 2, will find fresh new content in a new track called Enterprise Cloud & Digital Transformation.
SYS-CON Events announced today that N3N will exhibit at SYS-CON's @ThingsExpo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. N3N’s solutions increase the effectiveness of operations and control centers, increase the value of IoT investments, and facilitate real-time operational decision making. N3N enables operations teams with a four dimensional digital “big board” that consolidates real-time live video feeds alongside IoT sensor data a...
SYS-CON Events announced today that NetApp has been named “Bronze Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. NetApp is the data authority for hybrid cloud. NetApp provides a full range of hybrid cloud data services that simplify management of applications and data across cloud and on-premises environments to accelerate digital transformation. Together with their partners, NetApp emp...
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...
SYS-CON Events announced today that Avere Systems, a leading provider of hybrid cloud enablement solutions, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere Systems was created by file systems experts determined to reinvent storage by changing the way enterprises thought about and bought storage resources. With decades of experience behind the company’s founders, Avere got its ...
SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere delivers a more modern architectural approach to storage that doesn't require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbui...
SYS-CON Events announced today that IBM has been named “Diamond Sponsor” of SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California.
SYS-CON Events announced today that Ryobi Systems will exhibit at the Japan External Trade Organization (JETRO) Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Ryobi Systems Co., Ltd., as an information service company, specialized in business support for local governments and medical industry. We are challenging to achive the precision farming with AI. For more information, visit http:...
High-velocity engineering teams are applying not only continuous delivery processes, but also lessons in experimentation from established leaders like Amazon, Netflix, and Facebook. These companies have made experimentation a foundation for their release processes, allowing them to try out major feature releases and redesigns within smaller groups before making them broadly available. In his session at 21st Cloud Expo, Brian Lucas, Senior Staff Engineer at Optimizely, will discuss how by using...
In this strange new world where more and more power is drawn from business technology, companies are effectively straddling two paths on the road to innovation and transformation into digital enterprises. The first path is the heritage trail – with “legacy” technology forming the background. Here, extant technologies are transformed by core IT teams to provide more API-driven approaches. Legacy systems can restrict companies that are transitioning into digital enterprises. To truly become a lead...