Technical Details
The M3 Rest Connector is used to execute transactions in M3 via the M3-API-REST bulk API.
Available as a Connector Service as of Flow 6.14
Configuration
Url Required: URL to base address of REST API. Example: https://m3.yourdomain.com:7443
Additional path
Optional: addition to the URL, not including "m3api-rest". Example: If your M3 Rest API is at: "https://m3.yourdomain.com:7443/xyz/m3/m3api-rest/execute" Additional path would be: "/xyz/m3/" 'm3api-rest/execute' is always added/controlled by the connector.
Design time Authentication In this section, the authentication to be used when fetching metadata from the REST API is configured. User name (basic) and Password (basic) are used for Basic Authentication, as specified in RFC2617. The information in this section is only used while designing workflows in Flow Studio. It is never used in runtime. The user specified here must be allowed to run the transactions LstPrograms, LstTransactions, and LstFields in the program MRS001MI. In this section, there is also the possibility to accept any certificate from the server in an HTTPS session. This should only be used for test or development scenarios when no other option exists.
Runtime Authentication In this section, the authentication to be used when executing machine tasks is configured. User name (basic) and Password (basic) are used for Basic Authentication, as specified in RFC2617. In this section, there is also the possibility to accept any certificate from the server in an HTTPS session. This should only be used for test or development scenarios when no other option exists.
Logging In this section, logging is configured. Either incoming or outgoing or both can be logged. If something goes wrong in the communication, an entry is added to the file errorLog.txt. In order to enable logging, a valid path relative to the Flow Server must also be provided. Note that the path must already exist, the connector will not create the path. Also, note that the user that Flow Server is running as must have write-access to the path.
Get started
Press Select operation to select which transaction to execute.
Input
The input will of course depend on the transaction to execute. There is one common parameter that always is available though, readtimeoutmillis. In this parameter you can specify the amount of time to wait for response from job.
Another common feature for all transactions is the possibility to use an iterator. If you select a iterator it means that the transaction will be executed once for each row in the table specified as iterator. Using a iterator will change the output of the cogwheel to a table with the same number of rows as the iterator table, each row in the table is corresponding result of transaction execution for row in iterator table. You can of course map columns in iterator to parameters of transaction. Simply select an iterator, and for a parameter select I Iterator in dropdown menu for parameter and then select the suitable column of iterator table.
Output
Record (or table of records if iterator is used).
Member
Description
HttpStatusCode
The status code returned from REST API. Typically 200 if request (not necessarily transaction) was successful. 401 if not authorized etc.
ReasonPhrase
HTTP ReasonPhrase, if any
AllHeaders
Simple variable containing all headers (with line feed between each header) returned by REST API.
OK
A record containing result of transaction if it was successfully executed. Will be empty if transaction failed. - Program - Simple variable containing the program executed - Transaction - Simple variable containing the transaction executed - Records - A table containing the records (if any) returned by transaction. The columns of the table will of course depend on the transaction, but you can always choose not the request particular columns by unchecking the Included checkbox. By doing that, it will not be requested from the REST API, which could boost performance. You can also specify a row limit on Records (default 100).
Error
A record containing error information if transaction failed for some reason. Will be empty if transaction was successfully executed.
Note that if HttpStatusCode is 200, either OK or Error (never both) contains data. This can be used to take different paths in your workflow. Simply add a 'Decision Step' and add a script rule like transactionResults.Error != nil to check for errors.
Regional Formats (i.e. Culture)
Depending on what Region is set in Windows of the machine running Flow some numeric formats (and potentially other data types) may be affected. An example is the decimal symbol, some formats use a comma sign and some use the dot sign.
The connector expects dot as a separator, so if a region with a comma set as decimal symbol is selected for the operating system it can be overridden with a setting in Flow Server's web.config file. Under the systems.web tag, add a line with <globalization culture="en-US uiCulture="en-US" />. This will enforce en-US culture for Flow Server (not affecting clients nor users culture setting)
Last updated