Forum Discussion

alex_panganiban's avatar
alex_panganiban
Contributor
7 years ago

Create Array from Flattened Docs

I could really use some help. I have flattened documents and for each distinct product-id value, I wish to create an array list of the variants that belong in the product-id’s family. My desired r...
dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Copy LinkReport

I’ll reply to my own post. This error was due to timeout between SnapLogic cloudplex and on our AWS PostgreSQL instance. Adding Sort snaps in front of all my insert and update SQL snaps resolved the issue for me. I don’t quite fully understand the reasoning, but works.

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

    Just a couple of notes… The jsonPath() call used in the first part shouldn’t be necessary, you can access the field using a plain expression, like so:

    $groupBy['@product-id']

    The jsonPath() function would actually be more useful for the second part since you can use a wildcard in the path to traverse the array and extract all values for a given field. So, instead of the reduce() call, you should be able to just do:

    jsonPath($, "$group[*].variant")