Alternatively, you can provide the process table and subtable data when starting a new instance by using the XML format and the JRJOBIMPORTXML table.
The following table shows the structure of the JRJOBIMPORTXML table:
Column name |
Data type |
Description |
|
|---|---|---|---|
task_id |
(N)VARCHAR(50) |
A unique ID is needed for the link to the respective entry in the column task_id of the JRJOBIMPORT table. |
Required field |
xmldata |
(N)VARCHAR(MAX) |
Import data for process table and subtable in XML format |
Required field |
This is especially helpful if it is not possible to read the subtable data from a database table. The XML structure is pictured below. The individual values can also be transmitted Base64 encoded. In that case the base64encoded field has to be set true.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<JobRouterImport>
<fieldgroup name="processtable">
<field name="MAIL_ADDRESS" value="max.mustermann@jobrouter.de" base64encoded="false" />
<field name="MAIL_SUBJECT" value="AW: Support Request No.: JRS-11111" base64encoded="false" />
</fieldgroup>
<fieldgroup name="subtables">
<fieldgroup name="subtable" value="EMAIL_ANHAENGE">
<row id="1">
<field name="description" value="Screenshot 1" base64encoded="false" />
<field name="attachment" value="\\fileshare\\image001.jpg" base64encoded="false" />
</row>
<row id="2">
<field name="description" value="Screenshot 2" base64encoded="false" />
<field name="attachment" value="\\fileshare\\image002.jpg" base64encoded="false" />
</row>
</fieldgroup>
<fieldgroup name="subtable" value="MISC">
<row id="1">
<field name="text" value="dGV4dCBpbiBiYXN1NjQ=" base64encoded="true" />
</row>
</fieldgroup>
</fieldgroup>
</JobRouterImport>
Please note: If you use XML to pass the data, the values in the insstring and subtable_insstring columns are ignored.
