Miller 5 and 6 and managing a JSON

[aborruso]

Dear @johnkerl ,
in an old miller 5 script of mine I run

curl -kL 'https://gist.githubusercontent.com/aborruso/c0599a96c816fa57fa26912b38948b16/raw/0f195d860b18fdb14528935e76a7625ac998fd3b/tmp.json' | mlr5 --j2c cat then cut -x -r -f ":"

I have no error. In Miller 6 there are a lot of new things related to the Json world, but I can't figure out how to get the same result that 5 gave me.

The complete mlr5 code is this one

curl -kL 'https://gist.githubusercontent.com/aborruso/c0599a96c816fa57fa26912b38948b16/raw/0f195d860b18fdb14528935e76a7625ac998fd3b/tmp.json' | mlr5 --j2c cut -x -r -f ":" then unsparsify then sort -r metadata_created then put '$URL="https://dati.gov.it/view-dataset/dataset?id=".$id' then reorder -f metadata_created,metadata_modified,title,holder_name,url,URL,holder_identifier,issued,modified then put 'if(is_null($url)){$url=$indirizzo}' 

And I obtain something similar to the below table.

If I use miller 6

curl -kL 'https://gist.githubusercontent.com/aborruso/c0599a96c816fa57fa26912b38948b16/raw/0f195d860b18fdb14528935e76a7625ac998fd3b/tmp.json' | mlr --flatsep : --j2c cat then cut -x -r -f ":"

I have mlr: exiting due to data error. I tried using flatten and unflatten but I always get errors.

How to obtain in mlr6 the same output I have using mlr5?

Thank you

metadata_created	metadata_modified	title	holder_name	url	URL	holder_identifier	issued	modified	author	author_email	creator_user_id	dataset_is_local	id	isopen	license_id	license_title	maintainer	maintainer_email	name	notes	num_resources	num_tags	owner_org	private	state	type	version	indirizzo	license_url
2024-09-19T12:03:03.238952	2024-09-19T12:03:03.238957	Interventi pnrr-pnc	Comune di Torino	Https://www.torinocambia.it/	https://dati.gov.it/view-dataset/dataset?id=7570f7ff-61e8-427f-88e8-2e6e3354385c	00514490010	18-04-2024	18-04-2024			e514c9c4-6d64-45d6-ae28-c70bd3592d59	false	7570f7ff-61e8-427f-88e8-2e6e3354385c	true	cc-by-sa	Creative Commons Attribution Share-Alike			interventi-pnrr-pnc-0424	Riepilogo degli interventi pnrr e pnc	1	1	f804b34c-a5f7-42ca-bde2-82a0bcadd55e	false	active	dataset	1.0		http://www.opendefinition.org/licenses/cc-by-sa

[aborruso]

@johnkerl I'm tagging you, just to make sure you get the notification. Sorry for the double tagging.