Reputation: 91
I have this code for transforming JSON response and I'd like to insert the tags, channels, and members into each object.
import pandas as pd
import requests
members = [12321,21223,22131,23134]
tags = [6345,3456]
channels = ["abc","cde","fgh"]
access_token = "sample_token"
url = f"https://google.com/api/sample"
headers = {
"Content-Type": "application/json",
"Accept": "application/json",
"Authorization": f'Basic {access_token}'}
results = []
for tag in tags:
for channel in channels:
for member_id in members:
response = requests.post(url, headers=headers)
result = response.json()
if 'records' not in result:
print('No tickets found!')
search_results = result['records']
for item in search_results:
item["tag"] = tag
item["channel"] = channel
item["member_id"] = member_id
results.extend(search_results)
df = pd.DataFrame(search_results)
print(df.head(5))
but I keep getting this error:
item["tag"] = tag
TypeError: 'str' object does not support item assignment
** I already fixed the issue.
Upvotes: 0
Views: 111