I have JSONL file. I need to create a lambda function to parse it and convert to CSV file output.
the jsonl file is recieved as abc.jsonl.tar.gz.
pasting the sample data.
{"date":"2021-02-02T13:00:00.000Z","demoVersion":"315","bvodAudience":1.0000725552050473,"averageTimeSpent":100,"publisherName":"FOXTEL","publisherId":"f0619170-c1e9-47cf-b347-f068ee3a3b65","deviceType":"tv","mediaId":"NBCU260535","mediaType":"vod","mediaDuration":2536,"seriesId":"227316S9","seriesName":"Murdoch Mysteries","episodeId":"227316S9E15","episodeName":"House Of Industry","genre":"Crime / Law and Order","mainGenre":"Drama","channel":"FOX Sleuth","telProgrammeId":"2090264","telUniqueProgrammeId":"10172903","personPrimaryMinutes":42.269733333333335,"personCoViewerMinutes":0,"personTotalMinutes":42.269733333333335,"adMinutesViewed":0,"loadCount":1,"beginCount":1,"progressCount":43,"completeCount":1,"adBeginCount":0,"adCompleteCount":0,"recordCount":46,"streamStarts":1,"bvodReach":1,"sessionIdCount":1,"bvodMarket":"BRI","demo":{"C00-04":0,"C05-12":0,"C13-17":0,"F18-24":0,"F25-39":0,"F40-54":42.269733333333335,"F55-64":0,"F65+":0,"M18-24":0,"M25-39":0,"M40-54":0,"M55-64":0,"M65+":0}}
{"date":"2021-02-02T13:00:00.000Z","demoVersion":"315","bvodAudience":0.9998095238095238,"averageTimeSpent":99.98095238095239,"publisherName":"SEVEN","publisherId":"f5bb44c-5ad5-4c92-b989-7d17f48e131f","deviceType":"tv","mediaId":"BATA-007","mediaType":"vod","mediaDuration":2625,"seriesId":"BATA","seriesName":"Beauty And The Geek Australia","episodeId":"BATA-007","episodeName":"Season 1 Episode 7","genre":"Other Reality Television","mainGenre":"Entertainment","channel":"Channel 7","personPrimaryMinutes":43.74166666666667,"personCoViewerMinutes":0,"personTotalMinutes":43.74166666666667,"adMinutesViewed":6.286333333333333,"loadCount":1,"beginCount":1,"progressCount":47,"completeCount":1,"adBeginCount":14,"adCompleteCount":14,"recordCount":78,"streamStarts":1,"bvodReach":1,"sessionIdCount":1,"bvodMarket":"SYD","demo":{"C00-04":0,"C05-12":0,"C13-17":0,"F18-24":0,"F25-39":0,"F40-54":0,"F55-64":0,"F65+":0,"M18-24":0,"M25-39":0,"M40-54":43.74166666666667,"M55-64":0,"M65+":0}}
Back