Bulk Import AI - Authentication Failed!

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Reason: Invalid API Key

Agency ID: #arguments.agency_id#

Employee ID: #arguments.emp_id#

IP Address: #CGI.REMOTE_ADDR#

User Agent: #CGI.HTTP_USER_AGENT#

Provided Key (masked): #Left(arguments.appkey, 10)#***

Security Alert: Unauthorized access attempt detected.

This is an automated security notification from the Bulk Import AI API

Bulk Import AI - Authentication Error!

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Agency ID: #arguments.agency_id#

Employee ID: #arguments.emp_id#

IP Address: #CGI.REMOTE_ADDR#

User Agent: #CGI.HTTP_USER_AGENT#

Error Details:

Error Type: #cfcatch.type#

Error Message: #cfcatch.message#

Error Detail: #cfcatch.detail#

File: #cfcatch.TagContext[1].template#

Line: #cfcatch.TagContext[1].line#

Stack Trace:

#cfcatch.stacktrace#

This is an automated error notification from the Bulk Import AI API

Bulk Import AI - Patient Data Imported Successfully!

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Encryption IDs and AppKeys:

Field	Original (Encrypted)	Decrypted Value	Was Encrypted
Agency_ID	`#htmlEditFormat(arguments.originalAgencyID)#`	`#htmlEditFormat(arguments.decryptedAgencyID)#`	#iif(arguments.decryptedAgencyID NEQ arguments.originalAgencyID, DE('Yes'), DE('No'))#
Emp_ID	`#htmlEditFormat(arguments.originalEmpID)#`	`#htmlEditFormat(arguments.decryptedEmpID)#`	#iif(arguments.decryptedEmpID NEQ arguments.originalEmpID, DE('Yes'), DE('No'))#
Patient_ID	`#htmlEditFormat(arguments.originalPatientID)#`	`#htmlEditFormat(arguments.decryptedPatientID)#`	#iif(arguments.decryptedPatientID NEQ arguments.originalPatientID, DE('Yes'), DE('No'))#
Assessment_ID	`#htmlEditFormat(arguments.originalAssessmentID)#`	`#htmlEditFormat(arguments.decryptedAssessmentID)#`	#iif(arguments.decryptedAssessmentID NEQ arguments.originalAssessmentID, DE('Yes'), DE('No'))#
appkey	`#htmlEditFormat(arguments.originalAppKey)#`	`#htmlEditFormat(arguments.decryptedAppKey)#`	#iif(len(arguments.decryptedAppKey) GT 0 AND arguments.decryptedAppKey NEQ arguments.originalAppKey, DE('Yes'), DE('No'))#

