Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio - Building Copilot Studio Chatbo... / POST request to Snowfl...
Copilot Studio - Building Copilot Studio Chatbo...
Answered

POST request to Snowflake Cortex API not working in Copilot Studio, but works in Postman

(1) ShareShare
ReportReport
Posted on by LuisAznar 69

Hi everyone,

I'm trying to make a POST request to the Snowflake Cortex API (using the endpoint described here), but it's not working in Copilot Studio.

HTTP request failed with status code 400 BadRequest. Error code: HttpRequestFailure.

Here's the situation:

  • I’m using the same Body and Headers in both Postman and Copilot Studio.
  • The request successfully returns a 200 status in Postman with the same data.
  • However, in Copilot Studio, I’m getting no response or an error.

I was wondering if there's something specific I need to adjust in Copilot Studio that might differ from Postman? Could the issue be with how the Body is formatted, or is there something else I should check with the request setup?

Content-Type: application/json

Authorization: Bearer <token>
X-Snowflake-Authorization-Token-Type: KEYPAIR_JWT

{
    "messages": [
        {
            "role": "user",
            "content": [
                {
                    "type": "text",
                    "text": "find client TEST"
                }
            ]
        }
    ],
    "semantic_model_file": "@DB.SCHEMA.STAGE/SEMANTICFILE.yaml"
}


Yaml Portion:
 

            - kind: HttpRequestAction
              id: Ym4X1Z
              displayName: CortexREST
              method: Post
              url: =Topic.CortexAPIEndpoint
              headers:
                Authorization: Bearer ey...
                Content-Type: application/json
                X-Snowflake-Authorization-Token-Type: KEYPAIR_JWT

Any insights or troubleshooting steps would be greatly appreciated!

Thanks!
 

Categories:
General
CortexAPIRest.png
  • Verified answer
    LuisAznar Profile Picture
    LuisAznar 69 on at
    POST request to Snowflake Cortex API not working in Copilot Studio, but works in Postman
    When calling a Power Automate cloud flow from Copilot Studio and passing a parameter that includes a reserved character like @, you'll need to escape it. A simple workaround is to wrap the parameter value with the string() function, such as string("@mydb"), to avoid conflicts with the reserved character. Once escaped, you can include this in the body of your POST request. This method allows you to safely send the parameter to the flow, and then you can process the response in Copilot Studio as needed.
    PAReserverdCharac...
  • LuisAznar Profile Picture
    LuisAznar 69 on at
    POST request to Snowflake Cortex API not working in Copilot Studio, but works in Postman
    I detected the issue and is related to trying to pass a value that starts with 'at' symbol. Here is my YAML action

    This variable (Topic.SemanticModelFilePath) needs to have this structure 
    "@my_stage/my_semantic_model.yaml"
     
    How can I set this value inside the JsonRequestContent?
        - kind: HttpRequestAction
          id: IlwYeW
          method: Post
          url: https://<baseUrl>/api/v2/cortex/analyst/message
          headers:
            Accept: application/json
            Authorization: =Topic.BearerTokenSF
            Content-Type: application/json
            X-Snowflake-Authorization-Token-Type: KEYPAIR_JWT
     
          body:
            kind: JsonRequestContent
            content: |-
              ={
                  messages: [
                      {
                          role: "user",
                          content: [
                              {
                                  type: "text",
                                  text: Topic.InputValue
                              }
                          ]
                      }
                  ],
                  semantic_model_file: Topic.SemanticModelFilePath
              }
  • Suggested answer
    Artur Stepniak Profile Picture
    Artur Stepniak 1,521 Super User 2025 Season 1 on at
    POST request to Snowflake Cortex API not working in Copilot Studio, but works in Postman
    Hello,
     
    I cannot help you, because I don't see the whole YAML action. BadRequest usually suggests that something is wrong within the request body. You should check it out and make sure that it's correctly formatted.
     
    In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.

    Best regards,

    Artur Stepniak
    Interested in GenAI? Visit my site!
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,681 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans