M Code Help

gistfile1.txt

let
    AnalyzeDataWithChatGPT = (HelpRequest as text ) as text =>
    let  
        apikey = Text.FromBinary(File.Contents("C:\temp\PQ_API_KEY.txt")),
        GPTPrompt = Json.FromValue(
            [
                model = ModelToUse,
                messages = {
                    [ role = "system", content = "You are an expert in Power Query and M code. Provide a clear, detailed answer to the question below related to M code.  Include specific examples to help explain concepts" ],
                    [ role = "user", content  = HelpRequest ] 
                }
            ],
            TextEncoding.Utf8
        ),
        
        APICallResult = Json.Document(Web.Contents("https://api.openai.com/v1/chat/completions",[
            Headers = [
                #"Content-Type" = "application/json",
                #"Authorization" = "Bearer " & apikey
            ],
            Content = GPTPrompt
        ])),
        
        // Correctly extracting the response from the API result
        ResponseContent = APICallResult[choices]{0}[message][content]
    in
        ResponseContent
in
AnalyzeDataWithChatGPT

//Code created by Brian Julius, August 7, 2024
//Coontact me at https://www.linkedin.com/in/brianjuliusdc/
//Code based on similar work done by Oscar Martibnez Valero, #givecreditforcode
//PURPOSE: To provide detailed function help, coding assistance, and code explanation wiht Power Query