How to Fill a DocuWare Table field via Make.com

Views:

Question:
How can I fill a DocuWare table field with Make.com?

Answer:
Please refer to the following guide to fill a DocuWare table field with Make.com;

Generating the Sample Table JSON

Add a DocuWare\Get Document Information module.
Enter the File Cabinet GUID (KBA-36863) and the DocID of a document that contains Table Data.
Run the Scenario, then click on the "thought bubble" that appears on the Module:

e DocuWare Get Document Information

Select Download Output Bundles.

DocuWare Initialization Operation 1 • INPUT @ Bundle I: Document ID: 2470 x Data size: 4.8 Kg Download input bundles Download output bundles File Cabinet/Dacument c2cd5dd8b900 Pruideable Fields:

Locate your Table Field. You can Ctrl+F for "ItemElementName": "Table"
Copy the structure of your Table Field. This will look different depending on the number of rows that the table you referenced has. In this example, I have 3 rows filled:

[
{
"TABLE_NAME": "NameValue1",
"TABLE_STATUS": "StatusValue1",
"TABLE_COMPANY": "CompanyValue1"
},
{
"TABLE_NAME": "NameValue2",
"TABLE_STATUS": "StatusValue2",
"TABLE_COMPANY": "CompanyValue2"
},
{
"TABLE_NAME": "NameValue3",
"TABLE_STATUS": "StatusValue3",
"TABLE_COMPANY": "CompanyValue3"
}
]

Using the Sample Table JSON

Add and connect to an Aggregate to JSON module and add a new Data Structure.
Under Specification, choose the Generate option and paste in the sample JSON you copied earlier:

Your table Columns should appear as individual items. If everything seems correct, save this step and leave the values empty for now.

Add data structure Data structure name My data structure Specification TABLE NAME Name TABLE_NAME 2 Name of the property. Type Text Default Default value. Required O Yes NO Multi-line O Yes NO TABLE STATUS Type: text TABLE COMPANY Type: text Add item Generate

Writing to DocuWare

Add a DocuWare\Update the Document Index Fields module and connect it to our previous JSON step.
Choose the File Cabinet and DocID of the document with the Table Field you'd like to fill. The available Index Fields should appear below.
Locate the Table Field you'd like to fill. Toggle the Update Field option to Yes and determine which option you'd like to use to fill this Table:

"Select" / Individual Rows
Useful if you only need to fill a fixed number of rows.

Note: Each "Item" is 1 entire row of the Table and must be in JSON format!
Here is an example - each cell is a separate "Item" and will generate 3 rows in DW:

{"TABLE_NAME":"NameValue1","TABLE_STATUS":"StatusValue1","TABLE_COMPANY":"CompanyValue1"}

{"TABLE_NAME":"NameValue2","TABLE_STATUS":"StatusValue2","TABLE_COMPANY":"CompanyValue2"}

{"TABLE_NAME":"NameValue3","TABLE_STATUS":"StatusValue3","TABLE_COMPANY":"CompanyValue3"}

Table (Table) Update Field O Yes Table value Item 1 Item 2 Item 3 Add item NO

"Map" / Multiple Rows
Useful if you're going to have a dynamic number of rows.
Here is an example JSON, it can be easily scaled and allows for more flexible configurations:

Table (Table) update Field O No Yes Table value "TABLE_NAME": "NameValue1", "TABLE_STATUS": 'Statusvaluel'i, "TABLE_COMPANY": "Companyval uel" "TABLE_NAME": "NameValue2", "TABLE_STATUS": "Statusvalue2", "TABLE_COMPANY": "Companyval ue2" "TABLE_NAME": "NameValue3", "TABLE_STATUS": "Statusvalue3", "TABLE_COMPANY": "Companyval ue3"

Both examples will produce the same result in DocuWare:
Table Name NameValue1 NameValue2 NameValue3 StatusValue1 StatusValue2 StatusValue3 Company CompanyValue1 CompanyValue2 CompanyValue3

KBA applicable for Cloud Organizations ONLY

This article is valid for DocuWare versions: 7.5, 7.6, 7.7. 7.8, 7.9, 7.10, 7.11, Table field, Make.com