PowerBuilder / MeiliSearch v0.24 / Add or replace documents
Back to Collection Items
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Jarr
oleobject loo_JsonObj_1
oleobject loo_SbRequestBody
oleobject loo_Resp
// This example assumes the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
destroy loo_Http
MessageBox("Error","Connecting to COM object failed")
return
end if
// 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"
// }
// ]
loo_Jarr = create oleobject
// Use "Chilkat_9_5_0.JsonArray" for versions of Chilkat < 10.0.0
li_rc = loo_Jarr.ConnectToNewObject("Chilkat.JsonArray")
loo_Jarr.AddObjectAt(-1)
loo_JsonObj_1 = loo_Jarr.ObjectAt(loo_Jarr.Size - 1)
loo_JsonObj_1.UpdateInt("id",2)
loo_JsonObj_1.UpdateString("title","Pride and Prejudice")
loo_JsonObj_1.UpdateString("author","Jane Austin")
loo_JsonObj_1.UpdateString("genre","romance")
loo_JsonObj_1.UpdateNumber("price","3.5")
destroy loo_JsonObj_1
loo_Jarr.AddObjectAt(-1)
loo_JsonObj_1 = loo_Jarr.ObjectAt(loo_Jarr.Size - 1)
loo_JsonObj_1.UpdateInt("id",456)
loo_JsonObj_1.UpdateString("title","Le Petit Prince")
loo_JsonObj_1.UpdateString("author","Antoine de Saint-Exupéry")
loo_JsonObj_1.UpdateString("genre","adventure")
loo_JsonObj_1.UpdateNumber("price","10.0")
destroy loo_JsonObj_1
loo_Jarr.AddObjectAt(-1)
loo_JsonObj_1 = loo_Jarr.ObjectAt(loo_Jarr.Size - 1)
loo_JsonObj_1.UpdateInt("id",1)
loo_JsonObj_1.UpdateString("title","Alice In Wonderland")
loo_JsonObj_1.UpdateString("author","Lewis Carroll")
loo_JsonObj_1.UpdateString("genre","fantasy")
loo_JsonObj_1.UpdateNumber("price","25.99")
destroy loo_JsonObj_1
loo_Jarr.AddObjectAt(-1)
loo_JsonObj_1 = loo_Jarr.ObjectAt(loo_Jarr.Size - 1)
loo_JsonObj_1.UpdateInt("id",1344)
loo_JsonObj_1.UpdateString("title","The Hobbit")
loo_JsonObj_1.UpdateString("author","J. R. R. Tolkien")
loo_JsonObj_1.UpdateString("genre","fantasy")
destroy loo_JsonObj_1
loo_Jarr.AddObjectAt(-1)
loo_JsonObj_1 = loo_Jarr.ObjectAt(loo_Jarr.Size - 1)
loo_JsonObj_1.UpdateInt("id",4)
loo_JsonObj_1.UpdateString("title","Harry Potter and the Half-Blood Prince")
loo_JsonObj_1.UpdateString("author","J. K. Rowling")
loo_JsonObj_1.UpdateString("genre","fantasy")
destroy loo_JsonObj_1
loo_Jarr.AddObjectAt(-1)
loo_JsonObj_1 = loo_Jarr.ObjectAt(loo_Jarr.Size - 1)
loo_JsonObj_1.UpdateInt("id",42)
loo_JsonObj_1.UpdateString("title","The Hitchhiker's Guide to the Galaxy")
loo_JsonObj_1.UpdateString("author","Douglas Adams")
destroy loo_JsonObj_1
loo_Http.SetRequestHeader("X-Meili-Api-Key","masterKey")
loo_SbRequestBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbRequestBody.ConnectToNewObject("Chilkat.StringBuilder")
loo_Jarr.EmitSb(loo_SbRequestBody)
loo_Resp = loo_Http.PTextSb("POST","http://localhost:7700/indexes/indexUID/documents",loo_SbRequestBody,"utf-8","application/json",0,0)
if loo_Http.LastMethodSuccess = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_Jarr
destroy loo_SbRequestBody
return
end if
Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp
destroy loo_Http
destroy loo_Jarr
destroy loo_SbRequestBody
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": [
]
}
