Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3/4TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

PowerBuilder Examples

Web API Categories

ASN.1
Amazon Glacier
Amazon S3
Amazon S3 (new)
Amazon SES
Amazon SNS
Amazon SQS
Async
Azure Cloud Storage
Azure Service Bus
Base64
Bounced Email
Box
CAdES
CSR
CSV
Certificates
Compression
DKIM / DomainKey
DSA
Diffie-Hellman
Digital Signatures
Dropbox
Dynamics CRM
ECC
Email Object
Encryption
FTP
FileAccess
Firebase
GMail REST API
Geolocation
Google APIs
Google Calendar
Google Cloud Storage
Google Drive
Google Photos
Google Sheets
Google Tasks
Gzip
HTML-to-XML/Text

HTTP
HTTP Misc
IMAP
JSON
JSON Web Encryption (JWE)
JSON Web Signatures (JWS)
JSON Web Token (JWT)
Java KeyStore (JKS)
MHT / HTML Email
MIME
Microsoft Graph
NTLM
OAuth1
OAuth2
OneDrive
OpenSSL
Outlook
PEM
PFX/P12
POP3
PRNG
REST
REST Misc
RSA
SCP
SFTP
SMTP
SSH
SSH Key
SSH Tunnel
SharePoint
Socket/SSL/TLS
Spider
Stream
Tar Archive
Upload
WebSocket
XAdES
XML
XML Digital Signatures
XMP
Zip
curl

 

 

 

(PowerBuilder) SharePoint -- Upload File

Demonstrates how to upload a file to a SharePoint folder.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Http
oleobject loo_Resp
oleobject loo_Xml
oleobject loo_Req
integer li_BUseTls

//  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"

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat_9_5_0.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

//  If SharePoint Windows classic authentication is used, then set the
//  Login, Password, LoginDomain, and NtlmAuth properties.
loo_Http.Login = "SHAREPOINT_USERNAME"
loo_Http.Password = "SHAREPOINT_PASSWORD"
loo_Http.LoginDomain = "SHAREPOINT_NTLM_DOMAIN"
loo_Http.NtlmAuth = 1

//  -------------------------------------------------------------------------
//  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
//  -------------------------------------------------------------------------

//  When creating, updating, and deleting SharePoint entities, we'll need
//  to first get the server's form digest value to send in the X-RequestDigest header.
//  This can be retrieved by making a POST request with an empty body to
//  http://<site url>/_api/contextinfo and extracting the value of the
//  d:FormDigestValue node in the XML that the contextinfo endpoint returns.
loo_Resp = loo_Http.PostXml("https://SHAREPOINT_HTTPS_DOMAIN/_api/contextinfo","","utf-8")
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    return
end if

if loo_Resp.StatusCode <> 200 then
    //  A response status code not equal to 200 indicates failure.
    Write-Debug "Response status code = " + string(loo_Resp.StatusCode)
    Write-Debug "Response body:"
    Write-Debug loo_Resp.BodyStr
    destroy loo_Resp
    destroy loo_Http
    return
end if

loo_Xml = create oleobject
li_rc = loo_Xml.ConnectToNewObject("Chilkat_9_5_0.Xml")

loo_Xml.LoadXml(loo_Resp.BodyStr)
destroy loo_Resp

Write-Debug loo_Xml.GetXml()

//  The response XML looks like this:

//  <?xml version="1.0" encoding="utf-8" ?>
//  <d:GetContextWebInformation xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" m:type="SP.ContextWebInformation">
//      <d:FormDigestTimeoutSeconds m:type="Edm.Int32">1800</d:FormDigestTimeoutSeconds>
//      <d:FormDigestValue>0x3059FFB920651834540F3E6792EA73F5746B302E953FF4E808E485DB1E6C2836C7CF924644995F092453B02A94DE14A7962674B7B16780AF16EAFB8C246BCDC7,12 Apr 2017 17:08:22 -0000</d:FormDigestValue>
//      <d:LibraryVersion>15.0.4569.1000</d:LibraryVersion>
//      <d:SiteFullUrl>https://SHAREPOINT_HTTPS_DOMAIN</d:SiteFullUrl>
//      <d:SupportedSchemaVersions m:type="Collection(Edm.String)">
//          <d:element>14.0.0.0</d:element>
//          <d:element>15.0.0.0</d:element>
//      </d:SupportedSchemaVersions>
//      <d:WebFullUrl>https://SHAREPOINT_HTTPS_DOMAIN</d:WebFullUrl>
//  </d:GetContextWebInformation>
// 

//  We'll use the d:FormDigestValue in the X-RequestDigest request header
//  for the actual file upload.

//  --------------------------------------------------------------------
//  Now upload a file named "penguins2.jpg" to the "/Documents" folder.

