We help IT Professionals succeed at work.






Salesforce is a Platform as a Service (PaaS) for cloud-based customer resource management that includes components for case and task management, data management and a help desk system. It also includes systems for add-on applications written in Apex, a proprietary Java-like language, and systems for human resources management, employee training and performance management.

In Salesforce, how do I create a Service Appointment programmaticly via Force API (SOAP or REST API)?

Are there known method calls that do this?

C# code-behind

I have linked to the WSDL can I can create ServiceAppointment objects, but they have no internal methods I can call.

ServiceAppointment sa = new ServiceAppointment();

//sa.CreateServiceAppointment(  ... params ... )  //   nothing like this exists.

Open in new window

I am struggling with connecting with our salesforce sandbox.

For example, in Postman, what would a valid request look like using oauth token?

Should there be a callback URL (does there need to be?)
I need to perform an encrypted pull from SalesForce to an on prem SQL Server. I was reading some articles that SSIS can do this, I am just making sure that data does not come down as clear text.

Is there a way to just get a single pull of all the sales force data into the on prem SQL Server and make sure the channel is encrypted?
hold.tarI have failing call to update a table of salesforce. It returns this message:

update Opportunity set NextStep='Contact John Smith' where ID = '0066g00000fjfOqAAI'[ { "message" : "unexpected token: update", "errorCode" : "MALFORMED_QUERY" } ]

Here is my source code

public class SFEngine {
        public static final String clientId="3MVG9LBJLApeX_PDRFsRBGTuqsN.m3Vd1bIwEF5_FNoEUKGVX0gBqUM1YdL52614KXSW9O6pL6abWun9soVyw";

        public static final String clientSecret="8F418A0BCE45412081ED5D3057A20B178C203A05EC368BFC67D82FF5C4BFBD92";
        public static final String redirectUrl="https://na174.salesforce.com/services/oauth2/callback";
        public static  String tokenUrl="https://login.salesforce.com/services/oauth2/token";
        public static final String environment="https://login.salesforce.com";
        public static final String username="xxxxxxxxxxx";
        public static final String password="xxxxxxxxxxx";                

