(Excel) Shopify Private Authentication for Private Apps

Shopify private authentication is for interacting with your own store through private applications. It uses HTTP "Basic" authentication with your Shopify private application key and secret key.

This example demonstrates how to send a private authenticated request using Chilkat Http, and then the same using Chilkat Rest.

Download Excel Class Modules Chilkat Excel Class Modules

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

' First demonstrate sending a simple request using Shopify private authentication w/ the Chilkat Http API.
Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' To use HTTP Basic Authentication with any HTTP request, we simply set the Login, Password, and BasicAuth properties.
' Important: All HTTP requests using Basic authentication must be over SSL/TLS.
http.Login = "SHOPIFY_PRIVATE_API_KEY"
http.Password = "SHOPIFY_PRIVATE_API_SECRET_KEY"
http.BasicAuth = True

' Make sure to replace "chilkat" with your store name.

Set resp = http.QuickGetObj("https://chilkat.myshopify.com/admin/products.json")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

' Examine the response code.
If (resp.StatusCode <> 200) Then
    Debug.Print "Received error response code: "; resp.StatusCode
    Debug.Print "Response body:"
    Debug.Print resp.BodyStr

    Exit Sub
End If

' Success.
Debug.Print "Success."

' Examine the JSON response 
Dim sbJson As Chilkat.StringBuilder
Set sbJson = Chilkat.NewStringBuilder
Dim success As Boolean
success = resp.GetBodySb(sbJson)

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.LoadSb(sbJson)
json.EmitCompact = False
Debug.Print json.Emit()

' -------------------------------------------------
' Now let's do the same using the Chilkat Rest API.
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Provide the private app credentials:
success = rest.SetAuthBasic("SHOPIFY_PRIVATE_API_KEY","SHOPIFY_PRIVATE_API_SECRET_KEY")

' Connect to the shopify server.

bTls = True

port = 443

bAutoReconnect = True
' Make sure to replace "chilkat" with your store name.

success = rest.Connect("chilkat.myshopify.com",port,bTls,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

sbJson.Clear 
success = rest.FullRequestNoBodySb("GET","/admin/products.json",sbJson)
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "Received error response code: "; rest.ResponseStatusCode
    Debug.Print "Response body:"
    Debug.Print sbJson.GetAsString()
    Exit Sub
End If

' Success...
success = json.LoadSb(sbJson)
Debug.Print json.Emit()