Guest User

Untitled

a guest
May 28th, 2018
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'INTO'. (156) (SQLExecDirectW)")
  2.  
  3. import requests
  4. import json
  5. import pyodbc
  6.  
  7. username = input ('Username: ')
  8. password = input ('Password: ')
  9. endpoint = input ('Enter the endpoint here: ')
  10.  
  11. response = requests.get('https://' + username + ':' + password + '@api.exampledata.com/en/'+ endpoint +'.json')
  12.  
  13. data =response.text
  14. parsed=json.loads(data)
  15.  
  16. conn = pyodbc.connect(
  17. r'DRIVER={ODBC Driver 17 for SQL Server};'
  18. r'SERVER=localhost;'
  19. r'DATABASE=test;'
  20. r'UID=test;'
  21. r'PWD=test'
  22. )
  23.  
  24. cursor = conn.cursor()
  25.  
  26. for info in parsed['customers']:
  27. 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"]))
  28. conn.commit()
  29. conn.close()
Add Comment
Please, Sign In to add comment