How to add current workflow state value into an exported csv for Items

[SteveR]

How can I get the current workflow state value into an exported csv when exporting data from the Items table using a Data Export Definition.

[AlecC]

I didn’t immediately know the answer to the question but here is how I figured it out.

First of all, consider the general knowledge that every workflow enabled table in Nextworld has a common object in the data tables that is znwWorkflowInstance which is made up of multiple subfields. I used that knowledge in conjunction with Brower Dev Tools to find the information needed using the following steps:

1. Launch Item Global Master application from the Foundation menu.
2. Open Browser Dev Tools and then click Refresh in the Item Global Master app. This will cause the browser client to fetch data from the server which will show up on the Network tab of Browser Dev Tools.
3. Select the Items:fetch HTTP request from the left rail and then select the Response tab of the API call details.
4. Find the field names (and additional subfield names on objects such as znwWorkflowInstance).

Here is that info from the Browser Dev Tools.

[AlecC]

And here is the configuration of the mapping on the Data Export Definition.