Files
Joe Au-YeungGitHubDevin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>Claude Opus 4.5
f91511b927 feat(salesforce): add field rules for round robin routing (#27402)
* feat(salesforce): add field rules for round robin skip

- Add rrSkipFieldRules schema to appDataSchema in zod.ts
- Implement applyFieldRules method in CrmService.ts for post-query filtering
- Integrate field rules into getContacts method when forRoundRobinSkip=true
- Add UI component for configuring field rules in EventTypeAppCardInterface
- Add translations for new UI strings
- Add comprehensive tests for field rules functionality

Field rules allow users to specify conditions based on Salesforce record fields
with 'ignore' or 'must_include' actions. Rules are evaluated with AND logic
and gracefully handle missing fields by skipping those rules.

Co-Authored-By: [email protected] <[email protected]>

* fix: add children prop to Section.SubSectionHeader for field rules

Co-Authored-By: [email protected] <[email protected]>

* feat(salesforce): add edit button for field rules

Co-Authored-By: [email protected] <[email protected]>

* feat(salesforce): apply field rules to GraphQL results

Co-Authored-By: [email protected] <[email protected]>

* feat(salesforce): add Redis caching for field validation

Co-Authored-By: [email protected] <[email protected]>

* fix(salesforce): remove Redis caching to fix ERR_INVALID_THIS error

- Removed Redis caching for field validation that was causing ERR_INVALID_THIS errors
- Simplified field rules filtering to try query directly and skip filtering if it fails
- Restored ensureFieldsExistOnObject method for other uses (write to record)
- Field rules now gracefully handle invalid fields by skipping filtering

Co-Authored-By: [email protected] <[email protected]>

* chore: reformat getAttributes.ts

Co-Authored-By: Claude Opus 4.5 <[email protected]>

* feat(salesforce): dynamically build GraphQL query for field rules with multi-edge iteration

- Add buildDynamicAccountQuery to inject field rule fields into GraphQL query
- Add passesFieldRules to evaluate ignore/must_include rules against UIAPI nodes
- Validate field rules via getObjectFieldNames (in-memory + Redis cache) before branching
- Remove applyFieldRulesToGraphQLRecords (used jsforce conn in GraphQL path)
- Iterate all edges in Tiers 1 and 2 instead of only the first result
- Rank Tier 3 accounts by contact count and fallback to next on field rule failure

Co-Authored-By: Claude Opus 4.5 <[email protected]>

* feat(salesforce): add field rule routing trace steps

Add trace calls alongside field rule info logs for routing visibility:
- fieldRulesValidated: records validation result in CrmService
- fieldRuleFilteredRecord: records when account is filtered at each tier
- fieldRuleEvaluated: records individual rule evaluation details
- allRecordsFilteredByFieldRules: records when SOQL records are all filtered

Co-Authored-By: Claude Opus 4.5 <[email protected]>

* fix(salesforce): remove duplicate field validation and fix disabled Select options

applyFieldRules now receives pre-validated rules from the early
validation block instead of re-validating internally. Also adds
the missing options prop to the disabled Select in the field rules UI.

Co-Authored-By: Claude Opus 4.5 <[email protected]>

* feat(salesforce): include failed rule details in field rule trace steps

Rename passesFieldRules to getFailingFieldRule so the caller receives
the specific rule that caused filtering. The fieldRuleFilteredRecord
trace step now includes failedRule with field, value, and action.

Co-Authored-By: Claude Opus 4.5 <[email protected]>

* test(salesforce): add GraphQL path tests for field rules

Cover field rule filtering across all three GraphQL resolution tiers
(contact, account, related contacts) with ignore and must_include
actions, multi-edge fallback, case-insensitivity, and dynamic query
selection.

Co-Authored-By: Claude Opus 4.5 <[email protected]>

* Abstract new field rules settings

* Reduce extra SOQL call

* fix(salesforce): fix type errors in CrmService and GraphQL client

- Add missing import for getRedisService from @calcom/features/di/containers/Redis
- Fix ensureFieldsExistOnObject to properly return Field[] instead of incomplete function
- Use Array.from() instead of spread operator for Set and Map iterators to fix downlevelIteration errors

Co-Authored-By: [email protected] <[email protected]>

---------

Co-authored-by: Devin AI <158243242+devin-ai-integration[bot]@users.noreply.github.com>
Co-authored-by: Claude Opus 4.5 <[email protected]>
2026-02-01 23:03:19 -05:00

1103 lines
32 KiB
TypeScript

import { setupAndTeardown } from "@calcom/testing/lib/bookingScenario/setupAndTeardown";
import { describe, expect, it, beforeEach, vi } from "vitest";
import type { z } from "zod";
import type { CredentialPayload } from "@calcom/types/Credential";
import type { appDataSchema } from "../zod";
import type { SalesforceCRM } from "./CrmService";
import { createSalesforceCrmServiceWithSalesforceType } from "./CrmService";
import { SalesforceRecordEnum } from "./enums";
type AppOptions = z.infer<typeof appDataSchema>;
const contactQueryResponse = {
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: {
Email: "[email protected]",
},
},
],
};
const contactUnderAccountQueryResponse = {
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
AccountId: "acc001",
attributes: { type: "Contact" },
Account: {
attributes: { type: "Account" },
Owner: {
Email: "[email protected]",
},
},
},
],
};
const leadQueryResponse = {
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Lead" },
Owner: {
Email: "[email protected]",
},
},
],
};
const _ownerQueryResponse = {
records: [
{
Id: "owner001",
Email: "[email protected]",
Name: "Test Owner",
},
],
};
const accountQueryResponse = {
records: [
{
Id: "acc001",
OwnerId: "owner001",
Email: "[email protected]",
attributes: { type: "Account" },
},
],
};
const mockSalesforceGraphQLClientQuery = vi.fn();
vi.mock("./graphql/SalesforceGraphQLClient", () => ({
SalesforceGraphQLClient: class {
GetAccountRecordsForRRSkip = mockSalesforceGraphQLClientQuery;
},
}));
describe("SalesforceCRMService", () => {
let service: SalesforceCRM;
let mockConnection: {
query: ReturnType<typeof vi.fn>;
sobject: ReturnType<typeof vi.fn>;
search: ReturnType<typeof vi.fn>;
};
setupAndTeardown();
beforeEach(() => {
mockConnection = {
query: vi.fn(),
sobject: vi.fn(),
search: vi.fn(),
};
const mockCredential: CredentialPayload = {
id: 1,
type: "salesforce_crm",
key: {
access_token: "mock_token",
refresh_token: "mock_refresh",
instance_url: "https://mock.salesforce.com",
},
userId: 1,
appId: "salesforce",
teamId: null,
invalid: false,
user: {
email: "[email protected]",
},
delegationCredentialId: null,
encryptedKey: null,
};
service = createSalesforceCrmServiceWithSalesforceType(mockCredential, {}, true);
// eslint-disable-next-line @typescript-eslint/ban-ts-comment
// @ts-ignore - accessing private property for testing
service.conn = Promise.resolve(mockConnection);
});
const mockAppOptions = (appOptions: AppOptions) => {
const appOptionsSpy = vi.spyOn(service, "getAppOptions");
appOptionsSpy.mockReturnValue(appOptions);
};
describe("getContacts", () => {
it("should return empty array when no records found", async () => {
// Setup mock response
mockConnection.query.mockResolvedValueOnce({ records: [] });
const result = await service.getContacts({ emails: "[email protected]" });
expect(result).toEqual([]);
expect(mockConnection.query).toHaveBeenCalledWith(
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]')"
);
});
it("should handle single email string input", async () => {
// Setup mock response with descriptive name
const contactQueryResponse = {
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
},
],
};
// Setup query spy
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse);
const result = await service.getContacts({ emails: "[email protected]" });
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
recordType: "Contact",
},
]);
// Verify the exact query made
expect(querySpy).toHaveBeenCalledWith(
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]')"
);
});
it("should handle array of emails input", async () => {
const contactsQueryResponse = {
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
},
{
Id: "002",
Email: "[email protected]",
OwnerId: "owner002",
attributes: { type: "Contact" },
},
],
};
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactsQueryResponse);
const result = await service.getContacts({
emails: ["[email protected]", "[email protected]"],
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
recordType: "Contact",
},
{
id: "002",
email: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenCalledWith(
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]','[email protected]')"
);
});
it("should return contacts when includeOwner is true but no owner is found", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
});
const contactQueryResponse = {
records: [
{
Id: "001",
Email: "[email protected]",
// OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: {
Email: "[email protected]",
},
},
],
};
// Setup query spy with specific responses
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse); // Contact query
const result = await service.getContacts({
emails: "[email protected]",
includeOwner: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: undefined,
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]')"
);
});
describe("no additional params are passed", () => {
it("when createEventOn is contact", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]')"
);
});
it("when createEventOn is lead", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.LEAD,
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(leadQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
recordType: "Lead",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Lead WHERE Email IN ('[email protected]')"
);
});
it("when createEventOn is contact under an account", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.ACCOUNT,
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactUnderAccountQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, AccountId, Account.OwnerId, Account.Owner.Email, Account.Website FROM Contact WHERE Email = '[email protected]' AND AccountId != null"
);
});
});
describe("includeOwner param is passed", () => {
it("when createEventOn is contact", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
});
// Setup query spy with specific responses
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse); // Contact query
const result = await service.getContacts({
emails: "[email protected]",
includeOwner: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]')"
);
});
it("when createEventOn is lead", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.LEAD,
});
// Setup query spy with specific responses
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(leadQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
includeOwner: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Lead",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Lead WHERE Email IN ('[email protected]')"
);
});
it("when createEventOn is contact under an account", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.ACCOUNT,
});
// Setup query spy with specific responses
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactUnderAccountQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
includeOwner: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, AccountId, Account.OwnerId, Account.Owner.Email, Account.Website FROM Contact WHERE Email = '[email protected]' AND AccountId != null"
);
});
});
describe("forRoundRobinSkip param is passed", () => {
it("checking against contacts", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
});
// Setup query spy with specific responses
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse); // Contact query
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Contact WHERE Email IN ('[email protected]')"
);
});
it("checking against leads", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.LEAD,
});
// Setup query spy with specific responses
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(leadQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Lead",
},
]);
expect(querySpy).toHaveBeenNthCalledWith(
1,
"SELECT Id, Email, OwnerId, Owner.Email FROM Lead WHERE Email IN ('[email protected]')"
);
});
it("checking against contacts under an account", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.ACCOUNT,
});
mockSalesforceGraphQLClientQuery.mockResolvedValueOnce([
{
id: "acc001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: SalesforceRecordEnum.ACCOUNT,
},
]);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "acc001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Account",
},
]);
});
});
});
describe("getContactOrLeadFromEmail via getContacts", () => {
describe("with roundRobinSkipFallbackToLeadOwner enabled", () => {
it("should return contact when contact is found", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipFallbackToLeadOwner: true,
});
const searchSpy = vi.spyOn(mockConnection, "search");
searchSpy.mockResolvedValueOnce({
searchRecords: [
{
Id: "contact001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
},
],
});
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "contact001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(searchSpy).toHaveBeenCalledWith(
"FIND {[email protected]} IN EMAIL FIELDS RETURNING Lead(Id, Email, OwnerId, Owner.Email), Contact(Id, Email, OwnerId, Owner.Email)"
);
});
it("should return lead when no contact exists but lead is found", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipFallbackToLeadOwner: true,
});
const searchSpy = vi.spyOn(mockConnection, "search");
searchSpy.mockResolvedValueOnce({
searchRecords: [
{
Id: "lead001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Lead" },
Owner: { Email: "[email protected]" },
},
],
});
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "lead001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Lead",
},
]);
expect(searchSpy).toHaveBeenCalled();
});
it("should prefer contact over lead when both exist", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipFallbackToLeadOwner: true,
});
const searchSpy = vi.spyOn(mockConnection, "search");
searchSpy.mockResolvedValueOnce({
searchRecords: [
{
Id: "lead001",
Email: "[email protected]",
OwnerId: "owner002",
attributes: { type: "Lead" },
Owner: { Email: "[email protected]" },
},
{
Id: "contact001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
},
],
});
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "contact001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(searchSpy).toHaveBeenCalled();
});
it("should return empty array when no records found", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
roundRobinSkipFallbackToLeadOwner: true,
});
const searchSpy = vi.spyOn(mockConnection, "search");
searchSpy.mockResolvedValueOnce({
searchRecords: [],
});
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([]);
expect(searchSpy).toHaveBeenCalled();
});
});
describe("with createEventOnLeadCheckForContact enabled", () => {
it("should find and return contact when it exists", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.LEAD,
createEventOnLeadCheckForContact: true,
});
const searchSpy = vi.spyOn(mockConnection, "search");
searchSpy.mockResolvedValueOnce({
searchRecords: [
{
Id: "contact001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
},
],
});
const result = await service.getContacts({
emails: "[email protected]",
});
expect(result).toEqual([
{
id: "contact001",
email: "[email protected]",
recordType: "Contact",
},
]);
expect(searchSpy).toHaveBeenCalled();
});
it("should fallback to lead when contact not found", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.LEAD,
createEventOnLeadCheckForContact: true,
});
const searchSpy = vi.spyOn(mockConnection, "search");
searchSpy.mockResolvedValueOnce({
searchRecords: [
{
Id: "lead001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Lead" },
Owner: { Email: "[email protected]" },
},
],
});
const result = await service.getContacts({
emails: "[email protected]",
});
expect(result).toEqual([
{
id: "lead001",
email: "[email protected]",
recordType: "Lead",
},
]);
expect(searchSpy).toHaveBeenCalled();
});
});
});
describe("createContacts", () => {
describe("createEventOn lead", () => {
describe("createNewContactUnderAccount enabled", () => {
it("when attendee has an account", async () => {
mockAppOptions({
createNewContactUnderAccount: true,
createEventOn: SalesforceRecordEnum.LEAD,
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(accountQueryResponse);
querySpy.mockResolvedValueOnce({ records: [] });
mockConnection.sobject.mockReturnValue({
create: vi.fn().mockResolvedValue({
success: true,
id: "newContactId",
name: "New Contact",
email: "[email protected]",
}),
});
const result = await service.createContacts([{ name: "New Contact", email: "[email protected]" }]);
expect(result).toEqual([{ id: "newContactId", email: "[email protected]" }]);
});
it("attendee has no account", async () => {
mockAppOptions({
createNewContactUnderAccount: true,
createEventOn: SalesforceRecordEnum.LEAD,
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce({ records: [] });
querySpy.mockResolvedValueOnce({ records: [] });
mockConnection.sobject.mockReturnValue({
create: vi.fn().mockResolvedValue({
success: true,
id: "newLeadId",
name: "New Lead",
email: "[email protected]",
}),
});
const result = await service.createContacts([{ name: "New Lead", email: "[email protected]" }]);
expect(result).toEqual([{ id: "newLeadId", email: "[email protected]" }]);
});
});
});
});
describe("getAllPossibleAccountWebsiteFromEmailDomain", () => {
it("should return all possible account websites from email domain", () => {
const result = service.getAllPossibleAccountWebsiteFromEmailDomain("example.com");
expect(result).toEqual(
"'example.com', 'www.example.com', 'http://www.example.com', 'http://example.com', 'https://www.example.com', 'https://example.com'"
);
});
});
describe("getContacts with rrSkipFieldRules", () => {
const mockDescribeResponse = {
fields: [
{ name: "Industry", type: "string" },
{ name: "Type", type: "string" },
{ name: "Status", type: "string" },
],
};
it("should filter out records matching ignore rule", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "Industry", value: "Technology", action: "ignore" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
// Field rule fields are now included in the main SOQL query
querySpy.mockResolvedValueOnce({
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
Industry: "Technology",
},
],
});
// Mock describe for field validation
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
it("should keep records not matching ignore rule", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "Industry", value: "Technology", action: "ignore" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce({
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
Industry: "Healthcare",
},
],
});
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
it("should filter out records not matching must_include rule", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "Industry", value: "Technology", action: "must_include" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce({
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
Industry: "Healthcare",
},
],
});
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
it("should keep records matching must_include rule", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "Industry", value: "Technology", action: "must_include" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce({
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
Industry: "Technology",
},
],
});
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
it("should handle multiple rules with AND logic", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [
{ field: "Industry", value: "Technology", action: "must_include" },
{ field: "Type", value: "Inactive", action: "ignore" },
],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce({
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
Industry: "Technology",
Type: "Active",
},
],
});
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
it("should skip rules for fields that do not exist on the record type", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "NonExistentField", value: "SomeValue", action: "must_include" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse);
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
});
it("should be case-insensitive when matching field values", async () => {
mockAppOptions({
roundRobinSkipCheckRecordOn: SalesforceRecordEnum.CONTACT,
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "Industry", value: "TECHNOLOGY", action: "must_include" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce({
records: [
{
Id: "001",
Email: "[email protected]",
OwnerId: "owner001",
attributes: { type: "Contact" },
Owner: { Email: "[email protected]" },
Industry: "technology",
},
],
});
mockConnection.describe = vi.fn().mockResolvedValue(mockDescribeResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: true,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
ownerId: "owner001",
ownerEmail: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
it("should not apply field rules when forRoundRobinSkip is false", async () => {
mockAppOptions({
createEventOn: SalesforceRecordEnum.CONTACT,
rrSkipFieldRules: [{ field: "Industry", value: "Technology", action: "ignore" }],
});
const querySpy = vi.spyOn(mockConnection, "query");
querySpy.mockResolvedValueOnce(contactQueryResponse);
const result = await service.getContacts({
emails: "[email protected]",
forRoundRobinSkip: false,
});
expect(result).toEqual([
{
id: "001",
email: "[email protected]",
recordType: "Contact",
},
]);
expect(querySpy).toHaveBeenCalledTimes(1);
});
});
});