Weird behaviour of the Get request node

Hello,

I have noticed a strange behaviour of the Get-Request node.
I’m calling the productive API to get some CRM data (so I can’t share an example).

https://developer.productive.io/deals.html#deals

I want to retrieve some deal information, specifically the deal status ID. Below, I’ll show you three API calls that should return the same deal status ID for the respective company – but they don’t.

https://api.productive.io/api/v2/deals/123456?include=creator,company,deal_status,lost_reason,next_todo,contact,responsible&page[number]=1&page[size]=10 → deal status correct

https://api.productive.io/api/v2/deals/?include=creator,company,deal_status,lost_reason,next_todo,contact,responsible&page[number]=1&page[size]=10 → deal status missing

https://api.productive.io/api/v2/deals/?include=creator,company,deal_status,lost_reason,next_todo,contact,responsible&page[number]=10&page[size]=30 → deal status wrong

If I use the exact same API calls in Postman, I get the same result three times. So the problem must be in the GET request node — or am I wrong?

Thank you

Hello,
it is difficult to say without example, and without knowledge on this API in general. A few questions to understand this better and to rule out other mistakes:

  1. what is the significance of “123456” in the first query? Is this defining the company? Because I don’t see it in the other two queries.
  2. How do you define the queries in the GET Request node? I see that you use a variable input, but with this you can only use one query at a time. You could also use a table with all queries as the input table, which will return all queries at the same time.
  3. Can you provide a dummy example how the result looks like, both for KNIME and Postman (not with real data, just to know if other values are the same, and only the deal status ID is changed)? Are there several items returned? If yes, maybe there is a different sorting of the returned data?
1 Like