0 Replies Latest reply on Oct 22, 2012 12:37 PM by user17418

    Return Text file of field values of multiple Records via URL

    user17418

      I would like to send a query to FileMaker via a URL (no web page form involved)

      The resulting field values for each record found would then be placed into a text file.

       

      Start of Record

      <Time>[TimeFieldValue]</Time>

      <Date>[DateFieldValue]</Date>

      <Name>[FullNameFieldValue]</Name>

      <Title>[TitleFieldValue]</Title>

      <location>[LocationFieldValue]</location>

      <Misc>[OtherInfoFieldValue]</Misc>

      End of record

       

      The results in the Text File would look like this:

      <Record> <Time>1:00 PM</Time><Date>7/14/2012</Date><Name>John Smith</Name><Title>Owner</Title><location>Texas</location><Misc>Likes Baseball</Misc></Record>

      <Record> <Time>3:00 AM</Time><Date>3/6/2012</Date><Name>Chris Martin</Name><Title>Manager</Title><location>Texas</location><Misc>Pilot</Misc></Record>

      <Record> <Time>3:10 PM</Time><Date>5/2/2012</Date><Name>Chad Barton</Name><Title>Sales</Title><location>Ohio</location><Misc>Videographer</Misc></Record>

      <Record> <Time>1:40 PM</Time><Date>9/13/1992</Date><Name>Stacy House</Name><Title>VP</Title><location>Texas</location><Misc>Owns Cabin</Misc></Record>

      <Record> <Time>8:50 PM</Time><Date>10/18/2011</Date><Name>Kim Miller</Name><Title>Sales Manager</Title><location>New York</location><Misc>French</Misc></Record>

      <Record> <Time>12:00 PM</Time><Date>10/2/2012</Date><Name>Felix Unger</Name><Title>Marketing</Title><location>Texas</location><Misc>Rotary Member</Misc></Record>

      <Record> <Time>11:00 PM</Time><Date>1/22/2012</Date><Name>Tommy Miles</Name><Title>Janitor</Title><location>Texas</location><Misc>Works Late</Misc></Record>

       

      What implementation method would you suggest to do this?

      CDML did work, but is no longer supported.

      XML seems to only send back files predefined by FileMaker (which has a lot more text than I can handle)

      php - I can't seem to find how to send the URL command and on-the-fly URL query

       

      Suggestions?

       

      Thanks

      Zorba