OpenAI Chat Create Completion Parse JSON Error

How To
, , , ,
1

I am trying to create a custom message to send into the Open AI map message.

I am creating a database of prompts in ClickUp. That when selected it will create the message to send to OpenAI.

In Clickup I am passing 3 custom fields: User Role, Final Prompt, and Examples. The examples are a long string, that I am trying to write in JSON format so that I can have a varying about of examples.

I put in a Parse JSON but I keep getting an error that it doesn’t work when I add the variables.

Screenshot 2024-06-21 at 17.37.49
Screenshot 2024-06-21 at 17.37.49475×684 35 KB

This is an example of an input in without the variables that worked correctly:

[
    {
        "json": "{\n\"array\": [\n  {                \"role\": \"system\",\n                \"content\": \"You're a helpful an intelligent legal assistant who specializes in writing agreements for entertainment design agencies.\"\n            },\n            {\n                \"role\": \"user\",\n                \"content\": \"We are an entertainment design and management agency. We provide production services for live events, corporate conferences, and conventions. We hire contactors to help us provide services to our clients. Our contractors include but are not limited to the following positions: Stage Manager, Producer, Executive Producer, Senior Producer, Motion Graphics Artist, Script Supervisor, Graphics Designer, CAD Drafter (Vectorworks), Lighting Designer, Show Caller.Below is a loose scope. Turn that scope in to a high quality scope of work in markdown (atx) format. It should be an unordered listThis is a formal contract agreement so write it in a Spartan, no-frills tone, that implies intelligence.\"\n            },\n            {\n                \"role\": \"user\",\n                \"content\": \"Onsite Management, Preproduction, Daily Reports and production schedules, 2 pre-show calls 1.5 hours each, 12 hours pre-show work, General Producer tasks.\"\n            },\n            {\n                \"role\": \"assistant\",\n                \"content\": \"*filling out daily reports while onsite\\n*verifying and distributing the showbook\\n*notifying the client and crew of all daily schedules\\n*maintaining the overall vision of the show\\n*attending two (2) pre-show calls, each up to 1.5 hours.\\n*hours of pre-show work.\"\n            },\n            {\n                \"role\": \"user\",\n                \"content\": \"Senior Producer, Oversee General Session, Create and Maintain Show book, Create and Maintain Run of show, High touch interaction with clients, Pre-Production work as necessary for completion of show book, and run of show, Weekly Client meetings, Daily crew schedules, Maintain Show design and vision, Maintain timing\"\n            }\n]\n}"
    }
]

This is an example when using the data variables from clickup:

[
    {
        "json": "{\n  \"array\": [\n    {\n      \"role\": \"user\",\n      \"content\": \"You're a legal assistant specializing in entertainment design agency agreements.\n\"\n    },\n    {\n        \"role\": \"user\",\n        \"content\": \"Example scope: Onsite Management, Preproduction, Daily Reports and production schedules, 2 pre-show calls (1.5 hours each), 12 hours pre-show work, General Producer tasks.\"\n    },\n    {\n        \"role\": \"assistant\",\n        \"content\": \"Filling out daily reports while onsite, Verifying and distributing the showbook, Notifying the client and crew of all daily schedules, Maintaining the overall vision of the show, Attending two (2) pre-show calls, each up to 1.5 hours, Up to 12 Hours of pre-show work\"\n    }\n,\n    {\n      \"role\": \"user\",\n      \"content\": \"We are an entertainment design agency hiring contractors for events. Below is a loose scope. Convert it into a high-quality scope of work in markdown format. Use an unordered list and a Spartan, no-frills tone.\n\"\n    }\n  ]\n}"
    }
]

Blueprint:
blueprint-4.json (76.1 KB)

3

Hi @cre8iongroup

It is our pleasure to help you. Please find the updated JSON here:
{
“array”: [
{
“role”: “user”,
“content”: “{{toString(3.custom_fields.System Role)}}”
},
“{{toString(3.custom_fields.Examples)}}”,
{
“role”: “user”,
“content”: “{{toString(3.custom_fields.Prompt)}}”
}
]
}

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

4

@Msquare_Automation Thanks for the update. That did not work but I discovered that the custom fields when inserted into this were adding a newline after each of them

The newlines were not present in the module display. I used trim to remove the extra newlines after the text. This corrected the issues.

{"array": [{"role": "user","content": "{{trim(3.custom_fields.`System Role`)}}"},{{trim(3.custom_fields.Examples)}},{"role": "user","content": "{{trim(3.custom_fields.Prompt)}}"}]}

That was the JSON that finally worked.

2 Likes