Hi David, I'm afraid I can't offer much help related to all of your questions. What I find myself doing when Hop can't do what I want it to do is create a simple web endpoint to transform data. For example, build my JSON processing logic in nodejs and expose that on HTTP port 3000, then use Hop's HTTP Post transform. I also use the Javascript transform often to process JSON.
Geoff On Tue, Mar 12, 2024 at 9:52 PM David McNeill <[email protected]> wrote: > Greetings Hoppers. > > Can anyone suggest how to elegantly flatten nested json content? > > The json involved has > row > field > field > field > subfield > subfield (can be more, or deeper) > field > row... > > JSON Input transform doesn't seem to handle this, or document it. > > bash cli jq generates sequential embedded field names when flattening > row.field_0_subfield > row.field_1_subfield >
