(Excel) Akeneo: Create New Family

Demonstrates how to create a new family.

Download Excel Class Modules Chilkat Excel Class Modules

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

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

' Use your previously obtained access token.
' See Get Akeneo Access Token
http.AuthToken = "access_token"

' Build the following JSON to be sent in the request body:
' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON

' {
'   "code": "caps",
'   "attributes": [
'     "sku",
'     "name",
'     "description",
'     "price",
'     "color",
'     "picture"
'   ],
'   "attribute_as_label": "name",
'   "attribute_as_image": "picture",
'   "attribute_requirements": {
'     "ecommerce": [
'       "sku",
'       "name",
'       "description",
'       "price",
'       "color"
'     ],
'     "tablet": [
'       "sku",
'       "name",
'       "description",
'       "price"
'     ]
'   },
'   "labels": {
'     "en_US": "Caps",
'     "fr_FR": "Casquettes"
'   }
' }
' 
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.UpdateString("code","caps")
success = json.UpdateString("attributes[0]","sku")
success = json.UpdateString("attributes[1]","name")
success = json.UpdateString("attributes[2]","description")
success = json.UpdateString("attributes[3]","price")
success = json.UpdateString("attributes[4]","color")
success = json.UpdateString("attributes[5]","picture")
success = json.UpdateString("attribute_as_label","name")
success = json.UpdateString("attribute_as_image","picture")
success = json.UpdateString("attribute_requirements.ecommerce[0]","sku")
success = json.UpdateString("attribute_requirements.ecommerce[1]","name")
success = json.UpdateString("attribute_requirements.ecommerce[2]","description")
success = json.UpdateString("attribute_requirements.ecommerce[3]","price")
success = json.UpdateString("attribute_requirements.ecommerce[4]","color")
success = json.UpdateString("attribute_requirements.tablet[0]","sku")
success = json.UpdateString("attribute_requirements.tablet[1]","name")
success = json.UpdateString("attribute_requirements.tablet[2]","description")
success = json.UpdateString("attribute_requirements.tablet[3]","price")
success = json.UpdateString("labels.en_US","Caps")
success = json.UpdateString("labels.fr_FR","Casquettes")

json.EmitCompact = False
' Show the JSON to be sent..
Debug.Print json.Emit()


url = "http://pim.my-akeneo-site.com/api/rest/v1/families"

Set resp = http.PostJson3(url,"application/json",json)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: "; resp.StatusCode
Debug.Print "Response Body: "
Debug.Print resp.BodyStr