Encryption Key Available: Yes (Length: #len(Application.enckey)#)

Encryption Key Available: No

Import Results:

Patient AI ID: #arguments.insertedPatientID# (#arguments.patientAction#)

Emergency Contact: #iif(arguments.contactInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedContactID#)

Payer/Subscriber: #iif(arguments.payerInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedPayerID#)

Admission Record: #iif(arguments.admitInserted, DE('Inserted'), DE('Updated'))# (ID: #arguments.insertedAdmitID#)

Medications: #arguments.medicationCount# record(s) inserted

Problems/Diagnoses: #arguments.problemCount# record(s) inserted/updated

Extracted Data (JSON):

#htmlEditFormat(arguments.extractedJSONString)#

Partial Errors:

#err#

Debug Information:

Datasource: #Application.DataSrc#
Agency Database: #arguments.agency_db#
Transaction Status: Committed Successfully

This is an automated notification from the Bulk Import AI API

Bulk Import AI - Patient Data Import Failed!

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Error Information:

Error Type: #errorType#

Error Message: #errorMessage#

Error Detail: #errorDetail#

Failed at Step: #htmlEditFormat(arguments.currentStep)#

File: #errorTagContext[1].template#

Line: #errorTagContext[1].line#

Step-by-Step Error Details:

#htmlEditFormat(stepErr)#

Encryption IDs and AppKeys:

Field	Original (Encrypted)	Decrypted Value	Was Encrypted
Agency_ID	`#htmlEditFormat(arguments.originalAgencyID)#`	`#htmlEditFormat(arguments.decryptedAgencyID)#`	#iif(arguments.decryptedAgencyID NEQ arguments.originalAgencyID, DE('Yes'), DE('No'))#
Emp_ID	`#htmlEditFormat(arguments.originalEmpID)#`	`#htmlEditFormat(arguments.decryptedEmpID)#`	#iif(arguments.decryptedEmpID NEQ arguments.originalEmpID, DE('Yes'), DE('No'))#
Patient_ID	`#htmlEditFormat(arguments.originalPatientID)#`	`#htmlEditFormat(arguments.decryptedPatientID)#`	#iif(arguments.decryptedPatientID NEQ arguments.originalPatientID, DE('Yes'), DE('No'))#
Assessment_ID	`#htmlEditFormat(arguments.originalAssessmentID)#`	`#htmlEditFormat(arguments.decryptedAssessmentID)#`	#iif(arguments.decryptedAssessmentID NEQ arguments.originalAssessmentID, DE('Yes'), DE('No'))#
appkey	`#htmlEditFormat(arguments.originalAppKey)#`	`#htmlEditFormat(arguments.decryptedAppKey)#`	#iif(len(arguments.decryptedAppKey) GT 0 AND arguments.decryptedAppKey NEQ arguments.originalAppKey, DE('Yes'), DE('No'))#

Encryption Key Available: Yes (Length: #len(Application.enckey)#)

Encryption Key Available: No

Partial Import Results (before error):

Patient AI ID: #arguments.insertedPatientID#
Medications: #arguments.medicationCount# record(s)
Problems/Diagnoses: #arguments.problemCount# record(s)

Previous Errors:

#err#

Extracted Data (JSON):

#htmlEditFormat(arguments.extractedJSONString)#

Stack Trace:

#htmlEditFormat(errorStacktrace)#

This is an automated error notification from the Bulk Import AI API

Whisper Assessment Import Completed Successfully

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #arguments.websiteName#

Job ID: #arguments.jobID#

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Assessment Update Results

Assessment Reason: #htmlEditFormat(arguments.assessmentReason)#
Mapped F-columns Updated: #arguments.mappedAnswerCount#
Skipped Answers: #arrayLen(arguments.skippedAnswers)#
Transaction Status: Committed Successfully
Datasource: #Application.DataSrc#
Agency Database: #arguments.agency_db#

Skipped Answers

#htmlEditFormat(skippedAnswer)#

Warnings Captured During Import

#htmlEditFormat(stepErr)#

Extracted Data (JSON)

#htmlEditFormat(arguments.extractedJSONString)#

This is an automated notification from the Whisper Assessment Import API

No filled answers in payload.

" /> SELECT ques_id, answer_label, questions_label, CASE WHEN questions_2 <> '' THEN TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques_identifier_2), ''), NULLIF(TRIM(questions_2), ''))) ELSE TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques_identifier), ''), NULLIF(TRIM(questions), ''))) END AS question_description FROM #arguments.lookup_db#.#Request.assessment_questions_lookup# WHERE assessment_reason = AND Deleted = Questions and Filled Answers' /> Assessment Reason: ' & htmlEditFormat(trim(arguments.assessmentReason)) & '

' /> ' /> ' /> QuestionAnswerImport Status' /> ' /> ' /> ' & htmlEditFormat(questionText) & '' /> ' & filledValue & '' /> ' & importStatus & '' /> ' /> ' /> ' & vitalUpdated & '' & vitalSkipped & '—' /> ' & woundUpdated & '' & woundSkipped & '' & woundPhotos & '' /> ' /> ' /> ' /> ' />

importAssessmentData Wounds/Vitals Save Trace

Source: #htmlEditFormat(channel)#

Timestamp: #dateFormat(now(), 'mm/dd/yyyy')# #timeFormat(now(), 'HH:mm:ss')#

Success: #successFlag#

Message: #htmlEditFormat(arguments.message)#

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #htmlEditFormat(arguments.websiteName)#

Job ID: #htmlEditFormat(arguments.jobID)#

Whisper File ID: #val(arguments.whisperFilesId)#

#summaryHtml#

Request Payload

#htmlEditFormat(requestBody)#

Response Payload

#htmlEditFormat(responseBody)#

Automated trace from whisper_ai.cfc importAssessmentData (same format as mobile saveAssessmentWoundsVitals)

' /> TypeUpdatedInsertedSkippedNotes' /> Vitals (vital_* → pWoundsVitals)' & vitalUpdated & '' & vitalInserted & '' & vitalSkipped & '' /> ' /> Wounds (wound_* → pWoundsVitals)' & woundUpdated & '' & woundInserted & '' & woundSkipped & '' /> ' /> Questions table could not be built: " & htmlEditFormat(cfcatch.message) & "

" />

importAssessmentData Request / Response Trace

Agency ID: #arguments.agencyID#

Employee ID: #arguments.empID#

Patient ID: #arguments.patientID#

Assessment ID: #arguments.assessmentID#

Website: #htmlEditFormat(arguments.websiteName)#

Job ID: #htmlEditFormat(arguments.jobID)#

Timestamp: #DateFormat(Now(), 'mm/dd/yyyy')# #TimeFormat(Now(), 'HH:mm:ss')#

Last Step: #htmlEditFormat(arguments.currentStep)#

#vitalsWoundsSummaryHtml#

#questionsAnswersTableHtml#

Request Payload

#htmlEditFormat(requestBody)#

Response Payload

#htmlEditFormat(responseBody)#

Step Errors / Warnings

#htmlEditFormat(traceEntry)#

This trace email is sent only for importAssessmentData.

The full trace email could not be sent.

Error: #htmlEditFormat(mailError)#

Assessment ID: #arguments.assessmentID#

Last Step: #htmlEditFormat(arguments.currentStep)#

SELECT Lookup_1, Lookup_2, Measure FROM #arguments.lookup_db#.pValue_Lookup WHERE Item_ID = ORDER BY ID SELECT vp.Item_ID, vp.Value_Low, vp.Value_High, MAX(vl.Description) AS Description, MAX(vl.Measure) AS Measure, MAX(vl.Required) AS Required FROM #arguments.agency_db#.pVital_Param vp INNER JOIN #arguments.lookup_db#.pValue_Lookup vl ON vl.Item_ID = vp.Item_ID AND vl.Description <> WHERE vp.Status = AND vp.Vital_Sign <> GROUP BY vp.Item_ID, vp.Value_Low, vp.Value_High ORDER BY vp.Item_ID SELECT MAX(vl.Description) AS Description FROM #arguments.lookup_db#.pValue_Lookup vl WHERE vl.Item_ID = AND vl.Description <> SELECT Vital_Sign FROM #arguments.agency_db#.pVital_Param WHERE Item_ID = AND Status = LIMIT 1 SELECT ID, Item_ID FROM #arguments.agency_db#.pWoundsVitals WHERE ID = AND Assmt_ID = AND Status = AND VitalOrWound = LIMIT 1 SELECT ID, Item_ID FROM #arguments.agency_db#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = AND Item_ID = LIMIT 1 SELECT ID, Item_ID FROM #arguments.agency_db#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = ORDER BY Pathway_ID DESC LIMIT 1 UPDATE #arguments.agency_db#.pWoundsVitals SET Description = , Location = , other_locations = , Length = , Width = , Depth = , healingstage = , woundtype = , Pathway_ID = , wnd_tunneling = , wnd_underm = , wnd_gran = , wnd_epith = , wnd_eschar = , wnd_slough = , wnd_fib = , wnd_margin = , wnd_exudate = , wnd_odor = , wnd_pain = , Param_Hi = , Reading1 = , Date_Change = , Change_by = WHERE ID = SELECT Item_ID FROM #arguments.agency_db#.pWoundsVitals WHERE VitalOrWound = AND Assmt_ID = AND Status = ORDER BY Pathway_ID DESC INSERT INTO #arguments.agency_db#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Location, other_locations, Length, Width, Depth, Param_Hi, Reading1, Date_Create, Created_by, Date_Change, Change_by, healingstage, frompgnote, woundtype, wnd_margin, wnd_exudate, wnd_odor, wnd_pain, wnd_tunneling, wnd_underm, wnd_gran, wnd_epith, wnd_eschar, wnd_slough, wnd_fib ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT Value_Low, Value_High FROM #arguments.agency_db#.pVital_Param WHERE Item_ID = AND Status = LIMIT 1 SELECT ID FROM #arguments.agency_db#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = AND Item_ID = LIMIT 1 UPDATE #arguments.agency_db#.pWoundsVitals SET Description = , Reading1 = , Notes = , Param_Lo = , Param_Hi = , pain_location = , pain_duration = , pain_exacerbate = , pain_relief = , pain_med_effectiveness = , Date_Change = , Change_by = WHERE ID = INSERT INTO #arguments.agency_db#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Param_Lo, Param_Hi, Notes, Reading1, pain_location, pain_duration, pain_exacerbate, pain_relief, pain_med_effectiveness, Date_Create, Created_by, Date_Change, Change_by ) VALUES ( , , , , , , , , , , , , , , , , , , ) SELECT ID, Item_ID, Pathway_ID FROM #arguments.agency_db#.pWoundsVitals WHERE Assmt_ID = AND Status = AND VitalOrWound = ORDER BY Pathway_ID DESC LIMIT 1 UPDATE #arguments.agency_db#.pWoundsVitals SET Description = , Location = , other_locations = , Length = , Width = , Depth = , healingstage = , woundtype = , Pathway_ID = , wnd_tunneling = , wnd_underm = , wnd_gran = , wnd_epith = , wnd_eschar = , wnd_slough = , wnd_fib = , wnd_margin = , wnd_exudate = , wnd_odor = , wnd_pain = , Param_Hi = , Reading1 = , Date_Change = , Change_by = WHERE ID = SELECT Item_ID FROM #arguments.agency_db#.pWoundsVitals WHERE VitalOrWound = AND Assmt_ID = AND Status = ORDER BY Pathway_ID DESC INSERT INTO #arguments.agency_db#.pWoundsVitals ( Assmt_ID, Status, Pathway_ID, Item_ID, VitalOrWound, Description, Location, other_locations, Length, Width, Depth, Param_Hi, Reading1, Date_Create, Created_by, Date_Change, Change_by, healingstage, frompgnote, woundtype, wnd_margin, wnd_exudate, wnd_odor, wnd_pain, wnd_tunneling, wnd_underm, wnd_gran, wnd_epith, wnd_eschar, wnd_slough, wnd_fib ) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT Schedule_ID, Patient_ID, Assmt_ID, Visit_Type, DATE_FORMAT(Visit_Date, '%Y-%m-%d') AS Visit_Date, Skill FROM #arguments.agency_db#.pSchedules WHERE Schedule_ID = AND Status = LIMIT 1 SELECT Lookup_1, Lookup_2, Measure FROM #arguments.lookup_db#.pValue_Lookup WHERE Description = SELECT Lookup_1, Lookup_2, Measure FROM #arguments.lookup_db#.pValue_Lookup WHERE Item_ID = ORDER BY ID SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = SELECT pProgress.Progress_ID, pProgress.Assmt_ID, pProgress.Schedule_ID, pProgress.Item_ID, pProgress.Type, pProgress.Description, pProgress.Notes , pProgress.Careplan_ID , pProgress.YesOrNo , pProgress.severity , pProgress.Value_1 , pProgress.Value_2 , pProgress.Value_3 , pProgress.healing_stage , pProgress.wnd_tunneling , pProgress.wnd_underm , pProgress.wnd_gran , pProgress.wnd_epith , pProgress.wnd_eschar , pProgress.wnd_slough , pProgress.wnd_fib , pProgress.wnd_margin , pProgress.wnd_exudate , pProgress.wnd_odor , pProgress.wnd_pain , pProgress.Date_Target , pProgress.Discharge , pProgress.Discharge_Reason , pProgress.pain_location , pProgress.pain_duration , pProgress.pain_relief , pProgress.pain_exacerbate , pProgress.pain_med_effectiveness , (SELECT MAX(pw.Header) FROM #arguments.lookup_db#.pPathway pw WHERE pw.Item_ID = pProgress.Item_ID AND pw.Header IS NOT NULL) AS Header, CASE WHEN (pProblem.M0_No LIKE 'SK%' OR pProblem.M0_No = 'wound') AND LEFT(pProgress.Description, 1) = '##' THEN 'Wounds' ELSE '' END AS woundstitle FROM #arguments.agency_db#.pProgress LEFT OUTER JOIN #arguments.agency_db#.pProblem ON pProblem.Problem_ID = pProgress.Careplan_ID AND pProblem.status = 0 WHERE pProgress.Schedule_ID = AND pProgress.Status = AND NOT ( pProgress.Type IN ('problem','symptom') AND pProgress.Item_ID IN ( SELECT Item_ID FROM #arguments.lookup_db#.pPathway WHERE Header = ) ) GROUP BY pProgress.Progress_ID ORDER BY FIELD(pProgress.Type, 'patient_complaint','patient_goal','vital','problem','symptom', 'procedure','standing_order','goal','discharge_plan','teach'), pProgress.Progress_ID SELECT Schedule_ID FROM #agency_db#.whisper_files WHERE ID = AND Status = LIMIT 1 SELECT ques_id, CASE WHEN questions_2 <> '' THEN TRIM(CONCAT_WS(' ', NULLIF(TRIM(ques_identifier_2), ''), NULLIF(TRIM(questions_2), ''))) ELSE questions END AS questions, ques_identifier_2 AS questions_new, quescolor,title_2 as title, questions_label, answer_label, questions_type, new_order_id AS order_id , assessment_reason, new_wizard AS wizard, ques_identifier_2 AS ques_identifier FROM #lookup_db#.#Request.assessment_questions_lookup# WHERE assessment_reason = AND Deleted = 0 ORDER BY order_id, wizard, answer_label SELECT val_id AS VAL_ID, answer_2 AS ANSWER, text_labels AS TEXT_LABELS, assessment_reason AS ASSESSMENT_REASON, ans_id AS ANS_ID, item_id AS ITEM_ID, answer_2 AS ANSWER_2, question_id AS QUESTION_ID, answer_type AS ANSWER_TYPE FROM #lookup_db#.#Request.assessment_answers_lookup# WHERE assessment_reason = AND Deleted = 0 ORDER BY question_id, srt_id, answer_label UPDATE #arguments.agency_db#.whisper_files SET Review_Status = WHERE ID = AND Status = AND Review_Status = SELECT ID FROM #arguments.agency_db#.whisper_files WHERE Assmt_ID = AND Status = AND Review_Status = ORDER BY ID DESC LIMIT 1 UPDATE #arguments.agency_db#.whisper_files SET Review_Status = WHERE ID = UPDATE #arguments.agency_db#.whisper_files SET Review_Status = WHERE Assmt_ID = AND Status = AND Review_Status = SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = UPDATE #arguments.agency_db#.pAssessments SET #batchFields[i]# = NULL , , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = UPDATE #arguments.agency_db#.pAssessments SET #fieldName# = NULL , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = SELECT AutoAssmt_ID, F26, F25, F176, F177, F178 FROM #agency_db#.pAssessments WHERE Assmt_ID = AND Patient_ID = AND Status = ORDER BY AutoAssmt_ID DESC LIMIT 1 SELECT s.Visit_Type FROM #agency_db#.whisper_files wf INNER JOIN #agency_db#.pSchedules s ON s.Schedule_ID = wf.Schedule_ID AND s.Status = 0 WHERE wf.ID = LIMIT 1 SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = AND TABLE_NAME = AND COLUMN_NAME NOT IN ( , ) ORDER BY ORDINAL_POSITION INSERT INTO #agency_db#.pAssessments (#preserveSingleQuotes(assessmentColumnList)#) SELECT #preserveSingleQuotes(assessmentColumnList)# FROM #agency_db#.pAssessments WHERE AutoAssmt_ID = LIMIT 1 SELECT LAST_INSERT_ID() AS LastInsertID UPDATE #agency_db#.pAssessments SET Status = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = UPDATE #agency_db#.pAssessments SET Status = , Record_Creation_Date = , Record_Created_By = , Record_Mod_Date = , Record_Mod_By = WHERE AutoAssmt_ID = SELECT F26 FROM #agency_db#.pAssessments WHERE AutoAssmt_ID = SELECT ques_id, answer_label FROM #lookup_db#.#Request.assessment_questions_lookup# WHERE assessment_reason = AND Deleted = AND answer_label IS NOT NULL AND trim(answer_label) != '' SELECT ID, whisper_files_id, job_id, request_id, job_status, Patient_ID, Assmt_ID FROM #arguments.agency_db#.whipser_jobs WHERE Status = 0 AND job_id = AND whisper_files_id = ORDER BY ID DESC LIMIT 1 UPDATE #arguments.agency_db#.whipser_jobs SET job_status = , status_response = , Last_Checked = NOW() WHERE ID = SELECT ID, Agency_Id, Patient_Id, Assmt_ID, Schedule_ID, Dup_file_name, Notes, FileName, CreatedBy FROM #arguments.agency_db#.whisper_files WHERE ID = AND Agency_Id = AND Status = 0 LIMIT 1 SELECT pa.Assmt_ID FROM #arguments.agency_db#.pAssessments pa WHERE pa.Patient_ID = AND pa.Status = 0 ORDER BY pa.Assmt_ID DESC LIMIT 1 SELECT F26, DATE_FORMAT(F176, '%Y-%m-%d') AS Visit_Date FROM #arguments.agency_db#.pAssessments WHERE Assmt_ID = AND Status = 0 LIMIT 1 INSERT INTO #arguments.agency_db#.whipser_jobs ( Patient_ID, Assmt_ID, whisper_files_id, job_id, request_id, job_status, Status, raw_response, CreatedBy ) VALUES ( , , , , , , , , )