Lack of GROUP BY functionality in DataRaptor Extract for OmniStudio document generation [EP-21]
I haven't been able to find a simple way to GROUP BY in my DataRaptor Extracts so in this video I go through a somewhat complicated way to do it.
I do the following:
1. Create a DataRaptor Extract to get the picklist values to group by
2. Add it to an Integration Procedure
3. Use a List Action in the Integration Procedure to dedupe the picklist values list
4. Create another DataRaptor Extract to extract the fields I need
5. Add the completed Integration Procedure to the document generation OmniScript
Link to IdeaExchange: https://ideas.salesforce.com/s/idea/a...
Link to video data: https://github.com/saharaci/OmniStudi...
00:00 Intro
00:54 The template
01:48 DataRaptor to extract picklist values
02:44 Add DapaRaptor Extract to Integration Procedure
03:13 List Action to dedupe extract
04:40 Second DataRaptor extract to get all data
05:46 Add second DataRaptor to Integration Procedure
07:13 Configure the OmniScript
09:47 Fix TokenData Integration Procedure to prevent repeated values
14:03 Run OmniScript