(Excel) 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.

For more information, see https://faire.github.io/external-api-docs/#get-all-products

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

' 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

Dim queryParams As Chilkat.JsonObject
Set queryParams = Chilkat.NewJsonObject
Dim success As Boolean
success = queryParams.UpdateInt("limit",50)
success = queryParams.UpdateInt("page",1)

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


Set resp = http.QuickRequestParams("GET","https://www.faire.com/api/v1/products",queryParams)
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = resp.GetBodySb(sbResponseBody)

Dim jResp As Chilkat.JsonObject
Set jResp = Chilkat.NewJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = False

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


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)

' {
'   "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