VBScript

Faire - Get All Products

See more Faire Examples

Retrieves a list of products, ordered ascending by updated_at. By default, it only returns non-deleted products. 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 assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

set http = CreateObject("Chilkat.Http")

' Implements the following CURL command:

' curl -X GET -H "X-FAIRE-ACCESS-TOKEN: <access_token>" -d "limit=50" -d "page=1" https://www.faire.com/api/v1/products

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

set queryParams = CreateObject("Chilkat.JsonObject")
success = queryParams.UpdateInt("limit",50)
success = queryParams.UpdateInt("page",1)

http.SetRequestHeader "X-FAIRE-ACCESS-TOKEN","<access_token>"

set resp = CreateObject("Chilkat.HttpResponse")
success = http.HttpParams("GET","https://www.faire.com/api/v1/products",queryParams,resp)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    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)

' {
'   "page": 1,
'   "limit": 50,
'   "products": [
'     {
'       "id": "p_123",
'       "brand_id": "b_abc",
'       "short_description": "Our candles smell fantastic. Want to know how good? Read our description!",
'       "description": "Glad you decided to read our description! We have significantly more characters to describe to you just how good our candles smell.",
'       "wholesale_price_cents": 500,
'       "retail_price_cents": 1000,
'       "sale_state": "FOR_SALE",
'       "active": true,
'       "deleted": false,
'       "name": "Faire's fantastic candle",
'       "unit_multiplier": 8,
'       "taxonomy_type": {
'         "id": "tt_23nl3bzl00",
'         "name": "Votive Candle"
'       },
'       "options": [
'       ],
'       "created_at": "20190314T000915.000Z",
'       "updated_at": "20190315T000915.000Z"
'     }
'   ]
' }

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

page = jResp.IntOf("page")
limit = jResp.IntOf("limit")
i = 0
count_i = jResp.SizeOfArray("products")
Do While i < count_i
    jResp.I = i
    id = jResp.StringOf("products[i].id")
    brand_id = jResp.StringOf("products[i].brand_id")
    short_description = jResp.StringOf("products[i].short_description")
    description = jResp.StringOf("products[i].description")
    wholesale_price_cents = jResp.IntOf("products[i].wholesale_price_cents")
    retail_price_cents = jResp.IntOf("products[i].retail_price_cents")
    sale_state = jResp.StringOf("products[i].sale_state")
    active = jResp.BoolOf("products[i].active")
    deleted = jResp.BoolOf("products[i].deleted")
    name = jResp.StringOf("products[i].name")
    unit_multiplier = jResp.IntOf("products[i].unit_multiplier")
    taxonomy_typeId = jResp.StringOf("products[i].taxonomy_type.id")
    taxonomy_typeName = jResp.StringOf("products[i].taxonomy_type.name")
    created_at = jResp.StringOf("products[i].created_at")
    updated_at = jResp.StringOf("products[i].updated_at")
    j = 0
    count_j = jResp.SizeOfArray("products[i].options")
    Do While j < count_j
        jResp.J = j
        j = j + 1
    Loop
    i = i + 1
Loop

outFile.Close