(Visual Basic 6.0) Shopify GraphQL Simple Query (Get Shop Object)

See more Shopify Examples

Demonstrates a simple Shopify GraphQL query to get specific fields of the Shop object.

For more information, see https://www.shopify.com/partners/blog/shopify-graphql-learning-kit#query-structure

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

Dim http As New ChilkatHttp

' This example will use private authentication (which is HTTP Basic authentication)
' See the other Chilkat Shopify examples for OAuth2 authentication.
' 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 = 1

' We're going to do a POST  https://{shop}.myshopify.com/admin/api/2021-04/graphql.json
' Make sure to replace "chilkat" with your store name.

' The body of the request will be:
'    {
'        shop {
'            id
'            name
'            description
'            email
'         }
'     }

' The above query is not JSON.  It looks like JSON, but it's actually not.
' We'll just make it one line:

Dim query As String
query = "{ shop { id name description email } }"

' My store name is "chilkat".  Use your store name here instead.
Dim url As String
url = "https://chilkat.myshopify.com/admin/api/2021-04/graphql.json"

Dim resp As ChilkatHttpResponse
Set resp = http.PText("POST",url,query,"utf-8","application/graphql",0,0)
If (http.LastMethodSuccess <> 1) 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

Dim sbResponseBody As New ChilkatStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

Debug.Print "Response Body:"
Debug.Print jResp.Emit()

Dim respStatusCode As Long
respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
    Debug.Print "Response Header:"
    Debug.Print resp.Header
    Debug.Print "Failed."

    Exit Sub
End If

' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)

' {
'   "data": {
'     "shop": {
'       "id": "gid:\/\/shopify\/Shop\/24198053",
'       "name": "chilkat",
'       "description": null,
'       "email": "admin@chilkatsoft.com"
'     }
'   },
'   "extensions": {
'     "cost": {
'       "requestedQueryCost": 1,
'       "actualQueryCost": 1,
'       "throttleStatus": {
'         "maximumAvailable": 1000.0,
'         "currentlyAvailable": 999,
'         "restoreRate": 50.0
'       }
'     }
'   }
' }

' Sample code for parsing the JSON response...
' Use the following online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON

Dim shopId As String
shopId = jResp.StringOf("data.shop.id")
Dim shopName As String
shopName = jResp.StringOf("data.shop.name")
Dim shopDescription As String
shopDescription = jResp.StringOf("data.shop.description")
Dim shopEmail As String
shopEmail = jResp.StringOf("data.shop.email")
Dim costRequestedQueryCost As Long
costRequestedQueryCost = jResp.IntOf("extensions.cost.requestedQueryCost")
Dim costActualQueryCost As Long
costActualQueryCost = jResp.IntOf("extensions.cost.actualQueryCost")
Dim costThrottleStatusMaximumAvailable As String
costThrottleStatusMaximumAvailable = jResp.StringOf("extensions.cost.throttleStatus.maximumAvailable")
Dim costThrottleStatusCurrentlyAvailable As Long
costThrottleStatusCurrentlyAvailable = jResp.IntOf("extensions.cost.throttleStatus.currentlyAvailable")
Dim costThrottleStatusRestoreRate As String
costThrottleStatusRestoreRate = jResp.StringOf("extensions.cost.throttleStatus.restoreRate")

Debug.Print "Shop name: " & shopName
' ...