Forum Discussion
JSON importing - expanding list
Hello LivioLanzo ,
Please find attached the file here:
https://www.dropbox.com/s/8stj0vyku8qc8pl/test%20ozo%202.txt?dl=0
Most of the columns when you expand the file are not interesing for this example. You can remove them all except actie-lijst.
Any help would be greatly appreciated. My project can't move on without this problem being solved.
Hi cgeraeds ,
Looking at your JSON I can see that the the 'actie-lijst' array provides a set of lists with no relationship between the items in each of the lists, the consuming system must know that the data is meant to be displayed/stored as a table and that the list items are sorted correctly. Not sure that Power Query can meet that requirement. Are you able to get JSON that expresses the "actie-lijst" as an array of List Objects like
{ "client_574": { "naam": "Test1 Client1", "welzijnscoördinator": "Lorum Ipsum", "verhaal-algemeen": "Lorum Ipsum", "bevroren": "ja", "afweging": "Lorum Ipsum", "afweging-hermeting": "Lorum Ipsum", "opmerkingen-algemeen": "Lorum Ipsum", "overleg-tabel": null, "bepaald door": "cliënt/inwoner", "actie-lijst": [ { "actie-datum": "2019-03-13", "actie-beschrijving": "Lorum Ipsum", "actie-datum-gereed": "2019-03-30", "actie-wie": "Lorum Ipsum", "actie-resultaat": "Lorum Ipsum", "actie-vervolg": "Lorum Ipsum"} , { "actie-datum": "2019-03-15", "actie-beschrijving": "Lorum Ipsum2", "actie-datum-gereed": "2019-04-02", "actie-wie": "Lorum Ipsum2" } ] , "volgende meting": "11-06-2019", "werk / daginvulling - actielijn 1": null } }Richard
