Basic curl Query API with quoted string

[issmith (Ian)]

Hi Im attempting a basic command to test and get used to the API using https://reqbin.com/curl, I am posting the following curl and getting a 400 (Bad Request) error the issue appears to be with the enclosed strings “Postcode”, “N221RW” and appears to be with the double quotes I have tried escaping with " and various other symbols but unable to get it to work, can someone assist me? Thanks

curl -X POST -H “Content-Type:application/json” -H “Authorization:xxxxxxxxxxx” -d ‘{“query”:“{items_by_column_values (board_id: 114768112, column_id: “Postcode”, column_value: “N221RW”) {id}}”}’ “https://api.monday.com/v2/”

[dsilva (Daniel Silva)]

Hey @issmith - welcome to the community!

Could you confirm that the columnID above is valid? Usually in the interface you’ll see something like this saying “text” or whatever the column type may be:

-Daniel

[issmith (Ian)]

Thanks, yes it was different however I changed it to text9 and it still didnt work although I got the same string working in power automate, so maybe some limitation with reqbin

[dsilva (Daniel Silva)]

Understood @issmith - let me know if we can help with anything else.

-Daniel