Import metadata for a SalesForce model
Set up the datasource
Create and deploy a VDB
INSERT into Lead (LastName, FirstName, Company) values ('Tucker', 'Lavernius', 'Blue Team')
UPDATE Lead set Company='Red and Blue are the same' where LastName = 'Tucker'
Change the timestamp values here to values that will capture the update in the previous step.
EXEC sf.salesforce.getupdated('Lead',
{ts'2009-10-28 11:42:10.5'}
,
{ts'2009-10-30 11:42:10.5'}
)
Get the ID from the result and run this query with it:
SELECT Name, Company from Lead where id = <id>
should result in:
Lavernius Tucker, Red and Blue are the same
DELETE from Lead where LastName = 'Tucker'
Change the timestamp values here to values that will capture the delete in the previous step.
EXEC sf.salesforce.getDeleted('Lead',
{ts'2009-10-28 11:42:10.5'}
,
{ts'2009-10-30 11:42:10.5'}
)
Compare the ID with the ID returned from getUpdates; they should be the same.