If the payload you are downloading is binary you would write it like this:

open('my.jpg', 'wb').write(response.content)

Or if it is text:

open('my.txt', 'w').write(response.text)
#print(open("my.txt", "r").read())

As in the comment mentioned the solution is via a return redirect(url_with_sas) so the whole function looks like this:

@app.route('/download')
def download():
    account_name = "deeusblobstorage"
    container_name = "rperodct"
    blob_name = "face_1_7285.jpg"
    account_key = "hMlIRXCjAomfDRfied8Y5FPwTVnWEkEDuVsw//CQtkiOdcFD/y5wUcxH9Ou7Ni+DtDQFwe23YbZ3Qia9gw=="
    url = f"https://{account_name}.blob.core.windows.net/{container_name}/{blob_name}"
    sas_token = generate_blob_sas(
        account_name=account_name,
        account_key=account_key,
        container_name=container_name,
        blob_name=blob_name,
        permission=AccountSasPermissions(read=True),
        expiry=datetime.datetime.utcnow() + timedelta(hours=1)
    )

    url_with_sas = f"{url}?{sas_token}"
    return redirect(url_with_sas)

I'm executing python script from the command line. · I may be missing some steps below but the general way to install python is as follows. · 1. Install python · https://phoenixnap.com/kb/how-to-install-python-3-windows · 2. Create subdirectory · mkdir servicenowapis · 3. Move to the subdirectory · cd servicenowapis · 4. Create a virtualenv · python-m venv venv · 5. Activate venv · venv\Scripts\activate.bat · 6. Install request module · pip install requests · 7. Copy the script I've provided to the directory · 8. Copy and paste content of Constants.py over import statements · 9. Edit username, password · 9. Edit table_api.py to use Incident number · e.g. · get_file_attachment('INC0000002') · 10. Execute command · python test_api.py ·   · import requests · SERVICENOW_URL = 'https://.service-now.com' · SERVICENOW_USER = '' · SERVICENOW_PWD = '' · DOWNLOAD_DIR = './downloads/' · REQUEST_HEADER = {"json": {"Content-Type": "application/xml", "Accept": "application/json"}, · "png": {"Content-Type": "application/xml", "Accept": "application/png"}, · "xml": {"Content-Type": "application/xml", "Accept": "application/xml"}, · } · ATTACHMENT_API = '/api/now/attachment' · TABLE_API = '/api/now/table' · # TABLE_NAME = 'kb_knowledge' · TABLE_NAME = 'incident' · def get_table_data(table_name, param): · url = SERVICENOW_URL + TABLE_API + '/' + table_name + '?' + param · response = requests.get(url, auth=(SERVICENOW_USER, SERVICENOW_PWD), headers=REQUEST_HEADER.get('json')) · if response.status_code != 200: # if error, then exit · print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:', response.json()) · exit() · return response.json() · def get_attachment_info(sys_id): · url = SERVICENOW_URL + ATTACHMENT_API + '/' + sys_id · response = requests.get(url, auth=(SERVICENOW_USER, SERVICENOW_PWD), headers=REQUEST_HEADER.get('json')) · if response.status_code != 200: # if error, then exit · print(f'Status: {response.status_code}, Headers:{response.headers}') · exit() · return response.json() · def get_attachment(att_sys_id, file_type, download_dir): · url = SERVICENOW_URL + '/' + ATTACHMENT_API + '/' + att_sys_id + '/file' · response = requests.get(url, auth=(SERVICENOW_USER, SERVICENOW_PWD), headers=REQUEST_HEADER.get(file_type)) · if response.status_code != 200: # if error, then exit · print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:', response.json()) · exit() · with open(download_dir, 'wb') as f: · for chunk in response: · f.write(chunk) · def get_file_attachment(record_number): · param = 'sysparm_query=number=' + record_number + '&sysparam_limit=1' · file_info = get_table_data(TABLE_NAME, param).get('result') · if len(file_info) < 1: · print(f'There is no attachment to sys_id:{record_number}') · return · attachment_sys_id = file_info[0].get('sys_id') · param = 'sysparm_query=table_sys_id=' + attachment_sys_id + '&sysparam_limit=1' · kb_attachments = get_table_data('sys_attachment', param) · result = kb_attachments.get('result') · for attach_file in result: · attach_sys_id = attach_file.get('sys_id') · content_type = attach_file.get('content_type').split('/') · file_ext = content_type[1] · file_name = attach_file.get('file_name') · get_attachment(attach_sys_id, file_ext, DOWNLOAD_DIR + file_name) · if __name__ == '__main__': · # get_file_attachment('KB0010062') # knowledge base number · get_file_attachment('INC0000002') · View solution in original post

This worked For me

from starlette.responses import FileResponse

return FileResponse(file_location, media_type='application/octet-stream',filename=file_name)

This will download the file with filename

One more, using urlretrieve:

import urllib.request
urllib.request.urlretrieve("http://www.example.com/songs/mp3.mp3", "mp3.mp3")

(for Python 2 use import urllib and urllib.urlretrieve)

Download the file as binary content. You cannot convert it to JSON, that's why you get the error. Try this:

import requests

r = requests.get('XXXX.getDataSetByFeedId', params={'feedId': feed_id}, auth=(username, passwd))

filename = '{}.xlsx'.format(feed_id)

with open(filename, 'wb') as f:
    f.write(r.content)