XML import: connection with REST-APIs and user/password

[mheinzelmann]

Hello

 

Here is my problem:

Filemaker Server Adv v11.02, Server OSX 10.5.8, Client FM Adv 11.04

 

Using XML import, I would like to import data from a password-protected REST-API into my database solution. The database is on the server. Importing the xml data from a file from my harddisk with the appropriate xsl file is working fine, however, over http, it does not work. I tried the user:[email protected] method, but it did not work either (the user is an e-mail address and has an @ sign) and considering safety, this might not be a good method anyway. 

Is there a solution to this problem, i.e. import xml data over the internet (http) und integrate user and password? Is there a function, possibly ans external function of a plugin?

 

Thank you for your help

 

Michael Heinzelmann

[comment]

If the response is available through a GET http request, then it should work - you might have to URLEncode the parameters, though. Note that it will not work with the https protocol or the POST method. In such case you can use either AppleScript or a plugin (such as the free BaseElements plugin) to fetch the response.