        public static  String accessToken="";
        public static  String instanceUrl="";
        public HttpClient httpclient;
        public  HttpResponse queryResponse ;
        public  JsonNode queryResults;
        public  HttpGet get;
        public  URIBuilder builder;

private static final String TOKEN_URL =  "https://login.salesforce.com/services/oauth2/token";
public static String  OpenRest(String ID, String Field, String Value) {

        String consumerKey = clientId;
I am trying to achieve SAML single sign on between NetSuite ERP and Salesforce.
Here are the steps I followed.

I set up my Salesforce developer account as Identity Provider.
Salesforce Identity Provider
I created NetSuite SAML Configuation
NetSuite SAML Setup
I created a Connected App and entered NetSuite ACS URL.
Connected App
I created a Salesforce User
Salesforce User
I created a Customer record in NetSuite with same Email address and given it SAML custom role.
NetSuite Customer Record
When Salesforce user clicks on NetSuite URL hyperlink from a Visualforce page, the user is not automatically logged into NetSuite.
User should be logged into NetSuite
What am I doing wrong ?
How can I say in below code convert all fields into upper case ?

<!--  ----------------------------------------------------------------------  -->
<!--  NOTE: Please add the following <META> element to your page <HEAD>.      -->
<!--  If necessary, please modify the charset parameter to specify the        -->
<!--  character set of your HTML page.                                        -->
<!--  ----------------------------------------------------------------------  -->

<META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=UTF-8">

<!--  ----------------------------------------------------------------------  -->
<!--  NOTE: Please add the following <FORM> element to your page.             -->
<!--  ----------------------------------------------------------------------  -->

<form action="https://webto.salesforce.com/servlet/servlet.WebToLead?encoding=UTF-8" method="POST">

<input type=hidden name="oid" value="00D400000009UWY">
<input type=hidden name="retURL" value="http://">

<!--  ----------------------------------------------------------------------  -->
<!--  NOTE: These fields are optional debugging elements. Please uncomment    -->
<!--  these lines if you wish to test in debug mode.                          -->
<!--  <input type="hidden" name="debug" value=1>                              -->
<!--  <input type="hidden" name="debugEmail"                                  -->
<!--  value="dkelner@plasticade.com">                             …
how to split the map from sql result by filtering the value.

Map<string, AccountList> AccountListMap = new Map<String, [Select Id, Name, AccountType  from Accoount where AccountType in ('A','B','C')]>;

How can I get AccountListMap for only AccoountType = 'A'     or AccoountType = 'B'   ?

I d like to handle a ticketing System Remedy Force Powershell based: (to automate stuff) query tickets, tasks assigned to a group, user, create tickets, close etc. There is an api to use

But dont get result out of it. Sales force Online is used. Also dual factor: cert and use/pw
Could you help me, step by step please.

When it comes to cloud based applications like salesforce, office 365, what are the biggest security concerns when storing and managing sensitive data?   Does data need to be backed up outside of these systems in case of a failure?  Is it more secure to manage data in house rather than in the cloud?  What are the security risks of going to the cloud vs. staying on premise?  Is one better than the other for remote clients?

Thanks for your insights on these questions.
I'd be interested in connecting with sales force contractors who can do work on an as needed basis, in the United States, telework.

There used to be a job thing on here, but either it's gone or I can't find it any longer.

Got into a database and wanted to do some analytics on it with countries and noticed in several US based companies the contacts & accounts had a lovely variety of names for countries. So many US based companies either had US, USA, U.S. U.S.A. United States....you get the point.
Does Salesforce have the capability to take a field and replace all records with a naming convention that is consistent?
I need to change them all to "USA". It would take forever to open each contact or account to correct this. 9k
Can Salesforce do this internally on its own or would I have to go to a third party tool to get that fixed?
What is happening is my data analysis is not consistent with what it needs to be as summary data and totals are all off.
I found the Salesforce Data Loader and it has 3 features I am investigating. Is this the tool that can do it? If not, does Salesforce do it another way?
Data Loader ToolAny help appreciated. Thank you.

We are to deploy Sales force Cloud to users.  From initial testing 2FA looks to work well using the authenticator app, however we are now proposing to block access by corporate IP ranges i.e. our firewall WAN IPs, rather than 2FA.  This will mean VPN for remote users will be required not only for SF but other current and future apps.  
Unfortunately the subscription/evaluation has expired and SF wont extend the trial, i have to pay a years fee to continue.

We are also looking at SF inbox, marketing cloud, SF inbox and other 3rd party tools to help integrate SF with exchange.

So, if w ego the route of IP blocking can anyone confirm if this can be setup in Sales Cloud globally for Inbox, marketing and sales cloud?  I only see option to white-list SF IPs.

Can Salesforce allow me to create a list of accounts that will quickly allow me to open and append a field value? In other words. I would like to create a list of 500 accounts and input the actual total revenues of that particular company into the field called Total Revenue. We need to do that so we can identify if the representative who handles that account big or small really is QUALIFIED/SKILLED enough to handle them by themselves? Is there an efficient way to go into Salesforce and quickly do that? If not Salesforce needs a way to allow Managers a quick edit tool for salesmen, sales teams and representatives so that corrections can be made quickly and efficiently in the even a new salesman or representative missed some entries or new policy calls for the updating of all or some accounts with new variables for analysis purposes. Opening individually could take forever to do. It would be great to have a list with a column like excel and just go down the list entering the correct value....?
Does Salesforce do anything like that?
I need to add an import code to a developmental DB. Salesforce Enterprise is the application but this relates to databases in general. So since Salesforce has so many tables. Contacts, Leads, Opportunities, Tasks, Accounts & others. What would be the practical process to setup the tables so that when imported the data (all data) can be controlled by the import code. Eventually the data we test with may need to be completely and cleanly removed without destroying other imports.
How is it possible to build private file upload system ?
 I want to collect private data from colleagues without being seen by anybody except sender and me.

Any advice would be very appreciated.
  In Salesforce Marketing cloud we have four system tables. 1. Job , 2.Sent  , 3.Open  and 4.Cllick. Now we have one html file where user receive by email. user open the link and click the button (Click to Buy or Click to Call). Now we have to make three query.

1. No Open , No Click
2. Open , No Click
3. Open and Click

Data Views Links:
Job Data view
Sent Data View
Open Data view
CLick Data view
Subscriber Data View

Can you please help me to write quesry?
Hi Experts

Could you point a good material to have a start point on using Salesforce, mainly on Business parts?

Thanks in advance.
Our team is trying Salesforce and we have a sandbox and a production Salesforce.
To use SSO (Okta) are we able to use same SSO login to both environments? Or can we only use say our email attribute in one or the other (Sandbox or Production)? My understanding is Sandbox only allows you a login that is unique across both environments. And if that’s the case, what’s the usual workaround ? Don’t want to reinvent the wheel.
I'm trying to find more info on the SPF record for spf.salesforce.com.  It is in a format I'm not familiar with:

PS C:\Users\jason.crawford> Resolve-DnsName -Name _spf.salesforce.com -Server -Type txt

Name                                     Type   TTL   Section    Strings
----                                     ----   ---   -------    -------
_spf.salesforce.com                      TXT    2982  Answer     {v=spf1
                                                                 exists:%{i}._spf.mta.salesforce.com -all}

Open in new window

I have a client asking about their VFP app with a SQL backend database being able to import/export data from SalesForce (www.salesforce.com).  I am wondering if anyone has suggestions on how to best go about making these tasks work, using 3rd party tools or otherwise?
My friend's work has 20 sales reps using Salesforce.com, each processing 250 signed contracts per year, for a total of 5,000 contracts

When he asked DocuSign how much the above electronic signature cost would be DocuSign said it would cost about $3 per contract, for a total of $15k/year

What other "Salesforce.com electronic signature" options do you recommend for the above volume that would cost a lot less since the only thing he wants is eSignatures, no other features ?
Salesforce use 15 character unique IDs, but also have a 18 character version of the ID.
There is an algorithm to convert from the 15 chars to the 19 chars, as explained here. https://salesforce.stackexchange.com/questions/1653/what-are-salesforce-ids-composed-of

I am looking for a Google Sheets or a Javascript function that accepts a 15 character ID and converts it to a 19 character ID using that algorithm.
I am coding on the Salesforce platform using apex and I'm trying to create a class that will sort a list by two fields using the Comparable interface.

I'm trying to determine how I can sort by two fields so that each product grouping can be sorted by size. The products are clothing items. Each product has a series of sizes. For simplicity, the sizes are S, M, L, XL. What I am trying to achieve is sorting by the size field as well as the product name.

For example, if I have the following products:

Product Name            Size
black.v-neck.s               S
black.v-neck.m             M
black.v-neck.l                L
black.v-neck.xl             XL

I would want them sorted by smallest to largest:


There is a size__c field for each product that holds the size value.

I started by creating a generic sorting utility using the comparable interface to test sorting by product name:
public class GenericSortingUtil {

    public class ObjWrapper implements Comparable {
        public sObject obj;
        public ObjWrapper() {}

        public ObjWrapper(Sobject obj) {
            this.obj = obj;


        public Integer compareTo(Object compareTo) {
            ObjWrapper compareToObj = (ObjWrapper)compareTo;

            if((String)obj.get('Name') > (String)compareToObj.obj.get('Name')) {
                return 1;


Open in new window

I have a text field and want to implement regular expression to validate mm/dd format. I have a regex currently which works for this format but not able to validate against months like 29th February, 30th April etc.. How to modify the regex to include this month validation?

Currently regex I'm using is - (0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])






Salesforce is a Platform as a Service (PaaS) for cloud-based customer resource management that includes components for case and task management, data management and a help desk system. It also includes systems for add-on applications written in Apex, a proprietary Java-like language, and systems for human resources management, employee training and performance management.

Top Experts In