(Excel) Firebase PUT - Writing Data

Demonstrates how to PUT new data to a Firebase JSON database. The data used in this example is at Chilkat Firebase Pigs Database, and is shown here:

Download Excel Class Modules Chilkat Excel Class Modules

' Demonstrates how to PUT new data to a Firebase JSON database.

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

' This example assumes a JWT authentication token, if required, has been previously obtained.
' See Get Firebase Access Token from JSON Service Account Private Key for sample code.

' Load the previously obtained Firebase access token into a string.
Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess

accessToken = fac.ReadEntireTextFile("qa_data/tokens/firebaseToken.txt","utf-8")
If (fac.LastMethodSuccess <> True) Then
    Debug.Print fac.LastErrorText
    Exit Sub
End If

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Make the initial connection (without sending a request yet).
' Once connected, any number of requests may be sent.  It is not necessary to explicitly
' call Connect before each request.  

success = rest.Connect("chilkat.firebaseio.com",443,True,True)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim authGoogle As Chilkat.AuthGoogle
Set authGoogle = Chilkat.NewAuthGoogle
authGoogle.AccessToken = accessToken
Dim success As Boolean
success = rest.SetAuthGoogle(authGoogle)

' Chilkat's sample data (pig-rescue data) is publicly readable at: https://chilkat.firebaseio.com/.json
' This data is publicly readable, but not writable.  You'll need to 
' run against your own database..

' Generate a new push ID.
Dim prng As Chilkat.Prng
Set prng = Chilkat.NewPrng

pushId = prng.FirebasePushId()

' We're going to add a new pig with just the name.
Dim pigRecord As Chilkat.JsonObject
Set pigRecord = Chilkat.NewJsonObject
success = pigRecord.AppendString("name","William")

Dim path As Chilkat.StringBuilder
Set path = Chilkat.NewStringBuilder
success = path.Append("/pig-rescue/animal/")
success = path.Append(pushId)
success = path.Append(".json")

' The string content of the last arg passed is  {"name":"William"} 

jsonResponse = rest.FullRequestString("PUT",path.GetAsString(),pigRecord.Emit())
If (rest.LastMethodSuccess <> True) Then
    ' Something happened in the communications (either no request was sent, or no response was received.
    ' (The Chilkat REST API also has lower-level methods where an app can send the request in one call,
    ' and then receive the response in another call.)
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Check the response status code.   A 200 response status indicates success.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print rest.ResponseStatusText
    Debug.Print jsonResponse
    Debug.Print "Failed."
    Exit Sub
End If

Debug.Print jsonResponse
Debug.Print "Success."

' Note: In many of the Chilkat examples, you may notice strange ways
' of doing something that should be simpler and shorter.  For example,
' building the path (above) could've been written differently,
' with some simple string concatenation.
' 
' The reason is that the Chilkat examples are written in a 
' proprietary "example code" scripting language,
' and then automatically generated to each of the different programming
' languages you see on example-code.com.  The code generation is
' limited in what it can do.  For example, string concatentation
' is not yet a feature of the "example code" scripting language (as of May 2016), 
' and therefore you won't see the use of a programming language's string
' concatentation operators in any example.  
'