Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Makes API call
- resultsreturn = requests.get(url,headers=head)
- # Grabs text from API call
- # Data is returned in one long string:
- # '"Header1,Header2,Header3,Header4\nR1C1,R1C2,R1C3,R1C4\nR2C1,R2C2,R2C3,R2C4"'
- results_json_data = json.dumps(resultsreturn.text)
- # Splits results into list:
- # ['"Header1,Header2,Header3,Header4', 'R1C1,R1C2,R1C3,R1C4', 'R2C1,R2C2,R2C3,R2C4"']
- list_results_split = results_json_data.split('\n')
- #Splits list into dictionary.
- dict_results = dict(zip(range(len(list_results_split)), list_results_split))
- {0: '"Header1,Header2,Header3,Header4',
- 1: 'R1C1,R1C2,R1C3,R1C4'
- 2: 'R2C1,R2C2,R2C3,R2C4"'}
- {0: {"Header1":"R1C1", "Header2":"R1C2", "Header3":"R1C3", "Header4":"R1C4"}
- 1: {"Header1":"R2C1", "Header2":"R2C2", "Header3":"R2C3", "Header4":"R2C4"}
- 2: {"Header1":"R3C1", "Header2":"R3C2", "Header3":"R3C3", "Header4":"R3C4"}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement