WebDH blog - SalesForce

ColdFusion page added to SalesForce wiki

Tue, 03 Mar 2009 16:02:00 -0700

Today I added a section for Adobe ColdFusion to the SalesForce Developer Wiki under the Web Services API section. I then added the first code sample article, showing how to do a Basic Web2Lead Implementation. I looked at a similar PHP sample done by Wayne Abbott as the basis for my article. Hopefully this will spur others in the CF Community to start adding more content to this wiki and spread the knowledge of CF as a viable web development platform.

Tips for testing web-to-lead on SalesForce sandbox server

Tue, 03 Mar 2009 14:14:00 -0700

The SalesForce Web-to-Lead URL is well known to be: https://www.salesforce.com/servlet/servlet.WebToLead?encoding=UTF-8 If you have access to a Sandbox server to do your development, you may want to test Web-to-Lead against it. You first should go into the setup area to find your OID (Organization ID) which will differ from your production OID. Find this from SalesForce's top "Setup" link. Then drill down into the left navigation menu:
App Setup / Customize / Leads / Web-to-Lead
Make sure the checkbox for Web-to-Lead Enabled is checked. Then click the "Create Web-to-Lead Form" button. On the next page, keep all selected fields as defaults and click the "Generate" button. Look in the generated HTML output for your unique OID which is given in the first hidden form field. You should see lines of code like this:

Remember, you are developing for tests against the Sandbox server, so you will need to modify the Form action to match the URL of your Sandbox homepage. Look at your Sandbox url and replace "www" with the proper subdomain, such as "cs2" in this example.
Example Sandbox homepage: https://cs2.salesforce.com/home/home.jsp
New Web-to-Lead Form action: https://cs2.salesforce.com/servlet/servlet.WebToLead?encoding=UTF-8

Using ColdFusion to create a Lead in SalesForce using SOAP

Thu, 11 Oct 2007 09:56:00 -0700

At my day job, Secure Computing, I needed to figure out how to create a new Lead in SalesForce from a partner deal registration web application. I already had experience using Web-to-lead (WTL), but this would not work for the type of Lead I was trying to create. In this case, the Lead had fields for a Contact and Account (both lookup fields), which WTL doesn't support. I did some google searching for ColdFusion web services and SalesForce and found myself at the Adobe forums. After reading all the posts and grabbing some sample code, I started to figure it out. After a few days of coding and testing using SOAP web services, I had my solution. I posted my findings back to the Adobe forum to give back to the community, and my submission is found here on page 3 (posted by "tccfug"). The only drawback is I wasn't able to associate the Lead to a Campaign. However, it wasn't a show stopper and my solution is now in production. Here's the code, hope it will help somebody else down the road... Make sure you change the first lines of code with your respective username and password to login to SalesForce. This is required to first begin a new session, then create the lead with the sessionid.












 







#UserName# 
#Pwd#










",cfhttp.FileContent)>
",cfhttp.FileContent)>

",cfhttp.FileContent)>
",cfhttp.FileContent)>






 
  

      
   #sesid_final#   
    
   
    
     
       
   01250000000DKxf  
   Rich     
   Dude
   CEO
   rich_dude@prospect.com
   TEST
   123 Money Lane
   Las Vegas
   NV
   US
   89109
   888-PHONE
   777-FAX
   Other
   00550000000wtO9
   
      
  
 




 
 
 
 
 
 
 
 
 
 


",cfhttp.FileContent)>
",cfhttp.FileContent)>


	",cfhttp.FileContent)>
	",cfhttp.FileContent)>
	
	
	Lead ID: #Left(leadid_final,15)#
	


	",cfhttp.FileContent)>
	
	",cfhttp.FileContent)>
	",cfhttp.FileContent)>
	
	
	Fault Code: #faultcode_final#

	Fault String: #faultstring_final#
	


	Unknown response

	#cfhttp.FileContent#

Naming a ColdFusion variable beginning with a number

Fri, 12 Jan 2007 15:28:00 -0700

The naming rules for creating ColdFusion variables are found here in the LiveDocs. The first bullet point is

A variable name must begin with a letter, underscore, or Unicode currency symbol.

However, I am doing some integration with SalesForce.com, and they have custom variables that are named like "00N30000000dqFd". Now, if I want to name a form variable with that name, and do some validation before posting the form, I was running into problems. Here is some sample code and comments that outline my struggles. If you comment out the 3 spots (lines 3, 8, and 13-15) that throw errors, the code will run and you will get the 3 cfdumps.

Here is a demo of this in action.