(Delphi ActiveX) SharePoint -- Update List

See more SharePoint Examples

This example shows how to update a SharePoint (to change the value of a list property, such as Title).

For more information, see https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest

Chilkat for Delphi Downloads Chilkat ActiveX DLL for Delphi Chilkat non-ActiveX DLL for Delphi * The examples here use the ActiveX DLL.

uses
    Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
    Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Chilkat_TLB;

...

procedure TForm1.Button1Click(Sender: TObject);
var
http: TChilkatHttp;
req: TChilkatHttpRequest;
json: TChilkatJsonObject;
bUseTls: Integer;
resp: IChilkatHttpResponse;

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

http := TChilkatHttp.Create(Self);

// If SharePoint Windows classic authentication is used, then set the 
// Login, Password, LoginDomain, and NtlmAuth properties.
http.Login := 'SHAREPOINT_USERNAME';
http.Password := 'SHAREPOINT_PASSWORD';
http.LoginDomain := 'SHAREPOINT_NTLM_DOMAIN';
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

// To create a list, we're going to POST to
// https://SHAREPOINT_HTTPS_DOMAIN/_api/web/lists(guid'{list_guid}')
// with a request body containing the following JSON:
// 
// {
//   "__metadata": {
//     "type": "SP.List"
//   },
//   "Title": "New title"
// }

// In this case, the list_guid is "b0d92cec-4be1-4e52-943d-ebcb432e1c3b"
req := TChilkatHttpRequest.Create(Self);
req.HttpVerb := 'POST';
req.Path := '/_api/web/lists(guid''b0d92cec-4be1-4e52-943d-ebcb432e1c3b'')';

// We need to add a form digest value in the X-RequestDigest header field.
// See this example for details on
// how to get (and cache) a form digest value
req.AddHeader('X-RequestDigest','SHAREPOINT_FORM_DIGEST');

// Set the Content-Type, and indicate that a JSON response is desired.
req.ContentType := 'application/json;odata=verbose';
req.AddHeader('Accept','application/json;odata=verbose');

// Create and add the JSON body.
// Use this online tool to generate code from sample JSON: 
// Generate Code to Create JSON
json := TChilkatJsonObject.Create(Self);
json.UpdateString('__metadata.type','SP.List');
json.UpdateString('Title','New title');

// Send the POST using HTTPS (TLS). Port 443 is the default port for https.
bUseTls := 1;
resp := http.SynchronousRequest('SHAREPOINT_HTTPS_DOMAIN',443,bUseTls,req.ControlInterface);
if (http.LastMethodSuccess <> 1) then
  begin
    Memo1.Lines.Add(http.LastErrorText);
    Exit;
  end;

// The response body contains JSON.
json.Load(resp.BodyStr);
json.EmitCompact := 0;

// The expected success response code is 201.
// (Let's also check for 200, just in case things change..)
if ((resp.StatusCode <> 200) and (resp.StatusCode <> 201)) then
  begin
    Memo1.Lines.Add('Response status code = ' + IntToStr(resp.StatusCode));
    Memo1.Lines.Add(json.Emit());
    Memo1.Lines.Add('Failed');

    Exit;
  end;

// Show the successful JSON response.
Memo1.Lines.Add(json.Emit());
Memo1.Lines.Add('Success.');

// Use this online tool to generate parsing code from sample JSON: 
// Generate Parsing Code from JSON
end;