how do you fetch an Opportunity's Opportunity Products?


  • Why doesn't this fetch work?

    <fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
      <entity name='opportunityproduct'>
        <attribute name='productid' />
        <attribute name='productdescription' />
        <attribute name='priceperunit' />
        <attribute name='quantity' />
        <attribute name='extendedamount' />
        <attribute name='opportunityid' />
        <attribute name='opportunityproductid' />
        <order attribute='productid' descending='false' />
        <filter type='and'>
          <condition attribute='opportunityid' operator='eq' uiname='Test 02' uitype='opportunity' value='{9BAA4EE2-A2E5-E211-9CA2-AC162DB4ACAE}' />

    Friday, July 12, 2013 12:45 PM


  • I nested the filter in a linkentity and fixed it, but I was working with bad data so it may work like this as well.
    • Marked as answer by mardukes Saturday, July 13, 2013 12:16 AM
    Saturday, July 13, 2013 12:16 AM