10 Replies Latest reply on May 14, 2010 9:45 AM by Mark Lindberg

    Assistance with Query for Multiple Rows as XML mapping

    Mark Lindberg Level 2

      Greetings:

      I am trying to use the Query for Multiple Rows service to populate a schema that is not 'Flat' in the repeating node.

      I have used this service successfully when all elements to be populated are at the same level.

      I hope someone can tell me how to enter the mappings in the XML Information panel of the service operation.

       

      I have tried 'ATTRIBS/appt_req', and various other formats I could think of for mapping to the proper element name, but I always get XML errors.

       

      ACTIVES is the root, and ACTIVE is the repeating node.

      ATTRIBS does not repeat within ACTIVE.

       

      I am including a sample of the schema I am trying to load, and I can get data into the ACTIVES/ACTIVE level, but I have not been able to address to the ACTIVES/ACTIVE/ATTRIBS elements

       

      I will also have to figure out how to deal with the KEYWORDS node at some point.

       

      Thank You

      Mark

       

        <ACTIVES>
          <ACTIVE>
            <template_key>tkey1</template_key>
            <id>INSTLP0001a</id>
            <ver>1.2</ver>
            <ind_status>Inactive</ind_status>
            <last_mod_user>wade01</last_mod_user>
            <last_mod_dt>2010-19-04</last_mod_dt>
            <last_mod_tm>13:20:00-05:00</last_mod_tm>
            <flg_activate>0</flg_activate>
            <flg_attrib_change>string</flg_attrib_change>     
            <ATTRIBS>
              <appt_req>1</appt_req>
              <ref_md_req>1</ref_md_req>
              <site>CARDIO</site>
              <print_appt_card>1</print_appt_card>
              <send_ref_md_lttr>1</send_ref_md_lttr>
              <no_remind_lttr>1</no_remind_lttr>
              <area_code>612</area_code>
              <phone_prefix>619</phone_prefix>
              <dflt_pcc_notes>This is a test for Template 01 v1.2</dflt_pcc_notes>
              <flag_direct_prn></flag_direct_prn>
            </ATTRIBS>
            <KEYWORDS>
              <KEYWORD>
                <keyword>key 1 v1.2</keyword>
              </KEYWORD>
              <KEYWORD>
                <keyword>key 2 v1.2</keyword>
              </KEYWORD>
              <KEYWORD>
                <keyword>key 3 v1.2</keyword>
              </KEYWORD>
            </KEYWORDS>     
          </ACTIVE>   
        </ACTIVES>

       

      TEMPLOAD.JPG