can I query a document cache or delete duplicates from a document cache
I just realized that this is a duplicate answer. Varun provided a similar answer some time back:
( How to eliminate duplicate records )
Please see Clear up Cache Document in the middle of the process execution
I want to check whether there are multiple records with same email id in SFDC.
I used connector call and cache but they are giving "Found more than 1 document in the document cache" and "More than 1 document returned by connector call'.. Is there any other way to check the count or query document cache?
I used script to count records and set to dynamic process property which stores count while loading to cache from SFDC.
Based on property I am making the decision. This is working now!! thanks
I found a non-coding way to do it. I was trying to do this because I want to upload a quote and quote lines at the same time, but my filter parameters are on the quote line, so I had to start by querying the quote line. So I started with the list of quote lines, and then filtered them for unique Quote IDs this way:
Thus, the first line on a quote will always make it through, but then subsequent quote lines on that quote will be stopped.
Retrieving data ...