Retrieve Opportunities with Quotes (nested filtering)

POST {{url}}{{rest_endpoint}}/Opportunities/filter

Request Body

{"filter"=>[{"date_modified"=>{"$gte"=>"2024-01-31 00:00:00"}}, {"sales_status"=>{"$equals"=>"Closed Won"}}], "fields"=>["id", "sync_key", "name", "date_entered", "sales_status", "accounts", "revenuelineitems", "quotes", {"name"=>"accounts", "fields"=>["id", "sync_key", "name", "date_entered", "shipping_address_street", "shipping_address_street_2", "shipping_address_city", "shipping_address_state", "shipping_address_country", "shipping_address_postalcode", "syspro_salesperson_c"], "order_by"=>"date_modified:desc"}, {"name"=>"revenuelineitems", "fields"=>["id", "sync_key", "name", "date_entered", "rli_templates_link", {"name"=>"rli_templates_link", "fields"=>["id", "name", "sync_key"], "order_by"=>"date_modified:desc"}], "order_by"=>"date_modified:desc"}, {"name"=>"quotes", "fields"=>["id", "sync_key", "quote_num", "quote_stage", "name", "shipping_contact_name", "date_entered", "date_quote_expected_closed", "currency_id", "products", {"name"=>"products", "fields"=>["id", "sync_key", "date_entered", "category_name", "quantity", "cost_price", "discount_price", "revenuelineitems", "product_templates_link", {"name"=>"revenuelineitems", "fields"=>["id", "sync_key", "name", "date_entered"], "order_by"=>"date_modified:desc"}, {"name"=>"product_templates_link", "fields"=>["id", "name", "sync_key"], "order_by"=>"date_modified:desc"}], "order_by"=>"date_modified:desc"}], "filter"=>[{"quote_stage"=>{"$equals"=>"Closed Accepted"}}], "order_by"=>"date_modified:desc"}], "order_by"=>"date_modified:desc"}

HEADERS

KeyDatatypeRequiredDescription
OAuth-Tokenstring