Configuring input parameters in the dox42 Add'In

The dox42 SharePoint Online App needs an input parameter to generate your documents, which must be configured in the dox42 Add-In. You can find one sample template in your SharePoint App package folder SP_app_template.

Steps

1. In Microsoft Word, Excel or PowerPoint, go to the dox42 ribbon and select Data Map.

   

   The Data Map Designer window opens.
   

2. Select Input Parameter.

3. Configure an input parameter and give it a name (e.g. ItemID ).

   

4. For testing your documents easier with the dox42 Word Add-In, enter a Default Value for example: [ {"id": "1"}, {"id":"2"}]

5. Add a XML/JSON data source and call it JSON, for example. The JSON data source parses the ID, which is important for the SharePoint Online App:

   1. Select Insert Data Field and select your created input parameter: ItemID .

   2. In the Element text field, enter: ID.

      

   3. Go to the Initialisation & Fields tab.

      

   4. In the Table from the Read dropdown, select the Content entry.

   5. In the Table, in the Data Field Name text field, enter Example ID.

6. Add a SharePoint data source.

   

7. Go to the Select Fields tab.

8. Select the Query button.

9. Configure the Query for your SharePoint data source.

   

10. In the Filter Field, filter the ID with your previously created JSON.ID data field.

11. Use the provided template to test if everything is set up correctly after you have entered your Entra ID information and the site links in the Excel connection file.

Result

You have created an input parameter and configured an XML/JSON data source as well as a SharePoint data source. You can now generate your documents directly from SharePoint Online.