Xbase++

DynamoDB - PutItem

See more Amazon DynamoDB Examples

Creates a new item, or replaces an old item with a new item. If an item that has the same primary key as the new item already exists in the specified table, the new item completely replaces the existing item. Xbase++

LOCAL nSuccess
LOCAL oRest
LOCAL oAuthAws
LOCAL nBTls
LOCAL nPort
LOCAL nBAutoReconnect
LOCAL oJson
LOCAL oSbRequestBody
LOCAL oSbResponseBody
LOCAL nRespStatusCode
LOCAL oJsonResponse

nSuccess := 0

oRest := CreateObject("Chilkat.Rest")

//  Implements the following CURL command:

//  curl -X POST https://dynamodb.us-west-2.amazonaws.com/ \
//    -H "Accept-Encoding: identity" \
//    -H "Content-Type: application/x-amz-json-1.0" \
//    -H "Authorization: AWS4-HMAC-SHA256 Credential=<Credential>, SignedHeaders=<Headers>, Signature=<Signature>" \
//    -H "X-Amz-Date: <Date>" \
//    -H "X-Amz-Target: DynamoDB_20120810.PutItem" \
//    -d '{
//      "TableName": "Thread",
//      "Item": {
//          "LastPostDateTime": {
//              "S": "201303190422"
//          },
//          "Tags": {
//              "SS": ["Update","Multiple Items","HelpMe"]
//          },
//          "ForumName": {
//              "S": "Amazon DynamoDB"
//          },
//          "Message": {
//              "S": "I want to update multiple items in a single call. What is the best way to do that?"
//          },
//          "Subject": {
//              "S": "How do I update multiple items?"
//          },
//          "LastPostedBy": {
//              "S": "fred@example.com"
//          }
//      },
//      "ConditionExpression": "ForumName <> :f and Subject <> :s",
//      "ExpressionAttributeValues": {
//          ":f": {"S": "Amazon DynamoDB"},
//          ":s": {"S": "How do I update multiple items?"}
//      }
//  }'

//  Use the following online tool to generate REST code from a CURL command
//  Convert a cURL Command to REST Source Code

oAuthAws := CreateObject("Chilkat.AuthAws")
oAuthAws:AccessKey := "AWS_ACCESS_KEY"
oAuthAws:SecretKey := "AWS_SECRET_KEY"
//  Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
oAuthAws:Region := "us-west-2"
oAuthAws:ServiceName := "dynamodb"
//  SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
oRest:SetAuthAws(oAuthAws)

//  URL: https://dynamodb.us-west-2.amazonaws.com/
nBTls := 1
nPort := 443
nBAutoReconnect := 1
nSuccess := oRest:Connect("dynamodb.us-west-2.amazonaws.com", nPort, nBTls, nBAutoReconnect)
IF (nSuccess != 1)
    ? "ConnectFailReason: " + Str(oRest:ConnectFailReason)
    ? oRest:LastErrorText
    oRest:destroy()
    oAuthAws:destroy()
    RETURN
ENDIF

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

//  {
//    "TableName": "Thread",
//    "Item": {
//      "LastPostDateTime": {
//        "S": "201303190422"
//      },
//      "Tags": {
//        "SS": [
//          "Update",
//          "Multiple Items",
//          "HelpMe"
//        ]
//      },
//      "ForumName": {
//        "S": "Amazon DynamoDB"
//      },
//      "Message": {
//        "S": "I want to update multiple items in a single call. What is the best way to do that?"
//      },
//      "Subject": {
//        "S": "How do I update multiple items?"
//      },
//      "LastPostedBy": {
//        "S": "fred@example.com"
//      }
//    },
//    "ConditionExpression": "ForumName <> :f and Subject <> :s",
//    "ExpressionAttributeValues": {
//      ":f": {
//        "S": "Amazon DynamoDB"
//      },
//      ":s": {
//        "S": "How do I update multiple items?"
//      }
//    }
//  }

oJson := CreateObject("Chilkat.JsonObject")
oJson:UpdateString("TableName", "Thread")
oJson:UpdateString("Item.LastPostDateTime.S", "201303190422")
oJson:UpdateString("Item.Tags.SS[0]", "Update")
oJson:UpdateString("Item.Tags.SS[1]", "Multiple Items")
oJson:UpdateString("Item.Tags.SS[2]", "HelpMe")
oJson:UpdateString("Item.ForumName.S", "Amazon DynamoDB")
oJson:UpdateString("Item.Message.S", "I want to update multiple items in a single call. What is the best way to do that?")
oJson:UpdateString("Item.Subject.S", "How do I update multiple items?")
oJson:UpdateString("Item.LastPostedBy.S", "fred@example.com")
oJson:UpdateString("ConditionExpression", "ForumName <> :f and Subject <> :s")
oJson:UpdateString("ExpressionAttributeValues.:f.S", "Amazon DynamoDB")
oJson:UpdateString("ExpressionAttributeValues.:s.S", "How do I update multiple items?")

oRest:AddHeader("Content-Type", "application/x-amz-json-1.0")
oRest:AddHeader("X-Amz-Target", "DynamoDB_20120810.PutItem")
oRest:AddHeader("Accept-Encoding", "identity")

oSbRequestBody := CreateObject("Chilkat.StringBuilder")
oJson:EmitSb(oSbRequestBody)
oSbResponseBody := CreateObject("Chilkat.StringBuilder")
nSuccess := oRest:FullRequestSb("POST", "/", oSbRequestBody, oSbResponseBody)
IF (nSuccess != 1)
    ? oRest:LastErrorText
    oRest:destroy()
    oAuthAws:destroy()
    oJson:destroy()
    oSbRequestBody:destroy()
    oSbResponseBody:destroy()
    RETURN
ENDIF

nRespStatusCode := oRest:ResponseStatusCode
? "response status code = " + Str(nRespStatusCode)
IF (nRespStatusCode >= 400)
    ? "Response Status Code = " + Str(nRespStatusCode)
    ? "Response Header:"
    ? oRest:ResponseHeader
    ? "Response Body:"
    ? oSbResponseBody:GetAsString()
    oRest:destroy()
    oAuthAws:destroy()
    oJson:destroy()
    oSbRequestBody:destroy()
    oSbResponseBody:destroy()
    RETURN
ENDIF

oJsonResponse := CreateObject("Chilkat.JsonObject")
oJsonResponse:LoadSb(oSbResponseBody)

oJsonResponse:EmitCompact := 0
? oJsonResponse:Emit()

oRest:destroy()
oAuthAws:destroy()
oJson:destroy()
oSbRequestBody:destroy()
oSbResponseBody:destroy()
oJsonResponse:destroy()