Workflows Send HTTP Request and ChatGPT

[lj4353]

I am trying to use Workflows Send HTTP Request to send a message to ChatGPT. How can I get the response from ChatGPT?

Here is an example link for GTP.

var response = UrlFetchApp.fetch('https://api.openai.com/v1/chat/completions', {
method: 'post',
headers: {
'Authorization': 'Bearer ' + OPENAI_API_KEY,
'Content-Type': 'application/json'
},
payload: JSON.stringify({
'model': 'gpt-3.5-turbo',
'messages': [
{'role': 'system', 'content': '以下の文章に「外国籍可」を示す内容が含まれていますか？'},
{'role': 'user', 'content': text},
{'role': 'system', 'content': '回答は「はい」または「いいえ」で答えてください。'}
],
'max_tokens': 10,
'temperature': 0.2
}),
muteHttpExceptions: true
});
var json = JSON.parse(response.getContentText());
Logger.log(json);
return json.choices && json.choices[0] && json.choices[0].message.content.trim() === 'はい' && !text.includes('外国籍：不可');​

[lj4353]

I tried using the following prompts:

https://forum.espocrm.com/forum/developer-help/98929-assistance-regarding-api-results?p=99199#post99199

$response is equal to the following value:

{
    "id": "chatcmpl-9iwcaaaGbwtDtmfho6rVtY0VziK",
    "object": "chat.completion",
    "created": 1720498811,
    "model": "gpt-3.5-turbo-0125",
    "choices": [
        {
            "index": 0,
            "message": {
                "role": "assistant",
                "content": "可"
            },
            "logprobs": null,
            "finish_reason": "stop"
        }
    ],
    "usage": {
        "prompt_tokens": 233,
        "completion_tokens": 1,
        "total_tokens": 234
    },
    "system_fingerprint": null
}​

However, $choices = json\retrieve($response, 'choices'); is empty. json\retrieve does not seem to work. My version is Version 8.3.4.

[rabii]

Choices is an array, you need to access values within the array. try something as below:

 $choices = json\retrieve($response, 'choices.0.message.0.content') 

The message is a collection of objects so you need to access first / last etc element then access value.

[lj4353]

Thanks, he's working normally now

$response = workflow\lastHttpResponseBody();

// 获取第一个choice中的message.content
$choices = json\retrieve($response, 'choices');

if (array\length($choices) > 0) {
$firstChoice = array\at($choices, 0);
$message = object\get($firstChoice, 'message');
$content = object\get($message, 'content');
entity\setAttribute('body', $content);
}