Answered

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

(1) Share

Report

Posted on by LuisAznar

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:

Building Copilot Studio chatbots in Microsoft Teams

CortexAPIRest.png

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Artur Stepniak 1,539 Super User 2025 Season 2 on at

Like (1)

Report

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!

Was this reply helpful? Yes No
LuisAznar 69 on at

Like (0)

Report
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

}

Was this reply helpful? Yes No
Verified answer

LuisAznar 69 on at

Like (0)

Report

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...

Was this reply helpful? Yes No