Discussions

Is it possible to pull WorkOrder and WoEstimate data together. In the documentation for WorkOrder Entity, it mentions Estimate, but when pulling base WorkOrder info, Estiamte (or an estimate Id) isn't included.

I can also pull all WoEstiamte via a post to base_url+'api/v1/query/WoEstimate'

But lets say I wanted all Open Work Orders and the WoEstimate data. I know how to write a query for all open work orders, but since WoEstiamte doesn't have WO status, I'd end up having to pull all WoEstimates and then outside of the API tie the 2 together via WorkOrderId.

This is an issue because there is a 4000 record limit.

To avoid hitting this limit for WoEstimate query, is it possible to write a query to WorkOrder entity and do sometime of join to include WoEstimate data in the request?
Thanks.