Guest User

Untitled

a guest
Nov 15th, 2017
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. import clr
  2. clr.AddReference('System.Net')
  3. from System.Net import HttpWebRequest, NetworkCredential
  4. from Spotfire.Dxp.Data.Import import TextFileDataSource, TextDataReaderSettings
  5.  
  6. readerSettings = TextDataReaderSettings()
  7. readerSettings.Separator = ";"
  8. readerSettings.CultureName = "en-GB"
  9.  
  10. req = HttpWebRequest.Create("a link to csv file")
  11.  
  12. user_agent = 'individual user-agent'
  13. req.UserAgent = user_agent
  14. req.Method = "GET"
  15.  
  16. req.UseDefaultCredentials = True
  17. #req.PreAuthenticate = True
  18. user = Document.Properties["Username"]
  19. password = Document.Properties["Password"]
  20.  
  21. req.Credentials = NetworkCredential(user, password)
  22.  
  23. rsp = req.GetResponse()
  24. dSource = TextFileDataSource(rsp.GetResponseStream(),readerSettings)
  25. rsp.Close()
  26.  
  27. dataManager = Document.Data
  28. dataTable = dataManager.Tables[document.Name]
  29. dataTable.ReplaceData(dSource)
Add Comment
Please, Sign In to add comment