private async Task ExecuteApexAsync()
{
var apex = @"
Contact contact = new Contact();
contact.Salutation = 'Mrs';
contact.FirstName = 'Betty';
contact.LastName = 'Boo';
contact.MailingCountry = 'United Kingdom';
contact.MailingPostalCode = 'AB12 3CD';
insert contact;";
var result = await _api.ExecuteApexAsync(apex).ConfigureAwait(false);
Console.WriteLine($"Execute APEX - Success: {result["success"].Value<bool>()}");
}
public async Task ExecuteAnonymous()
{
var firstName = Guid.NewGuid().ToString();
var lastName = Guid.NewGuid().ToString();
var postalCode = DateTime.Now.Millisecond.ToString();
var contact = new JObject
{
{ "Salutation", "Mr" },
{ "FirstName", firstName },
{ "LastName", lastName },
{ "MailingPostalCode", postalCode },
{ "MailingCountry", "United Kingdom" }
};
var id = await _dataApi.CreateAsync("Contact", contact).ConfigureAwait(false);
Assert.False(string.IsNullOrWhiteSpace(id));
var apex = $@"
Contact contact = [SELECT FirstName, LastName FROM Contact WHERE Id = '{id}'];
contact.FirstName = '';
contact.LastName = '';
for(Integer i=0;i<5;i++) {{
contact.FirstName += String.valueOf(i);
contact.LastName += String.valueOf(i*2);
}}
update contact;".Trim();
await _toolingApi.ExecuteApexAsync(apex).ConfigureAwait(false);
var query = $"SELECT Salutation, FirstName, LastName, MailingCountry FROM Contact WHERE Id = '{id}'";
var queryResult = await _dataApi.QueryAsync(query).ConfigureAwait(false);
Assert.True(queryResult.Done);
Assert.Equal(1, queryResult.TotalSize);
Assert.Equal(queryResult.TotalSize, queryResult.Records.Length);
contact = queryResult.Records[0];
Assert.Equal("Mr", contact["Salutation"].Value <string>());
Assert.Equal("01234", contact["FirstName"].Value <string>());
Assert.Equal("02468", contact["LastName"].Value <string>());
Assert.Equal("United Kingdom", contact["MailingCountry"].Value <string>());
}