Multiple Grids in the Same Request

The example below returns the individual email addresses corresponding to an open action taken by the recipients of a published mailing. This document would be used after having requested and then receiving a response for MailingInstance. This example also shows how two requests can be made in a single document.

Request

<GridRequest xmlns="http://partner.informz.net/aapi/2009/08/">
 <Password>password</Password>
 <Brand id="9999">Test Brand</Brand>
 <User>testuser</User>
 <Grids>
  <Grid type="mailing_activity_opens">
   <Conditions>
    <Condition>
     <Single>
      <DataElement>Mailing_Instance_ID</DataElement>
      <DataValue>478922</DataValue>
      <Comparator>EQ</Comparator>
     </Single>
    </Condition>
    <Condition>
     <Single>
      <DataElement>Email</DataElement>
      <DataValue>gulliver@yahoo.com</DataValue>
      <Comparator>EQ</Comparator>
     </Single>
    </Condition>
   </Conditions>
   <ReturnFields>
    <DataElement>Open_Date</DataElement>
   </ReturnFields>
   <SortField order="asc">Open_Date</SortField>
   <StartRow>1</StartRow>
   <NumberOfRows>50</NumberOfRows>
  </Grid>
  <Grid type="mailing_activity_clicks">
   <Conditions>
    <Condition>
     <Single>
      <DataElement>Mailing_Instance_ID</DataElement>
      <DataValue>478922</DataValue>
      <Comparator>EQ</Comparator>
     </Single>
    </Condition>
    <Condition>
     <Single>
      <DataElement>Email</DataElement>
      <DataValue>gulliver@yahoo.com</DataValue>
      <Comparator>EQ</Comparator>
     </Single>
    </Condition>
   </Conditions>
   <ReturnFields>
    <DataElement>Link_Name</DataElement>
    <DataElement>Link</DataElement>
    <DataElement>link_date</DataElement>
   </ReturnFields>
   <SortField order="asc">link_date</SortField>
   <StartRow>1</StartRow>
   <NumberOfRows>50</NumberOfRows>
  </Grid>
 </Grids>
</GridRequest>