Forum Discussion

christwr's avatar
christwr
Contributor III
6 years ago

Pipeline Execute - Prepare on Neighbor Failed

Anyone have an idea what the culpret might be with this “prepare on neighbor” error with the Pipeline Execute snap, excuting a child pipeline on my groundplex? I get these sometimes, seemingly...
amit_saroha's avatar
amit_saroha
New Contributor III
4 years ago
Copy LinkReport

Below is the actual data and I want to pass the value “EBSPERSON_547229” in the target path.

Dheeraj's avatar
Dheeraj
Employee
4 years ago
Copy LinkReport

Use below expression :

jsonPath($, "$_Document_ID[?(value.Content_ID.startsWith('EBSPERSON_'))].Content_ID")

  • tstack's avatar
    tstack
    Former Employee
    6 years ago
    Copy LinkReport

    I think you can do this with a Mapper since the “Target Path” is a JSON-Path. Using a path with some wildcards (*), you can spread the quiz_id value across all the questions. Here’s a suggested Mapper configuration:

    The first row copies the quiz_id to all of the categories (e.g. “sports”) and then the questions (e.g. “q1” and “q2”). Since I set the Mapper to pass through the input doc, the second row deletes quiz_id from the input.

    Community7038_2020_03_09.slp (3.8 KB)

    • vaidyarm's avatar
      vaidyarm
      Contributor
      6 years ago
      Copy LinkReport

      Thanks a lot @tstack it worked great.

      below is the actual case which I wanted to implement using this logic but it doesn’t seem to be working

      Scenario to be implemented:
      with reference to JSON payload (refer attached pipeline), the item array has field “lineItemId”, this field i need to be mapped inside AccountingCodingBlockAssignment below ProductRecipientPartyInternalID field.
      here if for same lineItemId, there are more then one objects under AccountingCodingBlockAssignment, then it should map respective the “lineItemId” below each objects ProductRecipientPartyInternalID field.

      i have kept one expected json snap in pipeline for better understanding, archiving this would help us to design desired complex mappings.

      • vaidyarm's avatar
        vaidyarm
        Contributor
        6 years ago
        Copy LinkReport

        Hi,

        I have developed logic to archive this through JavaScript, can anyone help me to translate it in snaplogic expression language ? (newPayload is created by passing the actual payload)

        let itemlen = newPayload.PurchaseOrderERPRequest_V1.PurchaseOrder.item.length;
        for (i = 0; i < itemlen; i++) {
        let BlockAssignmentlen = newPayload.PurchaseOrderERPRequest_V1.PurchaseOrder.item[i].AccountingCodingBlockDistribution.AccountingCodingBlockAssignment.length
        for (j = 0; j < BlockAssignmentlen; j++) {
        newPayload.PurchaseOrderERPRequest_V1.PurchaseOrder.item[i].AccountingCodingBlockDistribution.AccountingCodingBlockAssignment[j][“lineItemId”] = newPayload.PurchaseOrderERPRequest_V1.PurchaseOrder.item[i].lineItemId
        }
        };

        In a nutshell want to know the functions/snaps which can be used in snaplogic to archive this.

        Thanks