AnsweredAssumed Answered

Import Records (http and httppost) limitation

Question asked by 5104117733 on Dec 6, 2013
Latest reply on Apr 2, 2014 by philmodjunk

Summary

Import Records (http and httppost) limitation

Product

FileMaker Pro

Version

13

Operating system version

MacOs Mavericks

Description of the issue

Using the script step "Import Records" using httppost does not execute (returns error 717).
it works fine when the posted data is short enough, but it breaks when you try to post longer data.

Steps to reproduce the problem

• create a script
• add "import record" script step
• set options:
   • specify datasource: xml data
   • specify xml datasource: Calculation:
"httppost://anyurl.com/api?d=WyAJCXsic3luY19pZCI6ICJCN0RBMzJFOS01MkQyLTREOTItQUFCNS0zMjJBQTMxMjM5NjAiLCAiaWQiOiAiNDk2OCIsICJ0aW1lc3RhbXAiOiAiNC4xMi4yMDEzIDk6NTM6MzYgVWhyIiwgImRhdGUiOiAiMjIuMTEuMjAxMyIsICJ0aW1lX3N0YXJ0IjogIiIsICJ0aW1lX3N0b3AiOiAiIiwgInRpbWVfZHVyYXRpb24iOiAiLjYiLCAiZmtfdXNlcl9pZCI6ICIiLCAiZmtfcHJvamVjdF9pZCI6ICIiLCAiZmtfYWRkcmVzc19pZCI6ICIiLCAiZmtfYXJ0aWNsZV9pZCI6ICIiLCAibm90ZXMiOiAiVGVzdCBOb3RpejwvYnI+IiwgInN5bmNoc3RhdGUiOiAicHJvZyIgfSAsIAkJeyJzeW5jX2lkIjogIjBFRjk2MDU0LUExQjktNEE1My1CODJBLTNBNzk1NjkwMTVEMiIsICJpZCI6ICI0OTY5IiwgInRpbWVzdGFtcCI6ICI2LjEyLjIwMTMgMDowMDowMyBVaHIiLCAiZGF0ZSI6ICIyMi4xMS4yMDEzIiwgInRpbWVfc3RhcnQiOiAiIiwgInRpbWVfc3RvcCI6ICIiLCAidGltZV9kdXJhdGlvbiI6ICIyIiwgImZrX3VzZXJfaWQiOiAiIiwgImZrX3Byb2plY3RfaWQiOiAiIiwgImZrX2FkZHJlc3NfaWQiOiAiIiwgImZrX2FydGljbGVfaWQiOiAiIiwgIm5vdGVzIjogImludGVybiBCdWVybyBOb3RpeiIsICJzeW5jaHN0YXRlIjogInByb2ciIH0gLCAJCXsic3luY19pZCI6ICI2QkZEMTA2Qy00OTkzLTQ4RDEtODhDNy00QjhBRjU5NkE4NzUiLCAiaWQiOiAiNDk3MCIsICJ0aW1lc3RhbXAiOiAiMjIuMTEuMjAxMyAxNjo0NjozNiBVaHIiLCAiZGF0ZSI6ICIyMi4xMS4yMDEzIiwgInRpbWVfc3RhcnQiOiAiIiwgInRpbWVfc3RvcCI6ICIiLCAidGltZV9kdXJhdGlvbiI6ICIuNzUiLCAiZmtfdXNlcl9pZCI6ICIiLCAiZmtfcHJvamVjdF9pZCI6ICIiLCAiZmtfYWRkcmVzc19pZCI6ICIiLCAiZmtfYXJ0aWNsZV9pZCI6ICIiLCAibm90ZXMiOiAiRXJidm9yYmV6dWcsIE5vdGl6IiwgInN5bmNoc3RhdGUiOiAicHJvZyIgfSAsIAkJeyJzeW5jX2lkIjogIjQ1QkMzNzI2LTM0MkEtNEYxNy04RDhELUQ5OEU3NjQzRkI2QyIsICJpZCI6ICI1MDM1IiwgInRpbWVzdGFtcCI6ICI2LjEyLjIwMTMgMTE6MTU6MjggVWhyIiwgImRhdGUiOiAiNi4xMi4yMDEzIiwgInRpbWVfc3RhcnQiOiAiIiwgInRpbWVfc3RvcCI6ICIiLCAidGltZV9kdXJhdGlvbiI6ICIiLCAiZmtfdXNlcl9pZCI6ICIiLCAiZmtfcHJvamVjdF9pZCI6ICIiLCAiZmtfYWRkcmVzc19pZCI6ICIiLCAiZmtfYXJ0aWNsZV9pZCI6ICIiLCAibm90ZXMiOiAiYWEiLCAic3luY2hzdGF0ZSI6ICJwcm9nIiB9ICwgCQl7InN5bmNfaWQiOiAiQjk4RjUzNDktQzM5My00OTU2LTg2OUQtMDBGMjNDOTgzRkQ0IiwgImlkIjogIjUwMzYiLCAidGltZXN0YW1wIjogIjYuMTIuMjAxMyAxMToxNTozMCBVaHIiLCAiZGF0ZSI6ICI2LjEyLjIwMTMiLCAidGltZV9zdGFydCI6ICIiLCAidGltZV9zdG9wIjogIiIsICJ0aW1lX2R1cmF0aW9uIjogIiIsICJma191c2VyX2lkIjogIiIsICJma19wcm9qZWN0X2lkIjogIiIsICJma19hZGRyZXNzX2lkIjogIiIsICJma19hcnRpY2xlX2lkIjogIiIsICJub3RlcyI6ICJ2dnZ2IiwgInN5bmNoc3RhdGUiOiAicHJvZyIgfSAsIAkJeyJzeW5jX2lkIjogIjIyQ0E3NkY1LUU5NTUtNDVDQy05MTU0LTQ3QTcxMDRDNTNGMSIsICJpZCI6ICI1MDM3IiwgInRpbWVzdGFtcCI6ICI2LjEyLjIwMTMgMTE6NDg6NDAgVWhyIiwgImRhdGUiOiAiNi4xMi4yMDEzIiwgInRpbWVfc3RhcnQiOiAiIiwgInRpbWVfc3RvcCI6ICIiLCAidGltZV9kdXJhdGlvbiI6ICIiLCAiZmtfdXNlcl9pZCI6ICIiLCAiZmtfcHJvamVjdF9pZCI6ICIiLCAiZmtfYWRkcmVzc19pZCI6ICIiLCAiZmtfYXJ0aWNsZV9pZCI6ICIiLCAibm90ZXMiOiAic3NzIiwgInN5bmNoc3RhdGUiOiAicHJvZyIgfSAsIAkJeyJzeW5jX2lkIjogIjIwQ0QzQTQ5LTRCOTItNEM3QS05NzAxLTk5Mzc5RkU3NjM2QSIsICJpZCI6ICI1MDM4IiwgInRpbWVzdGFtcCI6ICI2LjEyLjIwMTMgMTE6NDg6NDIgVWhyIiwgImRhdGUiOiAiNi4xMi4yMDEzIiwgInRpbWVfc3RhcnQiOiAiIiwgInRpbWVfc3RvcCI6ICIiLCAidGltZV9kdXJhdGlvbiI6ICIiLCAiZmtfdXNlcl9pZCI6ICIiLCAiZmtfcHJvamVjdF9pZCI6ICIiLCAiZmtfYWRkcmVzc19pZCI6ICIiLCAiZmtfYXJ0aWNsZV9pZCI6ICIiLCAibm90ZXMiOiAiZGRkIiwgInN5bmNoc3RhdGUiOiAicHJvZyIgfSAsIAkJeyJzeW5jX2lkIjogIjg3OUI2MDgzLTk3QUUtNDg4NS1CNzBGLURERkE4Nzc4NjZDNiIsICJpZCI6ICI1MDM5IiwgInRpbWVzdGFtcCI6ICI2LjEyLjIwMTMgMTE6NDg6NDQgVWhyIiwgImRhdGUiOiAiNi4xMi4yMDEzIiwgInRpbWVfc3RhcnQiOiAiIiwgInRpbWVfc3RvcCI6ICIiLCAidGltZV9kdXJhdGlvbiI6ICIiLCAiZmtfdXNlcl9pZCI6ICIiLCAiZmtfcHJvamVjdF9pZCI6ICIiLCAiZmtfYWRkcmVzc19pZCI6ICIiLCAiZmtfYXJ0aWNsZV9pZCI6ICIiLCAibm90ZXMiOiAiY2NjYyIsICJzeW5jaHN0YXRlIjogInByb2ciIH0gXQ=="

( whereas the data sent is a base64 encoded json object! )

• run script

Expected result

The "import records" request should post the parameter "d" to "http://anyurl.com/api" and import the received xml into a specified table.

Actual result

• Nothing is sent to the server (debugged the incoming traffic there as well)
• No records get imported

Exact text of any error message(s) that appear

The script step returns the error 717

Workaround

THERE IS NO WORKAROUND!!

please fix this.
(POST request lengths are not limited, as the data is sent within the header)
(GET requests are nowadays limited around 2500 characters, but it depends on the server)

Outcomes