Skip to main content
Best answer

Get request not filtering in zapier but works in postman

  • October 11, 2024
  • 4 replies
  • 33 views

Sigurdur130
Forum|alt.badge.img+1

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.

Why isn’t it working in Zapier?

API Documentation: https://apidoc.payday.is/#7114bb47-1d43-41b5-a3cf-627018f3a83c

Here are a couple of screenshots of my set-up.

I’m confident about the date formatting because I literally copy/pasted it from Postman, where it worked

And the results: notice the total of 409. This should retrieve only 2 invoices.

The paid/unpaid amounts look huge until you realise it’s not in dollars

And a screenshot from Postman. Note the total: 2. 

 

Best answer by Sigurdur130Best answer by Sigurdur130

@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.

Total: 2 is exactly what I was after!

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. 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • October 11, 2024

Hi @Sigurdur130 

Try moving the Query string parameters in the URL value after the ? to be set under the Query String Params section.

 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • October 11, 2024

@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.

 


Sigurdur130
Forum|alt.badge.img+1
  • Author
  • Beginner
  • 28 replies
  • Answer
  • October 12, 2024

@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.

Total: 2 is exactly what I was after!

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.