Forum Discussion

Charles's avatar
Charles
New Contributor II
4 years ago
Solved

Null Safe access option for object value reference in JSON Generator snap?

Hi, I’m trying to reference a value from the input object in the JSON Generator snap. The property is optional in the upstream snaps. If I straight reference it, I’ll get an “Invalid JSON-Path fiel...
  • koryknick's avatar
    koryknick
    2 years ago

    lukaszwisinski - This is a known issue that should be addressed in the next release.  In the meantime, I have created a pipeline that updates the pipeline metadata.  Please download the attached zip file, decompress it, and import the SLP file as a new pipeline.  Update the pipeline parameters to point to your project with the pipeline you want to use the expressions to specify your expression library file and execute the pipeline.  Close and re-open your pipeline and you should see the expression button re-enabled.

    Hope this helps!

  • RogerSramkoski's avatar
    RogerSramkoski
    Employee
    2 years ago
    Copy LinkReport

    Hi neelamanikandan, thank you for joining the SnapLogic Community within the last few weeks and for sharing how you split multiple array objects. I just want to double check, did you have a question about how you split the JSON arrays or were you just sharing a solution?

    • neelamanikandan's avatar
      neelamanikandan
      New Contributor II
      2 years ago
      Copy LinkReport

      Hi RogerSramkoski  It was a question, in the above example I had 2 (Servicecompany and Servicecompanydetail) fields that had values in array, so I have used 2 JSON splitters in the pipeline. But if my input JSON contains multiple(eg. 10) array fields should I always use multiple (10 JSON splitters) in the pipeline? Is there alternate Snap that can flatten all the Array elements at one go, or is there an alternative approach to use the JSON splitter to flatten all arrays

    • neelamanikandan's avatar
      neelamanikandan
      New Contributor II
      2 years ago
      Copy LinkReport
      Vehicle_IdInceptionDt@_Id$ServiceCompanyAddressLine1ServiceCompanyPhoneServiceCompanyPostalCode
      _Id408/03/2023_Id5ServiceCompany45ServiceCompanyAddressLine150ServiceCompanyPhone26ServiceCompanyPostalCode2
      _Id408/03/2023_Id5ServiceCompany45ServiceCompanyAddressLine163ServiceCompanyPhone9ServiceCompanyPostalCode15
      _Id408/03/2023_Id6ServiceCompany47ServiceCompanyAddressLine150ServiceCompanyPhone26ServiceCompanyPostalCode2
      _Id408/03/2023_Id6ServiceCompany47ServiceCompanyAddressLine163ServiceCompanyPhone9ServiceCompanyPostalCode15
  • alchemiz's avatar
    alchemiz
    Contributor III
    2 years ago
    Copy LinkReport

    Hi neelamanikandan ,

    Good day, see if this will work place the expression in a mapper 

    sl.ensureArray($ServiceCompanyArray).map(c=> sl.ensureArray($ServiceCompanyDetailArray).map(d=> {'Vehicle_Id': $Vehicle_Id, 'InceptionDt': $InceptionDt}.merge(c.merge(d)))).reduce((a,b)=> a.concat(b),[])

    Thanks,

    EmEm

    • neelamanikandan's avatar
      neelamanikandan
      New Contributor II
      2 years ago
      Copy LinkReport

      This works Thank You! 

      But this will also be a too much of coding when we have multiple attributes, and multiple arrays. Anyways thanks for this solution, we can take it from here.