[R] JSON to Dataframe

[Abhinaba Roy]

Hi R helpers,

I have json inputs from an app which I want to convert to dataframes. Below
are the two inputs. Can someone help me in converting these to dataframes

*Input1*

{"booking":{"id":"54092","createdOn":"2016-10-06T06:29:00.0000000+0000","bookingDateTime":"2016-10-08T06:45:00.0000000+0000","checkInDateTime":null,"checkOutDateTime":null,"tableNumbers":null,"pax":3,"type":"calling","status":"booked","source":"concierge","specialInstruction":"test
hoppi","outlet":{"id":"46a97c2e-c921-4339-819c-50e17f25d09a","name":"Hoppipolla"},"customer":{"name":"Hoppi","email":"
hoppi at xmail.com
","countryCallingCode":"91","phone":"8901234567"}},"eventType":"booked","serverDateTime":"2016-10-06T06:28:25.0000558+0000"}

{"booking":{"id":"54093","createdOn":"2016-10-06T06:30:00.0000000+0000","bookingDateTime":"2016-10-08T06:46:00.0000000+0000","checkInDateTime":null,"checkOutDateTime":null,"tableNumbers":null,"pax":3,"type":"calling","status":"booked","source":"concierge","specialInstruction":"test
hoppi","outlet":{"id":"46a97c2e-c922-4339-819c-50e17f25d09a","name":"Hoppipolla"},"customer":{"name":"Ravi","email":"
ravi at xmail.com
","countryCallingCode":"91","phone":"8901234548"}},"eventType":"booked","serverDateTime":"2016-10-06T06:28:25.0000558+0000"}


*Input2*


{"feedback":{"dateTime":"2016-10-06T09:24:05.0000730+0000","customerName":"mytestdevcog","averageRating":4,"isNegativeByComments":false,"outlet":{"id":"f9e9c21f-2e52-462e-a1f2-012dab216d27","name":"cholan
's Darbar"},"customer":{"name":"mytestdevcog","email":"
mytestdevcog123 at gmail.com","countryCallingCode":"91","phone":"7895478745"},"responses":[{"question":"Was
your waiting time too
long?","response":"No","questionType":"yes_no"},{"question":"Service","response":"3","questionType":"rating"},{"question":"desserts","response":"4","questionType":"rating"},{"question":"Comments","response":"good","questionType":"short_answer"},{"question":"How
likely is it that you would recommend us to a friend or
colleague?","response":"5","questionType":"nps"},{"question":"Portion
Size","response":"5","questionType":"rating"},{"question":"Indian
Food","response":"4","questionType":"rating"},{"question":"Desert
spread","response":"4","questionType":"rating"}]},"serverDateTime":"2016-10-06T09:24:27.0000644+0000"}

{"feedback":{"dateTime":"2016-10-06T09:24:05.0000730+0000","customerName":"mytestdevcog","averageRating":4,"isNegativeByComments":false,"outlet":{"id":"f9e9c21f-2e52-462e-a1f2-012dab216d27","name":"cholan
's Darbar"},"customer":{"name":"mytestdevcog","email":"
mytestdevcog123 at gmail.com","countryCallingCode":"91","phone":"7895478745"},"responses":[{"question":"Was
your waiting time too
long?","response":"No","questionType":"yes_no"},{"question":"Service","response":"3","questionType":"rating"},{"question":"desserts","response":"4","questionType":"rating"},{"question":"Comments","response":"good","questionType":"short_answer"},{"question":"How
likely is it that you would recommend us to a friend or
colleague?","response":"5","questionType":"nps"},{"question":"Portion
Size","response":"5","questionType":"rating"},{"question":"Indian
Food","response":"4","questionType":"rating"},{"question":"Desert
spread","response":"4","questionType":"rating"}]},"serverDateTime":"2016-10-06T09:24:27.0000644+0000"}


Would require two seperate dataframes for two inputs. Help would be highly
appreciated


Regards,

Abhinaba

	[[alternative HTML version deleted]]