PureBasic

Azure Table Insert Entity

See more Azure Table Service Examples

Insert an entity into an Azure table. PureBasic

IncludeFile "CkStringBuilder.pb"
IncludeFile "CkRest.pb"
IncludeFile "CkAuthAzureStorage.pb"
IncludeFile "CkJsonObject.pb"

Procedure ChilkatExample()

    success.i = 0

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

    rest.i = CkRest::ckCreate()
    If rest.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    ; 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.i = 1
    port.i = 443
    bAutoReconnect.i = 1
    success = CkRest::ckConnect(rest,"myaccount.table.core.windows.net",port,bTls,bAutoReconnect)
    If success <> 1
        Debug "ConnectFailReason: " + Str(CkRest::ckConnectFailReason(rest))
        Debug CkRest::ckLastErrorText(rest)
        CkRest::ckDispose(rest)
        ProcedureReturn
    EndIf

    ; Provide Azure Cloud credentials for the REST call.
    azAuth.i = CkAuthAzureStorage::ckCreate()
    If azAuth.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkAuthAzureStorage::setCkAccessKey(azAuth, "AZURE_ACCESS_KEY")
    ; The account name used here should match the 1st part of the domain passed in the call to Connect (above).
    CkAuthAzureStorage::setCkAccount(azAuth, "myaccount")
    CkAuthAzureStorage::setCkScheme(azAuth, "SharedKey")
    CkAuthAzureStorage::setCkService(azAuth, "Table")

    ; This causes the "x-ms-version: 2019-07-07" header to be automatically added.
    CkAuthAzureStorage::setCkXMsVersion(azAuth, "2019-07-07")
    success = CkRest::ckSetAuthAzureStorage(rest,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.i = CkJsonObject::ckCreate()
    If json.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckUpdateString(json,"PartitionKey","mypartitionkey")
    CkJsonObject::ckUpdateString(json,"RowKey","myrowkey")
    CkJsonObject::ckUpdateString(json,"Timestamp","2013-08-22T01:12:06.2608595Z")
    CkJsonObject::ckUpdateString(json,"Address","Mountain View")
    CkJsonObject::ckUpdateInt(json,"Age",23)
    CkJsonObject::ckUpdateNumber(json,"AmountDue","200.23")
    CkJsonObject::ckUpdateString(json,"CustomerCode","c9da6455-213d-42c9-9a79-3e9149a57833")
    CkJsonObject::ckUpdateString(json,"CustomerSince","2008-07-10T00:00:00")
    CkJsonObject::ckUpdateBool(json,"IsActive",1)
    CkJsonObject::ckUpdateString(json,"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
    CkRest::ckAddHeader(rest,"Accept","application/json;odata=nometadata")
    CkRest::ckAddHeader(rest,"Prefer","return-no-content")
    CkRest::ckAddHeader(rest,"Content-Type","application/json")

    sbRequestBody.i = CkStringBuilder::ckCreate()
    If sbRequestBody.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckEmitSb(json,sbRequestBody)
    sbResponseBody.i = CkStringBuilder::ckCreate()
    If sbResponseBody.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    ; IMPORTANT: Change "mytable" to the name of your actual table.
    success = CkRest::ckFullRequestSb(rest,"POST","/mytable",sbRequestBody,sbResponseBody)
    If success <> 1
        Debug CkRest::ckLastErrorText(rest)
        CkRest::ckDispose(rest)
        CkAuthAzureStorage::ckDispose(azAuth)
        CkJsonObject::ckDispose(json)
        CkStringBuilder::ckDispose(sbRequestBody)
        CkStringBuilder::ckDispose(sbResponseBody)
        ProcedureReturn
    EndIf

    ; A status code of 204 is a success response for the case where Prefer=return-no-content.
    respStatusCode.i = CkRest::ckResponseStatusCode(rest)
    Debug "Response Status Code = " + Str(respStatusCode)
    If respStatusCode >= 400
        Debug "Response Header:"
        Debug CkRest::ckResponseHeader(rest)
        Debug "Response Body:"
        Debug CkStringBuilder::ckGetAsString(sbResponseBody)
        CkRest::ckDispose(rest)
        CkAuthAzureStorage::ckDispose(azAuth)
        CkJsonObject::ckDispose(json)
        CkStringBuilder::ckDispose(sbRequestBody)
        CkStringBuilder::ckDispose(sbResponseBody)
        ProcedureReturn
    EndIf

    Debug "Success."


    CkRest::ckDispose(rest)
    CkAuthAzureStorage::ckDispose(azAuth)
    CkJsonObject::ckDispose(json)
    CkStringBuilder::ckDispose(sbRequestBody)
    CkStringBuilder::ckDispose(sbResponseBody)


    ProcedureReturn
EndProcedure