CodingForums.com - View Single Post - JSON response form server--Urgent

greeki78 · 01-21-2013, 04:09 PM

Hi All,
I'm copy an API on web browser (Its like this).I get response,
https://fridaycamp.ca/api/v1/version...1becbb188b91ed....

I get response
{"status": "ok", "version": "1.1.0"}

I have sample other responses where I get by using cURL.

I need to extract this data from the server and load it into another server.I'm horribly confused.

Here's the whole picture.

We have original data on server1
We can access the server1 data using only API requests.I sent API request to server1 and got the responses in JSON.
I need to extract the data from JSON responses and then load into SQL server which is on server2.
I'm connected to server 2(that's where I have to write the code to extract the data)

What is the best way to extract this data from server1 to server2?

Should I write Java script/PHP to extract the data from server1 and load it into server2?

Should it be written in Phython?or ......?

Any ideas would be appreciated at this point of time.

It's very urgent.

Thank You.

01-21-2013, 04:09 PM	PM User \| #1
greeki78 New to the CF scene Join Date: Jan 2013 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts	JSON response form server--Urgent Hi All, I'm copy an API on web browser (Its like this).I get response, https://fridaycamp.ca/api/v1/version...1becbb188b91ed.... I get response {"status": "ok", "version": "1.1.0"} I have sample other responses where I get by using cURL. I need to extract this data from the server and load it into another server.I'm horribly confused. Here's the whole picture. We have original data on server1 We can access the server1 data using only API requests.I sent API request to server1 and got the responses in JSON. I need to extract the data from JSON responses and then load into SQL server which is on server2. I'm connected to server 2(that's where I have to write the code to extract the data) What is the best way to extract this data from server1 to server2? Should I write Java script/PHP to extract the data from server1 and load it into server2? Should it be written in Phython?or ......? Any ideas would be appreciated at this point of time. It's very urgent. Thank You.