Forum Discussion

omair's avatar
omair
Contributor
8 years ago

Ultra task with Salesforce Read snap: merge output into single document

I have a question similar to the one asked here Merge documents into one big document

Specifically, I have a pipeline with a Salesforce Read Snap which returns 0 or more documents as the result. I’d like the output of the Read Snap to contain a single document containing an array with results returned by the Read Snap.

Based on my reading of the forum posting:

  • I cannot use the Group By N snap as it isn’t supported in Ultra tasks
  • It is possible to use the script snap in an Ultra snap to do this.

I’ve attached a pipeline that can do this:
SFReadUltraPipeline.slp (13.6 KB)

The pipeline returns the following output from a triggered (non-ultra task):

[
    {
        "theOriginal": {
            "Id": "0036A00000Vatj6QAB",
            "FirstName": "Andrew",
            "LastName": "Ramirez",
            "hed__AlternateEmail__c": "aramirez@destinsolutions.com",
            "original": {
                "FirstName": "Andrew",
                "Email": "aramirez@destinysolutions.com"
            }
        },
        "duplicates": [
            {
                "Id": "0036A00000AbbdpQAB",
                "FirstName": "Andrew",
                "LastName": "Ramirez",
                "hed__AlternateEmail__c": "aramirez@destinysolutions.com",
                "original": {
                    "FirstName": "Andrew",
                    "Email": "aramirez@destinysolutions.com"
                }
            },
            {
                "Id": "0036A00000AbbeOQAR",
                "FirstName": "Andrew",
                "LastName": "Mayzak",
                "hed__AlternateEmail__c": "4541474710648498@destinysolutions.com",
                "original": {
                    "FirstName": "Andrew",
                    "Email": "aramirez@destinysolutions.com"
                }
            },
            {
                "Id": "0036A00000Vatj6QAB",
                "FirstName": "Andrew",
                "LastName": "Ramirez",
                "hed__AlternateEmail__c": "aramirez@destinsolutions.com",
                "original": {
                    "FirstName": "Andrew",
                    "Email": "aramirez@destinysolutions.com"
                }
            }
        ]
    }
]

with the dashboard view demonstrating that documents are merged correctly:

A request sent to an ultra task based on the pipeline times out, with the dashboard indicating the script snap never returns:

I suspect that the issue is that document lineage is not being maintained by the script snap. However, I don’t know how to maintain document lineage and also get the snap to output a single document with an array containing the results of the Salesforce Read Snap.

Can someone tell me how to alter this pipeline to make it ultra compatible while still returning a single output document containing the results of the Salesforce Read snap?

salesforce
ultra
ultra_tasks