loo_Req = create oleobject
li_rc = loo_Req.ConnectToNewObject("Chilkat_9_5_0.HttpRequest")

loo_Req.HttpVerb = "POST"
//  Change "/Documents" to whatever folder is the destination.
loo_Req.Path = "/_api/web/GetFolderByServerRelativeUrl('/Documents')/Files/add(url='penguins2.jpg',overwrite=true)"
//  Give the location of the file to be uploaded.
//  Note: The file is not loaded into memory at this point.  It is never fully loaded
//  into memory.  Instead, the file data is streamed directly from the file when
//  when the upload occurs.
loo_Req.StreamBodyFromFile("qa_data/jpg/penguins2.jpg")

//  Add the X-RequestDigest header field.
loo_Req.AddHeader("X-RequestDigest",loo_Xml.GetChildContent("d:FormDigestValue"))

//  Do the upload using https (TLS). Port 443 is the default port for https.
li_BUseTls = 1
loo_Resp = loo_Http.SynchronousRequest("SHAREPOINT_HTTPS_DOMAIN",443,li_BUseTls,loo_Req)
if loo_Http.LastMethodSuccess <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_Xml
    destroy loo_Req
    return
end if

//  The response body contains XML.  Load it into our xml object..
loo_Xml.LoadXml(loo_Resp.BodyStr)

if loo_Resp.StatusCode <> 200 then
    Write-Debug "Response status code = " + string(loo_Resp.StatusCode)
    Write-Debug loo_Xml.GetXml()
    Write-Debug "Failed"
    destroy loo_Resp
    destroy loo_Http
    destroy loo_Xml
    destroy loo_Req
    return
end if

destroy loo_Resp

//  Show the successful XML response.
Write-Debug loo_Xml.GetXml()
Write-Debug "Success."

//  A successful XML response looks like this:

//  <?xml version="1.0" encoding="utf-8" ?>
//  <entry xml:base="https://SHAREPOINT_HTTPS_DOMAIN/_api/" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
//      <id>Web/GetFileByServerRelativeUrl('/Documents/penguins2.jpg')</id>
//      <category term="SP.File" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
//      <link rel="edit" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)" />
//      <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Author" type="application/atom+xml;type=entry" title="Author" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)/Author" />
//      <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/CheckedOutByUser" type="application/atom+xml;type=entry" title="CheckedOutByUser" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)/CheckedOutByUser" />
//      <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ListItemAllFields" type="application/atom+xml;type=entry" title="ListItemAllFields" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)/ListItemAllFields" />
//      <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LockedByUser" type="application/atom+xml;type=entry" title="LockedByUser" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)/LockedByUser" />
//      <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ModifiedBy" type="application/atom+xml;type=entry" title="ModifiedBy" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)/ModifiedBy" />
//      <link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Versions" type="application/atom+xml;type=feed" title="Versions" href="Web/GetFileByServerRelativeUrl(&apos;/Documents/penguins2.jpg&apos;)/Versions" />
//      <title />
//      <updated>2017-04-12T17:16:44Z</updated>
//      <author>
//          <name />
//      </author>
//      <content type="application/xml">
//          <m:properties>
//              <d:CheckInComment />
//              <d:CheckOutType m:type="Edm.Int32">0</d:CheckOutType>
//              <d:ContentTag>{FC8D1A58-9544-496C-8D9C-19B501A8B322},2,3</d:ContentTag>
//              <d:CustomizedPageStatus m:type="Edm.Int32">0</d:CustomizedPageStatus>
//              <d:ETag>"{FC8D1A58-9544-496C-8D9C-19B501A8B322},2"</d:ETag>
//              <d:Exists m:type="Edm.Boolean">true</d:Exists>
//              <d:Length m:type="Edm.Int64">99832</d:Length>
//              <d:Level m:type="Edm.Byte">255</d:Level>
//              <d:MajorVersion m:type="Edm.Int32">0</d:MajorVersion>
//              <d:MinorVersion m:type="Edm.Int32">1</d:MinorVersion>
//              <d:Name>penguins2.jpg</d:Name>
//              <d:ServerRelativeUrl>/Documents/penguins2.jpg</d:ServerRelativeUrl>
//              <d:TimeCreated m:type="Edm.DateTime">2017-04-12T17:14:19Z</d:TimeCreated>
//              <d:TimeLastModified m:type="Edm.DateTime">2017-04-12T17:16:44Z</d:TimeLastModified>
//              <d:Title m:null="true" />
//              <d:UIVersion m:type="Edm.Int32">1</d:UIVersion>
//              <d:UIVersionLabel>0.1</d:UIVersionLabel>
//          </m:properties>
//      </content>
//  </entry>
// 
// 


destroy loo_Http
destroy loo_Xml
destroy loo_Req

 

© 2000-2019 Chilkat Software, Inc. All Rights Reserved.