AnsweredAssumed Answered

Updating record with xml?

Question asked by kamal1234 on Apr 14, 2016
Latest reply on Apr 14, 2016 by beverly

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

Outcomes