AnsweredAssumed Answered

Return Text file of field values of multiple Records via URL

Question asked by user17418 on Oct 22, 2012

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

Outcomes