Chilkat Online Tools

PowerBuilder / Salesforce Platform APIs / Prediction models

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_SbResponseBody
oleobject loo_JResp
integer li_RespStatusCode
string ls_Id
string ls_Name
string ls_ProfilePhotoUrl
string ls_CreatedDate
string ls_HistoryUrl
string ls_Id
integer li_IsRefreshEnabled
string ls_Label
string ls_LastModifiedById
string ls_LastModifiedByName
string ls_LastModifiedByProfilePhotoUrl
string ls_LastModifiedDate
string ls_ModelId
string ls_ModelType
string ls_Name
string ls_PredictionDefinitionUrl
integer li_SortOrder
string ls_Status
integer j
integer li_Count_j
string ls_Label
string ls_ModelFieldName
string ls_V_Type
string ls_FieldLabel
string ls_FieldName
string ls_FieldType
integer k
integer li_Count_k
integer li_TotalSize
string ls_Url
integer i
integer li_Count_i

// 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

// Adds the "Authorization: Bearer <access_token>" header.
loo_Http.AuthToken = "<access_token>"

loo_SbResponseBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")

li_Success = loo_Http.QuickGetSb("https://domain.com/services/data/v{{version}}/smartdatadiscovery/predictionDefinitions/:PREDICTION_DEFINITION_ID/models",loo_SbResponseBody)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_SbResponseBody
    return
end if

loo_JResp = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")

loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0

Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()

li_RespStatusCode = loo_Http.LastStatus
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
    Write-Debug "Response Header:"
    Write-Debug loo_Http.LastHeader
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_SbResponseBody
    destroy loo_JResp
    return
end if

// Sample JSON response:
// (Sample code for parsing the JSON response is shown below)

// {
//   "models": [
//     {
//       "createdBy": {
//         "id": "0055Y00000DWwAIQA1",
//         "name": "Philippe Ozil",
//         "profilePhotoUrl": "https://crm-analytics-deorg-dev-ed--c.documentforce.com/profilephoto/005/T"
//       },
//       "createdDate": "2021-03-04T13:37:03.000Z",
//       "fieldMappingList": [
//         {
//           "modelField": {
//             "label": "Category",
//             "name": "Category",
//             "type": "Text"
//           }
//         },
//         {
//           "modelField": {
//             "label": "Sales",
//             "name": "Sales",
//             "type": "Number"
//           }
//         },
//         {
//           "modelField": {
//             "label": "Profit per Order",
//             "name": "Profit_per_Order",
//             "type": "Number"
//           }
//         },
//         {
//           "modelField": {
//             "label": "Sub-Category",
//             "name": "Sub_Category",
//             "type": "Text"
//           }
//         },
//         {
//           "modelField": {
//             "label": "Quantity",
//             "name": "Quantity",
//             "type": "Number"
//           }
//         }
//       ],
//       "filters": [
//       ],
//       "historyUrl": "/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA/models/1Ot5Y0000010wzNSAQ/histories",
//       "id": "1Ot5Y0000010wzNSAQ",
//       "isRefreshEnabled": false,
//       "label": "superstore-orders",
//       "lastModifiedBy": {
//         "id": "0055Y00000DWwAIQA1",
//         "name": "Philippe Ozil",
//         "profilePhotoUrl": "https://crm-analytics-deorg-dev-ed--c.documentforce.com/profilephoto/005/T"
//       },
//       "lastModifiedDate": "2021-03-04T13:37:03.000Z",
//       "model": {
//         "id": "1OT5Y0000010zlzWAA"
//       },
//       "modelType": "Regression",
//       "name": "superstore_orders",
//       "predictionDefinitionUrl": "/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA",
//       "prescribableFields": [
//         {
//           "customDefinitions": [
//           ],
//           "field": {
//             "label": "Quantity",
//             "name": "Quantity",
//             "type": "Number"
//           }
//         }
//       ],
//       "sortOrder": 0,
//       "status": "Enabled",
//       "url": "/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA/models/1Ot5Y0000010wzNSAQ"
//     }
//   ],
//   "totalSize": 1,
//   "url": "/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA/models"
// }

// Sample code for parsing the JSON response...
// Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

