Issues with Curl request in python

Question

I am attempting to get a simple JSON currency rate response from an API (oanda).
but receiving various error codes, such as 'invalid syntax'.

Here is my updated code:

import requests
import json

from optparse import OptionParser

def connect_to_stream():
    """
    Environment           <Domain>
    fxTrade               stream-fxtrade.oanda.com
    fxTrade Practice      stream-fxpractice.oanda.com
    sandbox               stream-sandbox.oanda.com
    """

    # Replace the following variables with your personal ones
    domain = 'stream-fxpractice.oanda.com'
    access_token = 'xxxxxxxxxxxxxxxx'
    account_id = 'xxxxxxxxx'
    instruments = "EUR_USD"

    try:
        s = requests.Session()
        url = "https://" + domain + "/v1/prices"
        headers = {'Authorization' : 'Bearer ' + access_token,
                   # 'X-Accept-Datetime-Format' : 'unix'
                  }
        params = {'instruments' : instruments, 'accountId' : account_id}
        req = requests.Request('GET', url, headers = headers, params = params)
        pre = req.prepare()
        resp = s.send(pre, stream = True, verify = False)
        return resp
    except Exception as e:
        s.close()
        print "Caught exception when connecting to stream\n" + str(e) 


response = urllib2.urlopen("https://api-fxpractice.oanda.com/v1/prices?instruments=EUR_USD")
    data = json.load(response)   
    print data

Sorry, I edited the code and left out the error messages.. I was, however, able to solve the problem by using Oanda's python wrapper here https://github.com/oanda/oandapy.

Answer 1

The url is invalid, I'd suggest checking whether the API has recently changed, as a search on it reveals that other people have tried using it in the past. When trying to access the url in chrome I receive the following information:

The server at api-practice.oanda.com can't be found, because the DNS lookup failed. DNS is the network service that translates a website's name to its Internet address. This error is most often caused by having no connection to the Internet or a misconfigured network. It can also be caused by an unresponsive DNS server or a firewall preventing Google Chrome from accessing the network.

Error code: DNS_PROBE_FINISHED_NXDOMAIN

Also, I would stick to using the requests library or urllib2. The request at the bottom of your question can be rewritten from:

response = urllib2.urlopen("https://api-fxpractice.oanda.com/v1/prices?instruments=EUR_USD")
data = json.load(response)   
print data

to:

r = requests.get("https://api-fxpractice.oanda.com/v1/prices?instruments=EUR_USD")
data = r.json()
print data

EDIT: Url updated to match edit in question.

https://api-practice.oanda.com/v1/prices?instruments=EUR_USD

to

"https://api-fxpractice.oanda.com/v1/prices?instruments=EUR_USD"

Answer 2

Please do an ipconfig /flushdns from command prompt of the server and you are most likely to get the result.