If you need to load SQL server data, you can use the Skyvia cloud data integration tool.
With Skyvia import you can perform any DML operations for imported SQL Server data in Salesforce, import data from several SQL Server objects at once, etc.
Here's the link to their step-by-step tutorial: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server
It's a very wide topic but let's consider the following scenario:
Salesforce is a system of record and it is sending all new leads to some marketing tool (in other words synchronizes some eligible Leads from SFDC to Marketing Tool). Let's assume we're using custom synchronization that is orchestrated by SFDC. There are avg 10 leads per 24h.
Assume not having ...
The queue and wait model might work, but it depends on how real-time you need the updates to be, how long you expect to recover from the overflow, etc. The reason why it's rarely talked about in concrete terms is because every situation is more-or-less unique depending on circumstances. If your external system can only handle a few records per second, then ...
From the help page on the JWT flow:
Salesforce requires that a JWT is signed using RSA SHA256, which uses an uploaded certificate as the signing secret.
HS256 is not accepted by Salesforce (via a connected app and the Salesforce-provided services/oauth2/token service).
OAuth's flow is meant to be an interactive experience with the login server. What you're meant to do is to redirect the user to the endpoint. Once the user clicks "Yes" to confirm access, an access code is sent back to the origin server to complete the final steps. That looks like this:
You will have hard time fetching these values with SSJS, as the request you are executing is done in frontend Java Script (where SSJS is running in the backend). This means, that the response received is "too late for the party", as your SSJS has already finished executing, when the content of your Google Sheet is returned to the page.
I will ...
This depends on how your leads from Facebook are imported to Salesforce.
For different lead sources - I have different forms with different hidden fields.
My FB form has the hidden field Lead Source = Facebook and another hidden field indicating that they are a new lead.
If both of these fields are selected - I have Marketing Cloud set to send emails until ...
There is unfortunately no method for sending a real time email upon submission of a lead capture form from Facebook. At least using the standard Lead Ads solution in Advertising Studio. You can build a solution utilising Automation Studio, but you will be limited to the frequency of scheduled automation executions.
What is worth clarifying is which Contact/...