web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
I have the same question (0)
  • 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,528 Super User 2025 Season 2 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

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 385 Super User 2025 Season 2

#2
trice602 Profile Picture

trice602 146 Super User 2025 Season 2

#3
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 144 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans