Release r202606
What's new
This release contains the following new or changed functionality:
- External database support for sql()
- Absolute URLs in HTTP request functions
- Improved package creation flow
- HTTP and REST account types unified
In addition to these changes, this release contains a large number of internal improvements to the automator. These improvements do not change any functionality, but they pave the way for important upcoming features, such as increased insight in and control over package executions.
External database support for sql()
The sql() function can now work with
external databases in addition to the built-in in-memory database. By calling
db_use() with the name of a MySQL
account, all subsequent sql() calls are executed against that external
database.
To use this, create an account of type "MySQL" with the connection details for your database.
db_use("mysql-account");
let rows = sql("SELECT * FROM customers WHERE active = ?", 1);
log("customers", rows);
For more information, see the (improved) database function documentation.
Absolute URLs in HTTP request functions
The http_request(),
http_request_file(), and
http_stream_file() functions
now support absolute URLs. Previously, the URL provided in the options was
always appended to the account's endpoint URL. Now, if the URL starts with
http:// or https://, it is used as-is without prepending the account
endpoint.
This is useful, for example, when working with pre-signed URLs from cloud storage services like S3.
let options = {
url: "https://my-bucket.s3.amazonaws.com/files/report.pdf",
method: "GET",
};
let result = http_request_file(options, "http-account");
Improved package creation flow
When creating a new package, you are now prompted to enter the package name first. This way, you can name your package upfront and then focus on writing the script, without later having to switch to the Settings tab to change the default name.
HTTP and REST account types unified
The REST account type has been merged into the HTTP account type. Existing REST
accounts are automatically converted to HTTP accounts with the Content type
field set to application/json.
All REST functions continue to work as before — no changes to existing packages are needed.
Timeline
The deployments of the release will be performed on
| Environment | Date |
|---|---|
| Demo | Friday, February 28th |
| Production | Thursday, March 12th |
The deployment of the Production environments will be conducted outside of office hours (Central European Time Zone).