AnsweredAssumed Answered

Insert From URL Un-encodes some encoded values

Question asked by nickorr on Feb 26, 2013
Latest reply on Jul 7, 2013 by disabled_JustinClose

Summary

Insert From URL Un-encodes some encoded values

Product

FileMaker Pro

Version

FMPA 12.0v3

Operating system version

Mac OS 10.8.3

Description of the issue

When you're sending data to a Web Service using the Insert From URL step, you need to encode the data using GetAsURLEncoded first.

However, the script step is modifying the encoded data before sending it to the server, and this can either cause data issues or break the url.

For example this string :

http//my.web.service/url?field1=abc&field2=abc%26def

contains 2 fields.  One is "abc" and the other is "abc&def" but encoded to %26.  But the value that FMP is sending to the server is actually

http//my.web.service/url?field1=abc&field2=abc&def

Meaning that field2 gets the wrong value, and there's likely an issue with the non-existent "def" field.

FileMaker also unencodes commas and @ symbols.

Steps to reproduce the problem

Generate an Insert URL Script step from field data with &, @ or commas.

Check using a tcp dump tool, or server side logs to compare the calculated request with the request that fmp sends.

I can generate sample urls that you can send dummy data to if you'd like.

Expected result

FileMaker shouldn't alter the url before sending it, all encoding is the job of the developer.

Actual result

FileMaker modifies the url before sending it, but only for some values.

Exact text of any error message(s) that appear

NA

Configuration information

NA

Workaround

If you do not run the Web service at the other end, then there is no workaround until it's fixed.

Outcomes