python 3.7 on windows using flask and flask-sqlalchemy.

[Alpy]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

[url=https://github.com/celiao/tmdbsimple/]API used[/url] #I can't extract data from an API arrow and add it to my database   @blueprintRote.route('/', methods =['GET','POST']) def post_movies():     #POST     if  request.method == 'POST':         def search(title):             search = tmdb.Search()             response = search.movie(query=title)             info = json.dumps(search.results)             record = []             for infos in info:                 record.append((infos['title'], infos['release_date'], infos['popularity']))             return record              m = search('The Bourne')                   new_user = Movies(title=m['title'],          release_date=m['release_date'],popularity=m['popularity'])           db.session.add(new_user)         db.session.commit()       return render_template('myMovies.htm')

Error:
File "c:\users\alefg\projects\mytop100movies\venv\lib\site-packages\flask\app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "C:\Users\alefg\projects\MyTop100Movies\src\blueprint\blueprintsRoutes.py", line 21, in post_movies
    m = search('The Bourne')
  File "C:\Users\alefg\projects\MyTop100Movies\src\blueprint\blueprintsRoutes.py", line 18, in search
    record.append((infos['title'], infos['release_date'], infos['popularity']))
TypeError: string indices must be integers

[mlieqo]

with this line:

1	info = json.dumps(search.results)

you serialize search.results to JSON formatted string and then later here:

1	record.append((infos['title'], infos['release_date'], infos['popularity']))

you try to access it's keys like it's dictionary, which causes the error shown

[Alpy]

1 2 3 4 5 6 7 8 9

def search(title):           search = tmdb.Search()           response = search.movie(query=title)           record = []           for info in search.results:                record.append(info['title'])                record.append(info['release_date'])                record.append(info['popularity'])           return record