Seems like this should be easy enough but I can't figure out how to do this in a Salesforce connection
Currently, we replicate the Salesforce database down to a SQL server. I'm trying not to pull from SQL and pull directly from Salesforce.
This is the query:
WITH cte_opp AS (
CASE Invoice_Recipient__c WHEN 'Account/Customer' THEN AccountId
WHEN 'Partner/Third Party Agent' THEN Partner_Account__c
END as ID
FROM [dbo].[Opportunity] o
WHERE CreatedDate > '1/1/2017'
SELECT a.ID, a.GP_Customer_ID__c FROM dbo.Account a JOIN
cte_opp on a.ID= cte_opp.ID
How would I generate a recordset so I can insert into another database?
And, another item is the Createdate actually needs to be a param that is dynamic and is based off the last time it ran.
Thanks all for your help