amazon-s3-find-and-forget icon indicating copy to clipboard operation
amazon-s3-find-and-forget copied to clipboard

Support for array nested column identifiers and same-row modification

Open matteofigus opened this issue 4 years ago • 0 comments

At the moment, it is possible to identify a row and delete the full row based on various identifier types - but not when nested within arrays.

Let's take the following example:

{ "foo": "bar", "list": [{ "customer_id": 12345 }, { "customer_id": 23456 } ]}
{ "foo": "baz", "list": [{ "customer_id": 23456 }, { "customer_id": 34567 } ]}

A desired output for deleting list.customer_id=23456 would be rewriting all the relevant rows when that would happen:

{ "foo": "bar", "list": [{ "customer_id": 12345 }]}
{ "foo": "baz", "list": [{ "customer_id": 34567 }]}

Pending questions:

  • What's the desired output of an array becoming empty? Leaving it empty or full row deletion?

matteofigus avatar Nov 23 '20 16:11 matteofigus