โ05-03-2018 11:31 AM
Hello. say i have the following JSON:
how can i remove one of the attributes / columns? Letโs say in the top left from the image above I want to remove the OwnerEmail value from that arrayโฆ how could i do that in snaplogic? iโve tried remapping but that breaks the grouping.
โ05-03-2018 11:46 AM
@matt.bostrom, use a Mapper, with Pass-Through enabled and with the field you wish to exclude/delete mapped to an empty Target Path:
โ05-03-2018 11:53 AM
hi @robin. the catch is (that i probably should have mentioned) is i am grouping the rows by the OwnerEmail b/c further down the pipeline I email the user 1 single email with an HTML Table email snap. The table loops through the $group variable. While the Group By Fields I set the OwnerName like soโฆ the subgrouping $groupBy still contains the field that I grouped by that I donโt want in the html table in the email.
here is what my json looks like (i blurred out the real emails but you can see the structure and the group part where i want to remove the owneremail value):
โ05-03-2018 12:29 PM
The thing to delete in the Mapper is interpreted as a JSON-Path. In Robinโs example, itโs just a top-level property in the document. But, you should be able to use a path like the following to walk an array and delete the property in all the objects in the array:
$group[*].OwnerEmail
So, this path will walk through all the elements in the โgroupโ array (the $group[*]
part) and delete the โOwnerEmailโ properties.
โ05-03-2018 02:07 PM
Got it. That worked for me! Thank you both for the help.