Python Download multplie json is not working

[netKen]

What am i missing?
Using Python 3.6

import json
import csv
import urllib.parse
import requests

start = int(input("Från stryktips omgång : "))
end = int(input("Till stryktips omgång: ")) + 1

for drawNumber in range(start, end):

    url = 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}?accesskey={1}'
    response = requests.get(url.format(drawNumber, apiKey.Strip()))
    draw = json.loads(response.content)

    print(draw)
with open('stryktipset', 'w') as json_file:

    json.dump(draw, json_file)

 

[netKen]

What am i missing?
Using Python 3.6

import json
import csv
import urllib.parse
import requests

start = int(input("Från stryktips omgång : "))
end = int(input("Till stryktips omgång: ")) + 1

for drawNumber in range(start, end):

    url = 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}?accesskey={1}'
    response = requests.get(url.format(drawNumber, apiKey.Strip()))
    draw = json.loads(response.content)

    print(draw)
with open('stryktipset', 'w') as json_file:

    json.dump(draw, json_file)

It downloads only 1 in range, if i type for example 4700 - 4730, then i get only 4730. I have no idea how to download multiplie files, i have search internet but cant find anything

 

[simong1993]

Hey, without your full code this is going to be really hard to help but try this :-

import json
import csv
import urllib.parse
import requests

start = int(input("Från stryktips omgång : "))
end = int(input("Till stryktips omgång: ")) + 1

for drawNumber in range(start, end):

    url = 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}?accesskey={1}'
    response = requests.get(url.format(drawNumber, apiKey.Strip()))
    draw = json.loads(response.content)

    print(draw)
with open('stryktipset', 'w') as json_file:

    json.dump(draw, json_file)

the problem you have is you are opening the json after you have finished rather then one at a time

 

[netKen]

Hey, without your full code this is going to be really hard to help but try this :-

That is my full code but because i have a personal apikey i cant show you the url without people to see my key.

Sorry for my bad understanding in english, i dont understand what you mean?
I have hundreds of files i want to download in 1 textfile, not 1 textfile for each file, they must be in one textfile together, then i will convert them to csv.

 

[racheal]

can you please share the entire code, since the above code looks fine and you are still facing error

 

[simong1993]

The API is what i need to be able to test for you 😀 So the issue you have having is this :-

for drawNumber in range(start, end):

    url = 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}?accesskey={1}'
    response = requests.get(url.format(drawNumber, apiKey.Strip()))
    draw = json.loads(response.content)

    print(draw)

Here you get your JsonFile in a loop but do not store it in any way so all you are doing is getting a new one but erasing the previous,Due to not having your API i do not know what is in there 🙁. What i would then do is make a dict like so and convert that dict into a CSV file. The code i have added should work fine, if possible can yous end me a copy of the json so i can make the dict for you 😀 :-

import pandas as pd
import json
import csv
import urllib.parse
import requests

start = int(input("Från stryktips omgång : "))
end = int(input("Till stryktips omgång: ")) + 1
draw_list = []

for drawNumber in range(start, end):
    draw = {}
    url = 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}?accesskey={1}'
    response = requests.get(url.format(drawNumber, apiKey.Strip()))
    data = json.loads(response.content)
  
    draw['first'] = data['firstdata']
    draw['second'] = data['second']
    draw['third'] = data['third']
    draw_list.append(draw)

df = pd.DataFrame(draw_list.)
df.to_csv('draw_list.csv',index=False)
pd.read_csv('draw_list.csv')

 

[netKen]

if possible can yous end me a copy of the json so i can make the dict for you 😀

how to private message you?, i can send you the file without the key, Ok, see the attached files 🙂

 

[simong1993]

Awesome, out of that JSON file as its huge what keys do you need?

 

[netKen]

Maybe i ask too much now 😱. The files i attached is called "Draw", i also have another JSON file that belongs to the draw, it called "result". In he "Draw" file there is odds and other things about the matches and the file "result" is the outcome for that game, is it possible to combine 2 jsonfiles and download them into 1? The attached files, first the original "draw", then the "draw2" is what i marked what i need to download, if you open with notepad++ you see what lines they are at. After i can change what order they can be at i hope. Also the closetime looks like this: 2021-10-03T14:59:00+02:00, a little too much but maybe i can format later in the spreadsheets/Excel, its enough with this: 2021-10-03

draw: 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}?accesskey={1}'
result: 'https://api.www.svenskaspel.se/external/1/draw/stryktipset/draws/{0}/result?accesskey={1}'

 

[simong1993]

All you are asking is possible 😀 best bet is to make a Dict then get both JSONs and store them in the dict but only the data you need then to export the dict to a excel.

If you take a screen shot and mark the bits you need in the files i can make a script to do this for you 😀 i just need the exact data you need and you can make the data the format you would like with python also 😀

 

[netKen]