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
In my experience if your prompt is written properly, you would get the values in JSON format it self. Example could be
when I pass a text, map my text to below json schema.
{ "$schema": "">json-schema.org/.../schema "type": "array", "items": { "type": "object", "properties": { "IPAddress": { "type": "string" }, "StartDate": { "type": "string", "format": "date" }, "StartTime": { "type": "string", "format": "time" }, "StartTimezone": { "type": "string" }, "EndDate": { "type": "string", "format": "date" }, "EndTime": { "type": "string", "format": "time" }, "EndTimezone": { "type": "string" } }, "required": [ "IPAddress", "StartDate", "StartTime", "StartTimezone" ], "additionalProperties": false }}
All Right, Let me check my prompt again.
Thank you Kumar Agniwesh for your answer, Appreciate it!
if it helps please mark this answer as verified
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?
An error occurred while evaluating expression: extractedData:a!localVariables( local!data:a!toJson(pv!TestData), local!appdata:{a!flatten(a!fromJson(local!data))}, a!forEach( items: local!appdata, expression: 'recordType!{5c360892-b7b1-4569-a96c-9f6a59a24f49}AG RSL IDP Extraction'( 'recordType!{5c360892-b7b1-4569-a96c-9f6a59a24f49}AG RSL IDP Extraction.fields.{882cd204-82d1-41d5-857f-147364852129}documentType':fv!item.documentType, 'recordType!{5c360892-b7b1-4569-a96c-9f6a59a24f49}AG RSL IDP Extraction.fields.{15cbb624-16a6-4915-b165-fea772bdc237}practitionerName':fv!item.doctorName ) ), ) (Expression evaluation error at function a!forEach [line 6]: Error in a!forEach() expression during iteration 1: Expression evaluation error : Invalid index: Cannot index property 'documentType' of type Text into type Text) (Data Outputs)
Value in test data
This took me a while to decode .....
That AI response is just a JSON string. So your first step must be a fromJson().
Even If I put it that way it does't even recognize it as JSON that why I gave it as toJSON first and from json next but still I'm unable to get the output it throws error. in one or other form.
Sure, a "List of Text" cannot be valid JSON. That rule input must be just "Text" and contain valid JSON.