I am trying to use items_by_column_values to search a board for a specific email. When I run the query through Postman a JSON I receivve the correct results. The JSON for the query is:
{"query": "{items_by_column_values (board_id: 312587506, column_id: \"email\",column_value: \"craig.warn@apmortgage.com\") {id name}}"}
Doing the same in Zapier always returns the “No query string was present” as the result. Here is the JSON I am passing from Zapier. It doesn’t seem to matter how I pass the query it always fails.
{"query": "{items_by_column_values (board_id: "312587506", column_id: "email",column_value: "craig.warn@apmortgage.com") {id name}}"} {"query": "{items_by_column_values (board_id: "\"312587506\"", column_id: "\"email\"",column_value: "\"craig.warn@apmortgage.com\"") {id name}}"} {"query": "{items_by_column_values (board_id: "312587506", column_id: "email",column_value: "craig.warn@apmortgage.com") {id name}}"}
I can’t seem to properly escape the double-quotes in zapier (Javascript). Please advise what I am doing wrong.