Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'INTO'. (156) (SQLExecDirectW)")
- import requests
- import json
- import pyodbc
- username = input ('Username: ')
- password = input ('Password: ')
- endpoint = input ('Enter the endpoint here: ')
- response = requests.get('https://' + username + ':' + password + '@api.exampledata.com/en/'+ endpoint +'.json')
- data =response.text
- parsed=json.loads(data)
- conn = pyodbc.connect(
- r'DRIVER={ODBC Driver 17 for SQL Server};'
- r'SERVER=localhost;'
- r'DATABASE=test;'
- r'UID=test;'
- r'PWD=test'
- )
- cursor = conn.cursor()
- for info in parsed['customers']:
- cursor.execute("INSERT IGNORE INTO test (idklanten, voornaam, achternaam,telefoonnummer,email,bedrijf) VALUES ('%s','%s','%s','%s','%s','%s')"%(info["id"], info["firstname"], info["lastname"],info["phone"],info["email"],info["companyName"]))
- conn.commit()
- conn.close()
Add Comment
Please, Sign In to add comment