Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import clr
- clr.AddReference('System.Net')
- from System.Net import HttpWebRequest, NetworkCredential
- from Spotfire.Dxp.Data.Import import TextFileDataSource, TextDataReaderSettings
- readerSettings = TextDataReaderSettings()
- readerSettings.Separator = ";"
- readerSettings.CultureName = "en-GB"
- req = HttpWebRequest.Create("a link to csv file")
- user_agent = 'individual user-agent'
- req.UserAgent = user_agent
- req.Method = "GET"
- req.UseDefaultCredentials = True
- #req.PreAuthenticate = True
- user = Document.Properties["Username"]
- password = Document.Properties["Password"]
- req.Credentials = NetworkCredential(user, password)
- rsp = req.GetResponse()
- dSource = TextFileDataSource(rsp.GetResponseStream(),readerSettings)
- rsp.Close()
- dataManager = Document.Data
- dataTable = dataManager.Tables[document.Name]
- dataTable.ReplaceData(dSource)
Add Comment
Please, Sign In to add comment