AutoIt

SharePoint -- Download a Text File into a String Variable

See more SharePoint Examples

Demonstrates how to download a text file from SharePoint into a string variable. AutoIt

Local $bSuccess = False

; This requires the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.

; -------------------------------------------------------------------------
; The following comments apply to SharePoint Windows classic authentication.
; -------------------------------------------------------------------------
; For example, imagine our SharePoint endpoint is https://xyzoffice.mycompany.com/
; The SHAREPOINT_NTLM_DOMAIN would be "mycompany.com"
; The SHAREPOINT_HTTPS_DOMAIN would be "xyzoffice.mycompany.com"
; Also, the SHAREPOINT_USERNAME would be just the name, not a full email address.
; for example, "chilkat" instead of "chilkat@mycompany.com"

$oHttp = ObjCreate("Chilkat.Http")

; If SharePoint Windows classic authentication is used, then set the 
; Login, Password, LoginDomain, and NtlmAuth properties.
$oHttp.Login = "SHAREPOINT_USERNAME"
$oHttp.Password = "SHAREPOINT_PASSWORD"
$oHttp.LoginDomain = "SHAREPOINT_NTLM_DOMAIN"
$oHttp.NtlmAuth = True

; -------------------------------------------------------------------------
; The more common case is to use SharePoint Online authentication (via the SPOIDCRL cookie).
; If so, do not set Login, Password, LoginDomain, and NtlmAuth, and instead
; establish the cookie as shown at SharePoint Online Authentication
; -------------------------------------------------------------------------

; This example downloads a CSV file that is utf-8 and contains Japanese characters.

Local $sUrl = "https://SHAREPOINT_HTTPS_DOMAIN/_api/web/GetFileByServerRelativeUrl('/Documents/ChilkatTest/japanese.csv')/$value"

$oHttp.AcceptCharset = "utf-8"

Local $strCsv = $oHttp.QuickGetStr($sUrl)
If ($oHttp.LastMethodSuccess <> True) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

; The CSV file is contained in strCsv.
ConsoleWrite("CSV:" & @CRLF)
ConsoleWrite($strCsv & @CRLF)

; Note: The HTTP response hopefully indicates the charset of the response,
; and Chilkat should receive the string correctly.  If the response sent by
; SharePoint does not indicate a charset, or indicates an incorrect charset,
; then we can instead download the text file as binary data and interpret the
; bytes ourselves correctly.  For example:  

$oBd = ObjCreate("Chilkat.BinData")
$bSuccess = $oHttp.QuickGetBd($sUrl,$oBd)
If ($bSuccess <> True) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

; Interpret the bytes correctly as utf-8
$oSb = ObjCreate("Chilkat.StringBuilder")
$oSb.AppendBd($oBd,"utf-8",0,0)
ConsoleWrite("CSV:" & @CRLF)
ConsoleWrite($oSb.GetAsString() & @CRLF)