Converting json to table

[tjamal1]

I am trying to parse json and convert it into table but i am getting this output 

Expected output 

Record ID	day_timestamp	sum_pageview_count
0	2016-06-06T00:00:00-04:00	19321
1	2016-06-05T00:00:00-04:00	5791

[MichalM · Accepted solution]

@tjamal1 

The json has a funny structure where the field name/type information is separate from the actual data. The attached should do the trick. I separate out the data and headers and then use dynamic rename to bring them back together.