Messages

1

General Board / Re: Dumping a production database into a staging environment - recommendations

« on: September 25, 2025, 09:26:24 pm »

We do that by option "Full Project Transfer via Native XML -> Export Complete Project" under "Settings -> Model -> Transfer".
This will export all tables from the database as-is to local xml files.
Then you can import these by "Import Complete Project".
However, you need to do something manually, to change your security settings, as it will also copy the security tables as-is.
This is much faster than regular Package Export function.

PS another much faster option is to do an SQL-dump to a local file, then import these in the other stage(s). This is even much faster than the process above.

2

Automation Interface, Add-Ins and Tools / Re: How to use Fetch() for JSON REST API calls?

« on: September 18, 2025, 08:18:51 pm »

You can simulate the fetch command with the following JavaScript example:

Code: [Select]

const http2 = new COMObject("MSXML2.ServerXMLHTTP");
http2.setTimeouts(15000, 15000, 15000, 900000);
http2.setProxy(2,"http://localhost:9000","");
http2.open("POST", url, false); // Use "true" for async
http2.setRequestHeader("Content-Type", "application/json");
http2.setRequestHeader("Authorization", "Bearer " + OPENAI_API_KEY);
http2.send(JSON.stringify(body));

if (http2.status == 200) {
Session.Output(http2.responseText);
} else {
 Session.Output("Error: " + http2.status + " - " + http2.statusText);
}