Get request not filtering in zapier but works in postman
I’m sending a GET request to retrieve all invoices sent on a particular date. I’m receiving all invoices sent, ever. I tried this in Postman and successfully retrieved only invoices sent on a particular date.
And the results: notice the total of 409. This should retrieve only 2 invoices.
And a screenshot from Postman. Note the total: 2.
Page 1 / 1
Hi @Sigurdur130
Try moving the Query string parameters in the URL value after the ? to be set under the Query String Params section.
@Sigurdur130
Also, your date format is wrong, and should be: YYYY-MM-DD
If a GET request is working in Postman but not filtering correctly in Zapier, it may be due to differences in how each platform handles parameters, authentication, or response parsing. In Postman, you have full control over request headers of post, query parameters, and can test responses directly. Zapier, on the other hand, relies on pre-configured settings that may not always interpret filters or parameters the same way.
@Troy Tessalone , thanks for your answer! I got it to work, though not...entirely how you suggested. I updated the params as per your recommendation, and this time the request ignored the perpage and page params, as well as the dateFrom param.
Since it respected the perpage and page params when they were in the URL, I tried adding ALL my params into the URL directly, leaving the param fields blank. Lo and behold! Worked like a charm.
So yeah, this ended up working. Bugger me if I understand how or why, though.
@finley97544d , thanks for your answer as well! It’s good to get a bit of a theoretical explanation of the cause, as well.