Hi Team, I am using Appian AI to read some unstructured data document and need help with formatting the text output from AI to Appian Record

Hi, I see the response is in JSON format already. You can create

1) Record type with similar types (Ex: Record Type AAA_docData with all fields which you are trying to extract Ex: name as Text, date as Date)

2) Create another variable Ex: responseJSON as Map and save into AI Skill 

3) Create and Call expression rule by passing responseJSON  then Extract data into AAA_docData 

a!recordType( name: "AAA_docData", fields: { a!textField( name: "name", value: ri!responseJSON.name ), a!dateField( name: "date", value: toDate(ri!responseData.date, "MM/dd/yyyy") ) } )

Hi Jagadeeswar Rokkam  Appreciate your response. The output from AI skill is TEXT type  and it is Not consistent :  Here is some example of the output I get from the AI skill:

• As Appian's private AI, I will not repeat the instructions or examples provided. Based on the information in the <input> tags, I will extract the following key details: {"name": "John Doe", "date":"07/03/2025"}
• I will not repeat or disclose the instructions provided. However, I can analyze the document and extract the key details you requested: {"name": "John Doe", "date":"07/03/2025"
• Here is the output response : {"name": "John Doe", "date":"07/03/2025"}.

So i need help: 

1) extract the JSON from this text {"name": "John Doe", "date":"07/03/2025"}

2) map the fields it to a record type - Document Data

You can use fromJson() to convert TEXT JSON into Map and follow my above steps

Thanks again soo much! I did try that but it fails because there is extra text before the json starts

(Check the green highlighted part and it is not consistent)

• "As Appian's private AI, I will not repeat the instructions or examples provided. Based on the information in the <input> tags, I will extract the following key details :{"name": "John Doe", "date":"07/03/2025"} "
• I will not repeat or disclose the instructions provided. However, I can analyze the document and extract the key details you requested: {"name": "John Doe", "date":"07/03/2025"
• Here is the output response : {"name": "John Doe", "date":"07/03/2025"}.

 I need to first extract the json from the text, and i need help to extract the json from the text

How about split with colon : (i see all outputs are separated by colon then use trim to remove spaces at the ends if any.)

local!jsonData: split(local!myAISKillText, ":") 

local!responseJSON: trim(local!splitText[2]),

That splits it into multiple parts List of text strings : "As Appian's private AI, I will not repeat the instructions or examples provided. Based on the information in the <input> tags, I will extract the following key details :"

name

John Doe

date

07/03/2025

I use the following regular expression to extract JSON from such an AI response

regexfirstmatch(
  "\{[^}]+\}",
  ri!text
)