Managing lists
A list is a data table stored on the Real-Time Decisioning platform that maintains profile information about users, accounts, and other entities. This data is often used in combination with the transactional event data sent to the system for the development of features and business rules. You can use lists to store entities that should be blocked, suspended, automatically approved, or applied with other specific treatments. For example, you can use lists to store phone numbers, card numbers, and IP addresses that you want to block. You can also use lists to store accounts that are placed in a temporary hold status until a future time. To use a list, you must first create a feature that performs a lookup on the list with given input parameters. The lookup will be performed when the feature’s output is calculated as part of a rule evaluation. The platform supports two types of lists: system lists and custom lists. There is no limit to the size of the lists.System lists
The platform provides two system lists:Blocklist and Allowlist. These lists have fixed schemas.
Both lists require two keys for each entry:
-
Entity type: The type of entity, such as
emailorbin_number -
Entity value: The value of the entity that should be stored in the list, such as
johndoe333@hotmail.comor400603
Custom lists
Authorized users can define custom lists. A custom list must have at least one primary key column, and zero or more value columns. A list can include optional effective dates.Defining a custom list
To define a custom list, follow this procedure: The effective dates fields are added automatically when the Use Effective Dates checkbox is selected.Populating a custom list
Once you have defined a custom list, you can start adding list entries. Entries can be added manually, or they can be added dynamically (when business rules are triggered).Maintaining custom lists
Marqeta recommends that you follow these list maintenance practices:- Apply strict permission controls so that only users with a higher authority can access and modify the lists.
- Use effective dates to retire an entry from a list instead of removing it, as a way to maintain full traceability.
- Set an appropriate time to live (TTL) for each list, based on the nature of the list.
- Keep complete audit information for each list.
Using a list for lookups
To use a list for lookups, you must create one or several features from the list to use when building business rules and models. Real-Time Decisioning Data Studio provides an intuitive user interface (UI) to build features from a list.Updating lists
You can update a list manually from the Manage List page in the Real-Time Decisioning Data Studio.Updating a list with a rule action
Follow these steps to update a list using a Data Source Update action in a rule:Select the Insert and Update option to update only the list columns specified in the action. If a specified column is null, it will not be updated. To replace an existing record completely, use the Insert and Replace option instead. If you want to replace an existing record completely, use the Insert and Replace option.