PSA - if you have not been using the JSONata Fusion module - please check it out!
Instead of iterating/filtering over items to create a new list of forms, fields or other objects, it literally takes 2 modules: The first to transform the object into JSON, the second JSONata.
In JSONata you can filter / map (transform) and many other things.
https://tryjsonata.org for online learning/testing - just slap the JSON in here and work out the set of functions.My use case: I have a data CSV to import, where each row has a column that is a dropdown in WF. So I want to check:
remove any WF option that is not in the new data file
add any option that is not yet in WF.
The JSONata expression is this: (
$importList := {{31.json}}; /* from a previous transformToJSON module */
$existing := {{30.json}}; /* from a previous transformToJSON module */
$oktokeep := $filter( $existing, function ( $v ) { $v.value in $importList ? true:false });
$toadd:= $map($filter( $importList , function ($v){
( ($v in $existing.value) ? false :true )
}), function ($v) { { "objCode": "POP