li_TotalSize = loo_JResp.IntOf("totalSize")
ls_Url = loo_JResp.StringOf("url")
i = 0
li_Count_i = loo_JResp.SizeOfArray("models")
do while i < li_Count_i
    loo_JResp.I = i
    ls_Id = loo_JResp.StringOf("models[i].createdBy.id")
    ls_Name = loo_JResp.StringOf("models[i].createdBy.name")
    ls_ProfilePhotoUrl = loo_JResp.StringOf("models[i].createdBy.profilePhotoUrl")
    ls_CreatedDate = loo_JResp.StringOf("models[i].createdDate")
    ls_HistoryUrl = loo_JResp.StringOf("models[i].historyUrl")
    ls_Id = loo_JResp.StringOf("models[i].id")
    li_IsRefreshEnabled = loo_JResp.BoolOf("models[i].isRefreshEnabled")
    ls_Label = loo_JResp.StringOf("models[i].label")
    ls_LastModifiedById = loo_JResp.StringOf("models[i].lastModifiedBy.id")
    ls_LastModifiedByName = loo_JResp.StringOf("models[i].lastModifiedBy.name")
    ls_LastModifiedByProfilePhotoUrl = loo_JResp.StringOf("models[i].lastModifiedBy.profilePhotoUrl")
    ls_LastModifiedDate = loo_JResp.StringOf("models[i].lastModifiedDate")
    ls_ModelId = loo_JResp.StringOf("models[i].model.id")
    ls_ModelType = loo_JResp.StringOf("models[i].modelType")
    ls_Name = loo_JResp.StringOf("models[i].name")
    ls_PredictionDefinitionUrl = loo_JResp.StringOf("models[i].predictionDefinitionUrl")
    li_SortOrder = loo_JResp.IntOf("models[i].sortOrder")
    ls_Status = loo_JResp.StringOf("models[i].status")
    ls_Url = loo_JResp.StringOf("models[i].url")
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("models[i].fieldMappingList")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_Label = loo_JResp.StringOf("models[i].fieldMappingList[j].modelField.label")
        ls_ModelFieldName = loo_JResp.StringOf("models[i].fieldMappingList[j].modelField.name")
        ls_V_Type = loo_JResp.StringOf("models[i].fieldMappingList[j].modelField.type")
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("models[i].filters")
    do while j < li_Count_j
        loo_JResp.J = j
        j = j + 1
    loop
    j = 0
    li_Count_j = loo_JResp.SizeOfArray("models[i].prescribableFields")
    do while j < li_Count_j
        loo_JResp.J = j
        ls_FieldLabel = loo_JResp.StringOf("models[i].prescribableFields[j].field.label")
        ls_FieldName = loo_JResp.StringOf("models[i].prescribableFields[j].field.name")
        ls_FieldType = loo_JResp.StringOf("models[i].prescribableFields[j].field.type")
        k = 0
        li_Count_k = loo_JResp.SizeOfArray("models[i].prescribableFields[j].customDefinitions")
        do while k < li_Count_k
            loo_JResp.K = k
            k = k + 1
        loop
        j = j + 1
    loop
    i = i + 1
loop


destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp

Curl Command

curl -X GET
	-H "Authorization: Bearer <access_token>"
https://domain.com/services/data/v{{version}}/smartdatadiscovery/predictionDefinitions/:PREDICTION_DEFINITION_ID/models

Postman Collection Item JSON

