3 Replies Latest reply on Apr 14, 2016 9:52 AM by beverly

    Updating record with xml?

    kamal1234

      Dear Community members,

      What changes I should make to following xml sample file so instead of creating new record it will update an existing record based on id.

      I am using following sample for my understanding purpose.

       

      <?xml version="1.0" encoding="UTF-8" ?>

      <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

        <ERRORCODE>0</ERRORCODE>

        <PRODUCT BUILD="04-17-2014" NAME="FileMaker" VERSION="ProAdvanced 13.0v3"/>

        <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="Weather.fmp12" RECORDS="1" TIMEFORMAT="h:mm:ss a"/>

        <METADATA>

        <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="City" TYPE="TEXT"/>

        <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Temperature" TYPE="NUMBER"/>

        <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Humidity" TYPE="NUMBER"/>

        <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Wind Speed" TYPE="NUMBER"/>

        <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Wind Direction" TYPE="NUMBER"/>

        <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Clouds" TYPE="TEXT"/>

        </METADATA>

        <RESULTSET FOUND="1">

        <ROW MODID="1" RECORDID="1">

        <COL>

        <DATA>Alpharetta</DATA>

        </COL>

        <COL>

        <DATA>303.69</DATA>

        </COL>

        <COL>

        <DATA>40.2</DATA>

        </COL>

        <COL>

        <DATA>6.7</DATA>

        </COL>

        <COL>

        <DATA>170</DATA>

        </COL>

        <COL>

        <DATA>few clouds</DATA>

        </COL>

        </ROW>

        </RESULTSET>

      </FMPXMLRESULT>

       

      Thank you,

      Kamal