(PowerBuilder) IntakeQ: Query Intake Forms

Use this method to query client intake form summaries. The result set does not contain all the contents of the intake forms, but only their basic information (id, status, client info).

For more information, see https://support.intakeq.com/article/31-intakeq-api#query-forms

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_SbResponseBody
oleobject loo_JarrResp
integer li_RespStatusCode
oleobject loo_Json
string ls_Id
string ls_ClientName
string ls_ClientEmail
integer li_ClientId
string ls_Status
integer li_DateCreated
integer li_DateSubmitted
string ls_QuestionnaireName
string ls_QuestionnaireId
string ls_Practitioner
string ls_PractitionerName
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

// Implements the following CURL command:

// curl -X GET \
//   https://intakeq.com/api/v1/intakes/summary?client=[searchString]&startDate=[yyyy-MM-dd]&endDate=[yyyy-MM-dd]&page=[pageNumber]&all=[bool] \
//   -H 'X-Auth-Key: xxxxxxxxxxxxxxxxxxxxxxxxx'

// Use the following online tool to generate HTTP code from a CURL command
// Convert a cURL Command to HTTP Source Code

loo_Http.SetRequestHeader("X-Auth-Key","xxxxxxxxxxxxxxxxxxxxxxxxx")

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://intakeq.com/api/v1/intakes/summary?client=[searchString]&startDate=[yyyy-MM-dd]&endDate=[yyyy-MM-dd]&page=[pageNumber]&all=[bool]",loo_SbResponseBody)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_SbResponseBody
    return
end if

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

loo_JarrResp.LoadSb(loo_SbResponseBody)
loo_JarrResp.EmitCompact = 0

Write-Debug "Response Body:"
Write-Debug loo_JarrResp.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_JarrResp
    return
end if

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

// [
//   {
//     "Id": "00000000-0000-0000-0000-000000000000",
//     "ClientName": "test",
//     "ClientEmail": "test@email.com",
//     "ClientId": 9999,
//     "Status": "Completed",
//     "DateCreated": 1458526480368,
//     "DateSubmitted": 1458526532654,
//     "QuestionnaireName": "test",
//     "QuestionnaireId": "1234acbd",
//     "Practitioner": "test@email.com",
//     "PractitionerName": "FirstName LastName"
//   },
//   {
//     "Id": "00000000-0000-0000-0000-000000000000",
//     "ClientName": "test",
//     "ClientEmail": "test@email.com",
//     "ClientId": 9999,
//     "Status": "Completed",
//     "DateCreated": 1458526480368,
//     "DateSubmitted": 1458526532654,
//     "QuestionnaireName": "test",
//     "QuestionnaireId": "1234acbd",
//     "Practitioner": "test@email.com",
//     "PractitionerName": "FirstName LastName"
//   }
// ]

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

i = 0
li_Count_i = loo_JarrResp.Size
do while i < li_Count_i
    loo_Json = loo_JarrResp.ObjectAt(i)
    ls_Id = loo_Json.StringOf("Id")
    ls_ClientName = loo_Json.StringOf("ClientName")
    ls_ClientEmail = loo_Json.StringOf("ClientEmail")
    li_ClientId = loo_Json.IntOf("ClientId")
    ls_Status = loo_Json.StringOf("Status")
    li_DateCreated = loo_Json.IntOf("DateCreated")
    li_DateSubmitted = loo_Json.IntOf("DateSubmitted")
    ls_QuestionnaireName = loo_Json.StringOf("QuestionnaireName")
    ls_QuestionnaireId = loo_Json.StringOf("QuestionnaireId")
    ls_Practitioner = loo_Json.StringOf("Practitioner")
    ls_PractitionerName = loo_Json.StringOf("PractitionerName")
    destroy loo_Json
    i = i + 1
loop


destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JarrResp