Zapier No query string was present

monday Apps & Developers No-Code (Zapier, Integromat, etc)
,
#1

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.

#2

Hello, @damercer6372!
Have you seen this link. Javascript looks pretty simple and seems there is no need to add double-quotes in the query itself.

1 Like
#3

Hey @damercer6372,
I suggest you to take a look at my reply to another thread at Problems with java post response.
I guess you need to slightly change your queries to prepend query command to the string.

1 Like
#4

Hey @damercer6372 :wave:

Have you been able to get this to work using the suggestions provided by the awesome @rob and @TMNXT-Dev? :slight_smile: Let us know!

-Alex