Enters the content from a URL into a field or variable.
•Verify SSL Certificates verifies the SSL certificate of the server specified in the URL. If the certificate cannot be verified, users can choose to connect anyway or cancel to skip this script step. If the certificate cannot be verified and the Set Error Capture script step is set to On, Insert From URL behaves as if the server were unavailable.
•Select entire contents replaces the contents of a field or variable. If you don’t select this option:
•For a field, replaces only the selected portion of the active field, or inserts data at the insertion point. The default insertion point is at the end of the field's data.
•For a variable that doesn’t have container data, inserts data at the end of the variable’s current value. For a variable that has container data, replaces the contents of the variable.
•With dialog specifies whether to display the "Insert from URL" Options dialog box when the script step is performed.
•Target specifies the field or variable to insert the URL content into. If the variable doesn’t exist, this script step creates it (see Using variables).
•Specify URL allows you to type the URL or to create your URL from a calculation.
•Automatically encode URL replaces special characters with the corresponding encoded values required for URLs. For example, a space character is replaced with %20. When this option is deselected, the URL remains as it is entered. cURL options are not encoded.
•Specify cURL options allows you to enter one or more supported cURL options as a calculation. See Supported cURL options.
Product | Supported |
FileMaker Pro Advanced | Yes |
FileMaker Go | Yes |
FileMaker WebDirect | Yes |
FileMaker Server | Yes |
FileMaker Cloud | Yes |
FileMaker Data API | Yes |
Custom Web Publishing | Yes |
Runtime solution | Partial |
FileMaker Pro 12.0
Insert From URL supports http, https, ftp, ftps, and file protocols. FileMaker Pro Advanced downloads the resource that is specified by the URL to a variable or a field.
You must specify a target variable, specify a target field on the current layout, click in a field, or use the Go to Field script step before performing this script step. If Target is not specified, the data is placed in the active field. Otherwise, this script step returns an error code that can be captured with the Get(LastError) function.
For a list of picture and audio/video formats supported in container fields, see Using data in container fields.
Important For better performance in FileMaker WebDirect, be sure that Select entire contents is selected when the target is a field.
•Insert From URL supports only UTF-8 for Specify URL. However, for Specify cURL options, you can control the character encoding of parameters in cURL options. See Supported cURL options.
•When Target is a variable, data is normally stored as text. To store as container data, specify the cURL option described in Supported cURL options.
•To control how long this script step waits for a response from the server, specify a value for the --max-time cURL option.
•Specify cURL options is not supported in runtime solutions.
•In FileMaker WebDirect:
•If the With dialog option is On, this script step performs as if Automatically encode URL is selected.
•If Select entire contents is deselected, and Insert From URL inserts content into a text field, the contents from the URL are appended to the text field. Multiple fetches can result in unpredictable results and slower performance.
•The file protocol:
•is not supported in FileMaker WebDirect, the FileMaker Data API, and Custom Web Publishing
•can be used in server-side scripts only to refer to files in the Documents or temporary folder (see Paths in server-side scripts)
Accesses a website and inserts a PDF into the Sales Report container field.
Insert from URL [With dialog: Off; Customers::Sales Report; "http://www.filemaker.com/sales_report.pdf"]Inserts a map showing the customer's address in the Address Map container field.
Insert from URL [With dialog: Off; Customers::Address Map; "http://maps.google.com/maps/api/staticmap?center=" & Customers::Address & "&zoom=14&markers=" & Customers::Address & "&size=256x256&sensor=false"]Inserts the HTML code for http://www.apple.com.
Insert from URL [With dialog: Off; Customers::HTML Website Code; "http://www.apple.com"]Uses the cURL options --user and --upload-file to upload a file from a container field to a server using the credentials myusername and mypassword, and stores any results from the server in the variable $$results. For HTTP or HTTPS, the filename on the server will be the same as the filename in the container field.
Set Variable [ $file ; Value: table::container ]
Insert from URL [Verify SSL Certificates; With dialog: Off; $$results ;
"https://www.filemaker.com/uploads";
"--user myusername:mypassword --upload-file $file
--header \"Content-type: image/png\""]