{
  "name": "Prediction models",
  "request": {
    "method": "GET",
    "header": [
    ],
    "url": {
      "raw": "{{_endpoint}}/services/data/v{{version}}/smartdatadiscovery/predictionDefinitions/:PREDICTION_DEFINITION_ID/models",
      "host": [
        "{{_endpoint}}"
      ],
      "path": [
        "services",
        "data",
        "v{{version}}",
        "smartdatadiscovery",
        "predictionDefinitions",
        ":PREDICTION_DEFINITION_ID",
        "models"
      ],
      "variable": [
        {
          "key": "PREDICTION_DEFINITION_ID",
          "value": ""
        }
      ]
    },
    "description": "Get available prediction definitions."
  },
  "response": [
    {
      "name": "Prediction models",
      "originalRequest": {
        "method": "GET",
        "header": [
        ],
        "url": {
          "raw": "{{_endpoint}}/services/data/v{{version}}/smartdatadiscovery/predictionDefinitions/1OR5Y0000010ws8WAA/models",
          "host": [
            "{{_endpoint}}"
          ],
          "path": [
            "services",
            "data",
            "v{{version}}",
            "smartdatadiscovery",
            "predictionDefinitions",
            "1OR5Y0000010ws8WAA",
            "models"
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Date",
          "value": "Thu, 04 Mar 2021 13:48:31 GMT"
        },
        {
          "key": "Strict-Transport-Security",
          "value": "max-age=31536002; includeSubDomains"
        },
        {
          "key": "Expect-CT",
          "value": "max-age=86400, report-uri=\"https://a.forcesslreports.com/Expect-CT-report/00D5Y000001crJvm\""
        },
        {
          "key": "X-Content-Type-Options",
          "value": "nosniff"
        },
        {
          "key": "X-XSS-Protection",
          "value": "1; mode=block"
        },
        {
          "key": "X-Robots-Tag",
          "value": "none"
        },
        {
          "key": "Cache-Control",
          "value": "no-cache,must-revalidate,max-age=0,no-store,private"
        },
        {
          "key": "Content-Type",
          "value": "application/json;charset=UTF-8"
        },
        {
          "key": "Vary",
          "value": "Accept-Encoding"
        },
        {
          "key": "Content-Encoding",
          "value": "gzip"
        },
        {
          "key": "Transfer-Encoding",
          "value": "chunked"
        }
      ],
      "cookie": [
      ],
      "body": "{\n    \"models\": [\n        {\n            \"createdBy\": {\n                \"id\": \"0055Y00000DWwAIQA1\",\n                \"name\": \"Philippe Ozil\",\n                \"profilePhotoUrl\": \"https://crm-analytics-deorg-dev-ed--c.documentforce.com/profilephoto/005/T\"\n            },\n            \"createdDate\": \"2021-03-04T13:37:03.000Z\",\n            \"fieldMappingList\": [\n                {\n                    \"modelField\": {\n                        \"label\": \"Category\",\n                        \"name\": \"Category\",\n                        \"type\": \"Text\"\n                    }\n                },\n                {\n                    \"modelField\": {\n                        \"label\": \"Sales\",\n                        \"name\": \"Sales\",\n                        \"type\": \"Number\"\n                    }\n                },\n                {\n                    \"modelField\": {\n                        \"label\": \"Profit per Order\",\n                        \"name\": \"Profit_per_Order\",\n                        \"type\": \"Number\"\n                    }\n                },\n                {\n                    \"modelField\": {\n                        \"label\": \"Sub-Category\",\n                        \"name\": \"Sub_Category\",\n                        \"type\": \"Text\"\n                    }\n                },\n                {\n                    \"modelField\": {\n                        \"label\": \"Quantity\",\n                        \"name\": \"Quantity\",\n                        \"type\": \"Number\"\n                    }\n                }\n            ],\n            \"filters\": [],\n            \"historyUrl\": \"/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA/models/1Ot5Y0000010wzNSAQ/histories\",\n            \"id\": \"1Ot5Y0000010wzNSAQ\",\n            \"isRefreshEnabled\": false,\n            \"label\": \"superstore-orders\",\n            \"lastModifiedBy\": {\n                \"id\": \"0055Y00000DWwAIQA1\",\n                \"name\": \"Philippe Ozil\",\n                \"profilePhotoUrl\": \"https://crm-analytics-deorg-dev-ed--c.documentforce.com/profilephoto/005/T\"\n            },\n            \"lastModifiedDate\": \"2021-03-04T13:37:03.000Z\",\n            \"model\": {\n                \"id\": \"1OT5Y0000010zlzWAA\"\n            },\n            \"modelType\": \"Regression\",\n            \"name\": \"superstore_orders\",\n            \"predictionDefinitionUrl\": \"/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA\",\n            \"prescribableFields\": [\n                {\n                    \"customDefinitions\": [],\n                    \"field\": {\n                        \"label\": \"Quantity\",\n                        \"name\": \"Quantity\",\n                        \"type\": \"Number\"\n                    }\n                }\n            ],\n            \"sortOrder\": 0,\n            \"status\": \"Enabled\",\n            \"url\": \"/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA/models/1Ot5Y0000010wzNSAQ\"\n        }\n    ],\n    \"totalSize\": 1,\n    \"url\": \"/services/data/v51.0/smartdatadiscovery/predictiondefinitions/1OR5Y0000010ws8WAA/models\"\n}"
    }
  ]
}