UNION equivalent - Or how to eliminate duplicates in a dynamic list block

I want to return a distinct list of email addresses from two unrelated tables and put them into a dynamic list block. I figured out how to load two table objects into the same dynamic list, but I’m not sure how to make it a unique list.


If the data comes from two unrelated tables, there would need to be some logic that removes the duplicattes. The way I’d handle this is by creating an API service that performs data retrieval, collapising the datasets into one, removing duplicates and returning a single data set back to the client-side. Here’s a video that shows how to create an API service with Codeless:


Thanks @mark-piller. I’ll check this out.