reading Facebook open graph into database

User: "robin"
New Altair Community Member
Updated by Jocelyn

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. 

 

Find more posts tagged with