reading Facebook open graph into database
Hi
I am wantingto read Facebook opengraph information into a clients DB. I have formatted the input into Facebook and I am processing the recursive requests. The problem I am having is that I am just not able to get the JSON into a format that I can read into the DB. Multple splits and transposes later and I am still no where. Is there an easier way to read this format of code in:
{
"posts":{
"data":[
{
"comments":{
"data":[
{
"created_time":"2018-04-19T06:09:10+0000",
"from":{
"name":"User 1",
"id":"12345"
},
"message":"Thank you",
"id":"12345_12345"
},
{
"created_time":"2018-04-19T06:11:50+0000",
"from":{
"name":"User 2",
"id":"567890"
},
"message":"for your help",
"id":"12345_567890"
},
],
}
}
]
}
}
The format it comes from in the open graph means that there can be sub comments of comments which is where I am fowling up as I end up with a matrix instead of a data table.