Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

JSON API parsing

Hi All

 

I am trying to replicate the table on this website:

 

https://www.pxweb.bfs.admin.ch/pxweb/en/px-x-1602010000_101/px-x-1602010000_101/px-x-1602010000_101.px/table/tableViewLayout2/?rxid=2c7771fe-0e1f-4ce3-ba1b-1212739a0a23

 

I can't manage to figure out the correct steps in Power Query. All I can extract are the different lists, separately.

 

I connect using this API link:

 

https://www.pxweb.bfs.admin.ch/api/v1/en/px-x-1602010000_101/px-x-1602010000_101.px

 

Looking forward to your suggestions!

 

Ben