Pascal (Lazarus/Delphi)

Azure Table Insert Entity

See more Azure Table Service Examples

Insert an entity into an Azure table. Pascal (Lazarus/Delphi)

program ChilkatDemo;

// Demonstrates using the Chilkat Pascal wrapper via the C bridge DLL.
// Builds as a console application under Lazarus (FPC) or Delphi.

{$IFDEF FPC}
  {$MODE DELPHI}
{$ENDIF}
{$APPTYPE CONSOLE}

uses
  {$IFDEF UNIX}
  cthreads,
  {$ENDIF}
  SysUtils,
  CkDllLoader,
  Chilkat.StringBuilder,
  Chilkat.Rest,
  Chilkat.AuthAzureStorage,
  Chilkat.JsonObject;

// ---------------------------------------------------------------------------

procedure RunDemo;
var
  success: Boolean;
  rest: TRest;
  bTls: Boolean;
  port: Integer;
  bAutoReconnect: Boolean;
  azAuth: TAuthAzureStorage;
  json: TJsonObject;
  sbRequestBody: TStringBuilder;
  sbResponseBody: TStringBuilder;
  respStatusCode: Integer;

begin
  success := False;

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

  rest := TRest.Create;

  //  IMPORTANT: Make sure to change "myaccount" to your actual Azure Storage Account name.
  //  IMPORTANT: Also change "mytable" to the name of your Azure table.
  //  We're going to POST to this URL:  https://myaccount.table.core.windows.net/mytable
  bTls := True;
  port := 443;
  bAutoReconnect := True;
  success := rest.Connect('myaccount.table.core.windows.net',port,bTls,bAutoReconnect);
  if (success <> True) then
    begin
      WriteLn('ConnectFailReason: ' + rest.ConnectFailReason);
      WriteLn(rest.LastErrorText);
      Exit;
    end;

  //  Provide Azure Cloud credentials for the REST call.
  azAuth := TAuthAzureStorage.Create;
  azAuth.AccessKey := 'AZURE_ACCESS_KEY';
  //  The account name used here should match the 1st part of the domain passed in the call to Connect (above).
  azAuth.Account := 'myaccount';
  azAuth.Scheme := 'SharedKey';
  azAuth.Service := 'Table';

  //  This causes the "x-ms-version: 2019-07-07" header to be automatically added.
  azAuth.XMsVersion := '2019-07-07';
  success := rest.SetAuthAzureStorage(azAuth);

  //  Note: The application does not need to explicitly set the following
  //  headers: Content-Length, x-ms-date, Authorization.  These headers
  //  are automatically set by Chilkat.

  //  Note: The above code does not need to be repeatedly called for each REST request.
  //  The rest object can be setup once, and then many requests can be sent.  Chilkat will automatically
  //  reconnect within a FullRequest* method as needed.  It is only the very first connection that is explicitly
  //  made via the Connect method.

  //  Use this online tool to generate code from sample JSON:
  //  Generate Code to Create JSON

  //  The following JSON is sent in the request body.

  //  {  
  //     "PartitionKey":"mypartitionkey",  
  //     "RowKey":"myrowkey",  
  //     "Timestamp":"2013-08-22T01:12:06.2608595Z",  
  //     "Address":"Mountain View",  
  //     "Age":23,  
  //     "AmountDue":200.23,  
  //     "CustomerCode":"c9da6455-213d-42c9-9a79-3e9149a57833",  
  //     "CustomerSince":"2008-07-10T00:00:00",  
  //     "IsActive":true,  
  //     "NumberOfOrders":"255"  
  //  }  

  json := TJsonObject.Create;
  json.UpdateString('PartitionKey','mypartitionkey');
  json.UpdateString('RowKey','myrowkey');
  json.UpdateString('Timestamp','2013-08-22T01:12:06.2608595Z');
  json.UpdateString('Address','Mountain View');
  json.UpdateInt('Age',23);
  json.UpdateNumber('AmountDue','200.23');
  json.UpdateString('CustomerCode','c9da6455-213d-42c9-9a79-3e9149a57833');
  json.UpdateString('CustomerSince','2008-07-10T00:00:00');
  json.UpdateBool('IsActive',True);
  json.UpdateString('NumberOfOrders','255');

  //  IMPORTANT: Pay attention to the options for nometadata, minimalmetadata, or fullmetadata.
  //  See the Azure table service API documentation at https://docs.microsoft.com/en-us/rest/api/storageservices/insert-entity
  rest.AddHeader('Accept','application/json;odata=nometadata');
  rest.AddHeader('Prefer','return-no-content');
  rest.AddHeader('Content-Type','application/json');

  sbRequestBody := TStringBuilder.Create;
  json.EmitSb(sbRequestBody);
  sbResponseBody := TStringBuilder.Create;
  //  IMPORTANT: Change "mytable" to the name of your actual table.
  success := rest.FullRequestSb('POST','/mytable',sbRequestBody,sbResponseBody);
  if (success <> True) then
    begin
      WriteLn(rest.LastErrorText);
      Exit;
    end;

  //  A status code of 204 is a success response for the case where Prefer=return-no-content.
  respStatusCode := rest.ResponseStatusCode;
  WriteLn('Response Status Code = ' + respStatusCode);
  if (respStatusCode >= 400) then
    begin
      WriteLn('Response Header:');
      WriteLn(rest.ResponseHeader);
      WriteLn('Response Body:');
      WriteLn(sbResponseBody.GetAsString());
      Exit;
    end;

  WriteLn('Success.');


  rest.Free;
  azAuth.Free;
  json.Free;
  sbRequestBody.Free;
  sbResponseBody.Free;

end;

// ---------------------------------------------------------------------------

begin

  try
    RunDemo;
  except
    on E: Exception do
      WriteLn('Unhandled exception: ', E.ClassName, ': ', E.Message);
  end;

  WriteLn;
  {$IFDEF MSWINDOWS}
  WriteLn('Press Enter to exit...');
  ReadLn;
  {$ENDIF}
end.