Visual FoxPro

Firebase GET - Reading Data

See more Firebase Examples

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

Visual FoxPro

LOCAL lnSuccess
LOCAL loFac
LOCAL lcAccessToken
LOCAL loRest
LOCAL loAuthGoogle
LOCAL lcJsonResponse
LOCAL loPiggyPath
LOCAL loShallow
LOCAL loPiggyData
LOCAL lnCount
LOCAL i
LOCAL lcPiggyJson

lnSuccess = 0

*  Demonstrates how to read parts of 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.
loFac = CreateObject('Chilkat.FileAccess')
lcAccessToken = loFac.ReadEntireTextFile("qa_data/tokens/firebaseToken.txt","utf-8")
IF (loFac.LastMethodSuccess <> 1) THEN
    ? loFac.LastErrorText
    RELEASE loFac
    CANCEL
ENDIF

loRest = CreateObject('Chilkat.Rest')

*  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.  
lnSuccess = loRest.Connect("chilkat.firebaseio.com",443,1,1)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loFac
    RELEASE loRest
    CANCEL
ENDIF

*  If authentication is required...
loAuthGoogle = CreateObject('Chilkat.AuthGoogle')
loAuthGoogle.AccessToken = lcAccessToken
loRest.SetAuthGoogle(loAuthGoogle)

*  Chilkat's sample data (pig-rescue data) is publicly readable at: https://chilkat.firebaseio.com/.json

*  Let's get the animals with the shallow parameter so we can see how many pigs exist.
lcJsonResponse = loRest.FullRequestNoBody("GET","/pig-rescue/animal.json?shallow=true")
IF (loRest.LastMethodSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loFac
    RELEASE loRest
    RELEASE loAuthGoogle
    CANCEL
ENDIF

*  The JSON returned should look like this:  
*  {"-KI3bD-FU_Dake7sYOiP":true,"-KI3bD-FU_Dake7sYOiT":true,"-KI3bD-FU_Dake7sYOiS":true,"-KI3bD-FU_Dake7sYOiU":true,"-KI3bD-FU_Dake7sYOiV":true,"-KI3bD-FU_Dake7sYOiR":true,"-KI3bD-FU_Dake7sYOiQ":true}
? lcJsonResponse

*  Parse the response so we can iterate over each pig in the database..
loPiggyPath = CreateObject('Chilkat.StringBuilder')
loShallow = CreateObject('Chilkat.JsonObject')
loPiggyData = CreateObject('Chilkat.JsonObject')
loShallow.Load(lcJsonResponse)
lnCount = loShallow.Size
i = 0
DO WHILE i < lnCount

    *  Get each individual pig's data.
    loPiggyPath.Clear()
    loPiggyPath.Append("/pig-rescue/animal/")
    loPiggyPath.Append(loShallow.NameAt(i))
    loPiggyPath.Append("/.json")

    lcPiggyJson = loRest.FullRequestNoBody("GET",loPiggyPath.GetAsString())
    IF (loRest.LastMethodSuccess <> 1) THEN
        ? loRest.LastErrorText
        RELEASE loFac
        RELEASE loRest
        RELEASE loAuthGoogle
        RELEASE loPiggyPath
        RELEASE loShallow
        RELEASE loPiggyData
        CANCEL
    ENDIF

    *  Show this piggy's data...
    *  An example of one pig's data is shown here:
    *  {"birth":"February, 1998","from":"Middle Ave.","gender":"F","in-date":"January, 2000",
    *    "name":"Molly II","picture":{"caption":"Molly in the Pasture","description":"Black pig","file":"molly_th.jpg"},
    *    "species":"pot belly pig","type":"Cathy's Herd"}
    ? "---- " + STR(i) + " ----"
    ? lcPiggyJson

    *  Let's get the pig's name, and the caption of the picture.
    loPiggyData.Load(lcPiggyJson)
    ? "name: " + loPiggyData.StringOf("name")
    ? "caption: " + loPiggyData.StringOf("picture.caption")

    i = i + 1
ENDDO

*  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 piggyPath (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.  
*

RELEASE loFac
RELEASE loRest
RELEASE loAuthGoogle
RELEASE loPiggyPath
RELEASE loShallow
RELEASE loPiggyData