News and Announcements icon

Power Platform CommunityForums Copilot Studio - General How to dynamically con...

Copilot Studio - General

Answered

How to dynamically construct the json payload correctly and send send it with HTTP Request

(0) Share

Report

Report

Posted on by Gosh

26

I want to construct a json object in my Copilot chat bot (former PVA) with the following structure:

{

 "messages": [
 {
 "role": "bot",
 "content": "message1"
 },
 {
 "role": "user",
 "content": "message2"
 }
 ]
}

The tricky part is that I want the strings message1 and message2 to be read from variables.

I tried to create a string and then parse it to json with a schema, but I had no luck with that.

I'll appreciate any suggestions and recommendations.

Thanks in advance

All responses Img

All responses (2)

Answers Img

Answers (1)

Gosh 26 on at

Like (0)

Report

Re: How to dynamically construct the json payload correctly and send send it with HTTP Request

Hi, Thank you for the response, but the problem I want to solve is vice versa. I need to get the value from a variable and apply it on the json object.
best regards
Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: How to dynamically construct the json payload correctly and send send it with HTTP Request

Hi @Gosh ,

I've made a test for your reference:

1\Add a 'Parse value' and set data type to 'From sample data'

2\Get schema form sample JSON

Result

3\Get first message

First(Topic.Var1.messages).content

4\Get last message

Last(Topic.Var1.messages).content

Best Regards,

Bof

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Leaderboard > Copilot Studio - General

#1

Romain The Low-Code... 25

#1

Pablo Roldan 25

#3

stampcoin 10

Overall leaderboard

Featured topics

Generative orchestration updates coming to Microsoft Copilot Studio! 

Please Read for Updates on Forums & Blogs

Tips & tricks for using the Power Virtual Agents Boost Conversational Coverage Preview

Product updates

Microsoft Power Platform Community release plans