Question:
I have set up a FMP file to make the SOAP call, to our server and it returns the XML with the data that I need. If I make the SOAP call to the server and there are 10 records for 10 patients with different names that get returned from the server, then all of this data is returned in the same XML.
If I then run the FmNx_XPATH_query to get the data out of the XML, using parameters like this:
(BBdemoSoap::result ; "//reportsns:ParentReader__FirstName" ; "true" ; BBdemoSoap::response_xml_namespaces ),
it will then put all the patient names in the same field, because all the patient names has the same tag in the XML.
I would like to able to put each of the names that were returned in the XML in a seperate field. Is this possible or is there a way to have the XML broken down in to separate fields for each patient?
Answer:
When you get back your list you can use MiddleValue (a FileMaker function to return to you each one individually and thus you can create individual records).
Set up a mini loop to loop over all the values till you have moved each one into your database.
/groups/ws/search/index.rss?tag=hotlist/groups/ws/search/?tag=hotWhat’s HotHotListHot!?tag=hot0/groups/ws/sidebar/HotListNo items tagged with hot.hot/groups/ws/search/index.rss?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomelist/groups/ws/search/?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomeRecent ChangesRecentChangesListUpdates?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcome0/groups/ws/sidebar/RecentChangesListmodifiedDateallRecent ChangesRecentChangesListUpdateswiki/welcomeNo recent changes.reverse5search
Web Services
Comments