Chilkat Online Tools

Foxpro / MeiliSearch v0.24 / Add or replace documents

Back to Collection Items

LOCAL loHttp
LOCAL lnSuccess
LOCAL loJarr
LOCAL loJsonObj_1
LOCAL loSbRequestBody
LOCAL loResp

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

loHttp = CreateObject('Chilkat_9_5_0.Http')

* Use this online tool to generate code from sample JSON: Generate Code to Create JSON

* The following JSON is sent in the request body.

* [
*   {
*     "id": 2,
*     "title": "Pride and Prejudice",
*     "author": "Jane Austin",
*     "genre": "romance",
*     "price": 3.5
*   },
*   {
*     "id": 456,
*     "title": "Le Petit Prince",
*     "author": "Antoine de Saint-Exupéry",
*     "genre": "adventure",
*     "price": 10.0
*   },
*   {
*     "id": 1,
*     "title": "Alice In Wonderland",
*     "author": "Lewis Carroll",
*     "genre": "fantasy",
*     "price": 25.99
*   },
*   {
*     "id": 1344,
*     "title": "The Hobbit",
*     "author": "J. R. R. Tolkien",
*     "genre": "fantasy"
*   },
*   {
*     "id": 4,
*     "title": "Harry Potter and the Half-Blood Prince",
*     "author": "J. K. Rowling",
*     "genre": "fantasy"
*   },
*   {
*     "id": 42,
*     "title": "The Hitchhiker's Guide to the Galaxy",
*     "author": "Douglas Adams"
*   }
* ]

loJarr = CreateObject('Chilkat_9_5_0.JsonArray')

loJarr.AddObjectAt(-1)
loJsonObj_1 = loJarr.ObjectAt(loJarr.Size - 1)
loJsonObj_1.UpdateInt("id",2)
loJsonObj_1.UpdateString("title","Pride and Prejudice")
loJsonObj_1.UpdateString("author","Jane Austin")
loJsonObj_1.UpdateString("genre","romance")
loJsonObj_1.UpdateNumber("price","3.5")
RELEASE loJsonObj_1

loJarr.AddObjectAt(-1)
loJsonObj_1 = loJarr.ObjectAt(loJarr.Size - 1)
loJsonObj_1.UpdateInt("id",456)
loJsonObj_1.UpdateString("title","Le Petit Prince")
loJsonObj_1.UpdateString("author","Antoine de Saint-Exupéry")
loJsonObj_1.UpdateString("genre","adventure")
loJsonObj_1.UpdateNumber("price","10.0")
RELEASE loJsonObj_1

loJarr.AddObjectAt(-1)
loJsonObj_1 = loJarr.ObjectAt(loJarr.Size - 1)
loJsonObj_1.UpdateInt("id",1)
loJsonObj_1.UpdateString("title","Alice In Wonderland")
loJsonObj_1.UpdateString("author","Lewis Carroll")
loJsonObj_1.UpdateString("genre","fantasy")
loJsonObj_1.UpdateNumber("price","25.99")
RELEASE loJsonObj_1

loJarr.AddObjectAt(-1)
loJsonObj_1 = loJarr.ObjectAt(loJarr.Size - 1)
loJsonObj_1.UpdateInt("id",1344)
loJsonObj_1.UpdateString("title","The Hobbit")
loJsonObj_1.UpdateString("author","J. R. R. Tolkien")
loJsonObj_1.UpdateString("genre","fantasy")
RELEASE loJsonObj_1

loJarr.AddObjectAt(-1)
loJsonObj_1 = loJarr.ObjectAt(loJarr.Size - 1)
loJsonObj_1.UpdateInt("id",4)
loJsonObj_1.UpdateString("title","Harry Potter and the Half-Blood Prince")
loJsonObj_1.UpdateString("author","J. K. Rowling")
loJsonObj_1.UpdateString("genre","fantasy")
RELEASE loJsonObj_1

loJarr.AddObjectAt(-1)
loJsonObj_1 = loJarr.ObjectAt(loJarr.Size - 1)
loJsonObj_1.UpdateInt("id",42)
loJsonObj_1.UpdateString("title","The Hitchhiker's Guide to the Galaxy")
loJsonObj_1.UpdateString("author","Douglas Adams")
RELEASE loJsonObj_1

loHttp.SetRequestHeader("X-Meili-Api-Key","masterKey")

loSbRequestBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loJarr.EmitSb(loSbRequestBody)

loResp = loHttp.PTextSb("POST","http://localhost:7700/indexes/indexUID/documents",loSbRequestBody,"utf-8","application/json",0,0)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loJarr
    RELEASE loSbRequestBody
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr
RELEASE loResp

RELEASE loHttp
RELEASE loJarr
RELEASE loSbRequestBody

Curl Command

curl -X POST
	-H "X-Meili-Api-Key: masterKey"
	-d '[
  { "id": 2,    "title": "Pride and Prejudice",                    "author": "Jane Austin",              "genre": "romance",    "price": 3.5 },
  { "id": 456,  "title": "Le Petit Prince",                        "author": "Antoine de Saint-Exupéry", "genre": "adventure" , "price": 10.0 },
  { "id": 1,    "title": "Alice In Wonderland",                    "author": "Lewis Carroll",            "genre": "fantasy",    "price": 25.99 },
  { "id": 1344, "title": "The Hobbit",                             "author": "J. R. R. Tolkien",         "genre": "fantasy" },
  { "id": 4,    "title": "Harry Potter and the Half-Blood Prince", "author": "J. K. Rowling",            "genre": "fantasy" },
  { "id": 42,   "title": "The Hitchhiker\'s Guide to the Galaxy",   "author": "Douglas Adams" }
]'
http://localhost:7700/indexes/indexUID/documents

Postman Collection Item JSON

{
  "name": "Add or replace documents",
  "request": {
    "method": "POST",
    "header": [
    ],
    "body": {
      "mode": "raw",
      "raw": "[\n  { \"id\": 2,    \"title\": \"Pride and Prejudice\",                    \"author\": \"Jane Austin\",              \"genre\": \"romance\",    \"price\": 3.5 },\n  { \"id\": 456,  \"title\": \"Le Petit Prince\",                        \"author\": \"Antoine de Saint-Exupéry\", \"genre\": \"adventure\" , \"price\": 10.0 },\n  { \"id\": 1,    \"title\": \"Alice In Wonderland\",                    \"author\": \"Lewis Carroll\",            \"genre\": \"fantasy\",    \"price\": 25.99 },\n  { \"id\": 1344, \"title\": \"The Hobbit\",                             \"author\": \"J. R. R. Tolkien\",         \"genre\": \"fantasy\" },\n  { \"id\": 4,    \"title\": \"Harry Potter and the Half-Blood Prince\", \"author\": \"J. K. Rowling\",            \"genre\": \"fantasy\" },\n  { \"id\": 42,   \"title\": \"The Hitchhiker's Guide to the Galaxy\",   \"author\": \"Douglas Adams\" }\n]",
      "options": {
        "raw": {
          "language": "json"
        }
      }
    },
    "url": {
      "raw": "{{url}}/indexes/{{indexUID}}/documents",
      "host": [
        "{{url}}"
      ],
      "path": [
        "indexes",
        "{{indexUID}}",
        "documents"
      ],
      "query": [
        {
          "key": "primaryKey",
          "value": "id",
          "disabled": true
        }
      ]
    }
  },
  "response": [
  ]
}