PowerBuilder / MongoDB Atlas / Create an Online Archive
Back to Collection Items
integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_Json
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
loo_Http.DigestAuth = 1
loo_Http.Login = "username"
loo_Http.Password = "password"
// Use this online tool to generate code from sample JSON: Generate Code to Create JSON
// The following JSON is sent in the request body.
// {
// "dbName": "people",
// "collName": "employees",
// "partitionFields": [
// {
// "fieldName": "firstName",
// "order": 0
// },
// {
// "fieldName": "lastName",
// "order": 1
// }
// ],
// "criteria": {
// "type": "DATE",
// "dateField": "created",
// "dateFormat": "ISODATE",
// "expireAfterDays": 5
// }
// }
loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")
loo_Json.UpdateString("dbName","people")
loo_Json.UpdateString("collName","employees")
loo_Json.UpdateString("partitionFields[0].fieldName","firstName")
loo_Json.UpdateInt("partitionFields[0].order",0)
loo_Json.UpdateString("partitionFields[1].fieldName","lastName")
loo_Json.UpdateInt("partitionFields[1].order",1)
loo_Json.UpdateString("criteria.type","DATE")
loo_Json.UpdateString("criteria.dateField","created")
loo_Json.UpdateString("criteria.dateFormat","ISODATE")
loo_Json.UpdateInt("criteria.expireAfterDays",5)
loo_Resp = loo_Http.PostJson3("https://domain.com/api/atlas/{{version}}/groups/{{ProjectID}}/clusters/{{CLUSTER-NAME}}/onlineArchives","application/json",loo_Json)
if loo_Http.LastMethodSuccess = 0 then
Write-Debug loo_Http.LastErrorText
destroy loo_Http
destroy loo_Json
return
end if
Write-Debug string(loo_Resp.StatusCode)
Write-Debug loo_Resp.BodyStr
destroy loo_Resp
destroy loo_Http
destroy loo_Json
Curl Command
curl -X POST
--digest -u 'username:password'
-d '{
"dbName": "people",
"collName": "employees",
"partitionFields": [
{
"fieldName": "firstName",
"order": 0
},
{
"fieldName": "lastName",
"order": 1
}
],
"criteria": {
"type": "DATE",
"dateField": "created",
"dateFormat": "ISODATE",
"expireAfterDays": 5
}
}'
https://domain.com/api/atlas/{{version}}/groups/{{ProjectID}}/clusters/{{CLUSTER-NAME}}/onlineArchives
Postman Collection Item JSON
{
"name": "Create an Online Archive",
"request": {
"method": "POST",
"header": [
],
"body": {
"mode": "raw",
"raw": "{\n \"dbName\": \"people\",\n \"collName\": \"employees\",\n \"partitionFields\": [\n {\n \"fieldName\": \"firstName\",\n \"order\": 0\n },\n {\n \"fieldName\": \"lastName\",\n \"order\": 1\n }\n ],\n \"criteria\": {\n \"type\": \"DATE\",\n \"dateField\": \"created\",\n \"dateFormat\": \"ISODATE\",\n \"expireAfterDays\": 5\n }\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "{{base_url}}/api/atlas/{{version}}/groups/{{ProjectID}}/clusters/{{CLUSTER-NAME}}/onlineArchives",
"host": [
"{{base_url}}"
],
"path": [
"api",
"atlas",
"{{version}}",
"groups",
"{{ProjectID}}",
"clusters",
"{{CLUSTER-NAME}}",
"onlineArchives"
]
},
"description": "https://docs.atlas.mongodb.com/reference/api/online-archive-create-one/#std-label-api-online-archive-create-one"
},
"response": [
]
}