Forum Discussion

vfantidou's avatar
vfantidou
New Contributor
2 years ago
Solved

Filter json array of objects by another json array of objects

Hello everyone, I have a json that looks like the bellow and I want to filter the $input0 data by whatever key/values exists in $filterData in the end. The $filterData may have ID or Customer (in th...
  • ivicakoteski's avatar
    ivicakoteski
    2 years ago

    Hi sobha353 ,

    You can parse the string as JSON using the JSON.parse() function in the mapper snap.

     

    JSON.parse($dataDetails.data)

     

    Hence, you can easily map the data as desired.
    Hope this helps!

    BR.
    Ivica

  • itrpkov's avatar
    itrpkov
    Employee
    9 years ago
    Copy Link

    One mechanism that can be used to isolate separate lines is to use Copy snap after CSV file has been parsed, for example, with 3 (or more) output views. You can then use Filter snaps and snap.in.totalCount function as a filter expression. To get the first line you can specify snap.in.totalCount ==1, for the second line you can specify snap.in.totalCount ==2 etc. Then you can use Union snap to collect the lines back etc. Hope this helps.

    • Abhijit's avatar
      Abhijit
      New Contributor
      9 years ago
      Copy Link

      Thanks for your reply. I found a working solution allready. I am writing 4 different structure/ lines into 4 different files locally into SnapLogic and then reading/merging them together to produce the desired target file. Thanks for your suggestion though.