VBScript Requires Chilkat v11.0.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. VBScript

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

success = 0

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

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"

set resp = CreateObject("Chilkat.HttpResponse")
success = http.HttpStr("POST",url,query,"utf-8","application/graphql",resp)
If (success = 0) 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

set sbResponseBody = CreateObject("Chilkat.StringBuilder")
success = resp.GetBodySb(sbResponseBody)
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