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
I'm to facing same issue with the prompt builder noting helps in adding comments to the prompt builder. KIndly let me know the steps to sort this issue.
What is your exact issue?
Sure, a "List of Text" cannot be valid JSON. That rule input must be just "Text" and contain valid JSON.
same error even when its list. And this list was takes from output of promt builder
The value I see is not valid JSON ...
{ "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.
This is not valid JSON. I suggest to clear out that field "Expression" and paste the text directly into the field "Value".
Text pasted into "Expression" is first evaluated as an Appian expression.
I have attached 3 images over here. I'm trying to pass the json data from the process model to this rule via script task.the output in the expression rule is working fine but im trying to store the value in extractedData PV in the Script Task but it show{}. How to fix this?Prompt Builder Issue: It shows an inappropriate text at times when testing and gives it as an output which breaks the JSON in the Process model
Can you share the setup of that script task?
Are you sure you need that toJson?
The AI returns a string, which you store to a PV. Then you call your expression which expects a string, which you already have.
I Tried it without toJSON now my PV extract data return {} attached 3 images
It feels like the data you feed into your expression is not what you expect. I suggest to validate this.
this is what im expecting and im getting it in rule but not in script task
Sure, then validate the way the data takes from the AI up to the script task. Does this meet your expectations in real process instances? Check the datatypes and values.
it is as expected from AI to PV
Do you have any additional save configurations in "Data" -> "Inputs" of that script task?
Nothing in input
Did you check that all the field names in the JSON do match the field names in your record? In your latest expression you do a simple cast. For this to work, the field names have to match exactly.
only some fields match and the rest are neglected by appian. For the matching fields im gettting output as expected in expression rule
My remote debugging powers are exhausted.
I situations like this, I build an extremely simplified test case, leaving out any complexities. Once I understand how things work, I start adding back more of the complexity. This way I typically understand what I did wrong, but did not see because things were more complex than I could handle.
Just say me how to achieve this in step by step process:I'm getting JSON output from AI prompt Builder as shown in above screen shots. Now I need to store them to my Record type with their respective fields. Help me just on this.