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
  • 0
    Certified Senior Developer

    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.

  • 0
    Certified Senior Developer
    in reply to Stefan Helzle

    	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)


    In TestData[Data Type : Text] pv! im getting JSON data as input from prompt builder but at time though its not in format I converted to to Json. My issues I want to map the data in record type with their respective fields but unable to achieve that in appian im putting the same login in expression rule it gives me correct out but if I put it in script task it throws error as. I have tried almost all possible ways but it fails unable to write to record type.

Reply
  • 0
    Certified Senior Developer
    in reply to Stefan Helzle

    	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)


    In TestData[Data Type : Text] pv! im getting JSON data as input from prompt builder but at time though its not in format I converted to to Json. My issues I want to map the data in record type with their respective fields but unable to achieve that in appian im putting the same login in expression rule it gives me correct out but if I put it in script task it throws error as. I have tried almost all possible ways but it fails unable to write to record type.

Children
No Data