By default, the API won't return future-dated data. BambooHR honors effective dates, so you are able to enter future changes without affecting the current data.
That being said, you can have the API return future-dated data by adding '&onlyCurrent=false' to the end of your API calls.
This would be great to have on this Workato function.
Send us a ticket, we will try our best to assist you with your problem