Assign AI extracted text to fields

[Robert_Benacka]

AI is giving me this result:

Can anyone Please point me to a document or video describing how to assign these to respective fields ? Thx

[ThinhDinh]

I would:

• Ask the AI to return data in a JSON format, with an example of JSON structure.
• Use JSON query to query out each of the fields (Date, Title, Text, Category).
• Use those queried fields for stuff you need.

[Robert_Benacka]

Yes great, thanks, now the AI field does a JSON extract however in some not in all instances the query failed:

And I am getting random good and bad query results:

[Jeff_Hager]

For starters, I would instruct the AI to not include the word JSON in front of the curly bracket. Second, I would make sure it’s not including those back ticks at the beginning and end.

[ThinhDinh]

Like Jeff said, add something like this:

"Strictly adhere to returning only a valid JSON, and don’t include backticks or the word JSON itself.

Invalid response:

‎```json
{
“key1”: “value1”,
“key2”: “value2”
}

Valid response:

{
“key1”: “value1”,
“key2”: “value2”
}
"

[Darren_Murphy]

@Robert_Benacka

Yes great, thanks, now the AI field does a JSON extract however in some not in all instances the query failed:

And I am getting random good and bad query results:

Which AI column are you using?
Use Text to JSON. It should always return valid JSON without any special prompting.

[Robert_Benacka]

Fantastic, Thanks have applied this:

For some reason the results are not alway the same, I getting some that look likes this:

and many that would look like this..

Is there a reason for this?

[Robert_Benacka]

[ThinhDinh]

Give an example in the instructions:

{
“title”: “Title value”,
“date”: “Date value”,
“category”: “Category value”,
“text”: “Text value”
}