0 Replies Latest reply on Oct 22, 2012 2:24 PM by AnswerFeedback_1

    Return Text file of field values of multiple Records via URL

    AnswerFeedback_1

      Title

      Return Text file of field values of multiple Records via URL

      Your post

            I would like to send a query to FileMaker 12 Server Advanced 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