How to convert Text Data returned from an Execute Gen AI Skill into a Map/Dictionary

Certified Senior Developer

Hi Experts,

Please help me to resolve my issue.

I want to convert the following data returned in "Text" format into a list of dictionary/map and afterwards map these fields to a CDT.

{ "IPAddress": "111.101.1111.11", "StartDate": "2024/06/26", "StartTime": "23:24:49", "StartTimezone": "UTC", "EndDate": "2024/06/28", "EndTime": "17:38:12", "EndTimezone": "UTC" }& { "IPAddress": "111.111.1101.11", "StartDate": "2024/07/02", "StartTime": "02:52:07", "StartTimezone": "UTC" }& { "IPAddress": "111.111.1110.11", "StartDate": "2024/07/07", "StartTime": "18:10:37", "StartTimezone": "UTC", "EndDate": "2024/07/09", "EndTime": "03:50:30", "EndTimezone": "UTC" }& { "IPAddress": "111.111.1111.10", "StartDate": "2024/07/16", "StartTime": "07:36:39", "StartTimezone": "UTC", "EndDate": "2024/07/17", "EndTime": "23:01:19", "EndTimezone": "UTC" }

Appreciate your help!

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Senior Developer
    in reply to Stefan Helzle

    {
    "doctorName": "Dr Mohsina Ahmed",
    "doctorAddress": "102a Haldon Street, Lakemba NSW 2195",
    "doctorPhone": "02 9759 5436",
    "doctorEmail": "info@isramedical.com.au",
    "doctorProviderNo": "5720463A",
    "documentType": "Mental Health Care Plan",
    "patientName": "Not Provided",
    "medicalCondition": "Anxiety and Depression",
    "effectiveDate": "24/8/2024",
    "treatmentPlan": "Regular follow-up, psychologist referral, crisis management review",
    "durationOfTreatment": "Not Provided",
    "doctorSignature": "Yes",
    "fileContent": "This letter is to confirm that the patient has attended Isra Medical service complaining of depressed mood, anxiety, sleep disturbance, difficulty concentration, headaches, and low self-esteem. The patient's K10 assessment score was 31, indicating distress. The doctor provided counselling, relaxation techniques, and a referral to a psychologist for further management. In the doctor's opinion, the patient is most likely suffering from anxiety and depression, and might benefit from reducing their study load to enable completing the management plan.",
    "recommendation": "approved",
    "reasoning": "The document includes all required details, including a valid doctor's signature, treatment plan, and medical condition. No missing information was detected."
    }


    This is what the AI prompt Builder is giving as output.

Children