Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

HowtoflattenJSONresponsefromgoogletrendsapi

on

I am facing a issue of flattening the output of a a google-trends-api: (Interest over time) :for the keywords: Cariaco','Sucre','Venezuela, in which I got a JSON such as:

{"default":{"timelineData":[{"time":"1535673600","formattedTime":"Aug 31, 2018","formattedAxisTime":"Aug 31","value":[0,5,100],"hasData":[true,true,true],"formattedValue":["<1","5","100"]},{"time":"1535760000","formattedTime":"Sep 1, 2018","formattedAxisTime":"Sep 1","value":[0,6,75],"hasData":[true,true,true],"formattedValue":["<1","6","75"]}],"averages":[0,6,88]}}

I want to get the timelineData property as follows: 

Time | Formattedtime | FormattedAxisTime | Value1 | Value2 | Value3

Comments

Post a Comment