🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

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