Home Forums The XBRL API Getting error – 'Bad or expired token'

This topic contains 4 replies, has 4 voices, and was last updated by  App Development Pros 3 days, 18 hours ago.

  • Author
    Posts
  • #157736

    Sriram Srinivasan
    Participant

    Hello everyone,

    I’m trying to access XBRL data from Python using the API. I’m new to Python and working with APIs so I’m going through some teething pains and would be glad to have some assistance.

    As a first step, I had to get the access token, which I successfully managed to do in Python using the below code (all sensitive data is masked).


    import requests
    API_ENDPOINT = “https://api.xbrl.us/oauth2/token”

    data = {‘grant_type’:’password’,
    ‘client_id’:’xxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’,
    ‘client_secret’:’xxxx-xxxx-xxxx-xxxx-xxxxx’,
    ‘username’:’xxxxxxxxxxxxxxx@xxx.com’,
    ‘password’: ‘xxxxxxxxxx’}

    # sending post request and saving response as response object
    r = requests.post(url = API_ENDPOINT, data = data)

    # extracting response text
    pastebin_url = r.text
    print(pastebin_url)

    This gave me output including an access token and a refresh token. I’m now trying to use the access token to pull data.

    This is the code I have been working with:

    “import requests

    # api-endpoint
    URL = “https://api.xbrl.us/api/v1/fact/search?concept.local-name=Assets&period.fiscalyear=2017&period.fiscal.period=1Q&Entity.cik=0000001&fields=fact.value”

    PARAMS = {‘Host’:’api.xbrl.us’,
    ‘Authorization’: ‘Bearer<xxxxxxx-xxxxx-xxx-xxx-xxxxx>’}

    # sending get request and saving the response as response object
    r = requests.get(url = URL, params = PARAMS)

    # extracting data in json format
    data = r.json()
    print(data)

    This returns the error: ‘Bad or expired token’. I have tried getting a fresh access token and running the code again but I’m still getting the same error.

    Is there anything wrong with my code? Will be grateful for any guidance. Thanks in advance for your help.

  • #157795

    Marc Ward
    Keymaster

    Hi Sriram,

    You’re almost there! The token needs to submitted in the header of the request. You don’t need to submit any parameters since they’re in the url.

    Add this to your code:

    headerarray = {'Authorization' : 'Bearer xxxxxxx-xxxxx-xxx-xxx-xxxxx'}

    Then change your request line to:

    r = requests.get(url, headers=headerarray)

    You should receive the results of the query now.

  • #160212

    k varun
    Participant

    Jack Nathan Health is committed to improving access to public health care by delivering consistent, quality care in state-of-the-art medical and dental clinics through cutting-edge technology and highly qualified medical expertise. walk in clinic saskatoon

  • #160223

    I think you change your XBRL data

You must be logged in to reply to this topic.

Comment