Storing json objects in sql server using facebook api?

Question

I am fetching friends of the logged in users on my website from facebook in the JsonObject in [name,uid] pair .

I have attached the debug image of the object.

enter image description here

I am referring to this code for reference

JSONObject me = api.Get("/me"); JSONObject meFriends = api.Get("/me/friends");

How do i store extract and store the id and name of meFriends?

I want to store this name value pair in sql database?

Please help how could i achieve this?

DMCS · Accepted Answer · 2012-01-28 09:53:36Z

2

Change JSONObject meFriends = api.Get("/me/friends"); to JSONObject meFriends = api.Get("/me/friends?fields=id,name");
foreach thru the resulting data in meFriends and inside of it you will do steps 3-5
create a parameters array
assign the id and name from data
call insert sproc passing it the parameters array

Of course, I'd recommend you look into batch operations relating to your particular data adapter rather than killing your data store with umpteem-zillion calls, but I wanted the pseudo-code to be clear.

Depending upon the data store and the data adapter you use, they may already have ways to store arrays of objects without having to do what I showed above.

answered Jan 28, 2012 at 9:53

DMCS

31.9k14 gold badges73 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Storing json objects in sql server using facebook api?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related