How to add a custom field to the resulting Exact online XML feed using a query with Invantive Data Access Point?

Question

For a customer we are building a custom made XML feed, but they added a custom field (Soort ProductDescription) in their Exact Online administration. How to get that extra field into the XML feed using Data Access Point?

Answer 1

Depending on how the Exact Online custom field was configured, the field should be visible in one of the Free*Field_** fields mentioned in this list of fields on Items.

You could try to select all fields (select * from logistics.Items) and see which field exactly contains the data you expected. I guess it is in FreeTextField_01, but it could be in another field.