Query issue in Power Query vs Monday Playground

Platform discussions monday apps & integrations
1

Hi,

I have an issue with Power Query and Monday API. The below query works perfectly in monday.com/apps/playground but it returns an error 500 when I place it in Power Query.

Power Query code (note that I set the double quotes to create a proper string):

url="https://api.monday.com/v2",
content="{""query"":""{items_by_multiple_column_values(limit: 1 board_id: 000000000 column_id: ""status07"" column_values: ""ACTIVE"") {id name updated_at group {id title} column_values {title text}}}""}",
...

In playground:
{
items_by_multiple_column_values(
limit: 1
board_id: 000000000
column_id: “status07”
column_values: “ACTIVE”
) {
id
name
updated_at
group {
id
title
}
column_values {
title
text
}
}
}

I just can’t figure out what’s wrong! Can someone help me please, thank you! :slight_smile: