(VBScript) 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

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

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

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Http")
set http = CreateObject("Chilkat.Http")

' 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:

query = "{ shop { id name description email } }"

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

' resp is a Chilkat.HttpResponse
Set resp = http.PText("POST",url,query,"utf-8","application/graphql",0,0)
If (http.LastMethodSuccess <> 1) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

' Examine the response code.
If (resp.StatusCode <> 200) Then
    outFile.WriteLine("Received error response code: " & resp.StatusCode)
    outFile.WriteLine("Response body:")
    outFile.WriteLine(resp.BodyStr)

    WScript.Quit
End If

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.StringBuilder")
set sbResponseBody = CreateObject("Chilkat.StringBuilder")
success = resp.GetBodySb(sbResponseBody)
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.JsonObject")
set jResp = CreateObject("Chilkat.JsonObject")
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0

outFile.WriteLine("Response Body:")
outFile.WriteLine(jResp.Emit())

respStatusCode = resp.StatusCode
outFile.WriteLine("Response Status Code = " & respStatusCode)
If (respStatusCode >= 400) Then
    outFile.WriteLine("Response Header:")
    outFile.WriteLine(resp.Header)
    outFile.WriteLine("Failed.")

    WScript.Quit
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

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

outFile.WriteLine("Shop name: " & shopName)
' ...

outFile.Close