Limit Assets Collected by the Digital Commerce API

Communication, Media, and Energy cloud leverages the Salesforce asset object to indicate what products and services have been bought by the customer, according to the customer account. Other packages, code, or businesses processes, including those of a third party, can also leverage the Salesforce asset object and populate records in the object.

When too many asset records are created on the object outside of the CME-managed package, Digital Commerce reaches a governor limit and throws a SOQL error, such as Too many query rows: 50001, when trying to execute the Asset to Basket API.

To avoid reaching governor limits and getting the SOQL error, you can limit the assets collected by the Digital Commerce API.

Create an Apex class named TransactionContextUtils.

1public class TransactionContextUtils
2{
3    private static vlocity_cmt.VOIInvoker invoker = vlocity_cmt.VOIInvoker.getInstance();
4    private static vlocity_cmt.VlocityOpenInterface transactionContext = (vlocity_cmt.VlocityOpenInterface)invoker.invoke('DefaultTrxnCtxImplementation', 'debugCreate', null, null, null);
5
6
7    public static Boolean put(String key, Object value)
8    {
9        return (Boolean)invokeMethod('put', key, null, value);
10    }
11
12    public static Object get(String key)
13    {
14        return invokeMethod('get', key, null, null);
15    }
16
17    public static void printTransactionContext()
18    {
19        Map<String, Object> input = new Map<String, Object>();
20        Map<String, Object> output = new Map<String, Object>();
21        Map<String, Object> options = new Map<String, Object>();
22        transactionContext.invokeMethod('debug', input, output, options);
23    }
24
25    public static Object invokeMethod(String methodName, String key, Set<String> keys, Object value)
26    {
27        Map<String, Object> input = new Map<String, Object>();
28        Map<String, Object> output = new Map<String, Object>();
29        Map<String, Object> options = new Map<String, Object>();
30        if (key != null)
31        {
32            input.put('key', key);
33        }
34        else if (keys != null)
35        {
36            input.put('keys', keys);
37        }
38
39        if (value != null)
40        {
41            input.put('value', value);
42        }
43
44        transactionContext.invokeMethod(methodName, input, output, options);
45
46        return output.get('value');
47    }
48}

Create an Apex class named CustomAssetsContextParser.

1global class CustomAssetsContextParser implements vlocity_cmt.VlocityOpenInterface
2{
3    public static String NSP = 'vlocity_cmt';
4
5    public Boolean invokeMethod(String methodName, Map<String, Object> input, Map<String, Object> output, Map<String, Object> options)
6    {
7        try
8        {
9            if (methodName.equalsIgnoreCase('parseContextInput'))
10            {
11                return parseContextInput(input, output, options);
12            }
13            else
14            {
15                return false;
16            }
17        }
18        catch(Exception e)
19        {
20            //EcommLogger.error('AssetsContextParser', e);
21            return false;
22        }
23    }
24
25    private Boolean parseContextInput(Map<String, Object> input, Map<String, Object> output, Map<String, Object> options)
26    {
27        List<SObject> assets = new List<SObject>();
28        TransactionContextUtils.put('AssetObjects', assets);
29
30        Map<String, String> rootItemIdAssetKeyMap = new Map<String, String>();
31        TransactionContextUtils.put('RootItemIdAssetKeyMap', rootItemIdAssetKeyMap);
32
33        List<Object> contextVal = new List<Object>();
34        output.put('ContextValue', contextVal);
35
36        return true;
37    }
38}

Add and activate a new interface implementation for AssetsContextInterface named CustomAssetsContextParser.
1. From the App Launcher, click Interface Implemtations.
2. Click New.
3. In the New Interface Implementation dialog, for Interface Name, enter AssetsContextInterface.
4. Click Save.
5. Click the Related tab.
6. Beside Interface Implementation Detail, click New.
7. In the New Interface Implementation Detail dialog:
  - For Available Implementation, enter CustomAssetsContextParser.
  - For Interface Name, enter CustomAssetsContextParser.
  - Click the Active check box to activate the interface implementation.
8. Click Save.